Database Adminstrator

Company Description:

Founded in 2006, eHealth Technologies is the leading provider of medical record retrieval and organization services and image-enabled Health Information Exchanges (HIEs). With customers across the country, eHealth Technologies works with prominent HIEs and the nation’s top-ranked hospitals, including 17 of the 20 US News & World Report Honor Roll Hospitals for 2020-2021. The company’s eHealth Connect® solution enhances patient and physician satisfaction by streamlining referrals and intelligently aggregating patients’ clinical records. This assures physicians have the right healthcare information to care for their patients, right when they need it. As a critical adjunct to HIEs, eHealth Connect® Image Exchange enables the automated access to all types of medical images in the context of the aggregated patient record, in full diagnostic quality.

Career Description:

Database Administrator will have a strong technical background in SQL Server, Azure SQL, CosmosDB, SQL, SSRS, SSIS, and SSAS. The ideal candidate will have experience in Azure DevOps processes, including the ability to create, set up, and manage these systems.

As a Database Administrator, you will be responsible for maintaining and optimizing our database systems to ensure maximum uptime and performance. You will work closely with other members of the technical team to design and implement database solutions that meet the needs of the organization. Additionally, you will be responsible for managing database security, backups, and disaster recovery processes.

The successful candidate will be a self-starter who is comfortable working in a dynamic, fast-paced environment. They will have excellent problem-solving skills and be able to work independently with minimal supervision. Additionally, they should be able to communicate effectively with both technical and non-technical team members.

Primary Responsibilities:

1. Solve highly technical and complex problems.

2. Conduct the following for Azure SQL/CosmosDB/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary

3. Install/Configure/Setup/Administer and Maintain production and non-production environments

4. Setup High-Availability and Disaster Recovery

5. Plan and test high availability and disaster recovery

6. Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets

7. Resolve database integrity, performance, blocking, connectivity, and replication issues.

8. Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.

+. Perform and manage Database backup/recovery/restore and capacity monitoring

10. Synapse workload management and optimization

11. Setup SQL agent jobs, elastic jobs and runbook automation

12. Identify and setup alerts and logging in Azure

13. Maintain databases – Statistics, Indexes, fragmentation

14. Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)

15. Implement operational automation using scripts.

16. Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)

17. Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.

18. Deploy and configure SSIS packages and SSRS Reports. Troubleshoot issues with SSRS and SSIS.

1+. Design and create databases to support development initiatives

20. Synapse workload management and optimization

21. Support release/code deployment activities

22. Provide 24x7 support as necessary

Information Privacy and Security

In an effort to safeguard the information privacy and security of all covered information Employee shall also be responsible for:

· Following eHealth Technologies’ information privacy and security policies, procedures, standard operating procedures, appendices, attachments, etc.

· Accessing, using, and disclosing only the minimum necessary covered information that is needed for job responsibilities, or otherwise allowed by law.

· Safeguarding the confidentiality, integrity, and availability of covered information at all times, whether or not on duty.

Knowledge and Skill Requirements:

· Must have an Associate’s Degree in Computer Science, Math, Engineering, MIS, or IT related from an accredited institution, BS degree preferred; or 3 years of full stack development can be substituted for BS degree,

· Minimum of 2 years experience in full-stack software development, preferred 5+ years

· History of successfully developing software following an Agile methodology

· Understanding of CI/CD

· Strong customer focus.

· Strong knowledge of data structures, algorithms, enterprise software, asynchronous architectures, and object-oriented programming.

· Ability to work independently

· Excellent oral and written communication skills

· Ability to present new ideas, approaches and information clearly

· Outstanding attention to detail and organizational skills

· Diligent work ethic and insatiable desire to learn and develop skills

· Ability acquire new knowledge quickly

· Strong interpersonal skills

· Self-starter, highly motivated

· Time management

· Cultural sensitivity/awareness

· Team player, ability to build strong relations internally across functional areas and externally with vendors, suppliers, members, constituents, and volunteers

· Commitment to company purpose and values

· Proficiency in Microsoft Office products (Word, Powerpoint, and Excel)

· Collaborative

· Strong business acumen

· Creativity and entrepreneurial skills

Key Relationships:

1. Directly supervised by the Director of Engineering

2. Interacts regularly with eHealth Technologies staff, customers, vendors, and community members.

Essential Functions:
• Physical Requirements: Extended periods of time typing, data entry, sitting, reading, writing, filing. Lifting up to 20 lbs.

2. While performing the duties of this job, the employee is regularly required to talk or hear.
• Mental Requirements include General, Visual, and Numerical Intelligence. Analytical skills.
• As eHealth Technologies’ workforce is currently teleworking remotely from home, it is a requirement of the position that employees have the following minimum requirements available in their home internet network, including a router that:
• Must achieve minimum speeds of 100MBPS for download and 10MBPS for upload, or any other higher speed required for the work to be produced contingent upon your role.
• Availability of at least two (2) Ethernet connections in the router to the internet source is required (for your PC and phone).
• Workstation should be plugged directly into the router as a hardwire connection to high-speed internet is critical to maintaining approved speeds for optimal functioning of various operational hardware, software and tools, as required for work performance; an appropriate Wi-Fi connection may satisfy this connection to high-speed internet.
• Router should be updated regularly with latest firmware, or ultimately replaced if router speeds are not within the minimum specifications above.

Work Conditions:

1. Normal office environment or telecommuting

2. On-call availability during the week with occasional weekend work.
• 3. Work requires willingness to occasionally work a flexible schedule