Database Administrator

HRC Pakistan; Karachi Division; On-site; PKR 1,400,000 - 2,000,000; Full time

Job summary

A technology services company in Karachi, Pakistan, is seeking a Database Administrator to manage and optimize databases, lead team initiatives, and ensure smooth daily operations. The ideal candidate will have experience with database maintenance and performance tuning, along with relevant certifications and a Master's Degree in Computer Science.

Qualifications

• 5+ years of experience as a DBA.
• Ability to maintain large databases and define backup recovery procedures.
• Experience in database synchronization/replication.

Responsibilities

• Manage and coordinate team progress on projects.
• Monitor production databases for health and availability.
• Optimize database queries and troubleshoot tuning operations.

Skills

Database administration

Performance tuning

Backup recovery procedures

Education

Master's Degree in Computer Science

Tools

Oracle

HANA

MySQL

Postgres

Job description

Responsibilities

• Responsible for managing team under the position and coordinating their progress and activities on projects and ensure that deadlines are met.
• Monitor production and DR database and RAC instances, ensuring its health and availability.
• Manage and maintain DB instances and session information for various application connectivity.
• Manage and maintain database archives on various backup systems that include remote DRS.
• Engage in optimizing processing‑intensive queries and troubleshooting related database tuning operations.
• Perform daily database‑related operations including End of Day and scripts as per defined SOP.
• Manage and maintain database patches and system upgrades, this involves deployment of complete system landscape and migration of data.
• Manage and maintain documented proofs for production database access, in the form of Ad‑Hoc request forms.
• Develop and design the code to extract, format, and present the requested data for various departments of PSX in coordination with the developer and system owners.
• Manage and maintain performance tuning, and capacity planning required to create and maintain the critical databases.
• Responsible for monitoring of data purging and cleaning (washing/removing unwanted characters) activities on a daily/weekly/monthly basis, to ensure next day smooth Database Operations.
• Any other task assigned by Line Manager.

Required Skills

• Should be able to maintain/administer large databases.
• Should be able to define and implement backup recovery procedures/schedule, performance tuning, and DB security.
• Maintain, develop and test databases by creating new environments, DB synchronization/replication among all DB services, all levels.

Preferred Education, Experience, and Certifications

• Master's Degree in Computer Science or equivalent.
• 5+ years of experience as a DBA.
• Relevant certifications in Databases (Oracle, HANA, MySQL, Postgres).
• Relevant pieces of training and certifications will be an added advantage.

We are an Equal Opportunity Employer. Please only apply if you are eligible.