Database Administrator is responsible for planning andadministering all activities related to complex, integrated databases; thisincludes providing support services for system performance, development andreliability for a MS SQL Server database environment.
Experience with MS SQL Server 2012+, SSIS,T-SQL
Experience with Tableau or Epic is a plus butnot required
Strong written and verbal communication
Administer and Manage Data Warehouse Database
Primary support for the technicaldesign and development of software and tools supporting the data acquisition,transformation, loading, cleansing and validation process.
Monitors the performance of the dataload processes ensuring availability meets established service levels.
Maintain the physical organization ofdatabase objects ensuring the database performs optimally. Creates useraccounts, group profiles and manage security access at the instance, schema,table and view level by providing group and individual account roles and otheraccess methods as needed.
Monitor and analyze system performanceand capacity data identifying potential problems before they occur
Review modifications to the database,manage DDL and maintain objects and libraries.
Provide support for differentenvironments (changes, refreshing, cloning)
Configure front and back-endconnectivity ensuring communication requirements are met and transactions aresuccessful
Plan and coordinate technology changeswith other departments. Provide advance level on-call 24x7 support.
Guide users to define and externalizethe metadata (intended use of data, data source, etc.)
Creates views, indexing, partitions,table reorganizing, analyze tuning provided by database utilities to improveand maintain satisfactory response times for users requesting information fromthe database tables.
Proactively evaluate potential issues,and provide solutions to existing performance concerns as identified by systemmonitors.
Architect, develop, and maintain SSIS packages and SSIS batchjobs involving complex source data
Ensure ETL processes are consistent and adheres toestablished standards
Design, implement and maintain T-SQL scripts, stored procedures
Vanderbilt University Medical Center is a comprehensive health care facility dedicated to patient care, research, and biomedical education. Our reputation for excellence in these areas has made us a major center for patient referrals from throughout the Mid-South. Each year, people throughout Tennessee and the Southeast choose Vanderbilt University Medical Center for their health care because of o...ur leadership in medical science and our dedication to treating patients with dignity and compassion.The mission of Vanderbilt University Medical Center is to advance health and wellness through preeminent programs in patient care, education, and research.