{"schemaVersion":"jobsearcher.job.v1","id":"ab4c60218c3b8a7d33f5b0df","url":"https://jobsearcher.com/jobs/ab4c60218c3b8a7d33f5b0df","canonicalUrl":"https://jobsearcher.com/jobs/ab4c60218c3b8a7d33f5b0df","title":"Site Reliability Engineer - PostgreSQL - Fully Remote - Contract Position","description":"Dice is the leading career destination for tech experts at every stage of their careers. Our client, Elite Technical, is seeking the following. Apply via Dice today!Engineer-PostgreSQLOur Client, a multi-national telecommunications technology is seeking an experienced Site Reliability Engineer (SRE) to join our Data Center Engineering team at Level 3. This role requires a technically strong and operationally mature engineer who will help design, scale, and maintain the reliability of our physical and virtual data center infrastructure. As a Level 3 SRE, you will be a technical leader responsible for ensuring system uptime, optimizing capacity and performance, and contributing to long-term infrastructure resiliency.Key Responsibilities:Design, implement, and maintain PostgreSQL databases, including schema design, indexing strategies, query optimization, logical/physical replication, hot standby failover, and load balancing.Develop and execute backup and recovery strategies, including pg_dump, pg_basebackup, WAL archiving, point-in-time recovery (PITR), and disaster recovery planning.Monitor and optimize database performance, resource utilization, and storage growth using pg_stat_statements, EXPLAIN ANALYZE, pg_top, and PrometheGrafana dashboards; proactively troubleshoot performance bottlenecks.Ensure database security through role-based access control (RBAC), audit logging with pgaudit, and compliance with regulatory standards.Implement high availability (HA) and disaster recovery (DR) solutions using Patroni, streaming replication, synchronoasynchronous replication, and failover orchestration.Plan and execute database version upgrades and apply security or performance patches with minimal downtime, ensuring data integrity and compatibility checks.Collaborate with application teams, BI developers, and ETL engineers to support data pipelines, optimizing queries, and workflow performance.Implement monitoring and alerting solutions using Prometheus, Grafana, Zabbix, or Nagios to track database health, query latency, and resource usage.Manage database user accounts, roles, and privileges to enforce security policies and regulatory compliance, including sudo/OS-level permissions for critical operations.Conduct capacity planning, workload forecasting, and index/partition tuning to handle anticipated growth and high-concurrency workloads.Automate database maintenance tasks using Python, Bash, or Ansible scripts, including schema migrations, routine checks, and patch deployment.Document procedures, configurations, operational runbooks, and PostgreSQL best practices for team knowledge sharing.Mentor and guide team members on PostgreSQL internals, replication setups, and performance tuning techniques.Evaluate and recommend new database tools, extensions (like TimescaleDB, pg_stat_statements), and best practices to improve efficiency, scalability, and resilience.Required Skills4+ years of hands-on PostgreSQL administration experience.Strong SQL and PL/pgSQL expertise; experience with database optimization and indexing. Hands-on experience with backup, recovery, and HA solutions. Strong proficiency in Linux and Debian environments.Proficiency in scripting for database automation.Excellent analytical, problem-solving, and troubleshooting skills.Strong communication skills for cross-team collaboration.Understanding of Oracle and MySQL databases is a plus, but not mandatory.","company":"Via Dice","rawCompany":"via dice","isRemote":true,"isActive":false,"createdAt":"2026-04-12T19:22:34.189Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Site Reliability Engineer - PostgreSQL - Fully Remote - Contract Position","description":"Dice is the leading career destination for tech experts at every stage of their careers. Our client, Elite Technical, is seeking the following. Apply via Dice today!Engineer-PostgreSQLOur Client, a multi-national telecommunications technology is seeking an experienced Site Reliability Engineer (SRE) to join our Data Center Engineering team at Level 3. This role requires a technically strong and operationally mature engineer who will help design, scale, and maintain the reliability of our physical and virtual data center infrastructure. As a Level 3 SRE, you will be a technical leader responsible for ensuring system uptime, optimizing capacity and performance, and contributing to long-term infrastructure resiliency.Key Responsibilities:Design, implement, and maintain PostgreSQL databases, including schema design, indexing strategies, query optimization, logical/physical replication, hot standby failover, and load balancing.Develop and execute backup and recovery strategies, including pg_dump, pg_basebackup, WAL archiving, point-in-time recovery (PITR), and disaster recovery planning.Monitor and optimize database performance, resource utilization, and storage growth using pg_stat_statements, EXPLAIN ANALYZE, pg_top, and PrometheGrafana dashboards; proactively troubleshoot performance bottlenecks.Ensure database security through role-based access control (RBAC), audit logging with pgaudit, and compliance with regulatory standards.Implement high availability (HA) and disaster recovery (DR) solutions using Patroni, streaming replication, synchronoasynchronous replication, and failover orchestration.Plan and execute database version upgrades and apply security or performance patches with minimal downtime, ensuring data integrity and compatibility checks.Collaborate with application teams, BI developers, and ETL engineers to support data pipelines, optimizing queries, and workflow performance.Implement monitoring and alerting solutions using Prometheus, Grafana, Zabbix, or Nagios to track database health, query latency, and resource usage.Manage database user accounts, roles, and privileges to enforce security policies and regulatory compliance, including sudo/OS-level permissions for critical operations.Conduct capacity planning, workload forecasting, and index/partition tuning to handle anticipated growth and high-concurrency workloads.Automate database maintenance tasks using Python, Bash, or Ansible scripts, including schema migrations, routine checks, and patch deployment.Document procedures, configurations, operational runbooks, and PostgreSQL best practices for team knowledge sharing.Mentor and guide team members on PostgreSQL internals, replication setups, and performance tuning techniques.Evaluate and recommend new database tools, extensions (like TimescaleDB, pg_stat_statements), and best practices to improve efficiency, scalability, and resilience.Required Skills4+ years of hands-on PostgreSQL administration experience.Strong SQL and PL/pgSQL expertise; experience with database optimization and indexing. Hands-on experience with backup, recovery, and HA solutions. Strong proficiency in Linux and Debian environments.Proficiency in scripting for database automation.Excellent analytical, problem-solving, and troubleshooting skills.Strong communication skills for cross-team collaboration.Understanding of Oracle and MySQL databases is a plus, but not mandatory.","datePosted":"2026-04-12T19:22:34.189Z","dateModified":"2026-04-12T19:22:34.189Z","hiringOrganization":{"@type":"Organization","name":"Via Dice","sameAs":"https://jobsearcher.com"},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"ab4c60218c3b8a7d33f5b0df"},"url":"https://jobsearcher.com/jobs/ab4c60218c3b8a7d33f5b0df"}}