Sr. AWS PostgreSQL DBA

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. They will need to have experience with both on-premise and AWS cloud implementation. 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 247 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. - Normally requires a Bachelor's Degree in Computer Science or equivalent, with 7-10 years of experience in related field. - 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 - Experience implementing PostgreSQL on-premise on Red Hat - 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 Stores Labcorp Is Proud To Be An Equal Opportunity Employer Labcorp strives for inclusion and belonging 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 and merit of the individual. Qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), 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. Additionally, all qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law. We encourage all to apply If you are an individual with a disability who needs assistance using our online tools to search and apply for jobs, or needs an accommodation, please visit our accessibility site or contact us at Labcorp Accessibility. For more information about how we collect and store your personal data, please see our Privacy Statement.