MS SQL Developer - San Diego, United States - Diverse Lynx

Description

Job Title: MSSQL Developer
Experience: 6 10 years
Duration: 12+ Months
Work Location: San Diego, CA Day 1 Onsite

Key words to search in resume: MSSQL, SSIS, ETL, Stored Procedures, Triggers, Cursors, Views, Dynamic queries

Technical/Functional Skills
As a member of the team you will be expected to not only deliver on technical requirements and solutions but also be able to present your solutions in group forums and to senior management. Responsibilities include but are not limited to working as individual contributor, a team member and a technical expert to explore, define and pilot new solutions with little supervision

Responsibilities (Role):
T-SQL, Stored Procedures, Triggers, Cursors, Views, Dynamic queries
Working with client/business analysts to understand the requirements for enterprise analytical reporting needs
Designing and developing the automated routines (scripts etc.) to facilitate the application development and Prod support
Performance Tuning, Query Optimization, Indexing
Database/Table migrations, Archiving strategies, Table Partitions
SQL Setup and upgrades for new and migrating environments
Prepare SSIS packages for ETL, modify the current packages for better performance, data migrations, data verifications
Error reporting and troubleshooting of packages and scheduled jobs with custom configurations
Derive different aspects of data into reports, grouped data, charts data, branding, security of server and reports

Experience Required

• Exposure to MSSQL development activities with good ETL knowledge
• Error reporting and troubleshooting of packages and scheduled jobs with custom configurations

Generic Managerial Skills
bility to multitask effectively in a dynamic environment.
ction driven with strong analytical and analytical skills.
Manages individual project priorities, deadlines, and deliverables with minimal supervision.
Serves as senior resource to resolve advanced system and/or application issues by interfacing with users and other IT Engineers.
nticipates complex issues and discusses within and outside of project team to maintain open communication.