Job Description :
Sr. Database Developer with 10+ Yrs of exp at IL ( SSIS, SSRS and/or SSAS , Snow Flake Modeling )
Position: Database Developer
Location: Deerfield, IL
Duration: Long Term
· Designs, develops, tests, maintains and enhances database objects using the Microsoft SQL Server platform (and related technologies) to support business processes in the order-to-cash and/or supply chain domains.
· Interfaces with users in order to determine requirements and deliver quality software which exceeds their expectations. Must have a strong desire to deliver well-designed and tested software.
· This role provides the technical SDLC expertise in planning, analysis, design, implementation, maintenance, and control of the organization's SQL Server databases.
· Handles and leads the complex or critical data/ database management initiatives that typically involve multiple disciplines, including responsibility for database architecture, design, integration, and/or data modeling.
· As the recognized technical expert, consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies.
· Works independently while designing, development and testing of all SQL server database objects and packages including Reporting services (SSRS), Integration services (SSIS) and/or Analysis services (SSAS
· Would be required to provide input and/or may lead logical and physical database design and development for new projects including data normalization, modeling etc.
Qualifications and Skills
Minimum Qualifications Requirements:
· In-depth understanding of MS SQL Server Relational Database Management software including expert proficiency in T-SQL
· 5+ years of previous database development experience using Microsoft SQL Server technologies.
· SQL Server based SSIS, SSRS and/or SSAS experience.
· Good knowledge and understanding of change management principles and testing.
· Database performance tuning.
Optionally Preferred Experience:
· Exposure to support any BI and/or big data environments.
· Any scripting language exposure for task automation Power shell, batch or Python etc.
· Exposure to Data Warehousing Concepts and Data modeling Techniques like Dimensional Data modeling, Star Schema Modeling and Snow Flake modeling is a strong plus.
· Any exposure to SQL Server Administration or DBA.