PostgreSQL DBA

Work Location: -Whitefield, Bangalore / Mepz, Chennai

5 Days working from Office

Experience:- 7+ Years

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.