Must Have Technical/Functional Skills
Database Administration
• Install, configure, and maintain Oracle databases (11g / 12c / 19c) on Linux/Unix platforms
• Perform database creation, configuration, cloning, and decommissioning
• Manage tablespaces, datafiles, redo logs, control files, and storage growth
• Perform routine maintenance activities such as space management and housekeeping
Backup & Recovery
• Design and implement backup and recovery strategies using RMAN
• Perform database restores and recoveries (complete and point in time recovery)
• Test backup and recovery procedures regularly to ensure DR readiness
• Handle archive log management and retention policies
Performance Monitoring & Tuning
• Monitor database performance using AWR, ADDM, ASH, OEM
• Identify and resolve performance issues related to CPU, memory, I/O, SQL
• Tune SQL queries, indexing strategies, and optimizer statistics
• Manage Oracle initialization parameters for optimal performance
High Availability & Disaster Recovery
• Implement and support Oracle Data Guard (Physical / Logical Standby)
• Manage Oracle RAC environments for high availability
• Perform planned and unplanned failover and switchover operations
• Support DR drills and business continuity testing
Security & Compliance
• Manage database users, roles, profiles, and privileges
• Ensure database security standards and compliance requirements are met
• Implement auditing, password policies, and access controls
• Apply security patches and CPU updates
Upgrades, Patch & Migration
• Perform Oracle patching, PSU/CPU upgrades, and version upgrades
• Support database migrations across platforms or versions
• Coordinate with application and infrastructure teams during releases
• Follow change management and release processes
Production Support
• Provide 24x7 on call support for production databases
• Troubleshoot database incidents and perform root cause analysis
• Work with vendors and internal teams to resolve complex issues
• Maintain SOPs, runbooks, and operational documentat ion
Salary Range: $100,000 - $130,000 a year