The role of this position is to provide knowledge, skills, and experience as a MySQL and SQL Server Administrator and programmer. This includes the installation, upgrade, configuration, performance tuning, maintenance, and support of complex mission-critical relational database management systems and application software supporting the remote servers within the School of Medicine departments. The database administrator has a lead role in the development of departmental and educational application projects. Also maintains and updates existing database schemas, data dictionary and other database-related documentation. Responsible for supporting and trouble-shooting data-related issues. Provides technical expertise to departments in their integration of databases and development of complex projects. Uses specialized knowledge of database design and development, optimization and normalization of data.REQUIRED --Experience with MySQL and/or MariaDB replication and clustering. --Ability to translate business requirements into functional specifications and SQL.--Data Flow Diagram, Process Modeling, Analysis of Business Requirements--Ability to create Logical and Physical Database Models (such as Entity Relationship and Data Flow diagrams)--Ability to integrate large scale databases with Oracle, MS SQL, MySQL or similar RDMS--Proficient with Database-system and database-management fundamentals and understanding of database design--Abilities include developing and implementing database schemas, backup strategies, data usage analysis, periodic and ad hoc reports.--Ability to create and open up very complex stored procedures/triggers and debug.--Experience in working with various db instances (dev,test,stage, prod)--Ability to multitask in an agile development environment working on multiple projects at the same time--Experience in data migration from same or different data sources--Specify user and user access levels for each segment of database--Experience modeling, designing and creating relational databases with solid understanding of referential integrity, normalization, attribute definition and query writing (Transact-SQL, PL/SQL, SQL)--Knowledge of various mechanisms for efficiently importing/exporting large amounts of data--Knowledge of any tools for database queries, data input, and report delivery.--Configure MySQL server options at runtime and maintain integrity of a MySQL installation utilizing security protocols--Understand data locking concepts and the different levels of locking in MySQL--Optimize Schemas (Databases) utilizing multiple techniques--Knowledge creating instances with the initialization parameters and database structures that represent database best practices--Demonstrated effectiveness and success working in a project focused environment. This includes a solid background working on and/or developing projects of various sizes, and experience delivering objectives on time, within budget, and with a high degree of quality.--Extensive in-depth experience with the RDBMS systems and SQL is required for the incumbent to perform complex analysis of application requirements, database design, develop monitoring scripts and tune performance. --Previous experience developing and maintaining database level security in all database environments. Review and implement security guidelines and mechanisms. --Demonstrated organizational and analytical skills.--Excellent written and oral communication skills.--Ability to work independently with a minimum of supervision. --Willingness to learn and apply new technology. --Willingness to develop skills to promote professional growth.PREFERRED--Experience in infrastructure architecture for highly available, scalable, fault-tolerant, and load balanced server clusters--Demonstrated experience with Eclipse, Java, SVN and web application containers--Experience with Linux operating system, SSH and SSH key management--Good knowledge of application security, platform hardening against intrusions, vulnerability assessment, and source code analysis techniques--Ability to perform basic administration of Linux & Virtual Server technologies and environments--Demonstrable experience in the preparation of project plans and estimates. --Bachelor's Degree in Computer-Science/Engineering SPECIAL REQUIREMENT - THIS POSITION MAY BE SUBJECT TO A CRIMINAL BACKGROUND INVESTIGATION, DRUG SCREEN, LIVE SCAN FINGERPRINTING, MEDICAL EVALUATION CLEARANCE, AND FUNCTIONAL CAPACITY ASSESSMENT
About University of California Davis Medical Center
At the end of 2015, we launched a comprehensive and inclusive process to tap into the broad, diverse knowledge of our entire UC Davis Health community to stimulate new and unique ideas for our next strategic plan.Throughout 2016, hundreds of members of our UC Davis Health family, as well as external friends and partners, took part in conversations and provided valuable input into charting a long-t...erm course for our future that will continue the momentum underway to solidify our position as a top-tier health care organization.With your valuable input and talents, I am excited to launch our six new strategic plan goals. Over the next few years, together we will:Lead Person-Centered Care in the best way, at the best time, in the best place, and with the best teamReimagine Education by cultivating diverse, transdisciplinary, life-long learners who will lead transformation in health care to advance well-being and equity for allAccelerate Innovative Research to improve lives and reduce the burden of disease through the discovery, implementation and dissemination of new knowledgeImprove Population Health through the use of big data and precision healthTransform Our Culture by engaging everyone with compassion and inclusion, by inspiring innovative ideas, and by empowering each otherPromote Sustainability through shared goals, balanced priorities and investments in our workforce and in our communityAt a time when our industry is experiencing some of the most formidable changes ever, these are bold aspirations that will anchor us and provide us with clarity of purpose and a path forward. I am fully confident that we will achieve great success knowing we have a solid plan and areas of focus to guide us.I thank everyone who participated in the planning process for their great input and their dedication to our future success.