PostgreSQL DBA

PostgreSQL DBA Long Term Contract
Hybrid 3x weekly in Pasadena
Position Overview:

We are seeking a highly skilled Senior PostgreSQL DBA to develop, implement, and maintain scalable, secure, and efficient database solutions. This role is a key member of the database team, supporting the effort in migration, development, optimizing performance, ensuring data security, and collaborating across teams to support business needs. The ideal candidate has extensive expertise in PostgreSQL, database design principles, and a strong understanding of cloud-based and on-premises environments.

KEY RESPONSIBILITIES-

Database Development and Support:

• Develop and Support high-performance PostgreSQL databases.
• Develop schema designs that balance performance, scalability, and reliability.
• Ensure database solutions align with business goals and technical requirements.

Performance Tuning and Optimization:

• Analyze and optimize complex SQL queries, indexes, and database performance.
• Identify and resolve performance bottlenecks in existing systems.
• Implement partitioning, sharding, and other techniques to handle large-scale data sets.

Database Security and Compliance:

• Ensure compliance with security standards and data protection regulations.
• Implement database access controls, encryption, and backup strategies.
• Perform regular security audits and vulnerability assessments.

Cloud Integration and Management:

• Develop, support, and manage PostgreSQL databases in cloud environments (AWS, Azure, Google Cloud Platform).
• Leverage cloud-native tools for scaling, monitoring, and disaster recovery.

Team Leadership and Collaboration:

• Collaborate with development teams to design and implement database solutions.
• Provide guidance and mentorship to junior database engineers and administrators.
• Work closely with DevOps teams to automate database deployment and maintenance.

Documentation and Best Practices:

• Develop and maintain comprehensive database documentation.
• Promote best practices in database development and management.

QUALIFICATIONS-

Education:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

Experience:

• 8 years of experience in database architecture, with a focus on PostgreSQL.
• Expertise in SQL development and creation of new databases
• Proven expertise in migration, support, and management of large-scale PostgreSQL databases.
• Experience in cloud-based database management and tools (AWS RDS, Aurora, etc.).

Technical Skills:

• Deep understanding of PostgreSQL internals, performance tuning, and optimization.
• Proficient in SQL, PL/pgSQL, and database modeling.
• Familiarity with tools like pgAdmin, pgBouncer, and replication techniques.
• Experience with ETL processes and integrating PostgreSQL with data pipelines.
• Knowledge of high availability, clustering, and disaster recovery solutions.

Soft Skills:

• Strong problem-solving skills and attention to detail.
• Excellent communication and ability to translate technical concepts to stakeholders.
• Leadership and mentoring experience in a technical setting.

Preferred Qualifications:

• Experience with NoSQL and hybrid database solutions.
• Certifications in PostgreSQL or cloud platforms (e.g., AWS Certified Database Specialty).
• Knowledge of containerization (Docker, Kubernetes) and Infrastructure-as-Code tools.