Database Administrator

Role & responsibilities

Key Responsibilities

1. Database Administration

• Install, configure, upgrade, patch, and maintain Oracle databases.
• Manage Oracle database instances, schemas, users, roles, privileges, and database objects.
• Perform routine database health checks and housekeeping activities.
• Monitor database availability, capacity, and overall health.

1. Performance Management

• Monitor database performance and identify bottlenecks.
• Analyze AWR, ADDM, ASH reports and SQL performance.
• Perform SQL tuning and database optimization.
• Monitor CPU, memory, storage, I/O, sessions, locks, and waits.
• Recommend capacity and performance improvements.

1. Backup & Recovery

• Manage database backup and recovery using RMAN.
• Perform backup validation and restoration testing.
• Support database recovery during incidents or failures.
• Ensure backup policies meet business continuity and DR requirements.

1. High Availability & Disaster Recovery

• Manage and support Oracle Data Guard environments.
• Monitor primary and standby databases.
• Perform Data Guard switchover/failover activities as required.
• Participate in DR drills and ensure database recovery objectives are met.

1. Incident & Problem Management

• Troubleshoot database incidents, performance issues, connectivity problems, and application-related database issues.
• Provide L2/L3 support for critical incidents.
• Perform RCA for recurring or major database incidents.
• Implement preventive and corrective actions.

1. Security & Compliance

• Manage database access, roles, privileges, and authentication.
• Follow security and compliance standards for database environments.
• Support vulnerability remediation and database patching.
• Maintain audit logs and required operational documentation.

1. Change & Release Management

• Execute database changes in accordance with the approved change-management process.
• Support application releases, database migrations, upgrades, and patching activities.
• Prepare implementation, rollback, and validation plans.

1. Monitoring & Automation

• Monitor database alerts and proactively identify potential failures.
• Work with monitoring tools to improve proactive incident detection.
• Automate repetitive DBA activities using scripts wherever possible.
• Maintain operational dashboards and database health reports.

1. Documentation & Governance

• Maintain SOPs, runbooks, database architecture documents, and recovery procedures.
• Prepare daily/weekly/monthly operational reports.
• Maintain database inventory and configuration information.
• Participate in service review meetings and governance calls.

Required Technical Skills

• Strong experience in Oracle Database Administration.
• Oracle 11g/12c/18c/19c/21c administration experience.
• Strong knowledge of SQL and PL/SQL.
• Oracle RMAN backup and recovery.
• Oracle Data Guard.
• Database performance tuning.
• AWR, ADDM and ASH analysis.
• Oracle Enterprise Manager.
• Database patching and upgrade.
• Linux/Unix operating system knowledge.
• Shell scripting.
• Storage and filesystem concepts.
• TCP/IP and database connectivity fundamentals.
• Knowledge of ITIL-based incident, problem and change management.

Good to Have

• Oracle RAC.
• ASM.
• GoldenGate.
• Oracle Cloud / OCI.
• Exadata.
• Enterprise Manager Cloud Control.
• Database migration and modernization experience.
• Automation using Python/Shell scripting.
• Experience working with ServiceNow or other ITSM platforms.

Key Competencies

• Strong analytical and troubleshooting skills.
• Good communication and stakeholder-management skills.
• Ability to work independently and as part of an operations team.
• Ability to handle P1/P2 database incidents under pressure.
• Strong documentation and process discipline.
• Proactive approach toward monitoring and problem prevention.
• Willingness to participate in rotational/on-call support where required.

Key Performance Indicators

• Database availability and uptime.
• SLA compliance.
• Backup success and recovery-test compliance.
• Database performance and capacity management.
• Incident resolution and MTTR.
• Change success rate.
• Reduction in recurring incidents.
• Security and patch compliance.
• Quality of operational documentation.

Education & Certification

• Bachelor's degree in Computer Science, IT, Engineering, or equivalent.
• Oracle Database certification is preferred.
• ITIL certification is an added advantage.