Sr. PostgreSQL Database Engineer (DBA)

Job Title: Sr. PostgreSQL Database Engineer (DBA)

Job Summary:

Senior PostgreSQL Database Engineer/Database Administrator is responsible for Install, configure, and upgrade PostgreSQL database systems, designing, implementing, maintaining, and optimizing PostgreSQL database systems on Linux platform to support enterprise applications and business requirements. This role involves ensuring high availability, scalability, and performance while adhering to industry best practices for database security and compliance. The ideal candidate will collaborate with development, operations, and analytics teams to deliver efficient and reliable database solutions.

Platform: Linux

Required Skills and Qualifications:

• 7+ years of experience managing PostgreSQL databases. Install, configure, and upgrade PostgreSQL database systems on Linux platforms.
• 2+ years of 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.

Key Responsibilities:

Database Design and Development:

• Design and implement PostgreSQL database schemas, tables, views, and indexes to meet application and business requirements.
• Develop and maintain SQL queries, stored procedures, triggers, and functions using PL/pgSQL.
• Support database architecture and modeling for structured and semi-structured data.

Database Administration and Maintenance:

• Install, configure, and upgrade PostgreSQL databases and extensions.
• Perform routine database maintenance, including backups, restores, and upgrades.
• Monitor and manage database health, ensuring uptime and performance.

Performance Tuning and Optimization:

• Identify and resolve database performance bottlenecks using PostgreSQL performance tools.
• Optimize query execution plans, indexing strategies, and configurations.
• Conduct performance benchmarking and implement improvements for high-volume databases.

Data Security and Compliance:

• Implement security policies, roles, and access controls to protect sensitive data.
• Ensure database compliance with organizational standards and industry regulations.
• Monitor and audit database activity and security logs.

Data Integration and Automation:

• Develop and manage ETL workflows for data integration and migration projects.
• Automate database management tasks using tools and scripts (e.g., pgAdmin, pgBouncer, shell scripts).
• Collaborate with DevOps teams to integrate PostgreSQL databases into CI/CD pipelines.

Collaboration and Support:

• Collaborate with developers, analysts, and infrastructure teams to meet database requirements.
• Troubleshoot and resolve database-related issues in development and production environments.
• Provide technical guidance and training to team members as needed.

Documentation and Reporting:

• Document database configurations, procedures, and operational best practices.
• Generate reports and dashboards on database performance and usage metrics.

Preferred Qualifications:

• Familiarity with PostgreSQL features like partitioning, JSON/JSONB, and full-text search.
• Experience with cloud platforms such as AWS RDS, Google Cloud SQL, or Azure Database for PostgreSQL.
• Knowledge of DevOps practices, CI/CD pipelines, and database automation tools.
• Understanding of data modeling and normalization principles.
• Certifications such as PostgreSQL Certified Engineer or AWS Database Specialty.