You’ll need
Certifications
✓Database (Oracle, Teradata, DB2, Sybase), Microsoft, Developer certifications.
Education
✓Bachelor’s degree in Information Technology (IT) or related field; or four (4) years experience in information technology may be substituted for the education requirement.
✓Graduate degree.
Qualifications
✓sitting, finger dexterity, seeing, hearing, speaking, lifting, pushing and carrying items up to usual weight of 5 pounds.
✓Continuous: reaching above, at and below shoulders; repetitive arm/hand motion and frequent gripping of objects.
✓Frequent: standing, walking, stooping/bending, and twisting body.
✓Operates various office equipment such as computers, copiers, 10-key adding machine, typewriter, facsimile, telephone, shredder etc.
✓In addition to the education requirement, five (5) years experience in database administration including the following:
✓o Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
✓o Experience with backups, restores, maintenance plans and recovery models.
✓o Advanced database object development, beyond tables and views, such as hand-coded stored procedures, user-defined functions, check constraints, indexing methods, partitioning, filestream.
✓o Experience with installing, upgrading, adding features and configuring MS SQL Server instances and migrating databases.
✓o Hands on experience with Extract, Transform, and Load (ETL) applications, Microsoft SQL Server – Integration Services (SSIS).
✓o Experience working with Windows server, including Active Directory.
✓o Thorough knowledge of practices, policies, and systems.
✓o Demonstrated application of information technology data and programming principles, theories, concepts, and best practice (e.g. requirements documentation, source code control, change management, promotions, and segregation of duties).
✓o Core tenants of Relational Database Management Systems (RDBMS) principles, processes, technologies and tools including management.
✓Strong sense of customer service to consistently and effectively address business and clinical partners’ needs.
✓Comfortable with ambiguity and changing priorities and direction in projects and core work.
✓Enjoys participating in a collaborative work environment partnering with colleagues inside and outside of own department.
✓Ability to maintain a high level of confidentiality.
✓Self-motivated; comfortable working independently under general direction.
Working with healthcare data systems, understanding of clinical operational measures, including experience with Electronic Medical/Health Record Systems (EMR/HER) and data (Epic/Clarity, ideally). preferred
Full employer posting
- Responsibilities I. JOB SUMMARY/RESPONSIBILITIES:
- Manages, administers, organizes, monitors, and maintains databases (DB) to support The Queen’s Health Systems (QHS) operations across all data domains (e.g. clinical, financial, employee, and patient experience). QHS is predominately, but not exclusively, a Microsoft SQL Server environment.
- Responsible for integrity of databases including, backup, recovery, capacity planning, security management, troubleshooting and issue resolution. Applies Relational Database Management System (RDBMS) and application DB updates as assigned.
- Performs tuning/optimization, testing, disaster recovery, development and ensures data quality.
- Provides consulting support to the Data Architecture team in all aspects of design, development and deployment of Enterprise Data Warehousing (EDW), applications and analytic solutions, including supporting data model/flow design and metadata accuracy.
- Maintains and monitors the health of upstream/downstream data flows in support of EDW operations, business intelligence (BI) initiatives and third party application suites.
- Trains and mentors junior-level team members in aspects of database administration. II. TYPICAL PHYSICAL DEMANDS:
- Essential: sitting, finger dexterity, seeing, hearing, speaking, lifting, pushing and carrying items up to usual weight of 5 pounds.
- Continuous: reaching above, at and below shoulders; repetitive arm/hand motion and frequent gripping of objects.
- Frequent: standing, walking, stooping/bending, and twisting body.
- Operates various office equipment such as computers, copiers, 10-key adding machine, typewriter, facsimile, telephone, shredder etc. III. TYPICAL WORKING CONDITIONS:
- Not substantially subjected to adverse environmental conditions. IV.
A. EDUCATION/CERTIFICATION AND
• Bachelor’s degree in Information Technology (IT) or related field; or four (4) years experience in information technology may be substituted for the education requirement. B.
- In addition to the education requirement, five (5) years experience in database administration including the following: o Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. o Experience with backups, restores, maintenance plans and recovery models. o Advanced database object development, beyond tables and views, such as hand-coded stored procedures, user-defined functions, check constraints, indexing methods, partitioning, filestream. o Experience with installing, upgrading, adding features and configuring MS SQL Server instances and migrating databases. o Hands on experience with Extract, Transform, and Load (ETL) applications, Microsoft SQL Server – Integration Services (SSIS). o Experience working with Windows server, including Active Directory. o Thorough knowledge of practices, policies, and systems. o Demonstrated application of information technology data and programming principles, theories, concepts, and best practice (e.g. requirements documentation, source code control, change management, promotions, and segregation of duties). o Core tenants of Relational Database Management Systems (RDBMS) principles, processes, technologies and tools including management.
- Strong sense of customer service to consistently and effectively address business and clinical partners’ needs.
- Comfortable with ambiguity and changing priorities and direction in projects and core work.
- Enjoys participating in a collaborative work environment partnering with colleagues inside and outside of own department.
- Ability to maintain a high level of confidentiality.
- Self-motivated; comfortable working independently under general direction.
- Effective written and verbal communication and presentation skills. V.
A. EDUCATION/CERTIFICATION AND
• Graduate degree. • Database (Oracle, Teradata, DB2, Sybase), Microsoft, Developer certifications. B.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Experience with Replication, Log Shipping, and/or Mirroring.
- Experience with MS SQL Server - Reporting Services (SSRS), and Analysis Services (SSAS).
- Experience with other enterprise class database systems (e.g. Teradata, Oracle, DB2, Sybase, MySQL).
- Working with healthcare data systems, understanding of clinical operational measures, including experience with Electronic Medical/Health Record Systems (EMR/HER) and data (Epic/Clarity, ideally).
- Experience with healthcare regulatory and clinical quality measurements frameworks such as NCQA HEDIS, Meaningful Use, PQRS, OPPE, CORE measures, etc.
- General understanding of analytics and statistics.
- Familiarity with development methodologies including the AGILE development approaches.
- Experience with Qlikview or other similar visualization and analysis tools (e.g. Tableau).
- Experience with data-driven web application development, e.g. ASP.net.
- Experience with scorecard/dashboarding visualizations to sustain and drive process improvement.
- Prior experience in leading projects and/or work streams and assignments. Experience with Big Data structures, platforms, programming languages such as R, Hadoop, Hive, NoSQL, Cloudera, MongoDB, predictive analytics, machine learning
- Self-motivated; comfortable working independently under general direction. Equal Employment Opportunity Equal Opportunity Employer / Disability / Vet
