Database Administrator

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

Job Description

• Advanced SQL: Strong hands-on expertise in writing, reviewing and optimising complex SQL queries, joins, subqueries, views, stored procedures, functions and triggers.
• Query performance: Ability to analyse execution plans, identify

Database Administration and SQL

• Advanced SQL: Strong hands-on expertise in writing, reviewing and optimising complex SQL queries, joins, subqueries, views, stored procedures, functions and triggers.
• Query performance: Ability to analyse execution plans, identify bottlenecks, optimise indexes and queries, and resolve locking, blocking and long-running transaction issues.
• PostgreSQL administration: Proven experience installing, configuring, upgrading, patching and administering PostgreSQL databases across development, test and production environments.
• Database operations: Experience with backup and recovery, point-in-time recovery, replication, high availability, failover, capacity planning, storage management, monitoring and routine maintenance.
• Security and compliance: Strong understanding of roles, privileges, authentication, encryption, auditing, data protection and database security standards.

Database Design, Data Modelling and Analysis

• Database design: Ability to translate functional and non-functional requirements into scalable, secure and maintainable relational database designs.
• Data modelling: Strong experience creating conceptual, logical and physical data models, entity-relationship diagrams, schemas, tables, keys, constraints and data dictionaries.
• Normalisation: Sound knowledge of normalisation and denormalisation techniques, referential integrity, data quality controls and appropriate modelling patterns.
• Data analysis: Ability to profile and analyse datasets, identify relationships and anomalies, validate data quality, reconcile results and support root-cause analysis.
• Documentation: Experience maintaining database standards, design specifications, lineage, metadata and operational runbooks.

ETL and Data Integration

• ETL development: Hands-on experience designing, developing, scheduling and supporting ETL workflows for extracting, transforming and loading data across heterogeneous sources and targets.
• Data transformation: Strong knowledge of data mapping, cleansing, validation, deduplication, reconciliation, error handling and restart/recovery processes.
• Performance and reliability: Ability to optimise batch loads, manage large data volumes, implement incremental and change-data-capture patterns, and monitor pipeline performance.
• Production support: Experience troubleshooting database and ETL failures, conducting root-cause analysis, implementing permanent fixes and supporting controlled releases.
• Collaboration: Ability to work effectively with applica tion, data engineering, architecture, infrastructure and business teams to deliver reliable data solutions.
• Administer, configure, patch, upgrade and maintain PostgreSQL databases across development, test and production environments.
• Design and implement scalable relational database structures, including schemas, tables, keys, constraints, indexes and data dictionaries.
• Develop, review and optimise complex SQL queries, views, stored procedures, functions and triggers for transactional and reporting requirements.
• Monitor database health and performance; analyse execution plans and resolve query bottlenecks, locking, blocking and long-running transactions.
• Manage backup, restore, point-in-time recovery, replication, high availability and failover processes, and regularly validate recoverability.
• Perform capacity planning, storage management, routine maintenance and proactive monitoring to ensure database availability, scalability and reliability.
• Create and maintain conceptual, logical and physical data models; apply normalisation, denormalisation and referential-integrity standards.
• Profile and analyse data, identify anomalies, validate data quality, reconcile results and support root-cause analysis.
• Design, develop, schedule and support ETL workflows, including data mapping, cleansing, transformation, validation, deduplication and error handling.
• Optimise batch and large-volume data loads, and implement incremental-load and change-data-capture patterns where required.
• Implement and maintain database security controls covering roles, privileges, authentication, encryption, auditing and data protection.
• Troubleshoot database and ETL incidents, implement permanent fixes, support controlled releases and maintain operational runbooks, metadata and data-lineage documentation.
• Collaborate with application, data engineering, architecture, infrastructure, QA and business teams to deliver secure and reliable data solutions.

Salary Range: $90,000 to $130,000 per year

Qualifications:

BACHELOR OF COMPUTER SCIENCE