Senior Database Administrator - SQL
LifePoint Hospitals - Corporate - Brentwood, TN

This job posting is no longer available on LifePoint Hospitals - Corporate. Find similar jobs:Senior Database Administrator jobs - LifePoint Hospitals jobs

Job Summary:
Primary support for corporate based Database Management Systems (DBMS) running Microsoft SQL server including software upgrades, security, backups, and disaster recovery. Also supports and troubleshoots for the facilities their decentralized DBMS. Analyzes, tests, and implements physical database design supporting various business applications (including base definition, structure, documentation, long-range requirements, and operational guidelines). Ensures data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management. Provides a high degree of coordination between user, technical, application, and corporate entities to ensure effective data management as a corporate enterprise. Above all, ensures that solutions meet business objectives, and establishes and maintains a high level of user trust and confidence in IT's knowledge of, and concern for, users' business needs. Has a willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment.

General Responsibilities:
Ensures Recoverability of Microsoft SQL corporate based DBMS; Including creating and testing backups
Ensures Integrity of Microsoft SQL corporate based DBMS; Verifying or helping to verify data integrity with application owners
Maintains Security of Microsoft SQL corporate based DBMS, including periodic scanning of existing permissions; implementing access controls to the data defined by the SQL team
Ensures Availability of Microsoft SQL corporate based DBMS; Ensuring maximum uptime and assisting Database Manager with system down time windows
Monitors Performance of Microsoft SQL corporate based DBMS via SCOM, Perfmon (including SQL VMware objects) and in-house SQL tools;
Development and testing support of Microsoft SQL corporate based DBMS; Assists programmers and engineers to efficiently utilize the database(s) and identify issues with structure, indexing, stored procedures, and potentially coding
Assists Database Manager with compliance of server software licensing and service/maintenance agreements on Microsoft SQL corporate based DBMS servers
Provide third-level application support; Resolve problems and answer questions related to the RDBMS and platform environment running Microsoft SQL, contact vendor support when necessary, facilitate application development and client problem resolution with optimum speed and efficiency
RDBMS performance monitoring and tuning via Profiler, DTA, BPA, and other Microsoft and third party tools; Closely monitor performance, identify problems and implement solutions, ensure the databases are running at optimum speed and efficiency
Install and upgrade RDBMS and related products; Keep RDBMS at current release, service pack, patch and maintenance levels, install supporting products, provide current, stable production, test, and development environments
Reorganize database structures as needed; Automate procedures at regular intervals, use tools to reorganize or defragment database table spaces, tables, and indexes
Provide assistance in database design as needed; Research and recommend optimal design criteria, publish standards and work with development staff, standardize environment and improve efficiency
Capacity planning and reporting; Monitor file system space, database allocation, transaction log requirements, fragmentation, efficient use of disk storage, reclaim dead space, optimize space allocation, configure database mail alerts domain wide to proactively avoid critical conditions

Minimum Qualifications: (Experience, Education and Special Certifications…)

Seven years of Experience with setup, testing, and troubleshooting DBMS on Microsoft SQL
Thorough understanding of the relational database model, ACID, solid theoretical knowledge of relational database techniques; skilled in ability to see the entire environment and conceptualize and document creative solutions
Advanced knowledge of Microsoft SQL Server, SSIS, and T-SQL, including programming and ways to optimize SQL code a must; knowledge of Oracle Database is a plus.
Experience in designing, modeling, developing, and supporting large RDBMS systems in an enterprise environment. Experience in the design of ETL, data extract, data migration, and data queuing facilities. Ability to monitor and tune the database
Education or experience equivalent to a Bachelors degree in Business Administration/Management/Information Systems
Ten years in-depth experience with design, administration, development, tuning, optimization and support of Microsoft SQL Server
Ability to handle sophisticated systems administration tasks to fulfill backup role to Manager - Databases, Systems Administrator - SQL DataBase Administrator - Oracle DataBase if needed

One of the following Microsoft certifications:
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified IT Professional (MCITP): Database Administration

Must possess excellent written and oral communications skills, good organizational skills
Must be self-motivated and able to work without direct supervision to meet deadlines, but work well with team members
Two years of experience migrating SQL 2005\2008 clusters and standalone servers to new SAN storage, and with EMC SAN to SAN migration
The ability to travel as needed (minimal travel expected)

This job description in no way states or implies that the key accountabilities above are the only ones being performed by the individual(s) with this job description. The individual(s) may be called upon and required to follow or perform other duties and tasks requested by his or her supervisor, consistent with the purpose of the position, department and/or company objectives.

LifePoint Hospitals, Inc. is an Equal Opportunity Employer