This Principal SQL Database Administrator provides leadership in the design solutions, implementation, and maintenance of Microsoft SQL databases. The Principal SQL Database Administrator performs root cause analysis, documentation and implementation of multiple large development projects. Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Serves as team lead between business customers, development and support groups. Coaches the development of other DBAs.
Creates design solutions for complex, large databases on critical enterprise systems.
Demonstrates expertise in building database security policy and procedures.
Plays lead role in aspects of database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.
The responsibilities listed are a general overview of the position and additional duties may be assigned.
DATABASE SECURITY (ADVANCED): Has expertise in building a database security policy. Is knowledgeable of the security weaknesses in database systems and can suggest compensating controls. Is experienced in the major database security vulnerabilities of Server Security, Database Connections, Table Access Control and Restricting Database Access.
DATABASE PERFORMANCE TUNING (ADVANCED): Demonstrates high levels of expertise in applying performance metrics in challenging and complex situations regarding performance problems. Able to interpret performance information and make recommendations. Often takes a lead role in highly pressurized situations when there is a need to achieve results and researches metrics in new areas for potential use. Plans performance and stress tests.
DATABASE BACKUP AND RECOVERY (ADVANCED): Plays a lead role in planning, scheduling and testing the backup and recovery procedures for mission-critical files, applications and databases. Demonstrates the ability to backup and recover Internet, intranet, extranet and other network systems. Helps develop backup and recovery best practices for the organization.
PHYSICAL DATABASE MODELING (ADVANCED): Is an organizational expert in physical database design. Has developed, reviewed and approved diagrams and documentation generated during physical modeling to determine the feasibility, effectiveness and efficiency of the physical database design. Has participated in the decision to use particular hardware, operating system platforms, and database software.
SERVER INSTALLATION AND UPGRADE (ADVANCED): Demonstrates mastery of complex installation procedures. Has the ability to provide solutions to complex software problems by either coding a new program or using the correct utility program.
Organizational Impact: Delivers projects/assignments that have a direct impact on goals/objectives of the unit/department that the job is in.
Problem Solving/ Complexity of work: Conducts extensive analysis of situations or data to resolve numerous, complex issues; may involve the input/work of others.
Breadth of Knowledge: Has in-depth level of knowledge within a professional area and working knowledge of other areas.
Team Interaction: May lead mid-sized projects; coaches and guides team members.
About the Department:
HealthIT provides the best health information technology tools that support Vanderbilt University Medical Center's mission of:
Delivering distinctively personalized care
Improving the health care of individuals and communities regionally, nationally and internationally
Providing transformative learning programs
Supporting compelling discoveries
Our tools, which form the digital arteries of VUMC, are either developed in-house by our innovative product teams or selected from the most cutting-edge solutions available in today's ever-changing marketplace. Our 500 colleagues provide ongoing support over each product's entire lifespan, ensuring that the tools are meeting the evolving needs of the Medical Center's 24,000 colleagues.
Our solutions are driven by the incredible work and research of our colleagues throughout Vanderbilt and supported through a close partnership with VUMC Information Technology (VUMC IT) . The strong collaboration among our teams means that VUMC can respond to clinical and operational issues with agility and innovation. Together, we ensure VUMC remains a leader in its pioneering use of healthcare information technology.
Located in Nashville, Tennessee, and operating at a global crossroads of teaching, discovery and patient care, VUMC is a community of individuals who come to work each day with the simple aim of changing the world. It is a place where your expertise will be valued, your knowledge expanded, and your abilities challenged. It is a place where your diversity -- of culture, thinking, learning and leading -- is sought and celebrated. It is a place where employees know they are part of something that is bigger than themselves, take exceptional pride in their work and never settle for what was good enough yesterday. Vanderbilt's mission is to advance health and wellness through preeminent programs in patient care, education, and research.
VUMC Recent Accomplishments
Because we are committed to providing the best in patient care, education and research, we are proud of our recent accomplishments:
US News & World Report: #1 Adult Hospital in Tennessee and metropolitan Nashville, named to the Best Hospitals Honor Roll of the top 20 adult hospitals, 10 nationally ranked adult specialty programs, with 3 specialties rated in the top 10 nationally, Monroe Carell Jr. Children's Hospital at Vanderbilt named as one of the Best Children's Hospital in the nation, with 10 out of 10 pediatric specialties nationally ranked.
Healthcare's Most Wired: Among the nation's 100 "most-wired" hospitals and health systems for its efforts in innovative medical technology.
Becker's Hospital Review: named as one of the "100 Great Hospitals in America", in the roster of 100 Hospitals and Health Systems with Great Oncology Programs and to its list of the 100 Hospitals with Great Heart Programs.
The Leapfrog Group: One of only 10 children's hospitals in the to be named at Leapfrog Top Hospital.
American Association for the Advancement of Science: The School of Medicine has 112 elected fellows
Magnet Recognition Program: Received our third consecutive Magnet designations.
National Academy of Medicine: 22 members, elected by their peers in recognition of outstanding achievement
Human Rights Campaign Healthcare Equality Index: 6 th year in a row that Vanderbilt University Medical Center was a Leader in LGBTQ Healthcare Equality.
Vanderbilt University Medical Center is home to Vanderbilt University Hospital, The Monroe Carell Jr. Children’s Hospital at Vanderbilt, the Vanderbilt Psychiatric Hospital and the Vanderbilt Stallworth Rehabilitation Hospital. These hospitals experienced more than 61,000 inpatient admissions during fiscal year 2015. Vanderbilt’s adult and pediatric clinics treated nearly 2 million patients during this same period. Vanderbilt University Hospital and the Monroe Carell Jr. Children’s Hospital at Vanderbilt are recognized again this year by U.S. News & World Report’s Best Hospitals as among the nation’s best with 18 nationally ranked specialties. Vanderbilt University Medical Center is world renowned because of the innovation, work ethic and collegiality of its employees. From our health care advances to our compassionate care, Vanderbilt owes its accomplishments and reputation to staff and faculty who bring skill and drive and innovation to the medical center day after day. World-leading academic departments and comprehensive centers of excellence pursue scientific discoveries and transformational educational and clinical advances across the entire spectrum of health and disease.As t...he largest employer in middle Tennessee, we welcome those who are interested in ongoing development in a caring, culturally sensitive and professional atmosphere. Most of us spend so much of our lives at work, we want to be part of maintaining a workplace in which people support one another and encourage reaching for excellence. Many high-achieving employees stay at Vanderbilt because of the professional growth they experience and because of their appreciation of Vanderbilt’s benefits, public events and discussions, athletic opportunities, beautiful setting and, above all, sense of community and purpose.Vanderbilt and its employees share a set of mutual expectations that have been created with productivity, legality, fairness and safety always in mind. We believe that our investment in training and compensating employees multiplies in value when we enable individuals to deliver their best performance for the benefit of us all.