PostgreSQL Database Admin (m/f/d)
Upload My Resume
Drop here or click to browse · PDF, DOCX, DOC, RTF, TXT
Requirements
• Here's how you'll make a difference: • Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora. • Perform regular database maintenance tasks, including backup validation, replication checks, patching, and upgrades. • Collaborated with developers to optimize SQL and database objects, maintain PL/pgSQL routines, and contribute to data modeling initiatives to enhance performance. • Set up and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools. • Identify and improve slow-running queries. • Implement and manage access control, auditing, and security policies in line with organizational standards. • Create and maintain database documentation and deployment scripts. • Contribute to and follow best practices for schema changes, migrations, and version control of database objects (GitHub experience is a plus). • Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation. • What makes you a great fit: • Hands-on experience with PostgreSQL in production environments. • Hands-on experience with Amazon RDS for PostgreSQL, including provisioning, parameter groups, backups, and failover. • Hands-on experience integrating PostgreSQL with other AWS services (e.g., Lambda, S3). • Hands-on experience in writing and debugging SQL queries, developing and optimizing PL/pgSQL routines, managing views and materialized views, implementing and maintaining partitions. • Hands-on experience with performance tuning, query planning, and index optimization. • Familiarity with PostgreSQL monitoring tools such as pg_stat_statements, auto_explain, and others. • Solid understanding of database design, normalization, and data integrity constraints. • Experience collaborating with developers to understand application logic and improve data-layer performance. • Knowledge of CI/CD practices for database development (e.g., Github Actions) • Strong collaboration and communication, with the experience to explain database concepts to both developers and non-technical stakeholders. • Proactive problem-solving mindset, with a strong sense of ownership and commitment to identifying issues through to resolution. • Comfortable participating in code reviews and providing constructive suggestions to improve database interactions. • Willingness to participate in on-call duty.
Responsibilities
• Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora. • Perform regular database maintenance tasks such as backup validation, replication checks, patching, and upgrades. • Collaborate with developers to optimize SQL queries and manage PL/pgSQL routines for performance enhancement. • Set up and fine-tune PostgreSQL performance metrics using AWS CloudWatch tools like pg_stat_statements. • Identify slow-running queries and implement improvements. • Implement access control, auditing, and security policies in line with organizational standards. • Create and maintain database documentation and deployment scripts for development teams. • Contribute to schema changes, migrations, and version control of PostgreSQL objects using tools like GitHub (experience is a plus). • Participate in DevOps processes including CI/CD pipeline integration with the databases.
Benefits
• Performance tuning of PostgreSQL databases on Amazon RDS and Aurora services is a key responsibility in this role. • Regular database maintenance tasks such as backup validation, replication checks, patching, and upgrades are required to be performed by the candidate. • Collaboration with developers for optimizing SQL queries and contributing to data modeling initiatives will enhance performance is expected from candidates. • Setting up and fine-tuning database performance metrics, logs, and alerts using AWS CloudWatch tools like pg_stat_statements are part of the job responsibilities. • Implementing and managing access control, auditing, and security policies in line with organizational standards is a benefit included within this role's scope. • Creating and maintaining database documentation and deployment scripts will be necessary for candidates to perform their duties effectively. • Contributing to DevOps processes including the implementation of CI/CD pipelines and automation schema deployments are benefits provided in this job posting.