POSITION SUMMARY The Database Administrator is responsible for the day-to-day operations and troubleshooting of all enterprise databases. This includes all aspects of database administration including installing, maintaining, monitoring, trouble shooting issues and upgrading. Assists with the design and implementation of next generation systems that will support the Information Services infrastructure as well. POSITION ACCOUNTABILITIES ,,X Responsible for all aspects of Enterprise Database Management. ,,X Manages all databases, performing database administration, database performance-tuning, security, maintenance and troubleshooting. ,,X Supports prototype development by designing, modeling and creating databases, stored procedures, triggers, etc., and moving all database objects to the production environment. ,,X Responsible for ensuring that development and staging databases are up to date. ,,X Responsible for the design, development, and implementation of mappings/transformations based on source-to-target specifications, development standards and conventions, performing monitoring and tuning of ETL jobs, and providing operational support to production ETL processes and code. ,,X Responsible for requirements analysis, design, development, performance analysis and tuning, testing, support and maintenance of database applications. ,,X Designs and develops data structures to store enterprise data. ,,X Manages scheduled database processes supporting automated file transfers. ,,X Maintains databases, including updating statistics, re-indexing, structure modifications, capacity planning, and index analysis. ,,X Manages database security, logins, users, roles, and object permissions. ,,X Develops best practices and supporting documentation. ,,X Maintains configuration management of database objects. ,,X Works with integrated project teams, as project database administrator for large-scale modifications and new product releases. ,,X Plans and executes small-scale database modifications and SQL scripts for bug fixes, data repair, and functionality enhancements following established change control policies and procedures. ,,X Implements database backup and recovery procedures, including disaster recovery procedures. ,,X Supports data replication to and from multiple web sites and maintains the underlying batch processes. ,,X Meets or exceeds all measurements as defined in the Information Services Service Level Agreements. ,,X Manages software upgrades, security patches and planned maintenance to minimize disruption of services following established Information Services change control procedures. ,,X Responsible for communicating all database performance degradation to the Information Services management and support staff. ,,X Develops and maintains technical documentation and project plans. ,,X Demonstrates the commitment to customer service by providing responsive and effective support, developing solid working relationships with customers and Information Services colleagues, and delivering high quality, value-added services that exceed customer expectations. In collaboration with Information Services Customer Services, develops and maintains a mechanism to monitor performance and customer satisfaction. ,,X Measures capacity and performance trends to determine long-term needs. ,,X Provides systems metrics, root cause analysis and proactive monitoring. ,,X Identifies areas of improvement in databases and implements improvements when approved. ,,X Works with the Disaster Recovery Team on creating, testing and updating disaster recovery plans. ,,X Provides other technical assistance as necessary for the successful completion of projects. ,,X Assist software engineers and end users with query writing, database access, and general information. ,,X Performs transaction analysis and performance tuning of database applications and batch processes. ,,X Prepares project status/progress reports on assigned activities. ,,X Demonstrates commitment by promoting and adhering to the System Office Code of Conduct, which includes the objectives of compliance program, policies and procedures and ethical business practices. ,,X Performs other duties as assigned by appropriate personnel. LEADERSHIP ACCOUNTABILITIES Empowering People: Actively participates in developing and maintaining a creative questioning organization united by a commitment to the Mission and Values of and characterized by open, honest communications and respect for the dignity of the person. Stewarding Resources: Carries on the Mission; ensures that Mission based considerations guide the use of human, financial, and material resources and shape plan for future services to those served. Integrating Values: Participates in developing and maintaining processes to ensure that the organization's Values are visibly reflected in all aspects of organizational life. Acts as Advocate: Acts to secure the human right to health care, especially for the poor and underserved; addresses issues of social justice; promotes conditions in society that contribute to health rather than illness. Supports Sponsor Priorities: Supports Sponsors by integrating their priorities for this sponsored health ministry into current services and the strategic plan. WORKING RELATIONSHIPS Contacts Information Services Colleagues Corporate Clinical and Administrative Colleagues RHC Clinical and Administrative Colleagues Representatives of external organizations (vendors, consultants, attorneys, auditors, other systems, etc.) Direct Reports None REQUIREMENTS Education, Certifications or Licenses: ,,X A Bachelor of Science degree from an accredited college or university with a major in Computer Science, Engineering or a related scientific or technical discipline. Experience: ,,X At least five years' experience as a SQL Server Database Administrator. ,,X At least five years of general information technology experience and Enterprise integration, data models to support transaction processing, and transactional business rules. ,,X Must have hands on experience with SSIS, ETL, DTS, T-SQL, and SQL server. Any experience with Oracle or Sybase is a plus. ,,X Experience with SQL Server Reporting Services (SSRS) and writing SQL based custom reports. ,,X Experience with SQL Server Replication. ,,X Experience in analyzing business/functional requirements and translating them into technical requirements and designs. ,,X Experience with commercial software development especially with large scale web based applications. ,,X Experience in technologies such as VB, ActiveX, COM/DCOM, XML Schemas, DOM, SQL, Web Services, HTML/DHTML, and IIS. ,,X Experience in data modeling, and developing database scripts and stored procedures. ,,X Experience in project management including defining requirements, tasks management, resource allocations, and time management.
Skills: ,,X Knowledge of SQL (with a variety of databases), XML, and object-oriented development. Experience with system design and integration tasks, comprising design and implementation of major systems, integration of systems elements, and related support systems. ,,X Advanced analytical and problem solving skills. ,,X Strong interpersonal skills. ,,X Excellent oral and written communication skills. ,,X Strong technical documentation skills. ,,X Flexibility to work in a 24x7 environment oriented towards a zero downtime target. ,,X Ability to follow established processes and guidelines for Change Management, Release Management, Problem and Incident management. ,,X Highly motivated having a strong sense of urgency, work well under pressure, high detail orientation and adept at multi-tasking. ,,X Team player with strong organizational skills, a positive attitude and customer service orientation. ,,X Technically strong individual with a breadth of understanding of information management, experience in large-scale integration, and who can embrace a large multi-level system. ,,X Innovative thinker who is able to see the big picture while remaining attentive to the details. Language skills: ,,X Candidate must have the ability to read, analyze, and interpret general business periodicals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Physical demands: ,,X While performing the duties of this job, the employee is regularly required to sit for long periods of time; use hands to finger, handle or feel; reach with hands and arms; and talk or hear. ,,X Specific vision abilities required by this job include close vision, depth perception, and ability to adjust focus.