PostgresSQL DBA - Tata Consultancy Services

About TCS :

Tata Consultancy Services is an Indian multinational information technology services and consulting company with its headquarters in Mumbai. It is a part of the Tata Group and operates in 150 locations across 46 countries. In July 2022, it was reported that TCS had over 600,000 employees worldwide.

About Job:

Job Title: PostgreSQL DBA

Location

Las Vegas, NV

Job Type: Full Time

Technical skills:

Essential Job Functions

• 10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS.

• Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS

• Working Knowledge of EDB, Oracle, SQL Server and AWS Day to Day operation on S3 EC2 etc

• Should be able to implement effective and maintainable database coding practices that form an architectural foundation

• Experience in Postgres SQL performance improvement, indexing/other approaches, Good experience on partitioning database

• Experience with message queuing, full-text indexing, and other high-performance data concepts

• Experience in AWS environment management and knowledge of different tools for the same

• Experience in Postgres SQL migration approach, estimating it, and technically managing it

• Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys

• Ability to efficiently write database code without compromising data quality, privacy, or security.

• Hands-on Experience in Jira, GitHub, Ansible & Terraform.

• Good understanding of CI/CD using GitLab

• Good understanding of the Batch process and Job scheduling automation

• Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels

• Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong

analytical, and interpersonal communication skills

• Must possess good communication skills, both in verbal and in written form, and be Proficient in identifying, analyzing, and solving problems for Client facing experience

Position Requirements

• AWS RDS hands-on experience

• Capacity planning, performance assessment of AWS RDSs

• Strong Postgres/SQL Server DB administration experience in production environments

• Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database

• Experience in managing multiple RDS, database versions on large systems

• Practical experience in monitoring

• Knowledge of reporting and query tools and practices

• Experience in using Performance Insights, RDS KPI design and management.

• Working knowledge of Lambda, Python

• Strong technical and functional experience in PostgreSQL Administration and associated tools like PgBouncer, PgPool and other related binaries.