Sr. AWS PostgreSQL DBA

Company: Labcorp
Location: Burlington
Posted on: March 16, 2023

Job Description:

Labcorp is recruiting a Senior AWS PostgreSQL DBA for a dynamic team in either the RTP or Burlington, NC area.
Get ready to redefine what's possible and discover your extraordinary potential at Labcorp. Here, you'll have the opportunity to personally advance healthcare and make a difference in peoples' lives with your bold ideas and unique point of view. With the support of exceptional people from across the globe and an energized purpose, you'll be empowered to own your career journey with mentoring, training and personalized development planning.
At Labcorp we believe in the power of science to change lives. We are a leading global life sciences company that delivers answers for crucial health questions because we know that knowledge has the potential to make life better for all. Through our unparalleled diagnostics and drug development capabilities, we provide insights and accelerate discoveries that not only empower patients and providers but help medical, biotech and pharmaceutical companies transform ideas into innovations.
Summary of Position: LabCorp is looking for a hands-on DBA, technologist and architect who has deep experience in PostgreSQL implementation to focus on building out the PostgreSQL DBA service.
Responsibilities include:

• Architect the PostgreSQL environment to support application requirements including the use of read replicas, number of connections, managing concurrency etc.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any unplanned downtime.
• Participate in application development projects and be responsible for the database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Participate in developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Establish and implement processes/automation which ensures regular backups and recovery of databases.
• Automate and perform regular database maintenance (e.g., Vacuum, Reindexing, Archiving, Connection pooling).
• Perform Query tuning and preventative maintenance.
• Participate in a 24 7 support rotation.
• Support complex cloud applications.
• Establish replication, as needed, to/from PostgreSQL instances
  Required Skills and Experience:
  • Minimum 7 years of experience in IT working on mid to large scale projects.
  • 5+ years in a DBA role including at least 5 years of PostgreSQL experience
  • Technical expertise regarding data models, database design and development
  • Familiarity with replication to/from PostgreSQL and other RDBMS's
  • Familiarity with several data modelling tools. ER/Studio a plus
  • Strong client interaction and communication skills (written & verbal)
  • Demonstrated experience with standard PostgreSQL tools like pgAdmin
    Desired Skills:
    • Experience working with Amazon RDS including Amazon Aurora
    • Application DBA experience
    • Domain experience: Healthcare
    • Knowledge of Key-Value Store and Document Store databases like DynamoDB, DocumentDB and MongoDB
    • Familiarity with Data Warehousing, ETL tools/processes and streaming data for Operational Data StoresLabcorp is proud to be an Equal Opportunity Employer:
      As an EOE/AA employer, Labcorp strives for diversity and inclusion in the workforce and does not tolerate harassment or discrimination of any kind. We make employment decisions based on the needs of our business and the qualifications of the individual and do not discriminate based upon race, religion, color, national origin, gender (including pregnancy or other medical conditions/needs), family or parental status, marital, civil union or domestic partnership status, sexual orientation, gender identity, gender expression, personal appearance, age, veteran status, disability, genetic information, or any other legally protected characteristic. We encourage all to apply.
      For more information about how we collect and store your personal data, please see our Privacy Statement .

Keywords: Labcorp, Burlington , Sr. AWS PostgreSQL DBA, Other , Burlington, North Carolina