New 
Database Administrator
 Tata Consultancy Services | |
$90,000 - $130,000
| |
 United States, Delaware, New Castle | |
 Oct 28, 2026 | |
|
Job Description
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 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
Location
New Castle, DE
Function
TECHNOLOGY
Role
Engineer
ID
430265
Skills
Data Modelling | SQL | Postgres DBA | Postgresql DBA
Salary Range
$90,000 - $130,000 Desired Candidate Profile
Qualifications BACHELOR OF COMPUTER SCIENCE | |