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 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./ 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 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 HADR concepts.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.