Database Administrator

Team Computers; Pune District; Presencial; INR 1.200.000 - 2.200.000; Jornada completa

Descripción de la vacante

Team Computers in Pune, India is seeking an experienced Oracle Database Administrator to manage, monitor, and optimize critical Oracle databases across environments. You will handle installation, patching, RMAN backups, Data Guard configurations, and regular health checks in a high-availability setup.

You will analyze AWR/ADDM/ASH, tune SQL, support incidents (L2/L3), ensure security and change controls, and contribute to automation and documentation.

Formación

• Bachelor's degree in Computer Science, IT, Engineering, or equivalent.
• Oracle Database certification is preferred.
• ITIL knowledge is a plus.

Responsabilidades

• Install, configure, upgrade, patch, and maintain Oracle databases.
• Manage database instances, schemas, users, roles, privileges, and objects.
• Perform routine health checks and monitoring of availability.
• Analyze AWR, ADDM, ASH reports and tune SQL for performance.
• Manage RMAN backups and recovery testing.
• Support Data Guard primary/standby configurations and DR drills.
• Troubleshoot incidents and provide L2/L3 support.
• Ensure security, access controls, and patching per standards.
• Document SOPs, runbooks, and governance artifacts.

Conocimientos

Oracle DBA

SQL/PLSQL

RMAN backup

Data Guard

AWR/ADDM/ASH analysis

OEM management

Linux/Unix

Shell scripting

Patching & upgrades

ITIL basics

Educación

Bachelor's degree in CS/IT

Oracle Database Certification

ITIL certification

Herramientas

Oracle Enterprise Manager

Descripción del empleo

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.