This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description We are seeking an experienced PostgreSQL Database Administrator to support application development teams in a heavily on-prem, command-line–driven environment. This role is hands-on and operations-focused, with a strong emphasis on ticket-based support, PostgreSQL administration, and major version upgrades from PostgreSQL 9 to PostgreSQL 16. This is not a cloud-only DBA role. Candidates must be comfortable working directly on Linux systems and managing PostgreSQL in traditional on-prem environments. - Provide day-to-day PostgreSQL DBA support for internal application development teams - Manage and resolve incoming tickets related to PostgreSQL environments - Perform major PostgreSQL upgrades (PostgreSQL 9 → 16), including planning, execution, and validation - Administer PostgreSQL databases in on-prem environments using the command line - Handle all core DBA responsibilities: - Backups and restores - Performance tuning and query optimization - Vacuuming and routine maintenance - Patching and upgrades - Migrations and data movement - Write, review, and troubleshoot SQL, DDL, and DML - Communicate clearly with stakeholders and close the loop on tickets and requests - Work independently once requirements and instructions are provided Qualifications - Strong experience administering PostgreSQL in on-prem environments - Deep understanding of PostgreSQL internals and operational best practices - Hands-on experience with: - Backups and restores - Performance tuning - Vacuuming and maintenance - Upgrades and migrations - Strong ability to write and interpret SQL, including DDL and DML - Comfortable working in a Linux command-line environment - Professional, reliable, and responsive - Follows instructions - Works independently - Communicates clearly and closes tickets effectively Nice-to-Have Qualifications - Experience with YAML and/or Puppet - Shell or Bash scripting experience - Prior experience upgrading PostgreSQL from older major versions to current releases - Exposure to cloud platforms such as AWS or GCP (not required)

• Lead the deployment, configuration, management, and optimisation of enterprise database platforms (MS SQL, MySQL, Progress, MongoDB, Oracle, DB2) • Own backup, restore, and disaster recovery strategies; validate and execute DR testing procedures • Perform advanced performance tuning (execution plans, indexing, wait events, resource bottlenecks, AWR/ASH analysis) • Manage database high availability solutions including clustering, replication, AlwaysOn, Data Guard, and log shipping • Drive version upgrades, patching, vulnerability remediation, and full database lifecycle management • Ensure data integrity, encryption (TLS, TDE), secure connectivity, and regulatory compliance • Lead incident response and deep troubleshooting of outages and performance degradations • Oversee database capacity planning, utilisation reviews, and growth forecasting • Support audit, compliance, and license reviews; remediate findings • Lead database migration and consolidation initiatives (on-premises to cloud or cross-platform) • Support business continuity planning and DR execution • Oversee secure decommissioning and data sanitisation processes • Maintain architecture documentation, operational procedures, and support models • Provide technical leadership and mentoring to L2 Database Analysts, including On-Call rota coordination • Manage vendor escalations and third-party support engagement

