"Alerted.org

Description

Introduction

Experience the HCA Healthcare difference where colleagues are trusted, valued members of our healthcare team. Grow your career with an organization committed to delivering respectful, compassionate care, and where the unique and intrinsic worth of each individual is recognized. Submit your application for the opportunity below:Consulting Database AdministratorHCA 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._

We are seeking a(an) Consulting Database Administrator for our team to ensure that we continue to provide all patients with high quality, efficient care. Did you get into our industry for these reasons? We are an amazing team that works hard to support each other and are seeking a phenomenal addition like you who feels patient care is as meaningful as we do. We want you to apply!

Job Summary and Qualifications

Job Summary:

This position will primarily support the Db2 Z/os & LUW database platform

Consulting Database Administrators (CDBA) are consulting level contributors within our Data Management organization. A CDBA is an expert with strong previous experience across the database and deep working knowledge of the entire IT stack. They have an essential role in the overall Data Strategy at HCA Healthcare and support mission critical applications across the enterprise.

As a CDBA, you will have the opportunity to grow and leverage your technical skills in database architecture, design, administration, engineering and tuning to manage our database environments. A CDBA will work with other database administrators, system reliability engineers, technicians, business analysts, and business owners to implement solutions that improve database reliability for end-users.

As such, the Consulting Database Administrator focuses primarily on tasks and activities that:

• Provide technical support of database environments including software installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, maintenance, process automation, evaluation, and tuning recommendations

• Contribute to application development in all aspects of database integration including the deployment of requested database code and configuration changes, as well as reviewing SQL statements and guiding developers on best practices around how to interact with the database

• Maintain a Highly Available database environment through the implementation and support of backup and restore capabilities, data replication, Disaster Recovery procedures and exercises, and failover to standby databases

• Review project requests to estimate time, cost, and infrastructure required to successfully deliver the desired outcomes

• Research, architect, and implement database technologies using industry and HCA best practices

• Optimize database resources for optimum configuration, database performance, and cost

• Continuously identify process improvement opportunities, including the reduction of manual tasks and elimination of human error through automation, as well as streamlining work activities

• Participate in On-Call rotation and during shifts provide Tier 3 off-hours support of critical systems for database problem resolution and recovery

CDBAs are expected to have a great deal of prior knowledge and experience, and will need to demonstrate the ability to learn quickly and thrive in a team-oriented environment. While in this position, they are expected to showcase experience in the design, development, maintenance, and administration of the database platform. The culture of our organization places an emphasis on teamwork, so social and interpersonal skills are equally important as technical capability.

Technical Experience:

Hardware/Operating Systems:

• MS Windows Server

• AIX

• LINUX

• z/OS

Networking: (ex: LAN/WAN, DHCP, VPN, TCP/IP)

• A senior level understanding of networking with respect to database connectivity and troubleshooting of connectivity errors

Certifications:

• Considered a plus

Databases:

• DB2 z/OS

• DB2 LUW

• MS SQL ( Good to have)

• PostgreSQL (Good to have)

• MySQL ( Good to have)

DB2 LUW &Z/os Specific Information:

With databases ranging in size from less than 1 TB to over 10 TBs, we support multiple applications and teams in their pursuit of always available data.

• Db2 Zos V11 and V12 function level 500

• Db2 LUW V11.1,11.5,11.7

• Db2 Zos Backup & Recovery

• Db2 HADR with Auxiliary HA

• Data Migration Using Recovery Expert

• High Performance Unload

• Db2 Tablespace Compression

We are also actively pursuing rapid advancements in automation and reliability engineering, with projects on-going with the following tools:

• Automating tasks with Bash and other scripting languages

• Automating tasks using Rexx

Job Skills:

• A strong communicator who can explain complex technical concepts to leadership, designers, support, and other technical resources

• A team player who enjoys helping onboard new team members, mentoring, and teaching others

• Prior experience planning and completing complex database projects that span months and/or years

• Demonstrated performance monitoring and tuning ability, including an aptitude to lead the diagnosis and resolution of performance problems within a large-scale, complex infrastructure

• Expertise in one or more of the following: database partitioning, database compression, data encryption, replication, disaster recovery, and database security

• Experience with writing shell or other high-level scripting languages to automate database maintenance and operational processes

• 7+ years of Hands-on Consulting database administration experience with Db2 Zos and LUW databases

Responsibilities:

Physical database design, construction, & implementation using current database technology

Collaborative design & development with programmers and business analysts

Problem analysis, diagnosis, and implementation of resolutions

Performance monitoring & tuning

On-call support for production systems, job streams, and processes

Database backup (archive) & recovery

Business continuity planning

Capacity planning, monitoring, and upgrade implementation

Software upgrade planning and implementation

EDUCATION

Bachelor’s degree required

EXPERIENCE

Must have 7+ years of relevant work experience

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.

"There is so much good to do in the world and so many different ways to do it."- Dr. Thomas Frist, Sr.

HCA Healthcare Co-Founder

If you find this opportunity compelling, we encourage you to apply for our Consulting Database Administrator opening. We promptly review all applications. Highly qualified candidates will be directly contacted by a member of our team. **We are interviewing apply today!**

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