Mainframe Database Administrator (Chennai)

DUTIES AND RESPONSIBILITIES Fully functional and self-directed Provides formal mentorship High complexity assignments - owner Moderate complexity assignments - owner (1 or >) Low complexity assignments - provide oversight/review Regularly lead self and others and/or established as Product SME and/or established as specialist Sees the whole picture and adjusts work accordingly Installation and configuration of database software and related products Plans and implements Database backup and recovery Implementing robust change control and configuration management policies Capacity planning & system-level architecture OS/Storage/DB configuration and optimization with supervision Database security checks and audits, including compliance-related reporting & controls General database health checks Database monitoring Working with DBMS vendor support (Oracle support, Microsoft support, etc.) Defining and maintaining quantitative SLAs and helping enhance current service levels with supervision Physical data model/architecture, DDL generation and maintenance DB server migrations and decommissioning Database creation and configuration Upgrading the databases Maintenance (proactive, reactive and automated); both scheduled and unscheduled Database refreshes Log-file review Medium-complex trouble-shooting and repairs Reporting on state of databases Database tuning (proactive and reactive) Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc. SOP (Std. Operating Procedure) definition & automation DBMS and related tools license management Documentation related to all Systems DBA areas Management of database-related tools (monitoring systems, tool repositories, etc.) Automated measurement of quantitative SLAs & any deviations thereof Development & utilization of detailed triage processes Detailed workload analysis with supervision Infrastructure advise and planning Disaster recovery/failover services Working with Developers Ensuring the .