Share this Job

Database Admin Specialist Advisor

Apply now »

Date: Nov 24, 2022

Location: Pune, MH, IN

Company: NTT DATA Services

  • Oracle database system - required to install and maintain the database software, create storage structures, set up user accounts, debug malfunctioning programs, create backups, and regularly maintain the database security.
  • Knowledge and hands on RMAN backup and restoration and extensive scripting knowledge
  • Perform Health Checks and proactive configuration management 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
  • Applying system patches as appropriate in line with the agreed patch management process
  • 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)

Job Segment: Database, System Administrator, Testing, DBA, Administrative Assistant, Technology, Administrative