SQL Database Developer - Remote
- Compensation
- Not disclosed
- Location
- Chennai, TN, IN
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Software engineering
- Posted
Skills
Must have
- BSCS with 3+ years MS SQL experience Thorough understanding of database structures, theories, principles, & practices Ability to write & troubleshoot SQL code & design stored procedures, functions, ta
- Working Conditions
- Must possess a smart-phone or electronic device capable of downloading applications, for multifactor authentication and security purposes Physical Demands: While performing the duties of this job, the
- Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status,
Full description
Job Purpose
The SQL Database Developer is responsible for analyzing, developing SSIS projects, custom reports and work closely with the team on any SQL issues.
Duties & Responsibilities
Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated
Design, develop, and maintain database tables, stored procedures, and supporting objects
Build and support operational reports for company and clients
Work with data team to provide operational support, resolve recurring problems
Document database topology, architecture, processes and procedures
Develop SQL queries and support ad hoc requests for data
Assist with capacity planning and resource expansion through data aggregation and analysis
Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement
Identify inefficiencies in the database platform and provide solutions to the management
Develop time estimates for assigned tasks
Use problem-solving skills to assist in resolution of business and technical problems
Identify root causes for problems and propose solutions to prevent recurring
Stay abreast of new and emerging security threats and mitigation approaches for your respective area and perform periodic security reviews of your assigned areas
Work to ensure regulatory compliance (HIPAA, etc.) in all aspects of data utilization and information access
Ensure all proposed changes follow the Change Management policy and procedure for production changes
Other duties as assigned
Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
Understand and comply with Information Security and HIPAA policies and procedures at all times
Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties
Qualifications
BSCS with 3+ years MS SQL experience
Thorough understanding of database structures, theories, principles, & practices
Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints
Extensive knowledge of MS SQL Server 2005/2008/2012/2014
Knowledge of SSIS/SSRS is a plus
Experience with C# or VB.NET
Technical knowledge of MS SQL Server internals with emphasis on query performance.