Database Administrator (PostgreSQL)

K&K Global Talent Solutions Inc. is an international recruiting agency that has been providing technical resources in the Canada and the USA region since 1993.

This position is with one of our clients in USA, who is actively hiring candidates to expand their teams.

 

Role:- Database Administrator (PostgreSQL)   

Location:- New Castle, DE / Jersey City, NJ / Tampa, FL (onsite)   

Fulltime

 

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.