TECHNICAL SKILLS

Tools: MS SQL server Management Studio, SQL Server 2005 - 2016, Azure, MS Analysis Services, Integration, Performance, & surface area configuration tools. DTS\SSIS\SSAS\SSRS, OLAP, Performance Monitor, MS SQL Broker, SQL Server Profiler Visio, Power BI, Powershell scripts.

Programming Languages: XML, HTML,T-SQL,PLSQL, & PERL

Databases: MySQL, SQL server 7/ 2000/2005/2008 R 2/2012/2014/2016 , Oracle 8, Oracle 10, Teradata

Operating Systems: UNIX, Win 3.1, Window NT, Window XP, Window 2012 and Window 2016

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. DBA/Developer

Responsibilities:

• Multiple data migration, Replication, DW and optimizations SQL Server versions 2012//2016.
• Performance and resource usage & Manage access paths to optimize availability of the databases.
• Re-Creation of the DW ETL/Azure Cloud databases process to improve performance by 80%
• Data ware house Development and configuring.
• Estimating storage capacity and monitoring the growth of database objects for capacity planning.

Confidential, Atlanta, GA

Sr. DBA/Developer

Responsibilities:

• Multiple data migration and optimizations SQL Server 2008 R 2/2012/2014/2016 .
• Optimized database performance and resource usage & Manage access paths to optimize availability of the databases.
• Re-Creation of the databases nightly process to improve performance by 70%
• In charge of Data Security, Backup Recovery, Storage and capacity planning.
• In Charge Databases design and architecture using SQL Server versions 2008 R 2/2012/2014/2016
• Create ETL/SSRS/SSIS/SSAS solutions. Set up DR solutions using log shipping, mirroring, Azure, etc.
• New Data ware house Development Dimensions and Facts configuring.
• Multiple SQL Server Clusters and Instances. Installation, maintains, upgrades and DR planning.

Confidential, Atlanta, GA

Sr. DBA

Responsibilities:

• Designing and Implementing Solutions using MS SQL server 2000/2005/2008 tuning Configuration.
• Multiple Migrations from SQL server 2000 to 2005 and 2008 R2.
• Multiple data migration from MySQL to SQL Server 2008 R2.
• Made recommendation to store, tuning, retrieve, and recover data in case of hardware or software failures within.
• Also Optimized database performance and resource usage & Manage access paths to optimize availability of the databases.
• Re-Creation of the databases nightly process to improve performance by 70%
• In charge of Data Security, Backup Recovery, Storage and capacity planning.
• Very large ETL process by translating requirements into a new SSIS packages
• Dimensions and Facts configuring & populated using SQL Server 2005/2008 SSIS/SSAS packages.
• Designing and Implementing Solutions using SSIS/SSRS/SSAS. MS SQL server Surface Area Configuration.
• Migrations from SQL server 2000 to 2005/2008..
• Made recommendation to store, tuning, retrieve, and recover data in case of hardware or software failures within.
• Also Optimized database performance and resource usage & Manage access paths to optimize availability of the databases.
• Assist in DB & application design configuring using SQL Server 2005/2008 SSIS.
• Generated Script files of the databases whenever changes were made to stored procedures or views.

Confidential, Atlanta, GA

Sr. DW Consultant

Responsibilities:

• Designing and Implementing Solutions using SSIS/SSRS/SSAS. MS SQL server Surface Area Configuration.
• Performed ETL process by translating requirements into a new SSIS packages
• Made recommendation to store, retrieve, and recover data in case of hardware or software failures within.
• Also Optimized database performance and resource usage & Manage access paths to optimize availability of the databases.
• Assist in DB & application design configuring using SQL Server 2005/2008 SSIS.
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Generated dashboards, scorecards, KPIs, and Reports using SSRS.

Confidential, Duluth, GA

Sr. BI/ DW Consultant

Responsibilities:

• Designing and Implementing Solutions using SSIS/SSRS/SSAS. MS SQL server Surface Area Configuration.
• Configured new Data Warehouse SQL Server 2008 by translating requirements into physical database structures that integrated with existing Databases.
• Dimensions and Facts configuring & populated using SQL Server 2008 SSIS/SSAS packages.
• Multidimensional models, OLAP/Dimensional cubes, ROLAP, star and snowflake schemas Modeling.
• Create and maintain test database environment for applications section, including the creation of necessary libraries and procedures and quality audit and promotion of databases from development or test to production.

Confidential, Cleveland, OH

Sr. MS SQL DBA/Developer Consultant

Responsibilities:

• Designing and Implementing Solutions using DTS/SSIS/SSRS and stored procedures.
• Configured SharePoint & Performance Point 2007.
• MS SQL server Surface Area Configuration & SQL Server Profiler / Manage.
• Involved in trouble shooting and fine-tuning of production databases for their performance and concurrency.
• Performed DBA duties such as capacity planning, monitoring disk space, DR, performance tuning, and maintenance plans.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Scheduled and monitored all maintenance activities including database consistency check, index de-fragmentation.
• Implemented Linked Server between the servers for cross database transactions.
• Estimating storage capacity and monitoring the growth of database objects for capacity planning. Database clustering.
• Multidimensional models, OLAP/Dimensional cubes, ROLAP, star and snowflake schemas Modeling.
• Made recommendation for MS SQL server 2000/2005/2008 DB migration and reconfiguration.
• Lead DBA in the architect design, and development of complex financial, billing, OCR, messaging and Data reviewing reports for Hamilton Beach Headquarter.

Confidential, Atlanta, GA

Sr. MS SQL Server Lead DBA/Developer Consultant

Responsibilities:

• Lead MS SQL server developers and DBA changes of new architect designer.
• Data mapping and data transformation.
• System maximization and optimization using MS SQL server tools.
• MS SQL server Migration from 2000 to 2005.
• Lead participant in the reconciliation SQL Server.
• Migration from 2000 to 2005.
• Direct project teams in the requirements gathering, design, and development of complex applications/programs
• Developed and automated different Client Info to produce month end reports using SSIS, vb.net and SQL Jobs.