Tata Consultancy Services
Database Administrator
Tata Consultancy Services, Ashburnham, Massachusetts, United States, 01466
Join to apply for the
Database Administrator
role at
Tata Consultancy Services Overview
Role focused on providing world-class support and expertise for PostgreSQL database environments, with leadership in designing, deploying, and maintaining scalable and secure database solutions. Responsibilities
Provide world-class support and expertise for Postgres database environments. 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. Design, deploy, and maintain 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. 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 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. Qualifications
Experience with PostgreSQL, EDB Postgres, PGD, and AWS RDS/Aurora. Strong Linux system administration and scripting skills (Bash, KSH, Perl). Proficiency in database design, tuning, migration, and disaster recovery planning. Familiarity with observability and monitoring tools (e.g., PEM, Splunk, Dynatrace). Ability to work with global teams across multiple time zones. Excellent interpersonal and communication skills; strong collaboration with cross-functional teams. Salary
Salary Range- $85,000-$90,000 a year Employment details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Information Technology Industries: IT Services and IT Consulting Referrals increase your chances of interviewing at Tata Consultancy Services by 2x #J-18808-Ljbffr
Database Administrator
role at
Tata Consultancy Services Overview
Role focused on providing world-class support and expertise for PostgreSQL database environments, with leadership in designing, deploying, and maintaining scalable and secure database solutions. Responsibilities
Provide world-class support and expertise for Postgres database environments. 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. Design, deploy, and maintain 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. 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 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. Qualifications
Experience with PostgreSQL, EDB Postgres, PGD, and AWS RDS/Aurora. Strong Linux system administration and scripting skills (Bash, KSH, Perl). Proficiency in database design, tuning, migration, and disaster recovery planning. Familiarity with observability and monitoring tools (e.g., PEM, Splunk, Dynatrace). Ability to work with global teams across multiple time zones. Excellent interpersonal and communication skills; strong collaboration with cross-functional teams. Salary
Salary Range- $85,000-$90,000 a year Employment details
Seniority level: Mid-Senior level Employment type: Full-time Job function: Information Technology Industries: IT Services and IT Consulting Referrals increase your chances of interviewing at Tata Consultancy Services by 2x #J-18808-Ljbffr