Engineer

TATA Consulting Services•Saint Louis, MO

47d•$90,000 - $110,000

About The Position

Represent Database Engineering team as a subject matter expert in EDB Postgres, Postgres Distributed (PGD), and AWS relational database services. Expectation is Level 3 and above with good AWS Experience Continuously seek opportunities to improve efficiency and integrate technologies and platforms within the Postgres and related domains. 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.

Requirements

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. Familiarity with observability tools like Splunk and Dynatrace is a plus.
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.
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.

Responsibilities

Designing, deploying, and maintaining EDB Postgres, PGD and AWS RDS database clusters to support large-scale platforms and applications.
Creating and managing fully functional database clusters across development, QA, and production environments, with experience in performance tuning.
Reviewing existing configurations and recommend improvements.
Assisting with planning and executing Postgres database upgrades and migrations.
Providing day-to-day administrative support and maintenance for Postgres and AWS Aurora databases.
Participating in production support and on-call rotations as needed.
Collaborating with Postgres and cloud vendors and utilize their support channels.
Developing and implementing backup strategies, perform upgrades, and apply patches.
Identifying inefficiencies and implement optimized solutions.
Designing and execute data and database migrations to new hardware or platforms.
Leading best practices and database solution strategies
Working with management to plan and implement new tools and data services.
Representing Database Engineering in strategic planning and long-term direction.
Supporting both internal and future cloud-managed Postgres systems, define best practices, and drive automation and innovation.
Collaborating with multiple application teams and developers.
Assisting in defining lon g-term strategic goals for database development in alignment with stakeholders.