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.