Job Title : PostgreSQL Database Administrator
Job Summary :
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. The DBA will be responsible for the performance, integrity, and security of our PostgreSQL databases.
You will manage database optimization, maintenance, troubleshooting, and data migration, while ensuring high availability and optimal performance across our database systems.
Key Responsibilities :
- Database Management : Install, configure, and maintain PostgreSQL database servers. Ensure the databases are running efficiently and are optimized for performance and scalability.
- Performance Tuning : Monitor database performance and tune as needed for optimal performance (queries, indexes, execution plans).
- Backup & Recovery : Design and implement robust backup, recovery, and failover strategies. Ensure disaster recovery capabilities.
- Security Management : Implement and maintain security protocols to protect sensitive data, including roles, permissions, encryption, and access controls.
- Database Design & Development : Work with developers to design schema, optimize queries, and ensure efficient database interactions in support of application development.
- Replication & Clustering : Set up, configure, and manage PostgreSQL replication and clustering for high availability.
- Database Monitoring : Use tools to monitor the database and proactively identify potential issues. Respond quickly to database-related alerts and escalations.
- Troubleshooting & Support : Troubleshoot and resolve complex database issues, including query performance, locking, connectivity, and resource contention.
- Database Upgrades & Patching : Plan and execute database version upgrades and security patches with minimal downtime.
- Documentation : Maintain up-to-date documentation for database architecture, configurations, processes, and best practices.
- Education : Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
- Experience : 9+ years of hands-on experience as a PostgreSQL DBA.
- Skills :
- Expertise in PostgreSQL database architecture, design, and management.
- Strong experience in SQL performance tuning and optimization.
- Proficiency with backup and recovery strategies.
- Knowledge of database replication and clustering techniques.
- Familiarity with PostgreSQL extensions and tools like pgAdmin, pgBouncer, and pg stat statements.
- Solid understanding of database security and encryption.
- Experience with scripting languages like Python, Bash, or SQL scripts.
- Strong problem-solving skills with the ability to troubleshoot and resolve database issues.
Preferred Qualifications :
- PostgreSQL certification is a plus.
- Familiarity with cloud database platforms like AWS RDS, Azure Database for PostgreSQL, or Google Cloud SQL.
- Experience with database automation and orchestration tools.
- Knowledge of containerization technologies like Docker and Kubernetes.
Postgresql DBA
PostgreSQL DBA (Database Administrator) is responsible for managing and maintaining PostgreSQL databases to ensure performance, security, and data integrity. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. SQ...
PostgreSQL DBA
PostgreSQL DBA (Database Administrator) is responsible for managing and maintaining PostgreSQL databases to ensure performance, security, and data integrity. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. SQ...
PostgreSQL DBA
Good experience PostgreSQL DBA activities. PostgreSQL database Administration, in-depth hands-on experience is a must. Strong experience in PostgreSQL Performance Tuning and Optimization. Skilled at optimizing large, complicated SQL statements in PostgreSQL. ...
PostgreSQL DBA (Database Administrator)
PostgreSQL DBA (Database Administrator) is responsible for managing and maintaining PostgreSQL databases to ensure performance, security, and data integrity. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. SQ...
PostgreSQL DBA
PostgreSQL DBA (Database Administrator) is responsible for managing and maintaining PostgreSQL databases to ensure performance, security, and data integrity. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. Jo...
PostgreSql DBA
Job Title: PostgreSQL Database Administrator</b></div> <div> </div> <div><b> </b> <b>Job Summary:</b> <p>We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) to join our team. The DBA will be responsible ...
Senior Software Engineer - Data Platforms
Be part of a group of engineers building data pipelines using big data technologies (Spark, Flink, Kafka, Snowflake, AWS Big Data Services, Snowflake, Redshift) on medium to large scale datasets. Senior Software Engineer - Data Platforms. As a Capital One Data Engineer, you’ll have the opportunity t...
Principal DBA /SQL Server Administrator
MS SQL Server, Azure Synapse, Postgres, AWS Aurora, Cosmos) to support high volume OLTP systems. Hands on experience with SQL and DB performance tuning and rapid problem troubleshooting/resolution. Teachable and embracing of best practices and feedback as a means of continuous improvement. ...
Software Engineer Senior (Database/ Data Modeling)
As the Senior Software Engineer for (Database/ Data Modeling)in Houston, Texas for ENGIE FlexGen (Flexible Generation including Storage, Thermal, and Hydrogen) North America you will be the lead software developer focused on design, development and implementation of the database architecture for the...
Data Analyst I
Develop and maintain databases by acquiring data from primary and secondary sources, and build scripts that will make our data evaluation process more flexible or scalable across datasets. Data Analyst I\n\nPurpose:\nIdentify trends and opportunities for growth through analysis of complex datasets w...