Apply on Employer Site

Ochsner Health · 1 day ago

Sr IS Database Administrator

Jefferson, LA

Full-time

Onsite

Senior Level

7+ years exp

Ochsner Health is committed to serving and innovating in healthcare since 1942. The Sr IS Database Administrator will develop, install, maintain, and support database management systems, ensuring optimal performance and reliability while collaborating with other departments on database issues.

Health CareHospitalInformation TechnologymHealth

H1B Sponsor Likely

Responsibilities

Designs and develops databases and prepares implementation plans for application upgrades and rollout

Supports and maintains databases

Manages database optimization

Participates in training and quality improvement activities

Other related duties as required

Qualification

SQL Server 2012+Performance tuningOracle 11g/12c/19cRAC on EXADATAT-SQLPowerShellAWS certificationData PumpDatabase cloningAnalytical skillsData modelingCommunication skillsInterpersonal skillsProblem-solving skills

Required

Bachelor's degree in Computer Science or related field

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 AlwaysOn 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 AlwaysOn Dashboards or scripting

Proficient in creating and maintaining stored procedures using T-SQL language

Ability to install/configure/repair/remove SQL server following documented procedures

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 PowerShell cmdlets

Experience with at least 2 of 3 versions of Oracle (11g, 12c,19c)

Proficient in performance tuning & monitoring using AWR, ASH, ADDM, TKProf, SQL Plan Baselines, Stats Pack as well as instance optimization via parameter changes

Proficient in RAC (Real Application Clusters) on EXADATA

Proficient in single instance/standalone deployments

Experience with ASM instances and Multitenant

Proficient with Data Pump (expdp/impdp) for exporting/importing data

Backup, Recovery and Cloning

Backup optimization for speed

Proficient in database restores to most recent time and point-in-time (PITR)

Proficient in database cloning using RMAN DUPLICATE from active instance/backups via shell scripting and CRON jobs

Proficient with RMAN DUPLICATE scenarios, each stage of the process and how to restart upon failure

Proficient in troubleshooting startup problems

Understand startup in NOMOUNT, and MOUNT modes

Understand shutdown in IMMEDIATE and ABORT modes

Experience opening SRs with Oracle and collecting required data using oracle provided instructions and tools like TKProf, AWR/ASH reports

Perform installation, configuration, and upgrades

Experience with Linux/AIX operating systems and basic commands

Patch instances using opatch and datapatch tools

Create/alter/delete logins. Role-based privilege assignments (RBAC) based on existing users

Must have computer skills and dexterity required for data entry and retrieval of information

Effective verbal and written communication skills and the ability to present information clearly and professionally

Must be proficient with Windows-style applications, various software packages specific to role and keyboard

Strong interpersonal skills

Working knowledge of database management systems such as ADABAS and Oracle, Natural, CICS, COBOL, and database concepts

Basic knowledge of MVS

String knowledge of SQL Server and Oracle database management systems and database concepts

Strong analytical and problem-solving skills

Strong written and verbal skills

Strong data modeling skills

Ability to move throughout and between facilities

Preferred

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 workstations as needed

Familiarity with Olla Hallengren stored procedures for backup, index reorg/rebuild and integrity check

Company

Ochsner Health

Glassdoor3.5

Ochsner Health is the leading nonprofit healthcare provider in Louisiana, Mississippi and across the Gulf South, delivering expert care at its 47 hospitals and more than 370 health and urgent care centers.

Founded in 1942

New Orleans, Louisiana, USA

10001+ employees

https://www.ochsner.org/

H1B Sponsorship

Ochsner Health has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (1)