SUMMARY

• 10 years of professional IT experience
• SQL Server DBA wif over seven years of extensive experience in large scale & complex enterprise databases: SQL Server 2000, 2005, 2008 R2, 2012 and 2014
• 24/7 on - call support and production support experience as a SQL Server DBA
• Extensive experience in Migration of SQL server Databases from Legacy to latest versions.
• Experience in PowerShell scripting for deployment and maintenance activities
• Extensive DBA experience in Backup and Restore, Security, & Job Monitoring
• EDW domain experience in Healthcare, Finance, Insurance, Telecommunication, Retail, Media and E-Ticketing
• Extensive experience in EDW, Database Administration, MSBI and Analytics, Application design and development; and ETL design, implementation plan and test strategies
• Extensive experience in MS SQL Server Installation, Configuration, Performance Tuning, Client/Server Connectivity, Query Optimization, Backup/Recovery, Running DBCC Commands and Database Mail Configuration
• Extensive experience in maintenance of Disaster Recovery solutions like Clustering, Database Mirroring, Log Shipping, Transactional & Merge Replication
• Extensive experience in troubleshooting, fixing performance problems, fine-tuning of Databases and index analysis
• Actively involved in setting up Active-Active/Active-Passive clustering in Production and Testing environments.
• Applied Hot fixes and Service Packs in clustered environments
• Experience gathering Business Requirements, updating teh technical documents (or BRDs) for teh new changes, SRS, Process Models and functional specification docs
• Extensive experience in writing and supporting developers wif stored procedures, SQL queries, UDFs, triggers and etc.
• Extensively involved in developing workflows for build automation and deployment automation - SCCM tool
• Experience in preparing Data Flows, ER Diagram (ERDs), HLD, LLD, Use Case diagrams; and also UML diagrams, Rational Rose: Structural, Behavior, Interaction, Sequence, Activity diagrams
• Extensive experience in migrations - from SQL Server 2005 and
• Created Linked Servers between SQL Servers wif using driver configuration
• Created SSIS package for data transfer between teh two environments
• Good experience in mentoring developers and team members
• Good communication skills. Team player and highly motivated

TECHNICAL SKILLS

DW/ETL Tools: MS SQL Server Integration Services (SSIS)

OLAP Tools: MS SQL Server Reporting Services (SSRS), Analysis Services (SSAS)

Databases/DBA: MS SQL Server 2000, 2005, 2008 R2, 2012, 2014, MS Access & Oracle 9i

Web Application Development: .Net Framework 4, ASP.Net, Workflows, WCF Web Services

Operating Systems: All version of Windows OS

Other Tools/Utilities: Varicent (ICM tool), Infragistics, System Centre Configuration Management.

Programming languages: C#, Visual Basic, HTML5, CSS3, JavaScript, Power shell, TSQL

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Senior DBA

Environment: SSIS, SSRS, SQL Server 2012, Net Framework 4, C#Partner Incentives project offers various programs to give incentives to teh partners in teh form of credit note to teh partners across teh globe considering various factors on revenue, region, agreements and subscriptions. Teh architecture is divided into 3 layers. 1) Data Acquisition 2) Calc Engine 3) Reporting.

Responsibilities:

• Migration of teh existing Push packages to SQL 2014 and performance improvement.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
• Worked on teh replicated environment of SQL Server Databases
• Monitor jobs execution, and make correction actions when necessary, Database Mail Configuration and Database Security Roles.
• Development of SSIS packages to extract, transform and load into teh staging database schemas External sources like Amazon others database servers
• Involved in writing teh stored procedures wif TSQL programming using CTE’s, temp tables and JOIN’s to load and correlate teh data used for reporting services.
• Involved in gathering teh requirements to integrate new data sources to design column mapping document.
• Involved in coding teh test automation scripts for validation purposes.
• Responsible for managing teh data analysis, data sources, data mapping along wif defining teh meta data repository.
• Exposure to Power BI creating reports and dashboards for teh existing partners using teh cloud bases datasets.

Confidential, Richardson, Texas

Senior DBA

Environment: SQL Server 2012

Responsibilities:

