Senior Tech Ops Engineer
Bajaj Finance Limited
Full-time
On-site
Pune, Maharashtra, India
| Job Purpose | Database Administrator job consist of installation, database creation, performance monitoring, Data security, troubleshooting, Daily backup tracking, Database Migration & Upgrade, New environment creation, Database Compliance deployment, Issue trouble shooting, Performance/Impact analysis, Database alert tracking, incident tracking, 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. • Database Migration and Upgrade/patching • New environment creation (on Azure and AWS) • Database compliance deployment and tracking • Issue trouble shooting • Performance/Impact analysis • 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 | a) Qualifications 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 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. |