SQL Database Administrator

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 diverse 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. Vanderbilt Health recognizes that diversity is essential for excellence and innovation. We are committed to an inclusive environment where everyone has the chance to thrive and 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.

Organization:

VUMC IT Oracle/SQL

Job Summary:

Designs, models, configures, tests and installs databases under occasional guidance. 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.

.

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

• 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.

• Database Security (Novice): 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 (Novice): 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 Informix's OnTape, Sybase's Dump, or Oracle's Enterprise Backup Utility, as well as other organizational tools.

• Server Installation and Upgrade (Novice): 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.

Our professional administrative functions include critical supporting roles in information technology and informatics, finance, administration, legal and community affairs, human resources, communications and marketing, development, facilities, and many more.

At our growing health system, we support each other and encourage excellence among all who are part of our workforce. High-achieving employees stay at Vanderbilt Health for professional growth, appreciation of benefits, and a sense of community and purpose.

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.

Core Capabilities :

Supporting Colleagues:- Develops Self and Others: Invests time, energy, and enthusiasm in developing self/others to help improve performance e and gain knowledge in new areas.- Builds and Maintains Relationships: Maintains regular contact with key colleagues and stakeholders using formal and informal opportunities to expand and strengthen relationships.- Communicates Effectively: Recognizes group interactions and modifies one's own communication style to suit different situations and audiences. Delivering Excellent Services:- Serves Others with Compassion: Seeks to understand current and future needs of relevant stakeholders and customizes services to better address them.- Solves Complex Problems: Approaches problems from different angles; Identifies new possibilities to interpret opportunities and develop concrete solutions.- Offers Meaningful Advice and Support: Provides ongoing support and coaching in a constructive manner to increase employees' effectiveness. Ensuring High Quality: - Performs Excellent Work: Engages regularly in formal and informal dialogue about quality; directly addresses quality issues promptly.- Ensures Continuous Improvement: Applies various learning experiences by looking beyond symptoms to uncover underlying causes of problems and identifies ways to resolve them. - Fulfills Safety and Regulatory Requirements: Understands all aspects of providing a safe environment and performs routine safety checks to prevent safety hazards from occurring. Managing Resources Effectively: - Demonstrates Accountability: Demonstrates a sense of ownership, focusing on and driving critical issues to closure.- Stewards Organizational Resources: Applies understanding of the departmental work to effectively manage resources for a department/area.- Makes Data Driven Decisions: Demonstrates strong understanding of the information or data to identify and elevate opportunities. Fostering Innovation:- Generates New Ideas: Proactively identifies new ideas/opportunities from multiple sources or methods to improve processes beyond conventional approaches.- Applies Technology: Demonstrates an enthusiasm for learning new technologies, tools, and procedures to address short-term challenges.- Adapts to Change: Views difficult situations and/or problems as opportunities for improvement; actively embraces change instead of emphasizing negative elements.

Position Qualifications:

Responsibilities:

Certifications:

Work Experience:

Relevant Work Experience

Experience Level:

2 years

Education:

Bachelor's

Vanderbilt Health recognizes that diversity is essential for excellence and innovation. We are committed to an inclusive environment where everyone has the chance to thrive and to the principles of equal opportunity and affirmative action. EOE/AA/Women/Minority/Vets/Disabled