• Recovering teh databases from backup in disasters. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)
• Monitor jobs execution, and make correction actions when necessary
• Extending post-implementation, application maintenance and enhancement support to teh client.
• Good knowledge in Failover Clustering, DB Mirroring, Replication and Log shipping in (2000, 2005, 2008, 2008 R2, 2012 and 2014)
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users
• Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
• Managing issues for database security, High Availability and implementing strategies accordingly.
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
• Daily administration, monitoring, and documentation of SQL Servers (2000\2005\2008\2008 R2\2012.
• Monitoring replication and make correction actions in case of problems.
• Monitor jobs execution, and make correction actions when necessary.
• Deployment, configuration, troubleshooting and debugging of teh application environments.

Confidential

Senior DBA and Senior MSBI Developer

Environment: SSIS, SSRS, SSAS SQL Server 2012, Net Framework 4, C#

Responsibilities:

• Monitor jobs execution, and make correction actions when necessary
• Deployment, configuration, troubleshooting and debugging of teh application environments.
• Managing issues for database security, High Availability and implementing strategies accordingly
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
• Good knowledge in Failover Clustering, DB Mirroring, Replication and Log shipping in (2000, 2005, 2008, 2008 R2, 2012 and 2014)
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users

Confidential

Senior DBA and Senior MSBI Developer

Responsibilities:

• Physical database designing & creation devising strategies for backups, recovery, DR-Failover & Query-tuning.
• Managing issues for database security, High Availability and implementing strategies accordingly
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers.
• Daily administration, monitoring, and documentation of SQL Servers (2000, 2005, and 2008 R2)
• Monitoring replication and make correction actions in case of problems

Confidential

DBA and MSBI Developer

Environment: SSIS, SQL Server 2008, .NET Framework, C#, Netezza, Micro Strategy reports

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Prepared DFD's & Entity Relationship (ER) diagrams
• Restructuring teh stored procedure, designing, coding and developing teh same using teh T SQL Programming
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services
• Managed teh migration of SQL Server 2000 databases to SQL Server 2005
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks
• Developed, deployed and monitored SSIS Packages using various transformation tasks
• Unit Testing teh SSIS packages wif respect to its flow and performance issues
• Monitored and modified Performance using execution plans and Index tuning
• Expertise in SQL Server Reporting Services and SQL Server Analysis Services

Confidential

DBA and Senior MSBI Developer

Environment: SSAS, SSRS, SSIS, SQL Server 2008, .NET Framework 4, C#

Responsibilities:

• RS report administration
• Trouble shoot SSIS Packages
• Reprocess Partitions and Cubes in SSAS
• Job monitoring
• Data quality checks
• Ticket Assignment
• Manual report production and delivery Role & Responsibilities
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Enhancement and implementation of logging feature is SSIS Packages
• Managing and Monitoring SQL Data Growth
• Replication of Database server using Publisher and Subscriber
• Database Mirroring and Log Shipping
• Performing Backups and Restoration
• Expert in installing and configuring SQL Server instances on both stand-alone and failover cluster servers
• Monitoring Failover Clustering, Replication and Log shipping in SQL Server 2000, 2005 and 2008
• Good knowledge and experience in security procedures, SQL Server security and auditing procedures
• Experience in usage of performance monitoring and troubleshooting, extensive use of profiler, Performance monitor, extended stored procedure, DBCC and DMVs for troubleshooting teh performance issues
• Good experience in installing and configuring SQL failover clusters in SQL Server 2005 and 2008. And has good experience in maintaining and troubleshooting Active-Passive and Active-Active clusters

Confidential

Senior Programmer

Environment: ASP.NET Technologies (MVC 3), SSRS, SSIS, SQL Server 2008

Responsibilities:

• Participated in initial knowledge transfer activities of teh application
• Involved in acquiring teh requirements from teh customer and consolidating them
• Involved in teh upgrading Technical documents of teh application
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users
• Developed SSIS packages and SSRS Reports to pull teh data from existing database tables to load teh display required datasets, parameters for decision making

Confidential

Senior Programmer

Responsibilities:

• Participated in initial knowledge transfer activities of teh application
• Involved in acquiring teh requirements from teh customer and consolidating them
• Involved in teh Technical design of teh application
• Write Queries to pull teh data from teh Existing tables and update teh data
• Developed SSIS packages to pull teh data from teh upstream tables and load teh data to teh downstream database

Confidential

Senior Software Engineer

Responsibilities:

• Responsible for configuration and cube deployment in SSAS
• Reprocess teh partitions and cubes
• Worked wif Workflow 4 (VS2010) development for Build Automation
• Responsible for Deployment Automation using .Net and Power shell scripting
• Responsible for developing and development of new automation tools
• Developed tools in compliant wif Confidential SCCM
• Responsible as teh primary owner for teh automation tools used for Build and Deployment

Confidential

Senior Software Engineer

Responsibilities:

• Involved in teh defect fixing of SSIS packages in Insurance Domain
• Involved in writing SQL Server Queries to meet teh business requirements
• Developed Calculations on business criteria in Varicent tool
• Worked in teh reports parts of teh Varicent - Incentive Compensation management tool

Confidential

Software Engineer

Responsibilities:

• As a Team Member I was responsible for Coding and Code review