Job Description :
We are eClinicalWorks. We are a privately held leader in healthcare IT, providing comprehensive, cloud-based EHR/PRM solutions to medical professionals worldwide to improve workflows and reduce the risk of physician burnout.


We care. We are committed to positive change. And that’s where you come in. Do you value creativity and innovation? Great, so do we. At eClinicalWorks, we share a passion for improving healthcare through dedication, education, and teamwork. Everyone has that one thing they’re really good at. We value your talent and want you to join our fast-paced, fun, and culturally diverse environment. Ready to make a difference? Apply today.


SQL Developer



Job Description

Help write and optimize in-application SQL statements


Perform query tuning and query writing


Designing databases and ensuring their stability, reliability, and performance.


Prepare documentations and specifications


Ability to handle common database procedures such as upgrade, backup, recovery, migration, etc.


Profile server resource usage, and optimize and tweak as necessary


Collaborate with other team members and stakeholders


Work with application development team to design and develop the schema, tables and dictionaries and architect the table/database structures


Development of high-quality database solutions


Develop, implement and optimize stored procedures and functions using T-SQL


Develop procedures and scripts for data migration


Memory management for database systems.


Ensure the data quality and integrity in databases.


Provide authentication and authorizations for databases


Optimize and maintain legacy systems


Modify databases according to requests and perform tests


Solve database usage issues and malfunctions


Provide data management support to users for production issues


Research and suggest new database products, services and protocols



Requirement

5+ years'' experience as a SQL developer or similar role


Bachelor''s degree in Computer Science, Computer Engineering, Information Technology or relevant field.


An ability to prioritize, organize and handle multiple tasks carefully and accurately


An ability to work independently and as part of a team


Critical thinker and problem-solving skills


A strong desire to learn new technology and disciplines quickly


Experience with some of the modern relational databases


Skilled at optimizing large complicated SQL statements


Knowledge of best practices when dealing with relational databases


Capable of configuring popular database engines and orchestrating clusters as necessary


Capable of troubleshooting common database issues


Familiar with tools that can aid with profiling database server resource usage and optimizing it


Proficient understanding of code versioning tools such as Git, Mercurial, SVN


Excellent understanding of T-SQL programming


Excellent understanding of Microsoft SQL Server and Oracle MySQL


Good knowledge of HTML and JavaScript


Strong knowledge of SQL Server Reporting Services and SQL Server Analysis Services


Familiarity with the practical application of NoSQL\NewSQL databases


An ability to understand front-end users’ requirements and a problem-solving attitude


eClinicalWorks is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences that bring us together and help create a healthy world.