Senior Engineer - Oracle Database Administration

To administer, monitor, optimize, and support enterprise Oracle database environments across on-premises and OCI platforms. The role focuses on database availability, performance, backup and recovery, security, patching, capacity management, cloud database administration, OCI monitoring, connectivity, operational readiness, and SLA-driven production support.

Responsibilities:

•    Administer Oracle databases across production and non-production environments.
•    Knowledge of OCI Database Management, Monitoring, Logging, and Alarms. 
•    Understanding of OCI IAM, compartments, VCNs, private endpoints, NSGs/security lists, and cloud connectivity. 
•    Hands-on experience with Oracle Cloud Infrastructure (OCI) DBA operations. 
•    Perform database installation, configuration, upgrades, patching, cloning, and migration activities.
•    Monitor database availability, capacity, sessions, storage, jobs, and performance indicators.
•    Undertake SQL and database performance analysis using appropriate diagnostic reports and tuning techniques.
•    Plan, execute, and validate backup, restore, recovery, and disaster-recovery procedures.
•    Manage database users, roles, privileges, auditing, and access controls in line with approved security requirements.
•    Investigate incidents, identify root causes, implement corrective actions, and contribute to problem management.
•    Support application releases, deployment validation, change implementation, and rollback planning.
•    Maintain database inventories, configuration records, SOPs, recovery runbooks, known-error records, and operational handover documents.
•    Coordinate with application, infrastructure, security, and vendor teams while meeting agreed SLAs and change controls.

Technical Skills:

• Oracle Administration: Oracle Database 12c, 19c, or later; installation, configuration, maintenance, patching, and upgrades. Including OCI database services, Autonomous Database, database monitoring, performance management, backup and recovery, scaling, and troubleshooting of OCI-hosted Oracle databases.
• Performance and Capacity: SQL tuning, indexing, execution plans, AWR, ASH, ADDM, storage, tablespace, and capacity management.
• Backup and Recovery: RMAN backup, restore and recovery; recovery validation and operational runbooks.
• High Availability and DR: Oracle Data Guard, standby database operations, switchover/failover support, and replication awareness.
• Security Administration: User, role and privilege management; auditing, hardening, access review, and security compliance support.
• Monitoring and Support: Oracle Enterprise Manager or equivalent monitoring, alert handling, incident resolution, RCA, and SLA-based support.
• Scripting and Documentation: SQL, PL/SQL and shell scripting awareness; SOPs, configuration records, and technical handover documentation.

Good To have:

•    Experience with Oracle RAC and clustered database environments.
•    Exposure to Oracle Exadata or engineered systems.
•    Experience with cloud-hosted Oracle database services.
•    ITIL-aligned production support and change-management experience.
 

Education: 

•    Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Soft Skills:

•    Strong analytical, problem-solving, and troubleshooting skills.
•    Excellent communication and documentation abilities.
•    Ability to work independently and collaborate effectively across technical and service-management teams.
•    Customer-focused mindset with disciplined ownership of incidents, requests, and operational commitments.