Role: Oracle Database Administrator (24x7)

Location: Mumbai/ Navi Mumbai

Years of Experience: 8 to 14 Years

Role & Responsibilities:

- Managing and monitoring of all the Oracle, Sybase, Ms-Sql, MySQL, Mongo and Db2 databases, Management of all SRs, PMRs and calls.
- Project initiation and execution as per business requirement
- Data replication with minimum lag at DR site; Keeping DR databases up to date
- Performance tuning of the databases
- Ensuring that all the databases backup taken and health check maintained
- Database hardening and version upgrade.
- Vendor management for handling database problem/escalation/application support

Reporting Structure: who is reporting to you:

Outsourced DBAs (Oracle, Sybase, MySQL, Ms-Sql, Db2, Application dba, RAC Admin, Bangalore DBA Team and Oracle ACS Support.)

Interfaces: whom do you interact daily with

- Database administrators
- Unix system administrators
- Windows system administrators
- Storage administrators
- IT operation team
- IT Projects Team
- Application Support Teams
- Application vendor teams 9. Respective Project Managers
- End Users 11. DRM Team

12 RTB (Run the Bank) Support Team

13 Cloud Support Teams.

Key performance Indicator*

- 99.5% uptime for all the Oracle, Sybase, MySQL, Ms Sql, Mongo and Db2 databases - Downtime/outage reporting - daily & monthly reports
- Ensure 100% backup for all the databases, Designing appropriate Database backup policy - Daily report, Successful restorations (periodic/as per business requirement) monthly report
- Continuous monitoring of the databases and its consistency, SR management, Database fine tuning to enhance performance - Daily checklist, Standby status report, Release of production and report databases. Performance report (hit ratios)
- Database management and support within budgeted cost- Cost saving. Review of billing details
- Security. Audit and ISO recommendation implementation for all the databases - VA reports. ISO/Audit reports & findings
- Patch management- Database event monitoring report

Other Key Performance Indicators:

- Ensure uptime for DB systems
- Handle deliverables in co-ordination with vendor who provides managed services so that SLA can be met
- Resource scheduling for onsite dba services
- Ensure that no system release delay due to DB error
- Tracking eod & bod status using application tables for critical systems
- Archive log volume tracking
- Monitor space at database level
- Review alert & error logs; corrective action in case of any error
- Monitor various application jobs,



services & corrective action/escalation against failure
- Measure hit ratios and protect against threshold values
- Ensure scalations are triggered on time and to the appropriate persons
- Identification of area where further tuning/enhance is require to smoothen the DB management and ensure corrective action
- Ensure synchronization for all standby databases at local & DR with minimal lag
- Measure database growth and share the trend
- Ensure analyse/gather stats for performance optimization
- Data movement to history tables
- Ldap db2 reorg activity in TAM setup of netbanking
- Automation of jobs up to best possible extent
- Raise SR/PMR with product companies for internal errors/problems and follow up until closure
- Handle 2nd level escalations 24*7 for all RDBMS
- Ensure appropriate documentatio
- Proactive communication with internal customers
- Identify root cause of the problem and implement permanent solution
- Manage the emails/phones efficiently and ensure no email/call is ignored or unattended
- Manage quality kiosks alerts / sms, Monitoring mails and alerts efficiently
- Attend weekly meetings with project team and allocate resources as per discussion
- Updation of major activities sheet on regular basis
- Ensure appropriate action plans and seamless execution for special tasks
- Publish / share notices for de supported versions of Databases and insist for upgrade to latest/supported version

Audit and compliance:

- Implementation of baseline hardening & closure of security finding from DB point of view
- Handling of various internal and external audits
- Ensure closure of all audit findings for databases
- Maintain up-to-date db inventory along with all details
- Reconcile & maintain record of rdbms licenses
- Ensure appropriate documentation and certify for ISO 270001 surveillance audit
- Adherence to processes and policies
- Ensure closure of pending VAs and CAs
- Maintain all necessary records for audit purpose
- RBI audit

Patch management:

- Ensure all patches coming from Application team are applied on databases and output is provided to them
- Handle data requests for all databases
- RDBMS version upgrade patches on databases
- Bug fixing patches





Backups:

- Backups as per standard policies and business requirement
- Data restoration using tape backups as per application and business requirement
- Configuration of backups for new databases
- Identification of backups taking more time and tuning those up to the best possible way
- Escalation for capacity planning to the management
- Scheduling of Special and other adhoc backups
- Re-verification of backup validity
- Backup of Uat & Dev environments
- Backup of user segments

Maintenance:

- Ensure proper housekeeping is carried out to avoid outage
- Initiation of tuning for various application in coordination with respective Application owner
- Periodic health check review and parameter tuning of databases
- Creation of various test setups to test application tuning as per requirement

Projects Support:

- DB upgrade to supported/latest version - Number of dbs upgraded, email communication to ensure necessary follow-up
- Support for UAT & Development databases
- Oracle license utilization tracking
- Execution of projects initiated by project team
- Close known vulnerabilities proactively
- Maintain & Update Documentation ops manuals, sop, exceptions, deviations, stop/start services.

Reports:

- Ensure all checklists received from database admin team - Daily checklists
- Monthly report to Senior Mgmt by 2nd of every month - Monthly report
- Database uptime report for critical applications - Daily report
- Publish performance gain reports wherever tuning is done by/as per app dba
- Timely update in Major activity report

Soft skills:

- Coordination with various teams for day to day operations
- Understand application & business requirement
- Quick response time
- Reports in neat and accurate format
- Working and interacting with others to accomplish team goals
- Express ideas and concerns clearly
- Team meetings and knowledge sharing sessions as per predefined frequency
- Learn recent technologies, acquire new skill set
- Prepare & do presentations during data center meetings

Role: Database Administrator, Industry Type: Banking, Department: Engineering - Software & QA, Employment Type: Full Time, Permanent Role Category: DBA / Data warehousing Education UG: Any Graduate read more

Key Skills Skills highlighted with ‘‘ are preferred keyskills Oracle Database Administrator Database AdministrationOracle DBAOracle DatabaseOracle AdministrationSyBaseMySQLMongoDBDB DBAMS SQL DatabaseDatabase AdministratorOracle Database Administration

📌 Oracle Database Administrator (Mumbai)
🏢 Kotak Mahindra Bank
📍 Mumbai