LHC Group. Inc

Database Administrator

Location : Facility Name
LHC Group Inc Home Office
Requisition ID
2020-87752
Location : Postal Code
70806
Position Type
Full-Time
Work Schedule
Normal (Based on FT, PT, PRN)
CATEGORY
ADMINISTRATIVE
Location : City
Baton Rouge
Location : State/Province
LA

Overview

LHC Group is the preferred post-acute care partner for hospitals, physicians and families nationwide. From home health and hospice care to long-term acute care and home and community-based services, we deliver high-quality, cost-effective care that empowers patients to manage their health at home. Hospitals and health systems around the country have partnered with LHC Group to deliver patient-centered care in the home. More hospitals, physicians and families choose LHC Group, because we are united by a single, shared purpose: It's all about helping people.

Additional Details

  • Install and upgrade SQL Server installations
  • Implement and manage company data management and security practices and policies
  • Provide guidance and support to Application Developers
  • Assist with schema design, code review, SQL query tuning
  • Monitor performance and troubleshoot problems to ensure database uptime
  • Troubleshoots and resolve database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues
  • Troubleshoots SQL Server related CPU, Memory, I/O, disk space and other resource contention
  • Performance tuning and query optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Collaborate with Developers, Sysadmins and Vendors to build reliable and scalable services.
  • Working with multiple business units on day-to-day operations.
  • Installing, monitoring, maintaining, upgrading, and tuning databases supporting a network of websites/business units.
  • Performance optimization, rewriting queries, introducing indexes, table partitioning and schema maintenance.
  • Implementations of backup and disaster recovery solutions.
  • Completing tasks required to maintain service levels of project delivery and ensure the availability of all features and functions.
  • Executes backups, restores, recovery models, and database maintenance tasks (Ola Hallengren Maintenance Solutions)
  • Writes and troubleshoots SQL Code and designs (stored procs, functions, tables, views, triggers, indexes, constraints)
  • Index maintenance
  • Log shipping and or database replication
  • Develop, deploy, and support SSIS packages
  • Develop and deploy SSRS reports
  • Develop, deploy, and support SSAS cubes

Qualifications

Skill Requirments

 

• Minimum 10 years of experience as DBA
• Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
• Proven knowledge of SQL Servers
• Strong analytical, problem-solving, and decision-making skills

• Understanding of the Windows / UNIX systems programming and administration philosophy.
• Experience as a DBA and/or Systems Administrator.
• Proficiency in the following database technologies: SQLServer / MySQL, Oracle and Hadoop
• Experience with NoSQL databases such as: MongoDB.
• Experience supporting development, testing and production databases.
• Experience setting up replication, sharing and other high availability solutions.
• Working expertise with at least one scripting language: Python or Bash.
• Strong Windows / Linux working knowledge (preferably RedHat/CentOS family)
• Proactive, collaborative, and a team player.
• Excellent verbal and written communication.

 

Desired Skills

 

• Kubernetes (or any other orchestration frameworks).
• Percona Toolkit such as pt-online-schema-change.
• AWS (RDS/EC2/Redshift) or Google Cloud Platform.
• Ansible, Terraform or Puppet.
• Docker containers.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.