SUMMARY:

• Over 6 years of professional experience in Installation, Registration, Configuration, Migration and Consolidation of MS SQL Server 2005/2008/2012/2014.
• I was involve in consolidation project where we consolidated 50 plus databases in SQLAlwaysOn architecture in two different data centre that covers High Availability as well as Disaster Recovery.
• I was involve in database migration project where we migrate 10 plus databases from on premises to MS Azure Cloud PaaS platform.
• I was involve in database Replication project where we built a distributed replication database infrastructure into 3 geographic locations.
• Experienced in applying data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Experienced in delivering on assigned database infrastructure related projects with participation through project lifecycle that includes new software releases, patch upgrades, prevention of feature exploitation, security and audit.
• Experienced in routine Database maintenance activities i.e. monitoring of jobs and Backup/Recovery procedures & using of the 3rd party tools (Red Gate Tools, Imelda Lite Speed, and Erwin).
• Experienced in Planning, Implementing, Performance Tuning, Query Optimization, SQL server security maintenance, Database permissions, Client/Server Connectivity, and Database Consistency checks.
• Knowledge of Optimizing Code and Improving Efficiency in databases including Re - indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Ensure data and databases are fully secured and comply with SOX and PCI regulations.
• Experienced in designing and implementing SSIS packages as business needs.
• Experienced in designing and developing analytical databases and reporting using SSAS, SSRS and Power BI.
• Experienced in Maintaining Database authentication modes, Creation of Principals, Securable and configuring permissions and assigning different type of roles to users.
• Experienced in transforming data from one server to other servers using tools like SSIS Packages, Bulk copied Program (BCP) and Data Transformation Services (DTS).
• Experienced in creating packages, Jobs, Sending Alerts using SQL Mail. /Database Mail.
• Experienced with recovering SQL Server in disaster conditions, performed production support for critical servers.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Experienced in providing 24x7 support for critical production systems. Works to resolve outages that may occur and performing root cause analysis post outage.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Business Intelligence & Development Studio and Erwin

Development skills: T-SQL,PL/SQL,SSIS/SSRS/SSAS, Oracle

Languages: T-SQL, HTML, XML, Power Shell

ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica.

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects, Crystal reports, MS Excel

Operating Systems: Windows, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

EXPERIENCE:

Confidential, Silver Spring, MD

SQL Server DBA

Responsibilities:

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Deliver on assigned database infrastructure related projects with participation through project lifecycle that includes new software releases, patch upgrades, prevention of feature exploitation, security and audit
• Responsible for database design, implementation, and maintenance, and the operation and setup of database systems.
• Executes database projects and assists in coordination of all database production scheduling; coordinates production support with outside vendors, as needed.
• Designing and developing analytical databases and reporting using SSAS, SSRS and Power BI.
• Participated heavily in the process of upgrading SQL Server systems from SQL Server 2005/ 2008, and SQL Server 2014 platform.
• I was part of the team of database consolidation project where we migrated 40+ stand-alone databases into SQLAlwaysOn platform that covers our HA and DR strategies.
• I was part of the team of database migration project where we migrated 15+ databases from on-premises to Azure PaaS platform.
• Participated heavily in all database-related technologies SQL Server, OS, Storage DAS, NAS, SAN, Network, Servers, VMware, Spotlight, and LiteSpeed.
• Involved in putting IT backend standards and roadmaps Architecture, Design, Performance, Monitoring, Security, and Troubleshooting etc.
• Prepared and participated in implementing the SQL Server Virtualization Roadmap at Deloitte to VMware.
• Supported, administered, optimized and maintained production and development SQL Server 2012 database environments running on Windows platforms.
• Troubleshoot various problems that arise in day-to-day work. Independently analyze, solve and correct issues in real time and providing problem resolution end-to-end.
• Provided full support of SQL Server SSIS and SSRS services.
• Designed, implemented, maintained and provided full support of SQL Server clustering and mirroring.
• Provided database sizing and capacity planning.
• Controlled, monitored, and generated an access report process for user access to the database.
• Planned, prepared, and rehearsed SQL Server database recovery plans.
• Evaluated and enforced database requirements regarding service level agreements ("SLAs").
• Ensured high quality of backend services though solid processes of planning, analysis, design, implementation, load testing, performance monitoring and tuning of SQL Server systems.
• Researched the market constantly to find ways of reducing costs virtualization, monitoring tools etc
• Participated in all Data Management and Integration applications performance and stress tests..
• Participated in creating and implementing Disaster Recovery and High Availability Plans Backup/restore, Clustering, Database Mirroring, Replication etc.
• Analyzed, designed, and architected the infrastructure of the migration of standalone environments to clustered and mirrored environments.
• Involved in integrating SCOM, Policy-based Management PBM, and Database Mail for better management and alerting.
• Worked closely with project managers and technical project leads to develop and formalize tasks relative to database development within each project.
• Worked well under pressure to meet the established SLA's.
• Ensured proper change management procedures were followed regarding all promotions into production systems.

