Sr. Aws Postgresql Dba

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 24x7 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 or contact us at For more information about how we collect and store your personal data please see our