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.
B- Additional Accountabilities Pertaining To The Role
Key Decisions / Dimensions
- Only Critical servers are being monitored with existing team member
Major Challenges
- 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)
Required Qualifications And Experience
Minimum qualification required is B.E./B.Tech/BSC-IT with minimum of 2.5+ Years of experience in PostgreSQL DBA
- 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.