Job title: Principal Oracle Database Administrator
Company: Pakistan Single Window
Job description:
Oversee Oracle 19c databases with a focus on RAC for high availability, ASM configuration, and minimal-downtime upgrades/migrations.
Optimize performance via OEM, AWR/ASH, and STATSPACK, implementing advanced tuning (partitioning, indexing, parallel query) for data warehouse queries.
Configure and maintain Data Guard, robust RMAN backups, and DR strategies to ensure seamless failover and data protection.
Collaborate on schema design, and capacity planning for large-scale analytics.
Utilize tools like Oracle GoldenGate or Data Pump for replication; Oracle APEX knowledge is a plus.
Automate routine tasks (backups, alerts) with Shell/PL/SQL scripts and potentially integrate CI/CD pipelines.
Mentor junior DBAs, provide best practices, and resolve complex issues alongside infrastructure and development teams.
Maintain up-to-date documentation on database configurations, DR plans, and operational standards.
Stay current with evolving Oracle features (multitenant, in-memory) and industry best practices to enhance performance and reliability.
Requirements
Bachelor’s or master’s degree in computer science, Information Systems, or a related field.
Years of Experience: 6+ years of hands-on Oracle database administration experience, with a strong focus on Oracle 19c and RAC in production environments.
Proven proficiency in Oracle RAC, Oracle Data Guard, ASM, and advanced backup/recovery strategies with RMAN.
Experience with Data Warehouse architectures, large data sets, and partitioning strategies.
In-depth knowledge of SQL and PL/SQL debugging, query tuning, and execution plan analysis.
Familiarity with Oracle Enterprise Manager (OEM), AWR, ASH, ADDM, and statspack for performance diagnostics.
Exposure to Oracle GoldenGate or similar replication technologies is highly advantageous.
Understanding of cloud platforms (AWS, Azure, or OCI) and experience with migrating or running Oracle databases in the cloud is a plus.
Benefits
Competitive salary
Fuel Card
Health benefits
Professional development opportunities
Inclusive work culture & much more
Expected salary:
Location: Karachi, Sindh
Job date: Thu, 17 Apr 2025 22:27:42 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck
