- Evaluate the daily and monthly batch process to improve performance and shorten the critical path window.
- Application Development and Production Support for multiple large projects.
- Research and resolve production issues, troubleshooting of Mid-Tier MS SQL Server.
- Deliver complete documentation for estimates, design and development.
- Perform Impact Analysis across multiple platforms and applications.
- Excellent programming and configuration skills in Microsoft SQL Server.
Desired Skills & Experience:
- SQL Server 2012+
- Changed Data Capture, schema design, query optimization
- Fundamental understanding of database administration.
- SSIS for ETL.
- Designing reports using either Crystal Reports or Business Objects XI or SSRS.
- SQL code tuning, consolidating views and tracking database performance metrics
- Designing and maintaining data dictionary and system documentation.
- Write complex SQL Server stored procedures.
- Strong experience in SSIS and SSRS