• Apply your depth of knowledge and experience towards enabling our business to transition to the cloud. • Engage with engineering teams to gather infrastructure and database platform requirements and transform them into functional solutions within the AWS/Azure database clouds. • Ensure the continuous availability of our mission critical systems. • Help manage all aspects of our Azure/AWS databases, instances, storage, and data flows backing our cloud platforms. • Conquer the day-to-day operational aspects of our systems: • Participate as a member of a Database DevOps team to automate infrastructure provisioning using Terraform • Performance monitoring/tuning • HA/DR strategies • Backup strategies • Query tuning • Cloud instance/storage design, provisioning and performance monitoring • On-prem to cloud migrations • Automate routine tasks with your own scripts and open-source tools

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description We are seeking a talented mid-level PostgreSQL Database Administrator to join our System Operations team. This role will be crucial in managing our PostgreSQL infrastructure, primarily running on AWS Aurora, supporting mission-critical healthcare applications. You'll work in a collaborative environment focused on automation, performance optimization, and operational excellence. Who will love this job - A problem-solver who enjoys diagnosing complex database performance issues and implementing elegant solutions that improve system reliability. - An automation enthusiast who sees repetitive tasks as opportunities to build scripts and tools that scale operations efficiently. - A detail-oriented professional who takes pride in maintaining robust backup strategies, ensuring data integrity, and planning for disaster recovery scenarios. - A collaborative team player who works effectively with DevOps, development, and infrastructure teams to deliver integrated solutions. - A continuous learner who stays current with PostgreSQL best practices, AWS innovations, and database optimization techniques. What you will work on - Database Management & Operations - Manage day-to-day operations of PostgreSQL databases in AWS Aurora environments across multiple accounts. - Perform database setup, configuration, and deployment following best practices. - Implement and maintain backup and recovery strategies, ensuring data integrity and disaster recovery readiness. - Monitor database health, performance metrics, and capacity planning. - Execute database upgrades, patches, and migrations with minimal downtime. - Performance Optimization - Conduct performance tuning and optimization of PostgreSQL databases and queries. - Analyze and resolve database performance bottlenecks using AWS CloudWatch, AppDynamics, Grafana and other monitoring tools. - Optimize database parameters, indexes, and query execution plans. - Work with development teams to review and optimize SQL queries and database designs. - AWS Cloud Infrastructure - Leverage AWS Aurora PostgreSQL features including read replicas, automated backups, and high availability configurations. - Implement and manage Aurora clusters, parameter groups, and security configurations. - Utilize AWS services such as RDS, CloudWatch, Systems Manager, Lambda, and S3 for database operations. - Implement AWS best practices for security, monitoring, and cost optimization. - Automation & Scripting - Develop automation scripts using Python or other programming languages for routine database tasks. - Create tools for database provisioning, monitoring, alerting, and reporting. - Build and maintain CI/CD pipelines for database deployments. - Automate backup verification, database refresh processes, and compliance reporting. - Collaboration & Support - Provide technical support and troubleshooting for database-related issues. - Collaborate with DevOps, NetOps, and development teams on infrastructure and application initiatives. - Participate in on-call rotation for production support. - Document database procedures, configurations, and troubleshooting guides. - Contribute to database standards and best practices. Qualifications - 4-7 years of hands-on experience as a PostgreSQL Database Administrator. - Strong experience with AWS Aurora PostgreSQL and RDS. - Proficiency in PostgreSQL performance tuning, query optimization, and troubleshooting. - Solid understanding of database backup and recovery strategies. - Experience with database security, user management, and access controls. - Programming skills in Python, Shell scripting, or similar languages for automation. - Knowledge of AWS services (CloudWatch, Lambda, S3, Systems Manager, IAM). - Experience with database monitoring and alerting tools. - Strong understanding of SQL and relational database concepts. - Excellent problem-solving and analytical skills. - Ability to work independently and collaboratively in a team environment. - Strong written and verbal communication skills. Preferred - Experience with PostgreSQL logical replication and streaming replication. - Familiarity with infrastructure as code (Terraform, CloudFormation). - Experience with CI/CD tools (Jenkins, GitLab CI, AWS CodePipeline). - Knowledge of other database platforms (Oracle, MySQL, Redshift). - Experience in healthcare technology or regulated industries. - AWS certifications (Solutions Architect, Database Specialty). - PostgreSQL certifications. - Familiarity with data warehousing and ETL processes. Physical Requirements - 90% Desk work. - 10% Remote travel to client sites, conferences, or internal team meetings. Benefits - Competitive compensation, with a base salary of $130,000 - $150,000 (Exact compensation may vary based on skills and experience). - Eligible for Company Performance-based Bonus Program, based on individual and company performance. - Medical, dental, and vision insurance. - 401K eligible after 3 months of employment, with 50% company match up to first 5% of salary contributed to the plan with a 3-year vesting schedule. - HSA for eligible employees enrolled in the HDHP, with a generous company contribution up to $500 for individual coverage and $1000 for family coverage per year. - 100% company paid short and long-term disability, AD&D, and group life insurance. - Accrued annual paid time off (PTO) of 18 days for the first 3 years of service, increasing thereafter and 7 paid holiday days. - Employee Assistance Program. - Continuing Education funds up to $1500 annually for eligible programs after 1 year of service. - Voluntary benefits including FSA, Hospital indemnity, Accident and Critical Illness insurances.