PostgreSQL

PostgreSQL

- Experience managing PostgreSQL databases.

Install, configure, and upgrade PostgreSQL database systems on Linux platforms.
- Experience setting up and managing Cassandra or MongoDB or CosmosDB
- Monitor and manage database performance, capacity, and health to ensure optimal functionality and availability.
- Perform regular backups, recovery, and disaster recovery planning to safeguard critical data.
- Implement and maintain database security measures, including user access controls and data encryption, to protect sensitive information.
- Monitor and manage database performance, capacity, and health to ensure optimal functionality and availability.
- Perform regular backups, recovery, and disaster recovery planning to safeguard critical data.
- Implement and maintain database security measures, including user access controls and data encryption, to protect sensitive information.
- Monitor database access and audit logs to detect and address potential security breaches.
- Identify and resolve performance bottlenecks, optimize SQL queries, and tuning database configurations to enhance system performance.
- Analyze database performance metrics and provide recommendations for improvements.
- Diagnose and resolve database-related problems, ensuring minimal downtime and disruptions.
- Participate in database schema changes and version upgrades, ensuring compatibility and data migration.
- Maintain detailed documentation of database configurations, changes, and troubleshooting procedures.
- Prepare regular reports on database performance, growth, and capacity planning.
- Design and implement backup and recovery strategies to ensure data integrity and availability in case of failures.
- Enforce security policies and standards to comply with relevant regulations and best practices.
- Conduct regular security audits and vulnerability assessments.
- Monitor database access and audit logs to detect
- Proficiency in SQL and PL/pgSQL programming.
- Strong understanding of PostgreSQL architecture, replication, and clustering.
- Experience with PostgreSQL tools such as pgAdmin, pgBouncer, and psql.

Work Location: -Pune

5 Days working from home

Experience:- 7-12 Years