Manager Database

The role focuses on the comprehensive management of the company’s database environment, primarily utilizing Oracle technologies. The successful candidate will be responsible for designing, deploying, maintaining, administering, backing up, restoring, and securing databases to ensure optimal performance and reliability. A key objective is to achieve the best possible Recovery Time Objective (RTO) and Recovery Point Objective (RPO) while continuously improving database operations. The role also involves managing integrated Service Level Agreements (SLAs) across multiple functions and systems to support business continuity and disaster recovery efforts.

Key Responsibilities

Control database access by defining appropriate roles and managing Access Control Lists (ACL) to safeguard sensitive information. Ensure data security by implementing measures to prevent unauthorized access and protect against potential security threats. Monitor and tune database performance regularly to maintain optimal operation levels. Lead the backup and recovery strategy, aligning with disaster recovery and business continuity SLAs to protect critical data.

Install and configure new Oracle RDBMS versions, associated tools, and applications that interact with the Oracle database. Design and implement disaster recovery (DR) solutions tailored to organizational needs. Develop and deploy Oracle 12c Real Application Clusters (RAC) and Data Guard solutions, including configurations over RAC environments. Document all aspects of database management, including hardware configurations and maintenance records, to maintain comprehensive system knowledge.

Prepare detailed roadmaps and implementation plans for migrating and upgrading existing RDBMS versions. Create User Acceptance Testing (UAT) environments to support development and testing activities. Configure and schedule database jobs, along with automated alerts and notifications, to ensure smooth operations. Adhere strictly to Business Continuity Planning (BCP) and Disaster Recovery Planning (DRP) responsibilities, supporting IT Service Management (ITSM) services, providing Root Cause Analysis (RCA), driving end-to-end system recovery, and maintaining effective RTO.

Required Qualifications

Bachelor’s degree in Computer Science or a related field is essential. A minimum of six years’ experience working with Oracle RAC Databases (10g, 11g, 12c) and Data Guard, including Active and Cascade configurations, is required. Proficiency in SQL and SQL Server tools is necessary. Advanced knowledge of database security, backup and recovery, disaster recovery, and performance monitoring is critical.

Strong scripting skills in PowerShell and Unix shell environments are expected. Experience working with Linux and Windows Server infrastructures is required. A thorough understanding of database technologies, including MySQL and Oracle, is important. Expertise in database patching using OPatch and OPatchAuto tools is essential.

In-depth knowledge of Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), and Active Data Guard is required. Familiarity with Oracle advanced technologies such as Advanced Security, Advanced Compression, Encryption, and load testing is highly desirable. Hands-on experience with backup and recovery techniques, including hot and cold backups, is necessary. Skilled in Oracle Data Guard physical standby and active configurations, as well as Oracle database patch management and performance tuning.

Preferred Qualifications and Additional Information

Candidates with experience in Oracle Enterprise Linux, Red Hat Enterprise Linux, and IBM AIX environments will have an advantage. This is a full-time position based in Karachi, requiring reliable commuting or relocation to the Shahra-E-Faisal area. The role mandates in-person attendance at the work location to ensure effective collaboration and operational support.