Talent.com
Engineer

Engineer

Tata Consultancy ServicesAshburnham, MA, United States
10 days ago
Job type
  • Full-time
Job description

PostgreSQL

Overview

  • 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.

Roles and Responsibilities

  • 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 lon g-term strategic goals for database development in alignment with stakeholders.

    • Required Skills :

  • 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.

    • Salary Range- $90,000-$110,000 a year

    #LI-SP3 #LI-VX1

    Create a job alert for this search

    Engineer • Ashburnham, MA, United States