Job Actions

Job Information

Senior SQL Server DBA
NASHVILLE TN 37230
Category: Other
  • Your pay will be discussed at your interview

Job code: lhw-e0-90672721

Company Profile

Vanderbilt University Medical Center

Contact Company


Local Information

Laugh while you Look

Sponsored Ads

Summary

  Job posted:   Thu Jun 7, 2018
  Distance to work:   ? miles
       
  4 Views, 0 Applications  
 
Senior SQL Server DBA
This
is a full-time position with Vanderbilt Medical Center for an experienced SQL Senior
Server DBA. Position is responsible for SQL database administration,
architecture, evaluating data integrity, and ensuring optimal performance of
the database environment.





The
responsibilities for this role include data warehouse design including database
objects, schemas, tables; performance optimization, upgrades, configuration,
replication and maintaining the infrastructure of the database systems.
Additional skills with stored procedures, ETL, and exposure to SQL Server 2012
will be helpful.





Senior
level SQL Server DBA skills:





Key
skills include SQL Server (2008 and 2012), advanced SQL Server infrastructure
design, experience with database recovery/backup and advanced QA/data integrity
experience. Additional experience with data warehouse, data modeling and
advanced reporting will be an advantage





Additional
skills with stored procedures, ETL, and exposure to SQL Server 2012 will be
helpful.



Key skills include SQL Server (2008 and 2012), advanced SQL Server
infrastructure design, experience with database recovery/backup and advanced
QA/data integrity experience.






**TECHNICAL CAPABILITIES:**


_DATABASE SECURITY (INTERMEDIATE):_ - Has expertise in finding exposures in databases and in developing/installing safeguards to protect the database physically and the information on the database. Familiar with the external access safeguards to Databases. Has worked with a variety of databases and the applications that access the databases. Is familiar with the major database security vulnerabilities of Server Security, Database Connections, Table Access Control and Restricting Database Access.


_DATABASE PERFORMANCE TUNING (INTERMEDIATE):_ - Demonstrates knowledge of what metrics are available, understands their meaning, and can produce sophisticated reports for multiple database systems. Possesses sufficient knowledge, training, and experience to be capable of successfully delivering Database Performance Monitoring/Tuning without requiring support and instruction from others. Performs statistical analysis with performance tuning data.


_DATABASE BACKUP AND RECOVERY (INTERMEDIATE):_ - Demonstrates ability to prepare complex and dependent backup procedures for important operational and production grade files and systems, including operating systems, databases, tools, applications and other critical computer-based materials. Has experience with the advanced features of various backup tools. Knowledgeable in disaster recovery operations and procedures. Demonstrates the ability to react quickly to recover and restore files and databases that have been damaged or otherwise deemed unusable.


_PHYSICAL DATABASE MODELING (INTERMEDIATE):_ - Has designed advanced physical databases. Demonstrated the ability to bring all the various pieces together to complete the process of defining a database for a business application. Takes into consideration that the objects defined during physical modeling can vary depending on the relational database software being used. Has worked with at least two relational database systems that have variations with the way data types are represented and the way data is stored. Has prepared advanced 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 using vendor-supplied and company-developed procedures. Demonstrates the ability to use core utility programs in the installation and maintenance of systems. Demonstrates the ability to quickly analyze and resolve problems that may arise during a software installation. Demonstrates the ability to create and use complex utility programs to facilitate software installations.


**CORE ACCOUNTABILITIES:**


+ Organizational Impact: Independently delivers on objectives with understanding of how they impact the results of own area/team and other related teams.

+ Problem Solving/ Complexity of work: Utilizes multiple sources of data to analyze and resolve complex problems; may take a new perspective on existing solution.

+ Breadth of Knowledge: Has advanced knowledge within a professional area and basic knowledge across related areas.

+ Team Interaction: Acts as a go-to resource for colleagues with less experience; may lead small project teams.




**CORE CAPABILITIES:**



SUPPORTING COLLEAGUES (P3):




+ - Develops Self and Others: Invests time, energy and enthusiasm in developing self/others to help improve performance 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 (P3):




+ - 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 (P3):




+ - 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 (P3):




+ - 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 (P3):




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


Bachelor's Degree (or equivalent experience) and 5 years relevant experience


**Physical Requirements/Strengths needed & Physical Demands:**


+ Sedentary category requiring exertion up to 10 lbs. of force occasionally and uses negligible amounts of force to move objects. Sedentary work involves sitting most of the time.


**Movement**


+ Occasional: Standing: Remaining on one's feet without moving.

+ Occasional: Walking: Moving about on foot.

+ Occasional: Lifting under 35 lbs: Raising and lowering objects under 35 lbs from one level to another

+ Occasional: Carrying under 35 lbs: Transporting an object holding in hands, arms or shoulders, with help of coworkers or assistive device.

+ Occasional: Bending/Stooping: Trunk bending downward and forward by bending spine at waist requiring full use of lower extremities and back muscles

+ Occasional: Reaching above shoulders: Extending arms in any direction above shoulders.

+ Frequent: Sitting: Remaining in seated position

+ Frequent: Reaching below shoulders: Extending arms in any direction below shoulders.

+ Frequent: Fingering: Picking, pinching, gripping, working primarily with fingers requiring fine manipulation.

+ Frequent: Bimanual Dexterity: Requiring the use of both hands.


**Sensory**


+ Continuous: Communication: Expressing or exchanging written/verbal/electronic information.

+ Continuous: Auditory: Perceiving the variances of sounds, tones and pitches and able to focus on single source of auditory information

+ Continuous: Vision: Clarity of near vision at 20 inches or less and far vision at 20 feet or more with depth perception, peripheral vision, color vision.

+ Continuous: Smell: Ability to detect and identify odors.


**Environmental Conditions**


**Job** _Information Technology_


**Organization:** _VUMC IT Oracle/SQL 108090_


**Title:** _Senior SQL Server DBA_


**Location:** _TN-Nashville-3401 West End Ave_


**Requisition ID:** _1805406_

More Information »