Required Skills

MSSQL Developer

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 21st Jul 2022

JOB DETAIL

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 experience.
  • Error reporting and troubleshooting of packages and scheduled jobs with custom configurations

Roles & Responsibilities

  • Ability to multitask effectively in a dynamic environment.
  • Action 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.
  • Anticipates complex issues and discusses within and outside of project team to maintain open communication.

Company Information