SUMMARY:

• Microsoft Certified IT Professional having good Experience in Administering SQL Server 2008.
• 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments on SSMS tool.
• Experience installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014; updating with hot fix and service packs.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Configured Always - On with synchronous and asynchronous secondary replicas.
• Implemented In place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012
• Experience in developing T-SQL (DDL, DML, and DCL) statements.
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Working Knowledge on AWS and Azure cloud technologies.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Migrating and configuring SQL servers to AWS (AMI, RDS, ELB, EC2, and S3) and also from physical disks to Azure.
• Experience in using DMV and DBCC commands for various performance issues.
• Extensively used third party tools like Lite Speed, Foglight, Avamar and Red gate.
• Auditing of database for Users transactions, login and database action and removing orphan users.
• Strong experience in mentoring junior team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, SQL Azure.

ETL & 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, DTA, SQL Server Management Studio.

Third Part Tools: SCOM, Companion, lite speed, Red gate, Veritas net backup, Erwin r7, Azure Storage Explorer, Cloudberry Storage Explorer.

Programming: T-SQL, C++, VB Script

Back up & Monitoring: Spotlight, Red gate, Fog light

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, Virginia

Sr. SQL Server DBA

Responsibilities:

• Production DBA for SQL Server Environment with over 50 Production Servers and 100 Development/ Test Servers and more than 1000 Databases.
• Actively collaborated with the developers and other teams to suggest the database design, development of objects and deployments to DEV, TEST and PRODUCTION environments.
• Install and configure SQL Server Troubleshooting Performance issues and database issues.
• Extensively worked on setting up Always on Availability Groups on a Multi-subnet failover network. Worked with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.
• Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
• Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Maintain the database consistency by checking with DBCC Utilities at regular intervals.
• Use Resource Governor to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Design and develop SSIS packages using different control flow tasks, data flow task and data transformations.
• Maintain Active/ passive and Active/ Active cluster environment with Virtual Machines using Hyper V.
• Create and maintain Transactional, and Merge Replication environments.
• Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
• Provided High availability through Clustering, Mirroring, Log Shipping, Replication and AlwaysOn.
• Hands on writing shell scripting to monitor the RIAK Cluster and perform administration tasks.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Worked with Storage team with the EMC AVAMARbackups and Storage Management.
• Implemented the restores of SQL Azure databases with a clear understanding of the backup retention periods of the Azure databases as per their service tiers.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Maintain and troubleshoot issues on Oracle and sql server databases
• Set up the SharePoint server 2013 and configured it to work with SQL server 2012.
• Integrated SharePoint and Power Pivot by fetching data from SQL server 2012 and deployed them onto SharePoint site.
• Point of contact for SQL related application issues. Successfully troubleshooted and resolved multiple SQL related issues prior to vendor involvement. Converted existing tables of significant size into partitions and migrated original data into new architecture. Developed sliding window maintenance to create new ranges at end of year and utilized performance testing to illustrate pros and cons of new schema.
• Explicitly used third party tools like Lite Speed, Foglight and Red gate
• Applied changes on Production through Change management after thoroughly testing on development servers.
• Worked on AWS in creating databases in Cloud Service and also Setting up Virtual Machines.
• Load data into SQL database from DB2 extracts using SQL loader.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Automated and centralized Administrative tasks using power shell and T-SQL.
• Successfully negotiated significant cost reductions with various vendors and utilities
• Experience in migration of databases from SQL Server 2012 to SQL Server 2014.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).
• Good understanding of SQL Server Azure. Tested SQL Server Azure in test environment.

Environment: SQL Server 2014/2012, OLTP, PL/SQL, OLAP, SSIS, SSRS 2008R2, 2012, 2014 Windows Server 2008, sharepoint, AWS,VS 2010/2012, Foglight, T-SQL, and Excel.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2005/2008/2008(R2)/2012on new servers with service packs.
• Extensively worked on Snapshot and Transactional Replication.
• Experience in working with Microsoft Active Directory Services
• Configure the RAID levels for data files, log files and tempdbat server level.
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Created reports from Yellow Fin reporting tool.
• Involved in ETL process under development, testing and production support environments.
• Develop complex mappings and tune mappings for better performance.
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Performed some DB2 administration.
• Automated the Replication Tear Down/ Rebuilt by automating the scripts and running them in the Power shell.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Responsible for installation and configuration of SQL server 2008R2/2012 database on Azure Servers.
• AWS migration- RDS and EC2 instance creation and administration.
• Link business processes to organizational objectives and analyzed ER diagrams.
• Converted existing tables of significant size into partitions and migrated original data into new architecture. Developed sliding window maintenance to create new ranges at end of year and utilized performance testing to illustrate pros and cons of new schema.
• Setup alerting mechanism on Foglight for all production servers.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Planned, tested, and deployed an AlwaysOn availability group on a multi-subnet failover cluster for our SharePoint SQL environment.
• Have experience in data modeling in Erwin, Star Schema Modeling and Snow Flake Modeling, Fact& Dimension tables.
• Monitor and modify performance using execution plans and Index tuning.
• Implement and manage the clustering environment like Active/Passive and Active / Active.
• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL server.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Working Knowledge on AWS and Azure cloud technologies.
• Maintain the database consistency with DBCC, DMF and DMV’s at regular intervals.
• Provide 24x7 Production Database on-call support.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000, TSQL, SSIS, SSAS, SSRS, Report Builder, Lite Speed, yellowfin, Foglight, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering,AWS, sharepoint, Windows XP/2000 and Windows 2003/2008 Server.

