Senior Sql Database Administrator

Company: Vanderbilt University Medical Center
Location: Nashville
Posted on: November 22, 2021

Job Description:

Senior SQL Database Administrator - 2110343Job : Information TechnologyPrimary Location : TN-Nashville-3401 West End AveOrganization : HealthIT Peri-Procedural App 108858Shift: : DaysDescriptionJOB SUMMARY:The Senior SQL Database Administrator designs, models, configures, tests and installs databases independently. The Sr. SQL Database Administrator provides support services for database creation, performance, monitoring, tuning and capacity planning. Designs and builds physical data structures. Recommends, develops and enforces policies and procedures for maintaining the security and integrity of the database and ensures the database meets availability and disaster recover requirements. Functions as lead on projects and may lead teams. Coaches the development of other SQL DBAs. Implements complex large/multiple development projects. Responsible for reviewing all data development activities and approve promotion to production environments. Database administration spans custom and vendor managed products. SQL Database administrator is responsible for understanding concepts and implementation of Windows Server clusters, SQL Server clusters, availability groups, and disaster recovery.KEY RESPONSIBILITIES: Develops and implements complex and large 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. Review and test data development / queries for performance impact and overall integrity of the database. The responsibilities listed are a general overview of the position and additional duties may be assigned.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.About the Department:Health ITHealthIT 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 discoveriesOur 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 : DaysDiscover 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 AccomplishmentsBecause 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.Basic QualificationsPOSITION QUALIFICATIONS : Bachelor's Degree (Required) 5 years relevant experiencePhysical 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 ConditionsReq ID: 2110343Vanderbilt University Medical Center is committed to principles of equal opportunity and affirmative action.

Keywords: Vanderbilt University Medical Center, Nashville , Senior Sql Database Administrator, IT / Software / Systems , Nashville, Tennessee