> Markdown version of [/jobs/ext/2661191-postgresql-database-administrator](https://www.wearedevelopers.com/jobs/ext/2661191-postgresql-database-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # PostgreSQL Database Administrator - **Company:** S&K GLOBAL SOLUTIONS LLC - **Location:** Tampa, FL, United States - **Contract:** Permanent contract - **Skills:** Query Performance, Data Analysis, User Authentication, Big Data, Databases, System Configuration, Data Deduplication, Data Dictionary, Information Engineering, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Systems, Relational Databases, Database Design, Database Security, Entity Relationship Models, Failover, PostgreSQL, Metadata, Standard Sql, Runbook, SQL Stored Procedures, SQL Databases, Freeform SQL, Data Storage Management, Sql Optimization, System Availability, Change Data Capture, Performance Monitor - **Published:** August 31, 2026 - **Apply:** https://www.dice.com/job-detail/71df3bac-a263-4cdc-ac7e-54f86eb3e639 ## About the Role 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. ## Description * 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Technical Documentation - How Can I Write Them Better and Why Should I Care?](https://www.wearedevelopers.com/videos/681-technical-documentation-how-can-i-write-them-better-and-why-should-i-care) - [System Resilience: Surviving the Software Storm](https://www.wearedevelopers.com/videos/874-system-resilience-surviving-the-software-storm) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Bridging AI and Nomad: a Go-based MCP Server for Cluster Control](https://www.wearedevelopers.com/videos/2063-bridging-ai-and-nomad-a-go-based-mcp-server-for-cluster-control) ## Related Articles - [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Effortlessly Scale Prometheus With The Telemetry Data Platform – And Keep your Grafana Dashboards, Too!](https://www.wearedevelopers.com/magazine/3-effortlessly-scale-prometheus-with-the-telemetry-data-platform-and-keep-your-grafana-dashboards-too)