| Description | LetsGetChecked is a global healthcare solutions company that provides the tools to manage health from home through health testing virtual care genetic sequencing and medication delivery for a wide range of health and wellness conditions. LetsGetChecked's end-to-end model includes manufacturing logistics lab analysis physician support and prescription fulfillment. Founded in 2015 and co-headquartered in Dublin and Atlanta LetsGetChecked empowers people to take control of their health and live longer happier lives. We're looking for a skilled Database Administrator whose primary focus will be on our SQL Server and PostgreSQL environments in AWS. You'll also gain significant exposure to our Amazon Redshift data warehouse clusters and other cutting-edge data technologies. If you're passionate about data eager to learn and want to advance your career in a dynamic environment this role is for you. ### Responsibilities Administer & Optimize: Take ownership of the tuning optimization and administration of our core database systems including MSSQL PostgreSQL (RDS/Aurora) and Redshift. Performance Monitoring: Proactively monitor the performance resource utilization and query throughput of our database systems using tools like DataDog Grafana CloudWatch and Splunk. Code & Troubleshoot: Identify and resolve performance bottlenecks in T-SQL and PL/pgSQL including stored procedures and work directly with our engineering teams to optimize code. Automate & Script: Develop and maintain automation scripts using Python or PowerShell for AWS Lambda functions and Octopus Deploy pipelines. Database Releases: Manage database releases across all development staging and production environments ensuring our high standards are consistently met. Maintain & Document: Keep our database documentation current and contribute to our knowledge base in Confluence. Support & Collaborate: Work efficiently through the JIRA ticket queue to handle database-related requests and collaborate with our talented team of engineers. ### What we are looking for… A BS in Computer Science or a related field or equivalent real-world experience. 3+ years of professional experience administering production databases with a strong focus on SQL Server and PostgreSQL in a cloud environment. Proven hands-on experience with AWS database services (RDS Aurora Redshift). Strong scripting skills in both T-SQL and PL/pgSQL. Solid experience with database automation using Python and/or PowerShell. A deep understanding of best practices for managing highly available 24/7 database environments. ### Preferred Experience Experience with other cloud platforms such as Microsoft Azure and/or GCP Cloud. Familiarity with NoSQL databases like MongoDB Atlas or other relational databases like MySQL. Experience with large-scale Cloud Migration projects. Active Database Certifications (e.g. AWS Certified Database – Specialty PostgreSQL Essentials/Advanced Certification Azure Database Administrator Associate). Experience using troubleshooting tools like wait statistics extended events or system views. Familiarity with CI/CD automation tools like Jenkins GitHub Actions or Octopus Deploy. Benefits: Alongside a salary of $135000 - $150000 (Depending on Experience) we offer a range of benefits including: Health dental & vision insurance 401k Matching contribution Employee Assistance Programme Annual Compensation Reviews Flexible PTO Policy and 3 paid volunteer days per year Free monthly LetsGetChecked tests as we are not only focused on the well being of our patients but also the well being of our teams A referral bonus programme to reward you for helping us hire the best talent Internal Opportunities and Careers Clinics to help you progress your career Maternity Paternity Parental and Wedding leave #LI-IF #LI-Remote Why LetsGetChecked At LetsGetChecked we are revolutionizing healthcare by making it more accessible convenient and personalized. Our mission is to empower individuals with the knowledge and tools they need to manage their health proactively so they can live longer happier lives. By joining our team you will be part of a dynamic and innovative company that is dedicated to improving lives through cutting-edge technology and compassionate care. We value our employees and invest in their growth offering opportunities for professional development and career advancement. Together we can make a meaningful impact on the future of healthcare and help people take control of their health journey. Join us in our commitment to transforming healthcare for the better. Our Commitment to Diversity Equity and Inclusion At LetsGetChecked we are committed to fostering an inclusive environment that celebrates diversity in all its forms. We believe that the diversity of thought background and experience strengthens our teams and drives innovation. We are an equal-opportunity employer and do not discriminate on the basis of race ethnicity religion color place of birth sex gender identity or expression sexual orientation age marital status military service status or disability status. Our goal is to ensure that everyone feels valued and empowered to thrive. To learn more about LetsGetChecked and our mission to help people live longer healthier lives please visit https://www.letsgetchecked.com/careers/ |