Senior Oracle Database Administrator

Job Overview

This position is responsible for designing and implementing database solutions that meet the needs of a dynamic organization.

Key Responsibilities

1. Analyze and execute end-to-end database consolidation, migration, conversion, and upgrade projects to ensure seamless integration with existing systems.
2. Lead the upgrade and management of large Oracle databases on Linux and Exadata to Oracle 19c, utilizing features like PDB/CDB, data compression, partitioning, RAC, RMAN, Data Guard.
3. Translate business and application requirements into database designs and capabilities to drive business growth.
4. Perform requirements analysis, data architecture design, data security, performance tuning, and backup/recovery planning to ensure high availability and scalability.
5. Consult on optimal database environment design, analyze complex deployments, and recommend performance improvements to optimize database performance.
6. Evaluate and implement new product features tailored to database needs to stay ahead of the competition.
7. Use optimization techniques such as projections and partitioning to improve query performance.
8. Ensure IT compliance and risk management, including security and privacy standards, to protect sensitive data.
9. Establish database access controls and respond to access and performance issues in a timely manner.
10. Manage database crash recovery and performance analysis, including SQL query tuning, to minimize downtime.
11. Document issues and support application teams in fine-tuning SQL queries to optimize database performance.
12. Participate in change management processes and develop backup, restore, and disaster recovery strategies to ensure business continuity.
13. Support development teams during various phases of application lifecycle to ensure smooth implementation.
14. Create reports and communicate with external teams to ensure optimal database performance and security.
15. Implement change control and testing processes for database modifications to prevent errors.
16. Conduct database transaction and security audits to identify areas for improvement.
17. Prioritize tasks effectively and work under pressure to meet deadlines in a fast-paced environment.
18. Maintain accurate records and documentation of all database activities and changes.
19. Demonstrate strong technical skills and knowledge of Oracle 19c and related technologies.

Requirements

• Bachelor's degree in a relevant IT field or equivalent experience.
• At least 5 years' experience as an Oracle DBA (10g, 11g, 12c, 19c).
• Hands-on experience with Oracle 19c implementations, upgrades, conversions, and consolidation projects on Exadata and Oracle Cloud Platform.
• Excellent troubleshooting and performance tuning skills, with knowledge of tuning features like SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository, and Automatic Database Diagnostic Monitor.
• Strong knowledge of Oracle 19c and technical database concepts such as physical data modeling, tuning large instances, PDB/CDB, resource management, data replication, and backup/recovery techniques.
• Minimum three years of working knowledge of Oracle RAC, Oracle Enterprise Manager, Oracle ASM, Oracle RMAN, Oracle Data Guard, and Oracle Database Security.
• Good organizational and communication skills to handle multiple priorities.
• Experience supporting enterprise, high-profile, mission-critical, and dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements.
• Proven experience in database and SQL performance tuning.
• Knowledge of RMAN backup and recovery strategies, with experience in database backups and restores using RMAN.
• Experience supporting both development and production database environments.
• Ability to drive product issues to resolution following ITIL processes and provide Level 3 support.
• Working knowledge of operating systems such as Windows Server, Unix, Linux, AIX, etc.
• Preferred skills include Oracle Certified Expert (RAC/Performance Tuning).
• Knowledge of data privacy laws and practices.
• Ability to conduct research into database issues, standards, and products.
• Effective prioritization and execution skills in high-pressure environments.
• Excellent written and oral communication skills, with strong technical documentation skills.
• Good interpersonal skills and willingness to work flexible hours, including being on call.

Location

Lahore, Pakistan