Executive- IT (Oracle DBA)

Role & responsibilities

Responsible for the administering & maintenance of Oracle / Sql Databases at Medanta:

1. Support and Training

• Providing User support (24x7) HRS On call
• Problem escalation to corporate team and third parties as appropriate.
• Identifying and resolving database related issues.
• Conducting period health checks on DBs
• Formulating new requirements after taking inputs from implementation and support teams
• Generating adhoc reports
• Providing Data setup support for QA and Dev environment
• Master Data maintenance
• Monitoring and administering Report Queues
• Monitoring and administering Golden gate replication routines
• Troubleshoot DB issues
• Identify bottlenecks and try resolving them

2. Coordination with Vendor

• Coordinating with vendor about any new patches with respect to DB as well as applications, new requirement and bugs within specified timeline.

3. Knowledge Transfer

• Providing technical training to the peers and subordinates within IT department

4. Release Deployment

• Testing the product patches released by Vendor and track the issues till closure
• Supporting the User Acceptance Testing for new features/functionalities added in HIS and related systems
• Go-live support post deployment of new features

5. Following Departmental Processes

• Maintaining the tracker of issues reported on day to day
• Maintaining approval records
• Any other duties given by the reporting manager

Additional Requirements:

1. Understanding on Oracle database architecture along with cloning, patching and upgrade

2. Expertise in installation/troubleshooting/monitoring of Oracle Golden Gate - 11g bidirectional replication

3. Experience with production critical/multi-terabyte Oracle Databases - 11g/10g administration, monitoring, proactive health check of the database

4. Knowledge in database backup/recovery including Hot Backup, Cold Backup and RMAN [Duplicate Database: Active/Backup]

5. Experience in SQL query tuning and database performance analysis.

6. Administration of oracle partitioned tables and their maintenance

7. Administration of Oracle Application Server / Oracle Forms & Reports Server - 10g/11g along with Oracle WebLogic Server 11g will be additional advantage

8. Expertise in Disaster recovery strategies for production/non production databases. [Active/Passive Dataguard]

9. Experienced in packages and tools like SQL*Plus, PL/SQL, Oracle RMAN, OEM, OUI, DBCA, NETCA etc.

10. Proficiency in Security administration like auditing, creating users, roles, profiles, assigning object level and column level grants, controlling users access to system resources etc.

11. Basic UNIX shell commands and scripting [ssh, vi, grep, sed, awk etc.]

12. Time management, organizing, analytical/problem solving skills

Preferred candidate profile

Understanding on Sql server database architecture along with administration, patching and upgrade