Database Analyst

Source Medical Alpharetta , GA 30023

Posted 2 months ago

Since 1996, Surgical Information Systems ("SIS") has been dedicated to providing surgical care providers with the solutions and services they need to deliver improved operational, financial, and clinical outcomes. Focused exclusively on perioperative IT, SIS serves over 2900 facilities across the United States and Canada.

The SIS product suite is built specifically for the perioperative environment and includes hospital and ASC-focused solutions covering perioperative Electronic Medical Records (EMRs), Anesthesia Information Management Systems (AIMS), ASC business management, and business intelligence and analytics solutions. SIS' AmkaiCharts solution, is the No. 1 ranked outpatient EMR[1]. Services, including revenue cycle management and ASC advisory services, complement SIS' software solutions.

For more information, visit SISFirst.com.

SIS, the SIS logo, and Surgical Information Systems are trademarks of Surgical Information Systems, LLC. AmkaiSolutions, AmkaiCharts, AmkaiOffice, and AmkaiAnalytics are trademarks of Amkai LLC. AdvantX, Vision, and SurgiSource are trademarks of Source Medical. Other company and product names may be trademarks of their respective owner.

[1] Black Book Research Rankings April, 2017 http://www.blackbookmarketresearch.com/ambulatory-alternate-site-ehr/ and "Top Ambulatory Electronic Health Records Vendors Comparative Performance Result Set of Top EHR Vendors," May 2016.

This position is responsible for the support of all internal and remote/virtual associates of SIS. This position will troubleshoot associate workstations as well as application support, operating system support, back-up processes, configuration of new hires, and managing support tickets.

This job is responsible for providing database analysis/design, management and day-to-day administration of the reporting databases within a BI environment This may involve working with SIS internal business process owners, business SME's (i.e. subject matter experts) and IT teams to manage data loads or other database activities, analysis of the reporting/ business intelligence tools to ensure optimal use of database.

ESSENTIAL DUTIES/ RESPONSIBILITIES:

  • Managing the database artifacts and providing subject matter expertise on best practices for creation, deployment and ongoing management of databases in a reporting/BI environment

  • Monitoring daily/other database jobs (SSIS) and data loads and proactive resolution of issues to ensure maximum up-time/availability of database for reporting

  • Designing databases and some data sourcing/ETL requirements for efficient use in reporting and BI

  • Performing routine database administration activities including setup login credentials for users & administer general security measures on database, to resolve and troubleshoot database access/other database issues, handle the backing up process of the database & its inspection

  • Provide support and participate in design and implementation of ETL processes and procedure

Database Management/Administration 70-80% of time includes the following activities:

  • Design & Develop dimensional and normalized data models describing data elements and how they are used, following standard data modeling practices for a Data Warehousing and Business Intelligence platform. Write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary.

  • Build database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems. Setup database for appropriate data sharing and disk partitioning, test programs or databases, correct errors and make necessary modifications.

  • Oversee backup, clustering, mirroring, replication and fail-over. Restore and recover corrupted databases. Implement security and encryption to the database and data source files to safeguard information against accidental or unauthorized use, modification or disclosure.

Approve, schedule, plan, and supervise the installation and testing of new data sourcing packages/jobs and improvements to existing data acquisition including setup of new data sources.

  • Analyze, consolidate and tune database for optimal efficiency, monitor systems and platforms for availability, monitor database jobs for timely and accurate completion, and monitor capacity and performance of database and jobs for effective up-time and response time to the consumers of the data.

  • Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.

Support ETL Design & Implementation 20-30% of time includes the following activities:

  • Support development of the ETL architecture/design and developing a solution in highly demanding environment. Identify, recommend and implement best practice ETL process and architecture improvements

  • Implement, maintain and enhance ETL solution fulfilling data quality, availability, data freshness and performance requirements, working with the business & data analysts to understand the business requirements to be fulfilled by the data, assessing requirements for completeness and accuracy.

  • Develop methods for integrating different data sources so they work properly together, such as customizing standard source system/product databases to fit specific needs. Analyze and interpret all complex data on target system and analyze and provide resolutions to all data issues and coordinate with analysts to validate all requirements

  • Strong OLAP experience required

  • 4-year degree (or equivalent experience) in IT, Computer Science, or Business Intelligence

  • 4+ Year of DBA experience with Microsoft SQL Server/Azure

  • Strong ability to communicate problems that occur to a technical and business audience

  • Preferred Certification in SQL Server development/ETL design & development

  • Expert level knowledge of Database Administration for MSSQL Server.

  • Excellent knowledge of data backup, recovery, security, and integrity. Capable of troubleshooting common database issues.

  • Experience in Performance Tuning and Optimization, including both query and server optimization, using native monitoring and troubleshooting tools.

  • Skilled at writing and optimizing large complicated SQL statements.

  • Expertise in understanding complex business needs, analyzing, designing and developing solutions.

  • Advanced communication and professional skills and the ability to establish relationships across business units.

  • Ability to participate in an on-call support rotation and provide non-standard work hour support.

  • Knowledge of High Availability and Disaster Recovery options for MSSQL Server.

  • Hands-on development experience in SQL Server 2012/2016.

  • Experience with SSIS, SSRS

We believe employees are our greatest asset and we empower them to make a difference in our business. Diversity and inclusion makes us all better. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, age, disability, protected veteran status, and all other protected statuses.

At this time we are unable to sponsor H1B candidates

