20 Aug
|
Parag Parikh Financial Advisory Services(PPFAS)
|
Mumbai
20 Aug
Parag Parikh Financial Advisory Services(PPFAS)
Mumbai
Job Summary The Database Administrator (DBA) will be responsible for the administration, security, performance, availability, and governance of the organizations database platforms across on-premises and cloud environments. The role requires robust hands-on expertise in Microsoft SQL Server, PostgreSQL, MySQL, AWS RDS, and high-availability architectures, with Oracle exposure being an added advantage. The incumbent will own database operations, performance optimization, backup and recovery, disaster recovery readiness, security compliance, automation initiatives, and database infrastructure modernization.
Key Responsibilities
Database Administration Performance Management
- Administer, maintain, secure, and optimize SQL Server, PostgreSQL, MySQL, AWS RDS, and Oracle databases.
- Manage database lifecycle activities including installation, configuration, patching, upgrades, migrations, and decommissioning.
- Monitor database health, availability, resource utilization, query performance, indexing strategies, and capacity planning.
- Perform performance tuning, bottleneck analysis, execution plan reviews, and optimization of production, DR, UAT, and development environments.
AWS RDS Cloud Database Operations
- Administer AWS RDS environments, including parameter groups, option groups, snapshots, backup policies, maintenance windows, security configurations, and storage management.
- Support on-premises to cloud migrations and optimize cloud database architectures for performance, scalability, resilience, and cost efficiency.
- Drive AWS database cost optimization initiatives.
Backup, Recovery Disaster Recovery
- Design and manage enterprise backup, recovery, retention, and archival strategies aligned to defined RPO/RTO objectives.
- Conduct restoration testing, backup validation, DR drills, failover testing, and recovery exercises.
- Manage replication, clustering, Always-On Availability Groups, log shipping, standby environments, and synchronization mechanisms.
- Maintain documentation, SOP, test reports, and operational readiness of DC and DR environments.
Database Security, Compliance Governance
- Implement database security controls including access management, auditing, encryption, activity monitoring, privilege management, and hardening.
- Support vulnerability remediation, security reviews, compliance audits, and regulatory requirements.
- Ensure adherence to organizational standards for data retention, data protection, and governance.
Monitoring, Automation Collaboration
- Implement monitoring, alerts, dashboards, health reports, utilization reporting, and proactive risk management practices.
- Drive automation of routine database administration and maintenance activities.
- Support application deployments, upgrades, modernization projects, architecture reviews, and database migrations.
- Act as the escalation point for critical incidents and provide technical guidance to junior team members.
Qualifications Experience
- Bachelor s Degree or higher in Computer Science, Information Technology, Engineering, or related discipline.
- 5-8 years of hands-on experience managing enterprise database environments with high-availability requirements.
- Proven experience supporting cloud-hosted databases, particularly AWS RDS.
Mandatory Technical Skills Microsoft SQL Server - PostgreSQL - MySQL - AWS RDS - Database Performance Tuning - Query Optimization - High Availability Disaster Recovery - Backup Recovery - Replication Technologies - Database Security Hardening - SQL Scripting Stored Procedures - Capacity Planning - Database Monitoring - Database Migration Upgrade Management - Windows Linux Server Administration.
Preferred Skills Certifications
Skills: Oracle Database Administration, PowerShell/Shell/Python Automation, AWS Cloud Services, Infrastructure Monitoring Platforms, DevOps CI/CD Concepts, Database Automation Tools.
Certifications: Microsoft SQL Server, PostgreSQL, AWS Database Specialty/Associate, MySQL Administration, Oracle Certified Professional (OCP) or equivalent.
Core Competencies
Strong analytical and troubleshooting skills, database performance engineering expertise, ownership mindset, operational excellence, incident management capability, documentation proficiency, stakeholder management, and proactive risk mitigation.
Working Conditions
Participation in database upgrades, migrations, DR exercises, maintenance windows, on-call support, critical incident response, and business continuity activities outside standard business hours may be required.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Database Administrator - IT Operations Management (Mumbai)
🏢 Parag Parikh Financial Advisory Services(PPFAS)
📍 Mumbai