Confidential -Virginia Beach, VA

MS SQL Server DBA

Responsibilities:

• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 R2databases by In-place upgrade process and also used upgrade advisor tool in upgradation process.
• Handled up to 2 TB Size databases with clustered and standalone environment
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Experience working with MS SCOM and MS SCCM.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Carry out requirement gathering and analysis and design ER Diagrams.
• Used DTS packages to move logins and jobs from one server to another server.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Worked with Storage team with the EMC AVAMARbackups and Storage Management.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Assist in capacity planning, space management and data maintenance activities for database system in DB2.
• Implemented Policy Based Management on the servers and also wrote a Power Shell script which generates reports for monitoring space of the drives on the servers.
• Used Idera SQL Safe tool for performance monitoring, backup and recovery, security, auditing and Power Shell scripting.
• Expertise in usingTFSto open bugs, create tasks and user stories, initiate change requests.
• Perform database enhancement and modification as per the requirements in DB2.
• Extensive testing on the Performance of the Stored Procedures.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2005/2008 R2, Windows 2003 Server, windows 2008 R2 Server, MS Visual Studio 2010.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Administering MS SQL Server, performing day-to-day tasks such as Database tuning by checking indexes and modifying procedures, creating users, assigning roles, etc.
• Gathered the requirement from the client and translated the business details into Technical design.
• Worked on Performance tuning servers, stored procedures, queries, index tuning and query optimization using SQL Server Profiler, NT Performance monitor, Query Analyzer.
• Involved in utilizing PL/SQL, T-SQL and Visual Basic Programming to write program units for conversions.
• Setting up security, creating groups, user defined roles, logins, granting permissions.
• Worked with different data models, normalization & de-normalization of tables.
• Planned and implemented various SQL, T-SQL statements, stored procedures and triggers according to the requirements of the projects for the OLTP database systems.
• Involved in writing T-SQL programming to implement stored procedures and Functions for different tasks.
• Worked on DTS, Import & Export Utility, BCP Utility and Replication tool for transferring data.
• Worked on Maintenance, installation, performance monitoring and tuning.

Environment: MS SQL Server 2005/2008, T-SQL, MS Access 97/2000, MS Visual Studio Windows NT.

Confidential

SQL Server DBA

Responsibilities:

• Maintained various client databases in MS SQL Server 2000, 2005, 2008, 2008R2 versions.
• Wrote stored procedures for ease of administration and management.
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL Server.
• Scheduled maintenance on databases and capacity planning to increase performance and productivity.
• Administer client reports using Reporting Services (SSRS) in native and SharePoint integrated mode.
• Troubleshoot and minimize production down issues.
• Created and Implemented, scheduled maintenances and backup procedures to the database to enhance overall performance and disaster recovery methods.
• Extensive use of DTS/SSIS and scripting for various ETL processes.
• Maintained 60 plus database instances in dev, test, stage and prod.
• Performed SQL Server database consolidations, migrations, upgrades and downgrades.
• Configured and Managed Standby databases using Log Shipping.
• Installed, configured and maintained SQL Server Clusters.
• Implemented Backup and Restore in SQL Server using Third party tools like VeritasNetBackup, LITESPEED and Sandpiper.
• Actively involved in capacity planning.
• Co-ordinated with Oracle team on various administrative and development activities.
• Apply security updates/patches on Oracle Databases.
• Perform Oracle backups and recovery.
• Installed Oracle clients.
• Actively involved in the upgrade of oracle databases from 9i to 10g.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008, IIS 6.0, VERITAS Net Backup, TSQL,VB.NET, and SQL Job Manager.