Database Administrator

Abacus


Date: 2 weeks ago
City: Lahore
Contract type: Full time

WHO WE ARE

At Abacus, we specialize in technology, outsourcing, and people solutions, bringing nearly 40 years of experience shaped alongside the organizations we support. As a global professional services leader, our focus remains on providing bespoke solutions that enable organizations to create the future of business and embrace change for sustainable growth, powered by a global team of over 5,000 people.

WHAT WE DO

Across digital transformation, emerging technologies, SAP enterprise solutions, outsourcing, and human capital, we support organizations in building environments that operate effectively and scale with the business. Today, this extends to more than 1,500 enterprise clients, where the focus remains on creating systems that are not only functional, but ready to adapt and evolve over time.

Location: Lahore

Job Summary:

We are seeking a highly skilled and motivated Database Administrator (DBA) to join our dynamic team at Abacus. The ideal candidate will possess expertise in Oracle and PostgreSQL databases, along with a strong background in database replication, deployment, and cluster application architecture. This role requires an individual with excellent problem-solving skills, the ability to manage multi-terabyte datasets, and a proactive approach to database administration and project lifecycle management.

Key Responsibilities:

  • Manage and maintain Oracle, Oracle GoldenGate and PostgreSQL databases, ensuring high performance, availability, and scalability.
  • Configure and manage database deployment, clustering, replication and load-balancing technologies to enhance performance.
  • Write and optimize complex queries and stored procedures for efficient data management.
  • Handle multi-terabyte datasets effectively, ensuring data integrity and security.
  • Implement and maintain database security, backup, and recovery strategies according to industry best practices.
  • Diagnose and resolve complex database issues, leveraging excellent problem-solving and analytical skills.
  • Oversee the full project lifecycle, including initiation, planning, execution, control, and closure, while maintaining technical excellence.
  • Provide daily production support and manage customer interface, proactively addressing issues to minimize downtime.
  • Prepare functional and technical specification documents to align with project requirements.
  • Manage and track ticket queues, ensuring compliance with SLAs, KPIs, and OLAs.
  • Ensure adherence to Software Quality Processes and project timelines, delivering quality results within deadlines.
  • Mentor and guide team members, fostering a collaborative and motivated work environment.
  • Act as the single point of contact between the team and project stakeholders, facilitating effective communication and resolution of issues.
  • Manage and optimize large data pipelines in a production support environment.

Requirements:

  • Must-Have Skills: Proficiency in Oracle and Oracle GoldenGate, PostgreSQL, database replication, deployment, and cluster application architecture.
  • Minimum 4+ years of experience in software development and database administration.
  • Experience with database clustering and load-balancing technologies is highly advantageous.
  • Knowledge of configuring active-active configurations for databases.
  • Strong knowledge of database security, backup, and recovery best practices.
  • Proven ability to manage multi-terabyte datasets in a production environment.
  • Expertise in writing queries and stored procedures.
  • Excellent problem-solving and analytical skills.
  • Strong organizational and leadership abilities to oversee project lifecycles and mentor team members effectively.
  • Familiarity with tracking and managing ticket queues, SLAs, KPIs, and OLAs.
  • Proven ability to prepare detailed functional and technical specification documents.

Immediate joining preferred

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Planning & Production Control Executive (PPC)

BATIK Pakistan, Lahore
4 days ago
Position Title: Planning & Production Control ExecutiveLocation: Quaid-e-Azam Industrial Area, Kot Lakhpat, LahoreDepartment: Planning & ProductionReports To: Head of Planning & ProductionEmployment Type: Full-TimeWork Model: On-Site (Monday to Saturday, 9am – 6pm) Who We Are:BATIK is a vibrant, forward-thinking brand that creates inspiring women’s apparel with style, soul, and purpose. Behind every design is a team committed to excellence, professionalism,...

Business Development Key Account Manager

tossdown, Lahore
5 days ago
About Ustossdown is a SaaS-based marketing agency offering e-commerce and digital marketing solutions tailored to the food industry. We work with food businesses to build e-commerce websites, mobile apps, and deliver impactful digital marketing strategies. We combine intelligent technology and expert services to help restaurants own their customer relationships and grow sustainably.Job DescriptionDrive revenue growth through sales, lead generation, and...

Assistant Store Manager

Levi Strauss & Co., Lahore
1 week ago
Levi Strauss & Co. isn't your typical retailer. We've been pushing boundaries since 1873, inventing the blue jean, redefining khakis, and breaking barriers with size-inclusive activewear. We champion sustainability and ethical practices. Our brands (Levi's, Dockers, Beyond Yoga) stand for freedom and self-expression. Assistant Store Manager is an integral part of the store management team by developing the store team...