GLFHC is currently seeking a Senior Database Administrator. This position is responsible for the administration of all Greater Lawrence Family Health Center databases. The person in this position serves as a resource for Health Center data analysts, EMR managers, and Health Center administrators regarding database design and use, web-based clinical data applications, and information related to clinical, educational and research activities within the Health Center and residency programs. Further, they work to design, implement, and continually improve knowledge of others in the Health Center about database structures and utilization. Job Responsibilities and Performance Standards:
- Design, implement and continually improve databases across GLFHC. Strive for maximum uptime.
- Perform data analysis in pursuit of accurate Reporting Services and Webfocus Reports.
- Design, document and monitor ETL for our data warehouses utilizing various technologies - including SSIS and DataMigrator.
- Ensure database backups are done in a timely manner in order to minimize disruptions and allow for the quickest disaster recovery turnaround.
- Design and document interfaces between the GLFHC application databases including the EMR, practice management, pharmacy, research and reporting databases. Facilitate interconnections between GLFHC and external systems regarding health information, electronic communication, and health outcomes data.
- Design, document, and administer the structure and utilization of clinical, administrative, reporting and research databases using state-of-the-art software, hardware, and security systems.
- Advise Information Services management about resource needs to provide appropriate database hardware, software, and personnel to support the needs of the organization.
- Maintain up-to-date knowledge and capacity to assist in the purchase and installation of needed information resources within the defined policies of the organization.
- Help to maximize the efficiency of the utilization of information resources in collaboration with the academic and clinical arms of the organization.
- Provide technical support to clinicians, administrators, researchers and technical staff regarding the design and utilization of database technology in the achievement of the goals and objectives of the organization.
- Act as the technical resource for the maintenance and tuning of databases within GLFHC and all associated programs including MS SQL Server 2008 and its successors and Access.
- Design and manage systems for data collection, entry, storage, and analyses in cooperation with other GLFHC information systems specialists.
- Understand the processes each program uses to obtain data in order to create appropriate configurations.
- Document procedures and train staff to access data from MS SQL Server 2008 and its successors and other databases as required. Assist Information Services Applications Manager in the purchase, installation and maintenance of equipment and inventory; upgrade as necessary.
- Assist the GLFHC management to prepare project reports for the funding agencies, if asked.
- Provide data summaries as requested for reports using multiple software packages and web-based resources including MS Office, Access, Excel, MS Reporting Services, Infoassist, Webfocus and MS SQL Server 2008 and it's successors.
- Evaluate and monitor utilization, solicit informal feedback on GLFHC database architecture and complete annual assessment forms as requested.
- Design and implement web-based applications for use by GLFHC as assigned by the Information Services Applications Manager.
- Clearly communicate and/or escalate to their Manager, IS staff, and Support Services, and other concerned entities (vendors, etc.) when necessary, regarding any IS Application issues or disruptions (planned or unplanned) to insure clear communication and minimize Customer/user impact.
- Work collaboratively with internal and external groups in a team environment to improve overall customer service and support. On a regular basis participate in ongoing quality improvement activities related to individual, team, and organizational performance improvement.
- Make recommendations about IS standard images for the various PC's and servers throughout the health center (Desktop/Laptop/Citrix) according to GLFHC procedures and policy to insure a consistent environment.
- Complete all activities within GLFHC security policies and practices to insure the safety and privacy of data, its clients, and its resources.
- Act as a technical resource to Information Services staff to facilitate the effective utilization and deployment of technology.
- Develop and maintain relationships with other GLFHC Information System staff, and information systems staff members at the state and other funding agencies.
- Coordinate the design, implementation, evaluation, and continual improvement of a comprehensive program in the use of computers and health information technology for all programs at GLFHC.
- Define and document what health information technology are used/to be used by research faculty and residents in conjunction with Information Services management.
QualificationsExperience:
- Seven years total experience in a large database environment. Five years of MS SQL Server 2008 and its successors including creation and deployment of SSIS Packages.
- Demonstrated ability to author and maintain MS Reporting Services Reports;2 years of SQL Reporting Services experience.
- Demonstrated knowledge and ability to act as a Project Manager when needed.
- Demonstrated knowledge of design and implementation of security concepts in a database environment. Knowledge of HITECH and HIPAA required.
- Prior knowledge of Webfocus, App Studio and Data Migrator desirable.
- Prior knowledge of EMR Software desirable.
- Demonstrated working knowledge of database design theory and architecture including relational and hierarchical design and implementation.
- Demonstrated experience working constructively with application vendors and their use of database products in order to maximize performance.
- Basic understanding and familiarity with PC hardware and Microsoft operating systems.
- Excellent knowledge of Microsoft applications.
- Demonstrated working knowledge of systems analysis, quality improvement theory, and team concepts.
- Knowledge about complementary roles such as Data Analysts, Network Administrators, etc.
- Knowledge about website design and maintenance.
- Must be conscientious, thoughtful, and invested in the importance of patient care in a family practice setting including research, and community action.
- Abilities to function independently, consult with professionals, prioritize job responsibilities, and help those involved in common projects to achieve milestones according to time-lines.
- Must be able to communicate effectively to professional staff.
- Must be a team player who understands the value of listening as part of the communication process.
Education:
- Bachelor's Degree in computer programming or closely related area or equivalent experience is required.
- Training in MS SQL Server 2008 and newer database development and support required.
- Certification as a Database administrator preferred.