Senior SQL Database Developer Loc: Buffalo Grove, IL
100,000 - 200,000
Job Description:
Create, optimize and maintain complex T-SQL as part of stored procedures, views, functions, and queries.Design and develop highly configurable, fault tolerant ETL systems using SSIS.
Develop and maintain SSRS reports for the various business applications.
Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring.
Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity and recommend changes as necessary.
Create database design documentation at architectural and functional level.Recommend new strategies and architecture to enhance efficiency of data systems.
Plan, manage and track database and ETL system changes.Collaborate with application developers, variable programmers, PM, QA and other IT team members.
Adhere to all policies and procedures related to security and protecting privacy of client and company information.
Role will work directly with confidential client data containing protected health information and/or personally identifiable information and individual must complete annual HIPAA training.
Required SkillsRequired Skills:
7+ years of experience in SQL/database development with SQL Server.
Substantial experience with development of SQL Integration Services packages and SQL Reporting Services (SSIS and SSRS).Experience with TFS, automated deployments and working with the Red Gate SQL development tools is a plus.Experience in inventory/order management systems environment is preferred.
Knowledge of IT security relevant to data protection and data integrity.
Proficiency in English and strong communication skills.4-yr college degree in Computer Science or Information Systems or equivalent experience is required