SUMMARY:

• Extensive experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, and User Defined Functions.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Extensive knowledge of data warehouse, ETL and report analysis.
• Extensive experience with performance tuning for stored procedures & ad hoc queries, implementing parallelism, analyzing wait types, locks, fragmentation and indexing.
• Extensive experience with MS BI (SSIS, SSAS, SSRS), ETL design and report development.
• Experience in performing database upgrades for SQL Server databases. Implement, design, plan & support almost all aspects of MSSQL Server from installation, configuration, performance tuning, client/server connectivity, query optimization and database maintenance.
• Experience in configuring SQL Server HA & DR strategies with Clustering, AlwaysOn Availability Groups and replications.
• Experienced in database backup, including full backup, differential backup and t-Log backup.
• Experience with performance monitoring & backup tools like Solarwinds and Confidential .
• Experience working with Windows 2016/2012/2008/2008 R2/2003 Enterprise Server stand alone and cluster’s.
• Experience with Confidential Report Studio and Framework Manager.
• Experience with Windows PowerShell and Visual Basic.
• Redesigned data warehouse dimension tables with SCD type 6 for better performance and maintenance. Redesigned fact tables with control flags so that inconsistent data or wrong data can be excluded from report or ETL process (cold delete).
• Developed a process to optimize indexes quickly by using t-SQL and SSIS. Created store procedures to rebuild or reorganize indexes of EDW based on fragmentation level daily. A multiple-thread parallel process was designed on SSIS to call the store procedures to rebuild or reorganize indexes. Total time was shortened to 1/5.
• Improved the performance of ETL by 50% by breaking down complex queries, partitioning, indexing, adding hints and setting plan guide.
• Created a data mart to monitor 160 cooperate SQL servers. Windows PowerShell was used to extract the data from those servers and loaded to the data mart. SSRS reports were created to send to IT team for monitoring.
• Developed a batch script with VB to replace software such as WinRAR to unzip data files. This script was called by SSIS to load zipped excel file into data warehouse by automation
• Starting from scratch plan and install Windows Clusters and AlwaysOn Availability Groups for SQL Server 2016/2014/2012 environments to use for data warehouse, SharePoint and Confidential Content Store.
• Set up and monitor backup of 160 SQL servers by Confidential . Set up and monitor performance of multiple instances by DPA-Solawinds.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016,2014,2012, 2008 R2,2008,2005,2000 with Oracle 11g/10g.

Operating Systems: Windows 2016/2012/2008/2008 R2/2003 Enterprise & Standard Server

Tools: Visual Studio 2005/2008/2015 Report Designer/Report Builder (SSRS), SSAS, SSIS, Erwin Data Modeler, Solarwinds, Confidential, Confidential Report Studio, Confidential Framework Manager, QlikView.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. System Administrator

Responsibilities:

• Write t-SQL ad hoc queries, store procedures, functions and triggers as per requirements. Create tables and set parent-children relationship. Create constraints, views and procedures to be used for ETL process and reporting. Create dimension tables with Slow Changing Dimension type 6. Create fact tables with control flags so that inconsistent data can be processed by “cold” delete rather than “hot” delete.
• Develop SSIS packages to replace batch jobs to load data from different data sources such as Oracle R12, DB2, excel files, CSV files or zipped files into data warehouse of BI team. Set Change Data Capture between EDW and data mart. Set alert to send to both data sources and report users on missing data.
• Develop dynamic SQL queries to collect statistics related to performance. Troubleshoot and analyze SQL query performance issues. Set alert and respond to blocking. Analyze efficiencies of indexes by dynamic views. Rebuild or Reorganize indexes based on their fragmentation levels.
• Work with Confidential team to deploy business model on IBM Confidential Framework Manager. Create and validate reports from Report Studio of Confidential .
• Perform database upgrades for SQL Server databases, including system databases and user databases. Migrate security logins, SQL agent jobs, alerts and operators between different versions of SQL servers.
• Plan and implement Windows Clusters. Install & maintain AlwaysOn Availability Groups for SQL Server 2016/2014/2012 environments to use for data warehouse, SharePoint and Confidential Content Store. Monitor synchronization of AlwaysOn replicas. Monitor transaction log behavior and take quick remedy actions when transaction log is full.
• Providing day-to-day production support. Monitor performance behavior of multiple SQL Server Instances by Database Performance Analyzer (DPA)-SolarWinds.
• Schedule and implement database backup, including full, diff and t-Log backup. Monitor database backups of over 160 SQL Server Instances by Confidential . Refresh QA environment of Business Intelligence Group from production (4TB) by Confidential .
• Perform administrative activities like creating user logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.

Confidential, NY

Insight Developer (SSRS, SSIS, SSAS)

Responsibilities:

• Mapped and tested views of Blackbaud CRM databases to create customized reports. Developed and delivered dashboard reports, cascading reports and dynamic reports using SSRS. Wrote SSRS reports against Blackbaud CRM by report builder. Created stored procedure spec xml files, rdl spec xml files and package spec xml files on visual studio.
• Write stored procedures and ad hoc queries for the purpose of ETL or reporting. Designed SSIS package to load master data to dimension tables of data warehouse.
• Created OLAP cubes, dimensions and business critical KPIs using SSAS. Built hierarchy attribute relationships and Created MDX queries according to business requirements.

Confidential, NJ

SQL Server Developer/ DBA

Responsibilities:

• Scheduled database backup including full backup, transaction log backup and differential backup. Implemented HA/DR strategies including database backup/restore, log shipping and mirroring. Implemented and designed Security related configuration and best practices for SQL Server 2008/2005.
• Performed database tuning and monitoring by SQL profiler and database engine tuning advisor. Created and maintained jobs, alerts, operators, notifications and maintenance plans. Worked on troubleshooting day to day production support and development SQL Server issues.
• Created OLAP cubes, dimensions and business critical KPIs using SSAS. Built hierarchy attribute relationships and Created MDX queries according to business requirements.
• Designed dashboard reports for high level decision making using SSRS. Created schedules and subscriptions on SSRS report server. Configured Web Part at Web Part zone on SharePoint and Deploy Reports to SharePoint.
• Used SQL loader to load CSV files to Oracle 11g. Ran queries to valid data from SQL plus.