Database Engineer - SQL Server

Overview

Database Engineer - SQL Server

(on-site 2 days, off-site 3 days)

***Employer will not sponsor work visas for this position now or in the future and is not interested in corp.-to-corp. business arrangements at this time.***

Select Medical is one of the largest operators of critical illness recovery hospitals, rehabilitation hospitals, outpatient rehabilitation centers and occupational health centers in the United States, with more than 50,000 colleagues caring for nearly 80,000 patients every day across our care continuum.

Select Medical and its parent company, Select Medical Holdings Corporation (NYSE: SEM), are based in Mechanicsburg, Pennsylvania and honored to be recognized as one of America's Best-In-State (Pennsylvania) Employers 2020 by Forbes.

The Database Engineer performs daily maintenance and support for the Oracle and Microsoft SQL Server database environments. The areas of responsibilities include maintaining the Reliability, Availability and Serviceability (R.A.S.) of all database environments. The Database Engineer is also responsible for supporting the organizational growth through effective capacity planning, performance tuning and change management. This position must maintain coordination and communication with other IS resources dedicated to network services and systems development issues and projects. The Database Engineer reports to the Sr Manager, IT Shared Services.

Responsibilities

• Participate in the planning, installation, configuring, monitoring, and deployment of database systems in an SQL Server environment
• Assist with testing, implementation, and installation of new/improved systems, as well as product upgrades
• Ensure all database system operational processes are managed according to established service level agreement
• Maintain database objects such as indexes, tables, views, constraints, stored procedures
• Maintain archiving, backup / recovery, replication, cloning, import/export and refresh
• Lead database users
• Design, test, and optimize/tune RDBMS components
• Install, design, and maintain SQL SSAS (Analysis Services), SSIS (Integration Services) and SSRS (Reporting Services)
• Install, design, and maintain SQL Clustering
• Support SQL server for large databases (over 1TB)
• Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX compliance
• Review and assess new features or upgrades to existing RDBMS components as well as application database changes
• Develop, maintain, and optimize programming code for maintenance jobs and application reporting tools. Develop shell scripts as required
• Perform continuing analysis of database infrastructure to assist in proactive tuning efforts
• Maintains awareness of the rapidly changing Select Medical environment and recommends cost efficient techniques when supporting corporate and field systems users
• Recognizes and identifies potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.
• Troubleshoot and resolve critical and minor issues detected via monitoring
• Perform database updates, patching, and prescribed maintenance during approved maintenance windows
• Interact with vendor to resolve issues and/or maintain vendor relationships
• Develop capacity assessment practices to forecast future software and system needs
• Conduct database security risk assessments that include, but not limited to, monitoring, investigation and reporting of security and access violations
• Work closely with neighboring departments with the intent on ensuring proper implementations of projects and maintaining a collaboration effort
• Work on an on-call rotation responding to alerts within the defined SLA
• Attend meetings and interact regularly with management, team, and clients to continuously improve services
• Stay abreast of industry knowledge and technology as it pertains to assigned roles and responsibilities
• Supports the mission and direction of Select Medical Information Services both within the department and throughout the corporation.

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Qualifications

Required Qualifications:

• Bachelor's degree from an accredited college or university in an IT related field required or equivalent education and experience
• In lieu of undergraduate degree, the ratio is 1:1 meaning one year of college equals one year of work experience and vice versa.
• Select Medical Core Competencies of Service Mentality, Attention to Detail, Sense of Urgency, Initiative and Flexibility
• Ability to make decisions or solve problems by using logic to identify key facts, explore alternatives, and propose quality solutions
• Outstanding customer service skills as well as the ability to deal with people in a manner which shows tact and professionalism
• The ability to properly handle sensitive and confidential information (including HIPAA and PHI) in accordance with federal and state laws and company policies
• Strong communications skills; able to communicate clearly orally and in writing across the IT organization, business units, and with customers
• A strong understanding of Release and Change Management with the various associated processes
• Must interact well with peers and management
• Able to complete assignments that are defined in general terms
• Self-motivated to direct own workflow in a manner that maximizes results and meets division goals/schedules
• Desire to produce high quality, thorough work
• Able to prepare and maintain comprehensive and accurate documentation
• Must be able to adapt presentation to a specific target audience (i.e., client management/personnel)
• Adapt well to changing project and departmental priorities
• Able to work scheduled hours and overtime when needed
• Strong team orientation
• Open-minded, able to listen to other's ideas
• Willingness to develop expertise in other areas
• Willingness to actively participate in group cross-training by sharing personal areas of expertise with other engineers
• Solid understanding of Data Management Products, designs and best practices
• Ability to diagnose database/applications issues and develop effective solutions for resolutions

Preferred

1. Customarily has seven or more years of experience as an SQL Server Database
2. Administrator high availability architecture and design experience within an enterprise environment a plus
3. Oracle and/or ASE (Sybase) experience is a plus

Additional Data

Select Medical is one of the largest operators of critical illness recovery hospitals, rehabilitation hospitals, outpatient rehabilitation centers, and occupational health centers in the United States, with more than 50,000 colleagues caring for more than 80,000 patients every day across our care continuum.

Select Medical and its parent company, Select Medical Holdings Corporation (NYSE: SEM), are based in Mechanicsburg, Pennsylvania, and honored to be recognized as one of America's Best-In-State (Pennsylvania) Employers 2020 by Forbes.

For more information, visit selectmedical.com or https://youtube.com/SelectMedicalTV.

Select Medical strives to provide our employees with a solid work-life balance, as we understand that happy employees have both fulfilling careers and fulfilling lives beyond our doors.

• Flexible Remote work available
• An extensive and thorough paid orientation program.
• Paid Time Off (PTO) and Extended Illness Days (EID).
• Health, Dental, and Vision Insurance; Life insurance; Prescription coverage.
• A 401(k) retirement plan with a company match.

Select Medical is committed to having a workforce that reflects diversity at all levels and is an equal opportunity employer. Qualified applicants are considered for employment, and employees are treated during employment without regard to race, color, religion, national origin, citizenship, age, sex, sexual orientation, gender identity, marital status, ancestry, physical or mental disability, veteran status, or any other characteristic protected under applicable law.