Database Administrator

Write complex SQL queries involving inner and outer join, store procedures, triggers and user defined functions, Perform Performance Tuning, Query Optimization, Manage Alerts, Operators and Jobs through SQL Server Agent, Create Dimensional Modeling and ETL design. Work on ETL process using SSIS packages, Create packages to extract data from DB2 (AS/400), ORACLE, MS ACCESS and FLAT FILES and load it to SQL SERVER use DTS/SSIS and implement Incremental load in SSIS packages, Deploy SSIS Packages using Team Foundation Server and migrate SSIS packages, Design STAR, SNOW FLAKE Schemas, Report writing using SQL Server Reporting Services (SSRS) and create various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Table, Matrix, Chart, Adhoc and Sub Reports, Creating Data Visualizations using Tableau/Power BI, Work with Data Modeling Tools like Erwin and Microsoft Visio, Good understanding of (SDLC) Software Development Life Cycle process methodologies and principles