Centraprise ยท 3 weeks ago
Postgres SQL DBA
St Louis, MO
Contract
Onsite
Mid, Senior Level
4+ years expCentraprise is seeking a Postgres SQL DBA to join their Database Engineering team. The role involves providing leadership in EDB Postgres and AWS relational database services, as well as managing and maintaining database clusters to support large-scale platforms and applications.
EmploymentRecruitingStaffing Agency
Hiring Manager
Manav Singh
Responsibilities
Represent Database Engineering team as a subject matter expert in EDB Postgres, Postgres Distributed (PGD), and AWS relational database services
Provide leadership and contribute to technology roadmaps supporting vision for Postgres and other relational database technologies
Possess experience with data migration and integration across multiple systems
Excellent interpersonal and communication skills
Strong collaboration skills to work effectively across cross-functional teams
Forward-thinking approach to infrastructure automation and scripting
Ability to work with global teams across multiple time zones
Self-motivated with the ability to work independently and seek guidance when needed
Ability to understand application data requirements and recommend appropriate database solutions
Responsible for designing, deploying, and maintaining EDB Postgres, PGD and AWS RDS database clusters to support large-scale platforms and applications
Create and manage fully functional database clusters across development, QA, and production environments, with experience in performance tuning
Review existing configurations and recommend improvements
Assist with planning and executing Postgres database upgrades and migrations
Provide day-to-day administrative support and maintenance for Postgres and AWS Aurora databases
Participate in production support and on-call rotations as needed
Collaborate with Postgres and cloud vendors and utilize their support channels
Develop and implement backup strategies, perform upgrades, and apply patches
Identify inefficiencies and implement optimized solutions
Design and execute data and database migrations to new hardware or platforms
Lead best practices and database solution strategies
Work with management to plan and implement new tools and data services
Represent Database Engineering in strategic planning and long-term direction
Support both internal and future cloud-managed Postgres systems, define best practices, and drive automation and innovation
Collaborate with multiple application teams and developers
Assist in defining long-term strategic goals for database development in alignment with stakeholders
Qualification
Required
Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS
Deep understanding of EDB Postgres architecture and internals
Expertise in Table Partitioning on Large Data sets
Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB
Skilled in PostgreSQL monitoring and alerting tools, particularly PEM
Experienced in setting up, configuring, and monitoring PostgreSQL binary and logical replication (e.g., Binary Streaming, Bi-Directional Replication - BDR)
Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance
Proficient in PostgreSQL procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL
Excellent troubleshooting and debugging skills
Experience in performance tuning and automation for Postgres and AWS platforms
Proficient in Linux, especially Oracle Linux Enterprise
Familiarity with scripting languages such as Bash, KSH, and Perl
Preferred
Familiarity with observability tools like Splunk and Dynatrace
Company
Centraprise
Centraprise is an executive search and direct hire company.
501-1000 employees
H1B Sponsorship
Centraprise has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (34)
2024 (16)
2023 (49)
2022 (35)
2021 (42)
2020 (125)
Funding
Current Stage
Late StageLeadership Team
Praveen Mummaneni
Chief Executive Officer
Anand Bandarupally
Managing Partner - Developing Recruitment and Business Development
Company data provided by crunchbase