01 Sep
|
Softenger
|
Mumbai
Postgre SQL Database Administrator (DBA)Experience: 4+ Years Employment Type: Full-time Job Location: Mumbai Shift: 24/7 Job Summary : We are looking for an experienced Postgre SQL Database Administrator (DBA) with 4+ years of hands-on experience in database administration, performance tuning, security, troubleshooting, migration, and high-availability environments. The ideal candidate will be responsible for managing and maintaining Postgre SQL databases, ensuring high availability, performance, integrity, security, and compliance. The candidate should have strong experience in database troubleshooting, hardening, patching, clustering, migration, user management, maintenance activities, and performance optimization.
Key Responsibilities Manage, maintain, and administer Postgre SQL databases across development, testing, and production environments. Monitor database health, availability, performance, capacity, and key database metrics. Perform database performance tuning and optimization, including query and configuration optimization.
Troubleshoot database issues, identify root causes, and implement effective solutions. Perform database hardening, patching, upgrades, and security-related activities. Design, configure, and maintain Postgre SQL database clusters and high-availability environments.
Plan and execute database migrations and version upgrades with minimal downtime. Configure and manage Foreign Data Wrappers (FDW) and related database integrations. Implement and maintain database backup, recovery, and disaster recovery processes.
Manage database replication and ensure data consistency and availability. Manage database users, roles, permissions, access controls, and security policies. Ensure database data integrity, security, and availability in accordance with organizational standards.
Collaborate closely with development, Dev Ops, infrastructure,
and operations teams to support application and database requirements. Automate repetitive database administration tasks using scripts and appropriate tools. Develop and maintain database scripts, utilities, monitoring processes, and operational documentation.
Conduct database capacity planning and proactively identify potential performance or storage issues. Maintain database standards, procedures, architecture documentation, and operational runbooks. Ensure compliance with applicable data protection and security requirements.
Stay current with Postgre SQL releases, database technologies, best practices, and industry trends. Must-Have Skills Postgre SQL Database Administration – 4–6 years Strong experience in database troubleshooting Hands-on experience with database hardening and patching Experience in Postgre SQL cluster setup and configuration Strong knowledge of Foreign Data Wrappers (FDW)Hands-on experience with database migration and version upgrades Experience with database maintenance jobs and activities Strong experience in database user and role management Solid knowledge of database performance monitoring, tuning, and optimization Experience with backup and recovery processes Good understanding of database security, availability, and data integrity Good-to-Have Skills Experience with Postgre SQL replication Knowledge of high-availability and disaster recovery solutions Experience with database monitoring and automation tools Exposure to cloud-based database environments Knowledge of scripting/automation for database administration What We’re Looking For Strong analytical and troubleshooting skills Ability to work independently and resolve complex database issues Good communication and collaboration skills Strong focus on database security, reliability, and performance Ability to work effectively with cross-functional development and operations teams
📌 Database Administrator (Mumbai)
🏢 Softenger
📍 Mumbai