Database Administration Advisor

**Req ID**: 216365

We are currently seeking a Database Administration Advisor to join our team in Bangalore, Karnātaka (IN-KA), India (IN).-
- Database Support

NTT DATA will manage and provide support service for database instances in scope as documented in Schedule 2 (Customer Hardware) for the following in-scope technologies - SQL, MySQL, DB2, IMS and Oracle, which are in on-premise locations in Dublin, Ireland.

NTT DATA's responsibilities, related to the in this section mentioned database instances, will include:

- Perform Health Checks and proactive configuration management of IMS and DB2 like reviewing critical configuration settings on database environment, proactively responding to changes, periodically reviewing logs and triage and take action when required
- Perform availability monitoring as part of incident resolution on database instances, including infrastructure availability (ping and heartbeat)
- Provide Out of Hours On-Call support for P1 or critical incidents. P1 or Critical Incidents are addressed 24x7x365 days. Outside of the Business Hours, P1 or critical incidents are handled through On-Call Support.
- Resolving incidents and service requests relating to the database instances
- Track, update and confirm that database instance environment and associated software inventory is correctly recorded in CMDB
- Support the software troubleshooting and repair processes, including vendor coordination for database related software based on client-purchased maintenance agreements from the OEM
- Verify database operability after maintenance activities
- Maintain policy and procedure documentation for database administration
- Perform instance reboot or rebuild activities in case of major failure from existing data backup data if available
- Proactive system optimisation and maintenance including housekeeping partitioning and instance management activities as required
- Troubleshoot and manage performance, tuning, diagnostics and space utilisation
- Provide database backup support including database backup configuration, testing and reporting Provide database monitoring of backups ensuring backups run as expected
- Provide ongoing forecasts regarding database capacity and storage management
- Provide support for high availability cluster management solutions,
- Support restoration activities from backup upon client request
- Create and manage local accounts, including service accounts where applicable
- Remove end user accounts, roles and revoke permissions, modify permissions or remove logins as requested by client
- Unlock accounts, including service accounts, and reset passwords based on receiving authorised requests
- Troubleshoot and remediate problems in all in-scope database environments, including the high availability-supported database instances for Platinum and Gold environments and engage other teams if needed
- Database instance provision/decommission as requested by client
- Assist client in database version upgrades
- Liaise with 3rd party suppliers and vendors where required as part of incident resolution
- Use reasonable endeavours to support the database software / tool where at a level not supported by the OEM
- Perform relevant remediation actions on database instance environment raised as a result of disaster recovery exercise or vulnerability assessment
- Participate as resolver party in Priority One resolution process (owned and managed by client's service management team)

**About NTT DATA Services**

**NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.**

**Job Segment**:
Database, DBA, Cloud, System Administrator, Testing, Technology