Senior PostgreSQL & Data Integration Engineer

Tata Consultancy Services; New Castle (DE); On-site; USD 90,000 - 130,000; Full time

Job summary

Tata Consultancy Services is seeking a qualified Database Administrator & SQL Specialist in the United States to design, implement and optimize PostgreSQL-based data solutions. The role emphasizes complex SQL, ETL development, data modelling and security across multi-environment deployments.

Candidates should demonstrate extensive experience with query performance tuning, data integration and production support, ensuring reliability and compliance in distributed data architectures.

Qualifications

• Must translate functional requirements into scalable relational database designs.
• Experience profiling datasets and validating data quality.
• Ability to design and implement ETL workflows and data mappings.
• Knowledge of backup, recovery, replication and high availability.

Responsibilities

• Design, develop and support ETL workflows for data integration.
• Analyse execution plans, identify bottlenecks and resolve query performance issues.
• Administer PostgreSQL databases across development, test and production environments.
• Ensure database security, roles, privileges, encryption and auditing.
• Collaborate with application, data engineering, architecture and QA teams to deliver reliable data solutions.

Skills

Advanced SQL

Query optimization

PostgreSQL

Data modelling

ETL development

Data integration

Data security

SQL performance analysis

Documentation

Education

Bachelor of Computer Science

Job description

Tata Consultancy Services is seeking a qualified Database Administrator & SQL Specialist in the United States to design, implement and optimize PostgreSQL-based data solutions. The role emphasizes complex SQL, ETL development, data modelling and security across multi-environment deployments.

Candidates should demonstrate extensive experience with query performance tuning, data integration and production support, ensuring reliability and compliance in distributed data architectures.