PostgreSQL

As an experienced PostgreSQL Database Administrator, you will be responsible for managing PostgreSQL databases on Linux platforms, ensuring their optimal functionality and availability. Your key responsibilities will include: - Installing, configuring, and upgrading PostgreSQL database systems - Setting up and managing other databases like Cassandra, MongoDB, or CosmosDB - Monitoring and managing database performance, capacity, and health - Performing regular backups, recovery, and disaster recovery planning - Implementing and maintaining database security measures such as user access controls and data encryption - Identifying and resolving performance bottlenecks, optimizing SQL queries, and tuning database configurations - Analyzing performance metrics and providing recommendations for improvements - Diagnosing and resolving database-related problems with minimal downtime - Participating in database schema changes, version upgrades, and data migration - Maintaining detailed documentation of configurations, changes, and troubleshooting procedures - Designing and implementing backup and recovery strategies for data integrity and availability - Enforcing security policies to comply with regulations and best practices - Conducting regular security audits and vulnerability assessments Additionally, your experience should include proficiency in SQL and PL/pgSQL programming, a strong understanding of PostgreSQL architecture, replication, and clustering, as well as familiarity with PostgreSQL tools like pgAdmin, pgBouncer, and psql. The work location for this position is Pune, with the flexibility of 5 days working from home. The ideal candidate will have 7-12 years of relevant experience in managing PostgreSQL databases. As an experienced PostgreSQL Database Administrator, you will be responsible for managing PostgreSQL databases on Linux platforms, ensuring their optimal functionality and availability. Your key responsibilities will include: - Installing, configuring, and upgrading PostgreSQL database systems - Setting up and managing other databases like Cassandra, MongoDB, or CosmosDB - Monitoring and managing database performance, capacity, and health - Performing regular backups, recovery, and disaster recovery planning - Implementing and maintaining database security measures such as user access controls and data encryption - Identifying and resolving performance bottlenecks, optimizing SQL queries, and tuning database configurations - Analyzing performance metrics and providing recommendations for improvements - Diagnosing and resolving database-related problems with minimal downtime - Participating in database schema changes, version upgrades, and data migration - Maintaining detailed documentation of configurations, changes, and troubleshooting procedures - Designing and implementing backup and recovery strategies for data integrity and availability - Enforcing security policies to comply with regulations and best practices - Conducting regular security audits and vulnerability assessments Additionally, your experience should include proficiency in SQL and PL/pgSQL programming, a strong understanding of PostgreSQL architecture, replication, and clustering, as well as familiarity with PostgreSQL tools like pgAdmin, pgBouncer, and psql. The work location for this position is Pune, with the flexibility of 5 days working from home. The ideal candidate will have 7-12 years of relevant experience in managing PostgreSQL databases.