Tata Consultancy Services
Database Administrator
Tata Consultancy Services - St Louis, Missouri, United States
Work at Tata Consultancy Services
Overview
- View job
Overview
PostgreSQL DBA
• Provide world-class support and expertise for Postgres database environments.
• Database Architects set the direction for enterprise leadership by designing and building highly available, scalable, and efficient solutions that adhere to standards and security policies.
• Represent Database Engineering team as a subject matter expert in EDB Postgres, Postgres Distributed (PGD), and AWS relational database services.
• 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 int ernal 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. • Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS. • Deep understanding of EDB Postgres architecture and internals. • Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from Enterprise DB. • 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
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 int ernal 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. • Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS. • Deep understanding of EDB Postgres architecture and internals. • Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from Enterprise DB. • 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