Oracle DBA

Bachelor's degree in relevant IT departments.

At least 5 years' experience as 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. Demonstrated knowledge and skills using 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.

At least three years of working knowledge of Oracle Real Application Clusters (Oracle RAC), Oracle Enterprise Manager (Oracle OEM/Grid Control), Oracle Automatic Storage Management (Oracle ASM), Oracle Automatic Storage Management Cluster File System, Oracle Recovery Manager (RMAN), Oracle Data Guard, and Oracle Database Security.

Good organizational and communication skills with the ability to handle multiple priorities.

Experience in handling and supporting enterprise, high profile, mission-critical, and dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements.

Proven experience in Performance Tuning of Database and SQL.

Knowledge of Backup and Recovery - RMAN including exposure to plan and strategize backup and recovery operations. Proven experience in Database backups and restores using RMAN.

Experience in supporting both Development and Production Database environments.

The candidate must be able to drive product issues to resolution and register all steps in document following ITIL processes.

Ability to provide L3 support.

Working knowledge of operating systems such as Windows Server, Unix, Linux, AIX, etc.

Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades.

Drive upgrade and management of large, complex Oracle databases currently running on Oracle 11g/12c environments on Linux and Exadata to Oracle 19c with features for PDB/CDB, data compression, partitioning, RAC, RMAN, Data Guard.

Lead analysis of business and application requirements to translate into new or modified database or data capabilities.

Requirements analysis, data architecture, integrated database design, data security, performance tuning, back-up and recovery specifications.

Consult for optimal design of DB environments, analyzing complex distributed production deployments, and making recommendations to optimize performance.

Assist with the evaluation and implementation of new product features to tailor solutions for database requirements.

Use optimization techniques such as projections and partitioning.

IT compliance and risk management requirements (eg. security, privacy, SOX etc.).

Establish appropriate end-user database access control levels.

Respond to and resolve database access and performance issues.

Crash/Recovery of Databases.

Database Performance Analysis & Developing Tuning Approach.

Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Documenting any Bad SQL Queries and support Application team for fine-tuning.

Participate in Change Management Process.

Preparing Backup and Restore Strategy and implementation.

DR Plan, Implementation, and Management.

Consultancy (if required) developers in optimizing SQL query and support to application development team during the development, testing, pre-production, and post-production phase.

Create, or support creation of, required reports in response to business user needs.

Communicate with external teams including the biz clients on various issues and resolutions thereof to provide best customer experience.

Develop, implement, and maintain change control and testing processes for modifications to databases.

Analyze database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Consultancy for DB Upgrades and Enhancement.

Security Compliance Preparation and Implementation plan.

Perform database transaction and security audits.

Information Technology and Services - Lahore, Pakistan.