Associate Delivery Manager - Tech Ops

Location Name: Pune Corporate Office - Mantri

Job Purpose

Database Administrator job consist of Architecture & Design, High Availability & Disaster Recovery, Installation, Database Creation, Performance monitoring, Automation & Scripting, Troubleshooting, Daily backup tracking, Database Migration & Upgrade, New environment creation, Database Security & Compliance, Issue trouble shooting, Performance/Impact analysis, Database alert tracking, Capacity Planning, Change Management tracking and data extractions for MIS Reporting/Analysis

Duties And Responsibilities

A- Minimum required Accountabilities for this role

•  Provide 24x7 support for mission critical production databases.
•  PostgreSQL Database Installation, monitoring, managing, and maintaining production databases.
•  High Availability & Disaster Recovery
•  Database Migration and Upgrade/patching
•  New environment creation (on Azure and AWS)
•  Database Security compliance deployment and tracking
•  Issue trouble shooting
•  Performance/Impact analysis
•  Process Automation & Scripting
•  Resolving Incidents/service request and update the status.
•  Tracing of daily backups/incidents/database alerts/Governance & compliance/Support to DR drill/database growth etc
•  Monitor the database health using monitoring tools.
•  SQL query tuning hands-on experience
•  Data extractions for weekly, monthly & quarterly MIS reporting/Monthly deck/issue investigation & update database inventory
•  Experience in installing, managing, monitoring Postgres Version 12, 13, 14, 15, 16
•  Experience in PostgreSQL Server DB Creation, User creation and Permissions, Object creation etc.
  
  
  

•  Only Critical servers are being monitored with existing team member
  
  
  

•  No of Database servers to be monitored are increased up to 80+
•  No of compliance points are 65 to be maintained on all 80+ Servers.
•  No consistent support from Off-Role team
•  Maintaining 100% uptime on all database servers
•  Regular database patching and VA resolution MoM
•  Maintain all Compliances (100+ compliances)
•  Yearly 8+ Audit management (include RBI / NPCI / ISO / PayU / ISMS / BCMS etc)
  
  
  

•  Qualifications
  
  
  

•  Work Experience
•  Should have good analytical and problem-solving skills.
•  Should have strong ownership.
•  Should have good communication skills.
•  RDBMS: Experience in PostgreSQL version 12,13,14,15,16, 17 etc.
•  Operating Systems: Knowledge of Linux technology RedHat, CentOS, Debian, etc.
•  Operating Systems: Experience in Windows 2008 R2/2012/2016/2019 Server, & Linux RedHat
•  Backup and Recovery: Experience of DB Backup and Disaster Recovery methods, with DR drill
•  HA/DR: Knowledge of HA\DR concepts.