Job Title: Epic Clarity / SQL Server DBA Must be on-site 4 days a week. All travel reimbursed. Needs - 2 When do you have to present candidates - Now Location – Sacramento Ca If you have Clarity Certified at more we will look at them. Start - Now Duration - 6+ - 12 months Status – They have asked us for this along with 2 other projects were working on for them. Description: Below is probably more information then you need, here is the summary. Must have: · Epic Clarity ETL experience · SQL Database Administration experience Nice to have: · Epic meaningful use and other reporting experience · Epic Clarity certified This list of job elements, responsibilities, skills, duties, requirements, or conditions is not exhaustive, but is merely the most descriptive of the current job. Management reserves the right to revise the job description or require that other tasks be performed when the circumstances of the job change (for example, emergencies, changes in personnel, workload, or technical development). Position Summary (also used as job posting language for Taleo, as applicable): Provides complex database development, maintenance and enhancements in support of Enterprise Data Warehouse (EDW) and associated applications. Lead role in establishing database strategies in support of Enterprise Data Warehouse solutions. Provides database optimization support to developers building Data Warehouse and Business Intelligence solutions. Top five principal accountability's: |----------------------------------------------------------------------------------+------ | Database development | 30% | | · Builds databases, stored procedures and scripts in support of EDW solutions designed by Data Warehouse Architects. | · Supports development staff during the build of EDW. | · Recommends database and fields naming conventions. | · Assists in the development of database extracts. | · Documents database models, scripts, stored procedures, promotion procedures and system architecture. | · Establishes development guidelines designed to maintain optimum performance. | · Advises Information Management Solutions Architect in the creation of development guidelines. | · Takes a new perspective on existing solutions, recommending new procedures and processes to achieve results. |----------------------------------------------------------------------------------+------| | Performance tuning and monitoring of databases | 30% | | · Establishes guidelines for query structure to maintain adequate performance. | · Proposes and implements enhancements that will improve the performance, reliability and data integrity of the system. | · Reviews queries for performance issues. | · Identifies and performs routine maintenance to ensure high performance. |----------------------------------------------------------------------------------+------| | Back-up and recovery | 10% | | · Recommends back-up schedule and strategy. | · May set up and regularly monitors back-up as specified by SLA. | · Adheres to enterprise disaster recovery policies and procedures. | · Performs database restores from back-up. |----------------------------------------------------------------------------------+------ | Database security and access | 10% | | · Researches and recommends security and data access strategies. | · Configures user database access based on approved policy, user roles andresponsibilities. | · Works with Security and Internal Audit to comply with corporate security standards. | · Audits data access as scheduled or requested. |----------------------------------------------------------------------------------+------ | Capacity planning | 10% | | · Performs 5 year capacity planning for hardware and software in support of EDW initiatives. | · Assesses impact of and recommends solutions based on current and future data volume needs. | · Allocates and reallocates database resources. | · Designs database system architecture to meet performance needs. | · Researches and recommends database strategies to management. | · Assesses and recommends vendor tools for enterprise databases. |----------------------------------------------------------------------------------+------ Administrator, Data Warehouse 3 3 |----------------------------------------------------------------------------------+------ | Supports developed applications | 10% | | · Adheres to all Enterprise Change Management (ECM) procedures per IS policy. | · Makes configuration upgrades. | · Identifies impact of enhancement requests. | · Assists customers to identify and resolve problems. | · Escalation point for complex issues. | · Provides formal or informal training to customers. | · Facilitates timely resolutions of database defects and issues. | · Develops procedures under approved policy structure. | · Provides users with highest quality service and system expertise and escalates issues appropriately. | · May analyze, create and deliver reports as assigned. |----------------------------------------------------------------------------------+------ Security: It is the responsibility of every employee to integrate security practices in dailywork by appropriately using and safeguarding SH IS resources in compliance with SH policies and procedures. Experience/Knowledge/Skills: · Relevant work experience as typically acquired 6 to 8 years. · Healthcare experience is desired. · Working knowledge of presentations, word processing and spreadsheet applications,preferably Microsoft. · Data modeling tools and EDW design concepts. · Database design and tuning. · Database back-up and recovery strategies. · High availability database design and management. · Expertise with export, transform and load tools preferred. · Strong working knowledge of data modeling tools. · Advanced MS SQL server skills preferred. · Strong written, verbal and presentation skills. · Ability to develop and deliver training. · Strong analytical and troubleshooting skills. · Good organizational, prioritization and time management skills. · Strong interpersonal skills with vendors, co-workers and users. · Ability to work independently and as a team member.