#ZR


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Database Analyst

Surgical Information Systems

Posted 2 months ago

VIEW JOBS 11/6/2019 12:00:00 AM 2020-02-04T00:00 Since 1996, Surgical Information Systems ("SIS") has been dedicated to providing surgical care providers with the solutions and services they need to deliver improved operational, financial, and clinical outcomes. Focused exclusively on perioperative IT, SIS serves over 2900 facilities across the United States and Canada. The SIS product suite is built specifically for the perioperative environment and includes hospital and ASC-focused solutions covering perioperative Electronic Medical Records (EMRs), Anesthesia Information Management Systems (AIMS), ASC business management, and business intelligence and analytics solutions. SIS' AmkaiCharts™ solution, is the No. 1 ranked outpatient EMR[1]. Services, including revenue cycle management and ASC advisory services, complement SIS' software solutions. For more information, visit SISFirst.com. SIS, the SIS logo, and Surgical Information Systems are trademarks of Surgical Information Systems, LLC. AmkaiSolutions, AmkaiCharts, AmkaiOffice, and AmkaiAnalytics are trademarks of Amkai LLC. AdvantX, Vision, and SurgiSource are trademarks of Source Medical. Other company and product names may be trademarks of their respective owner. [1] Black Book Research Rankings – April, 2017 http://www.blackbookmarketresearch.com/ambulatory-alternate-site-ehr/ and "Top Ambulatory Electronic Health Records Vendors Comparative Performance Result Set of Top EHR Vendors," May 2016. This position is responsible for the support of all internal and remote/virtual associates of SIS. This position will troubleshoot associate workstations as well as application support, operating system support, back-up processes, configuration of new hires, and managing support tickets. This job is responsible for providing database analysis/design, management and day-to-day administration of the reporting databases within a BI environment This may involve working with SIS internal business process owners, business SME's (i.e. subject matter experts) and IT teams to manage data loads or other database activities, analysis of the reporting/ business intelligence tools to ensure optimal use of database. ESSENTIAL DUTIES/ RESPONSIBILITIES: * Managing the database artifacts and providing subject matter expertise on best practices for creation, deployment and ongoing management of databases in a reporting/BI environment * Monitoring daily/other database jobs (SSIS) and data loads and proactive resolution of issues to ensure maximum up-time/availability of database for reporting * Designing databases and some data sourcing/ETL requirements for efficient use in reporting and BI * Performing routine database administration activities including setup login credentials for users & administer general security measures on database, to resolve and troubleshoot database access/other database issues, handle the backing up process of the database & its inspection * Provide support and participate in design and implementation of ETL processes and procedure Database Management/Administration – 70-80% of time includes the following activities: * Design & Develop dimensional and normalized data models describing data elements and how they are used, following standard data modeling practices for a Data Warehousing and Business Intelligence platform. Write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary. * Build database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems. Setup database for appropriate data sharing and disk partitioning, test programs or databases, correct errors and make necessary modifications. * Oversee backup, clustering, mirroring, replication and fail-over. Restore and recover corrupted databases. Implement security and encryption to the database and data source files to safeguard information against accidental or unauthorized use, modification or disclosure. Approve, schedule, plan, and supervise the installation and testing of new data sourcing packages/jobs and improvements to existing data acquisition including setup of new data sources. * Analyze, consolidate and tune database for optimal efficiency, monitor systems and platforms for availability, monitor database jobs for timely and accurate completion, and monitor capacity and performance of database and jobs for effective up-time and response time to the consumers of the data. * Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project. Support ETL Design & Implementation – 20-30% of time includes the following activities: * Support development of the ETL architecture/design and developing a solution in highly demanding environment. Identify, recommend and implement best practice ETL process and architecture improvements * Implement, maintain and enhance ETL solution fulfilling data quality, availability, data freshness and performance requirements, working with the business & data analysts to understand the business requirements to be fulfilled by the data, assessing requirements for completeness and accuracy. * Develop methods for integrating different data sources so they work properly together, such as customizing standard source system/product databases to fit specific needs. Analyze and interpret all complex data on target system and analyze and provide resolutions to all data issues and coordinate with analysts to validate all requirements * Strong OLAP experience required * 4-year degree (or equivalent experience) in IT, Computer Science, or Business Intelligence * 4+ Year of DBA experience with Microsoft SQL Server/Azure * Strong ability to communicate problems that occur to a technical and business audience * Preferred – Certification in SQL Server development/ETL design & development * Expert level knowledge of Database Administration for MSSQL Server. * Excellent knowledge of data backup, recovery, security, and integrity. Capable of troubleshooting common database issues. * Experience in Performance Tuning and Optimization, including both query and server optimization, using native monitoring and troubleshooting tools. * Skilled at writing and optimizing large complicated SQL statements. * Expertise in understanding complex business needs, analyzing, designing and developing solutions. * Advanced communication and professional skills and the ability to establish relationships across business units. * Ability to participate in an on-call support rotation and provide non-standard work hour support. * Knowledge of High Availability and Disaster Recovery options for MSSQL Server. * Hands-on development experience in SQL Server 2012/2016. * Experience with SSIS, SSRS We believe employees are our greatest asset and we empower them to make a difference in our business. Diversity and inclusion makes us all better. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, age, disability, protected veteran status, and all other protected statuses. At this time we are unable to sponsor H1B candidates #ZR Surgical Information Systems Alpharetta GA

Database Analyst

Source Medical