JOB SUMMARY:

This SQL Database Administrator designs, models, configures, tests and installs databases under occasional guidance. The SQL Database Administrator provides support services for database creation, performance, monitoring, tuning and capacity planning. Builds physical data structures. Enforces policies and procedures for maintaining the security and integrity of the database and ensures the database meets availability and disaster recover requirements. Implements small development projects or components of large projects. Ability to solve medium to complex problems.

Provide administration and support of third-party databases used in the procedural areas of the hospital. Uses basic understanding of domain architecture and ability to further support and maintain those architectures.

Facilitates communication within team and IT enterprise. Uses basic understanding of associated business domain for database design and integration. Participates in afterhours on-call support rotation.

Provides troubleshooting capabilities for assigned databases.

KEY RESPONSIBILITIES:

• Develops and implements databases supporting enterprise systems.
• Performs all aspects of database management including installation, patching, backup and recovery, performance and tuning, security administration and space management.
• Ensures databases are secure and protected.
• The responsibilities listed are a general overview of the position and additional duties may be assigned.

TECHNICAL CAPABILITIES:

DATABASE SECURITY (INTERMEDIATE): Has performed security assessments to secure a database environment. Is knowledgeable of security tools, security policies, and copyright law as it relates to the database and the information on it. Able to perform basic database administration on a given product.

DATABASE PERFORMANCE TUNING (NOVICE): Possesses fundamental proficiency to successfully produce reports and graphs from performance metrics. Can use the facilities available to gather performance data and produce basic reports. Familiar with actions such as redo log buffer latches, database buffer cache size, shared pool size and tuning scripts. Knowledgeable of at least two database systems.

DATABASE BACKUP AND RECOVERY (INTERMEDIATE): Has experience backing up routine files and applications used by the organization. Assures that computer-based work is backed up and the recovery process's tested on a regular basis. Has experience with basic backup tools such as log shipping, availability groups, SQL Always on, as well as other organizational tools and strategies.

PHYSICAL DATABASE MODELING (NOVICE): Has prepared a simple physical database design or has worked as part of a team designing a more complex physical database. Has defined constraints, including primary keys, foreign keys, other unique keys, and check constraints. Has created views from database tables to summarize data or to provide the user with another perspective of certain data. Has defined simple indexes and snapshots. Has worked with simple server model diagrams that show tables, columns, and relationships within a database, user feedback documentation, and database design documentation.

SERVER INSTALLATION AND UPGRADE (INTERMEDIATE): Has the ability to install software on a specific platform. Demonstrates an ability to resolve problems that may occur during the installation of software. Is capable of understanding the design and purpose of the software being installed.

CORE ACCOUNTABILITIES:

• Organizational Impact: Executes job responsibilities with the understanding of how output would affect and impact other areas related to own job area/team with occasional guidance.
• Problem Solving/ Complexity of work: Analyzes moderately complex problems using technical experience and judgment.
• Breadth of Knowledge: Has expanded knowledge gained through experience within a professional area.
• Team Interaction: Provides informal guidance and support to team members.

About the Department:

Health IT

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.

Underscoring our entire department are our core values of accountability, transparency and execution , delivered with a strong Partner Promise .

Position Shift : Days

Discover Vanderbilt University Medical Center:

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.