SQL Database Engineer at Softheon in Stony Brook, NY
SoftheonStony Brook, NY
SQL Database Engineer
We are looking for a SQL Database Developer who has in-depth experience with Microsoft SQL Server versions 2012 and ideally 2017. The Ideal candidate will have an enterprise background using MS SQL Server and be able to understand complex SQL design concepts, practices, and procedures. This position involves identifying business requirements, developing data models, performing data analysis, writing advanced SQL queries, designing, and coding complex stored procedures and performance tuning existing database processes.
RequirementsKey Responsibilities (include but not limited to): Design and develop database objects, stored procedures, views, functions, tables, and triggers; ensure their stability, reliability, and performance.
Design, develop, and maintain SSRS reports based on user requirements.
Write and optimize SQL statements for data access and retention.
Perform regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable.
Collaborate with developers on database design, query tuning, and schema refinement.
Independently, and with collaboration, analyze, solve, and correct database related issues in real time while providing efficient resolutions.
Respond to feedback from users regarding performance and work with developers to improve the performance of queries and indexes.
Tune stored procedures and T-SQL queries to improve performance and sustainability.
Provide support for the deployment of database scripts in development, test, pre-production and production environments.
Monitor database performance parameters to provide fast query responses to front-end users.
Study the technical requirements provided by product team and design databases to fulfill the requirements.
QualificationsBachelors degree with a minimum GPA of 3.5 in Computer Science or a related field of study.
Knowledge of object-oriented programming.
Experience in C#, , SOAP Web Services, and Microsoft.
NET technologies a plus. 0-2 years of experience in software development using Microsoft SQL Server 2012, Microsoft SQL Server 2016 a plus, T-SQL and T-SQL language (queries, views, procedures), SQL Server database design, stored procedure design and implementation.
If 0 then provide database University project information related to SQL Server.
Experience coding stored procedures (using T-SQL). Proven analytical problem solving and debugging skills.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.
Experience with performance tuning, query optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Excellent communications skills (written and verbal).
BenefitsWhen you join Softheon, you will:
Have an opportunity to add value to a diverse team of innovative professionals Rise to new challenges everyday Receive competitive salary and career growth opportunities ABOUT US: At Softheon, we are motivated to solve the biggest challenges in the healthcare industry by creating simple solutions to complex problems. We support our clients, track performance data, manage administrative tasks, and so much more. To find out more about Softheon please visit [ _To all recruitment agencies: Softheon does not accept agency resumes. Please do not forward resumes to Softheon employees or any other company location. Softheon is not responsible for any fees related to unsolicited resumes and will not pay fees to any third-party agency or company that does not have a signed agreement with the Company._
More ICYMI Jobs
Uh oh! Something went wrong. Please try again.