Work whereevery momentmatters. Every day, approximately 38,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut’s most comprehensive healthcare network. The creation of the HHC System Support Office recognizes the work of a large and growing group of employees whose responsibilities are continually evolving so that we and our departments now work on behalf of the system as a whole, rather than a single member organization. With the creation of our new umbrella organization we now have our own identity with a unique payroll, benefits, performance management system, service recognition programs and other common practices across the system. The Database Administrator develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of company databases. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. Collaborates and consults with application support teams to fully understand database requirements, issues, and concerns and to maintain database operations according to service level agreements. Provides consulting services to application support teams, DBA teammates, and management for purposes of explaining and defining optimal database strategies and operations. Comply with departmental strategies and operational service level agreements. Mentors junior DBAs and collaborates with peers to achieve all of the above across all databases. Provide expert, hands-on production support of mission-critical and other assigned databases. Monitors assigned databases for performance, maintenance, and tune these databases as appropriate to maintain predefined service level agreements. Install, upgrade, patch, backup, and recover assigned databases as specified by business and compliance requirements. Adheres to company change control processes. Develops patch management strategy for the database environment. The position reports to the ITS Enterprise Data Manager. This role is regarded as a technical expert responsible for representing IS during project discussions at their early conception. Specifically, working with the various business unit representatives at the hospital and gathering their requirements for new upcoming initiatives and translating those requirements into technical solutions. These solutions must meet the objectives of the business while ensuring compliance with IS standards of security and manageability. KEY ACCOUNTABILITIES · Responsible for the design, implementation, support and maintenance of all functions of relational database systems · Responsible for the following: database security access and documentation. · Monitor overall standards and procedures and assist in integrating various systems · Consult with users, determine requirements and recommend database establishment and utilization · Provide database administration for mission-critical custom and packaged database software · Design storage strategies around backup and recovery for complex database environments, physical structures, and specialized database applications/systems · Uphold enterprise policy guidelines and recommend new/improved guidelines · Partner with project teams and interact with customers to find solutions for projects and operational issues for existing and proposed databases · Act as a liaison serving as primary point of contact between application business segments and database administrators · Demonstrate proficiency in database administration, physical structure, overall architecture, and performance analysis · Provide build standardization and consistency across production and non-production environments · Implement database monitoring to ensure operational stability. · Identify and initiate resolutions to user problems and concerns associated with database server equipment (hardware and software) · Anticipate customer needs and proactively develop solutions to meet them · Serve as a key resource on complex and/or critical issues · Support help desk personnel in troubleshooting. · Protect and maintain user data at all times. QUALIFICATIONS: · Bachelor's degree in Computer Science preferred or five (5) years of work-related experience may substitute for minimum education requirement · At least 5 years’ experience administering Oracle SQL Server databases · Current, professional-level certification in database administration is highly desirable · Experience writing SQL queries, generating reports and writing scripts to automate processes · experience with EPIC Clarity and Caboodle · active EPIC credentials preferred · Knowledge of, and experience supporting Oracle Database, 19c and later is a plus · Knowledge of, and experience with Cloud computing platforms is a plus · Experience implementing and configuring Linux server, especially Red Hat Enterprise is a plus · Design new client environments before the environment build process is started · Monitoring current server capacities and recommending the timing for new server purchases · Proactively investigate and suggest better uses of current technologies that help with gaining efficiencies or saving money · Understanding of and adherence to Microsoft’s Best-Practices for database administration and security · Conceptual understanding of highly availability database architectures · The knowledge and ability to perform in all of the basic database management skills of database administration o Develop, implement, and maintain processes and procedures for database administration on production and non-production servers o Develop scripts and/or jobs to perform routine database administration tasks o Development and maintain support key performance metrics, reports, and operational alerts o Manage database backup and recovery o Management of database patching implementation requirements for the enterprise o Assist System Administrators with system Patch/Fix and other teams in planning, tuning, upgrade, and build efforts o In depth experience performing database tuning and performance analysis o Assist in the development of policies for data management pertaining to security, auditability, and privacy, and ensure these policies are complied with · Provide on-call DBA support as part of a team rotational schedule · Due to sensitive security and financial responsibilities, must successfully pass Credit/Financial screenings • Strong troubleshooting skills required • Analytical and problem-solving capabilities. • Ownership of problem resolution • Ability to prioritize and execute tasks in a high-pressure environment. • Strong customer-service orientation. • Good judgment, integrity and confidentiality. • Strong written and oral communication skills. • Ability to appropriately handle stressful situations, critical deadlines, and a customer base with both high service level expectations and technical sophistication. • Availability to work nights and weekends during (un)planned outages and other special circumstances, with 24/7 accountability. • Healthcare experience desirable · Ability to maintain records and filing systems · Ability to multi-task · Ability to work independently · Process improvement and quality skills · Project management skills ORGANIZATIONAL COMPETENCIES · Attends all mandatory education and training programs (including department specific) and can describe his/her responsibilities related to general safety and regulatory compliance as well as department safety and specific job-related hazards. · Maintains all required CEUs for certifications and licensure. · Follows the hospital exposure control plans/bloodborne and airborne pathogens. · Attire is professional, neat, clean, and appropriate for the work environment, according to the HHC and/or Department Appearance Policy and a high standard of personal cleanliness is maintained. · Reports to work on time and meets acceptable standard for attendance, based upon the department attendance policy. We take great care of careers. With locations around the state, Hartford HealthCare offers exciting opportunities for career development and growth. Here, you are part of an organization on the cutting edge – helping to bring new technologies, breakthrough treatments and community education to countless men, women and children. We know that a thriving organization starts with thriving employees-- we provide a competitive benefits program designed to ensure work/life balance. Every moment matters. And this is your moment. *Job: Information Technology *Organization: Hartford HealthCare Corp. *Title: *ITS Application Analyst III / IS Tech Support Location: Connecticut-Newington-Curtis-181 Patricia Genova Dr (10016) Requisition ID: 23162580