AGM Tech Solutions, on behalf of our highly reputable Client, is proudly hiring top talent to join their innovative team.
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, GCP).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 databasesProven 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.Why Join Us?
Opportunity to work on cutting-edge database technologies.Collaborative and innovative work environment.Competitive compensation and benefits package.Additional Perks :
Excellent Market Rate / SalaryPositive Work-Life BalanceCompetitive Benefit Packages Including Medical Insurance, Dental Insurance.Company Overview :
AGM Tech Solutions is a Women-Minority owned Firm relationship-based IT Consulting firm dedicated to Serving our Clients Nationwide. Our dedicated team strives to exceed the expectations of our clients and employees by building long term relationships based on Integrity, Trust, Hard Work, Commitment and our service experience. We offer a consultative approach to each and every client by taking the time to listen to their needs and help them get where they want to go by becoming an extension of their organization. We provide Information Technology staffing : High caliber talent for temporary support and project Deliverables. Direct IT placement services : Contract-to-Hire Direct Hire professionals for longer-term needs.
