Description

Introduction

Do you have the career opportunities as a(an) Consulting PostgreSQL Database Administrator you want with your current employer? We have an exciting opportunity for you to join HCA Healthcare which is part of the nation's leading provider of healthcare services, HCA Healthcare.

Benefits

HCA Healthcare, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive medical coverage that covers many common services at no cost or for a low copay. Plans include prescription drug and behavioral health coverage as well as free telemedicine services and free AirMed medical transportation.

• Additional options for dental and vision benefits, life and disability coverage, flexible spending accounts, supplemental health protection plans (accident, critical illness, hospital indemnity), auto and home insurance, identity theft protection, legal counseling, long-term care coverage, moving assistance, pet insurance and more.

• Free counseling services and resources for emotional, physical and financial wellbeing

• 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service)

• Employee Stock Purchase Plan with 10% off HCA Healthcare stock

• Family support through fertility and family building benefits with Progyny and adoption assistance.

• Referral services for child, elder and pet care, home and auto repair, event planning and more

• Consumer discounts through Abenity and Consumer Discounts

• Retirement readiness, rollover assistance services and preferred banking partnerships

• Education assistance (tuition, student loan, certification support, dependent scholarships)

• Colleague recognition program

• Time Away From Work Program (paid time off, paid family leave, long- and short-term disability coverage and leaves of absence)

• Employee Health Assistance Fund that offers free employee-only coverage to full-time and part-time colleagues based on income.

Learn more about Employee Benefits (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)

Note: Eligibility for benefits may vary by location.

Our teams are a committed, caring group of colleagues. Do you want to work as a(an) Consulting PostgreSQL Database Administrator where your passion for creating positive patient interactions are valued? If you are dedicated to caring for the well-being of others, this could be your next opportunity. We want your knowledge and expertise!

Job Summary and Qualifications

JOB SUMMARY

The Consulting PostgreSQL Database Administrator’s role is to lead and manage the creation, management, and quality of PostgreSQL and other open source databases, schemas, and queries. The database administrator must provide specific technical depth of database platform and infrastructure knowledge and skills that cover a broad range of disciplines including systems design, storage design, data modeling, data warehousing design, and other data delivery technologies. The candidate will work closely with the Manager of System Engineering, Customer Engagement, Architecture and Planning, and Product Development team leaders as well as with HCA IT&S Service Management & Delivery and Information Security teams. Candidates provide engineering skills covering various open database technologies, including PostgreSQL administration, MySQL, Google cloud data platforms, database schema definition, query performance tuning, and scripting. Candidates are expected to be capable of meeting objectives with very little supervision. We need motivated, independent workers who can work well within a team, effectively communicate thoughts and ideas, and bring a high level of innovation and quality.

GENERAL RESPONSIBILITIES

• Works with stakeholders to create requirements for new infrastructure and solutions related to PostgreSQL and other open database platforms

• Leads efforts to create architecture around new database systems and platforms

• Leads implementation efforts of database systems and platforms, delivering quality solutions in a timely manner in compliance with defined requirements

• Works with application delivery managers and application developers to deploy DDL and queries; and create automated deployment solutions

• Conduct regular performance testing and tuning

• Manage database server CPU, storage, and memory utilization

• Manage cloud database configurations

• Provision, manage, and audit database security

• Provides support to application development teams for database needs

• Works with System Engineers to integrate systems and applications with databases

• Work in collaboration with Data Architect to design, implement, and tune database schemas

• Work in collaboration with Data Architect to optimize physical tables and partitions

• Work in collaboration with Data Architect to implement dimensional models, including aggregation and indexing strategies

• Fully responsible for the PostgreSQL technology stack

• Manages documentation of database standards

• Responsible for defining and executing operational procedures for database systems and platforms, including backups, monitoring, capacity planning, and administration

• Leads activities to proactively maintain and upgrade platforms and systems

• Develops automation capabilities to automate the deployment and maintenance of systems and platforms

• Identify, investigate, evaluate and quickly become proficient in new technologies and technical disciplines that are of significance to HealthTrust

• Coaches team on use of approved methodologies, processes and toolsets defined within the operations and infrastructure services group

• Mentoring of junior and entry level DBAs

• Participates in system engineering strategy planning

• Defines project tasks and plans and executes to project completion

• Capable of leading small teams on specialized projects

• Assists in the interviewing process for future teammates

• Other duties as assigned

EXPERIENCE

• 7+ years

EDUCATION

• College Graduate Preferred

• Other as Noted: Technical Certification and experience may substitute for formal education.

OTHER/SPECIAL QUALIFICATIONS

Required Experience:

• Significant experience in deploying technically complex infrastructure computing solutions across platforms and components

• Demonstrated ability to prepare and maintain documentation

• Specific platform knowledge in PostgreSQL, MySQL, GCP Cloud Spanner, and/or related technologies

• Knowledge of Google cloud architecture and operations, particularly related to the transfer, storage, and integration of data

• Knowledge of ETL, stored procedures, SQL optimization, PL/pgSQL

• Knowledge of scripting languages and their applicability to PostgreSQL

• Solid understanding and experience with operating system concepts and practical implementation of those fundamentals in a large-scale production environment

• Support relating to technical issues involving database technologies, as well as PostgreSQL integration with operating systems and storage platforms

• Experience supporting custom application development

• Experience in system automation using command shell, scripting, database and/or application programming

• Proven strong critical thinking

Technologies utilized at Healthtrust (nice-to-have skills, but not required):

• Cloud technologies – Google Cloud Platform, GCP Cloud Spanner, Google Cloud SQL, AlloyDB, Azure SQL

• SAN & NAS technologies – EMC, NetApp, StorageGrid (S3)

• Network technologies – Cisco routers, switches, DNS

• Security technologies, including Ping Federate, certificate management

• Virtualization technologies – Vmware

• Business Intelligence platform – Microstrategy, Power BI

• Application Platforms – IIS, .NET Core, Sitecore, Java, SharePoint

• SOA technologies –IBM MQ Advanced, IBM Datapower, Mulesoft

• Database technologies – PostgreSQL, MySQL, MS SQL Server

• Automation & System Management – Terraform, Ansible, Powershell

• Backup technologies – Veeam

• Monitoring platforms – Solarwinds, SCOM, SQL Sentry, Database Performance Analyzer

• Anti-virus – Microsoft Defender

• Search technologies - Solr

HCA Healthcare has been recognized as one of the World's Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

"Bricks and mortar do not make a hospital. People do."- Dr. Thomas Frist, Sr.

HCA Healthcare Co-Founder

If you are looking for an opportunity that provides satisfaction and personal growth, we encourage you to apply for our Consulting PostgreSQL Database Administrator opening. We promptly review all applications. Highly qualified candidates will be contacted for interviews. Unlock the possibilities and apply today!

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.