Sr IS Database Administrator

We've made a lot of progress since opening the doors in 1942, but one thing has never changed - our commitment to serve, heal, lead, educate, and innovate. We believe that every award earned, every record broken and every patient helped is because of the dedicated employees who fill our hallways.

At Ochsner, whether you work with patients every day or support those who do, you are making a difference and that matters. Come make a difference at Ochsner Health and discover your future today!

This job develops, installs, maintains and supports database management systems, administration tools and other associated products on a variety of platforms. Assists in maintenance of the corporate data dictionary and database reorganizations. Consults with other IS departments on database issues, provides technical assistance to the application development staff on file design and efficient techniques for extracting data, performs database administration tasks as requested by applications development, and implements data models, database designs, data access and table maintenance codes.

Resolves database performance and capacity issues, and replication and other distributed data issues and adheres to standards, policies and procedures. Monitors database performance, proactively performs database tuning to enhance operations or increase database availability and reliability, troubleshoots database problems, and investigates database tools that will add value to the client’s database environment. Stays abreast of emerging database technology and presents recommendations on new or upgraded database software.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential duties.

This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at the company's discretion.

• Required - Bachelor's degree in Computer Science or related field

• Required - 7 years in Experience as a Database Administrator or an Application Developer in a Database Environment.

• Experience with SQL Server 2012 or later versions.
• Proficient troubleshooting skills using sql server extended events, sql server profiler and windows performance monitor.
• Proficient in performance and tuning using query tuning, index redesigning, execution plan analysis, and sql profiler.
• SQL Always On Availability Groups for High Availability and DR
• Build 2 nodes and 4 nodes clusters following documented procedures.
• Add/remove nodes to/from a cluster.
• Fix synchronization problems for very large databases using “Join Only” method using SQL Server Management Studio “Add Database” wizard or direct T-SQL commands.
• Monitoring availability groups using SQL Always On Dashboards or scripting.
• Proficient in creating and maintaining stored procedures using T-SQL language. These procedures are used on our sql agent jobs to perform various tasks including database integrity checks, index reorganization/rebuild, backups and housekeeping jobs.
• Ability to install/configure/repair/remove SQL server following documented procedures. Download and apply patches as needed.
• Create/alter/delete logins. Role-based privilege assignments (RBAC).
• Migrate data from one instance to another with near zero downtime using full/diff/t-log backups strategy.
• Familiar with SQL Server Agent Jobs.
• Refresh non-production environments.
• Point-in-time restores.
• Good knowledge or ability to learn basic Power Shell cmdlets.
• Desired Skills
• Rackspace/AWS cloud migration experience
• Azure/AWS certification for SQL Server
• Knowledge of third-party monitoring tools specially Idera SQL Diagnostics.
• Knowledge of import/export wizards in SSMS and bcp tools.
• Use SSMS to connect to SSAS/SSRS instances and make changes as needed.
• Install SQL server Management Studio (SSMS) on…