SUMMARY:

• 8 years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Experience inMicrosoft Visual C#in script component of SSIS.
• Experience with Windows Server 2003/2008 installation, administration, performance tuning.
• Expert in creating Views.
• Experience with backups, restores and recovery models.
• Has good experience on Data Transformations like Derived Column, Conditional Split, Aggregate, Multicast and Sort & Execute SQL Task to load data into the Data Warehouse.
• Have experience in creating of workflows with Tasks, Containers and various Transformations.
• Wide exposure in identifying various dimensions and facts to implement data - ware house architecture.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
• Experience in developing the table and matrix reports using SSRS.
• Creation of cubes and modifying measures and attributes, creating hierarchies and relationships among dimensions and facts in SSAS.
• Created calculated measures and members in calculations, KPIs, Partitions, and Actions.
• Experience in implementing operational automation using scripts.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012
• Involve in MSBI projects with wide use of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Services (SSAS).
• Very good knowledge and hands on experience of indexes, index management, and statistics
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in using the DMVS, DBCC, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Data Cleansing, Data Quality Tracking and Process Balancing Checkpoint.
• Experience with full development cycle of a Data Warehouse, including requirement gathering, design, implementation and maintenance.
• Worked with Type 1 and 2 dimensions, Operational Data Store ODS leveling and other Data Warehouse Concepts.
• Skilled in error and event handling, precedence Constraints, Break Points, Check points and Logging.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
• Expertise in usingglobal variables,expressionsandfunctionsfor the reports with immense experience in handling sub reports inSSRS.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in maintaining one to many and many to one relationships while moving data between two databases.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, Oracle, legacy systems and loading into SQL server.
• Extensively used third party tools like Lite Speed, Fog light and Red gate.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Experience working on Hyper-V and VMware environments
• Experience working with Change control process/Change management
• 24*7 Production support experience
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Hands on experience on configuring Always-On from High Availability
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Auditing of database for users transactions, login and database action and removing orphan users.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Always On Availability groups, Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Designed and implemented a Multi-tier data warehouse and Data Mart using SQL Server 2008.
• Installed, configured SQL Server 2008/2008R2 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Experience in AZURE VM management involving Configuring, Migrating, deallocating and Capturing images of Virtual machines in Windows Azure.
• Experience configuring and working Microsoft SQL server 2008/R2, 2012 on AZURE and VMware Environment.
• Expert in AZURE Blob Storage Management and migrating blobs.
• Maintenance of Virtual Machines across Microsoft AZURE subscriptions.
• Monitoring and maintenance of Azure Bolb Storage and Virtual Hard drives
• Extensively worked on Active-Active and Active-Passive Clustering.
• Implemented new features in MS SQL Server 2012 like Always-On HADR in prod and non-prod environments

TECHNICAL SKILLS:

Operating Systems: Windows NT/2003/2008R2/2012/2014, Linux, Unix.

Databases: MS SQL Server 2012/2008 R2/2008/2005/2000, MS Office, Access 97/2000/2003. SQL Azure

ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Perfmon counters.

Third Part Tools: Fike Maker Pro, Idera V5.2\7.1\7.2.2, Companion, Lite Speed, Red Gate, Veritas Net Backup. Azure Storage Explorer

Languages: T-SQL, XML, C#, Pearl, Shell

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. SQL Server DBA

Environment: MS SQL Server 2000/2005/2008 R2/2012/2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl, SQL Azure

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2)/2012/2014 on Production and Non-Prod environments.
• Migrated SQL servers from Virtual to physical environments for improving performance.
• Upgrades of SQL server 2005/2008R2 to 2008R2 /2012 and apply Service Packs wherever needed.
• Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Wrote T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Configured Always-On with synchronous and asynchronous secondary replicas.
• Configured Transactional replication from multiple publishers to one subscriber.
• Creating and Maintaining Database Maintenance Plans.
• Migrated SQL Databases on Cloud using SQL Server Azure.
• Maintenance of Virtual Machines across Microsoft AZURE subscriptions.
• Monitoring and maintenance of Azure Bolb Storage and Virtual Hard drives
• Configuring and setting up RAID levels for the Virtual Hard Drives.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Performed database refreshes from prod to non-prod environments
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Configured Always-On availability group for High Availability.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Optimized the database server using DMV’s and DMF’sand performed acode reviewandtuningfor the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.
• Mentoring junior team members and creating documents on daily basis.
• 24* 7 on-call production support

Confidential, Atlanta, GA

Sr. SQL Server DBA

Environment: SQL Server 2008 R2/2005/2000,Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008 R2

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 on Prod and Non-Prod environments.
• Configured HA & DR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments.
• Worked on side-by-side migrations of SQL server.
• Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clustering(Active-Active, Active-Passive).
• Applied service packs as a part of standardization project.
• Implemented SQL server auditing to collect data for Quarterly audits.
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks.
• Resolve locking and blocking issues.
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
• Provided RAID level suggestion for data files, log files and tempdb drives
• Used Index tuning wizard for optimal query performance.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008. Providing 24*7 support

Confidential, Cincinnati, OH

SQL Server DBA

Environment: SQL Server 2008/05/00,Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, Fog Lite.

Responsibilities:

• Installing, configuring, tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server 2000 to 2005 and 2008/2008R2.
• Created Database Diagrams using ERWin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Extensively used SSIS to move data from text files to SQL Server.
• Prepared daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential, Baltimore, MD

SQL Server DBA/SSIS/SSAS/SSRS Developer

Environment: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB, Reporting Service(SSRS).

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up gradation process.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Development Studio (BIDS)
• Setting up and Monitored Clustering, transactional replication, Database mirroring on Production environments.
• Prepared the complete Data Mapping for all the migrated jobs using SSIS.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and standalone environment
• Configured Transactional replication on migrated server.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Experience working with MS SCOM and MS SCCM..
• Used DTS packages to move logins and jobs from one server to another server.
• Good experience in data modeling and metadata services.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, Bloomington, IL

SQL Server DBA/SSIS/SSAS/SSRS Developer

Environment: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 Servers, .NET, MS Access, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB, Reporting Service(SSRS).

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created SSIS package for loading the data coming from various interfaces and also used multiple transformation in SSIS to collect data from various sources.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Using SSAS created OLAPcubes for data mining and created reports from OLAP cubes using SSRS.
• Created Data Model or the Marketing Information System Team using Erwin.
• Created databases and Schema Objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Worked extensively on SQL Server Reporting Services(SSRS) to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server 2000 to 2005 and 2008/2008R2
• Created Database Diagrams using ERWin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server Developer/DBA

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files