Environment: Crystal Reports, Microsoft SQL Server 2008R2/201/2014, Windows server 2012/2016, Transact SQL, SSIS, SSRS, SSAS,SSDT, Visual Studio, SQL Server Profiler, SQL Query Manager, Performance Monitor, Query Optimizer, Execution Plan, Microsoft Office 2010, Microsoft Visio.

Confidential, Chicago, IL

Database Administrator

Responsibilities:

• Involved in gathering requirements with team lead for efficient Reporting of the database.
• Created Data mapping document on the basis of information required to create the temporary staging system for particular analysis and research in the organization.
• Created Schemas, Views, and Tables, Stored procedures, Triggers and functions using TSQL queries in SQL Server Management Studio. Performed data migration, back-up and restore of the database. Extensively used SSIS Import/Export Wizard for performing the extract, transforms and load operations and migrating data from database.
• Created Clustered and Non-Clustered indexes on multiple tables to enhance query performance.
• Created report models for ad hoc reports when the end user wants to see the reports on report server.
• Created SQL Server Reports using SSRS 2008and 2008 r2 and exported them to Excel format for managers and Quality Analyst team for easy validation.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Send Mail task, Data conversion, Slowly Changing dimension, Merge, Union all and Derived Column.
• Successfully deployed and managed the reports on the Report manager with the Subscriptions.
• Extensively worked on the stored procedures and functions for creating the SSRS reports. Since they enhance the report performance and make it efficient to use.
• Developed all kind of reports in SSRS and send them to business users for easy validation in all PDF and Excel formats. Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Worked on Team Foundation Server and Microsoft Visual Studio for saving the Reports, Stored procedures, Functions and Tables.
• Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services.
• Created and deployed Adhoc reports, sub-reports, parameterized, drill down, drill through reports with Security.

Environment: Microsoft SQL Server 2008/2008R2, Windows XP, Windows 2007, Transact SQL, SSIS, SSRS, Visual Studio 2008, Team Foundation Server, SQL Profiler, Query Analyzer, SQL Query Manager, Performance Monitor, ETL, Query Optimizer, Execution Plan, Microsoft Office 2007/2010 .

Confidential

MS SQL Server DBA

Responsibilities:

• Involved in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages in SSIS to get the historical and operational data from database.
• Conducted data migration processes in the SQL Server environment using SSIS. Scheduled and executed SQL Server Integration Packages using SQL Server Agent.
• Developed SSIS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server 2008 Integration Services.
• Involved in transforming of data such as adding derived column, sorting of data, merging of data had been done while pulling data from SQL Server 2005 to the SQL Server 2008.
• Created copies of operational databases using the Import/Export Wizard.
• Assisted DBA in performance tuning and optimization of procedures and queries using SQL Profiler.
• Optimized the Indexes in database using Index tuning Wizard.
• Developed dimension and fact tables in Data ware house and create OLAP cubes for Analysis Services.
• Developed test reports, conducted data analysis, data modeling and created Entity Relationship diagrams using Logical and Star Schema.
• Involved in developing logical and physical modeling of the database using Erwin.
• Worked with building the complex Ad Hoc, Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.

Environment: Microsoft SQL Server 2008/2005, Windows XP, Transact SQL, SSIS, SSAS, SSRS, XML, BIDS, Visual Studio, Query Analyzer, SQL Query Manager, ETL, Query Optimizer.