SUMMARY

• MS SQL Server Administrator with around 10+ years of experience in the IT industry experience, challenging position in Server administration and technical maintenance with the state of the art technology where my managerial, analytical, problem solving skills and application knowledge can be put in for successful execution of projects.
• Over 10+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2014, 2012, 2008 R2, 2005 and 2000in Production, Development, UAT and SIT Environments.
• IT Professional with 10 years of Administration and Development experience on MS SQL Server 2014/2012 / 2008 R 2 / 2008 / 2005 / 2000 systems in OLTP and OLAP environments
• Extensive experience in installation, configuration, and maintenance of MS SQL Server 2016, 2014, 2012, 2008 R 2/2005/2000.
• Proficient experience in Upgrading and migrating from SQL server 2005/2008/2008 R2 to SQL server 2008R2 and SQL server 2012/2014.
• Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.
• Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• Experience in AWS design and Administration with knowledge in EC2 and AWS.
• Expert working in Virtual Environment using VMWARE for SQL Server.
• Experienced in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2005/2008/2008 R2 to provide robust database solutions. Including SQL Server 2012 Always On High Availability.
• Expert in Active/Passive and Active/Active Clustering and also implemented ALWAYS ON in SQL 2014 environment.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Expert in implementing log shipping and Expert in implementing database mirroring.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
• Experience in Managing Security of SQL Server 2000/ 2005/2008/2008 R2/2012 by creating DatabaseUsers, Roles and assigning proper permissions according to business requirements
• Acquaintance in supporting Very Large databases (VLDB) and troubleshooting the problems in OLTP Environment.
• Good knowledge on Client-Server Application using Oracle 11g/10g/9i.
• Migration of Databases from MYSQL/ORACLE/SYBASE to SQL Server 2012 using SQL Server Migration Assistance (SSMA) tool.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
• Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.
• Using new features of SQL Server 2008 like Log compression, transparent data encryption TDE, Policies, Performance data collector, Auditing.
• Worked extensively with Developers in processing the Cubes, Hierarchies, and Measures putting calculations and processing for Analysis Services (SSAS).
• Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
• Helped the Developers team with Query Tuning.
• Experience in working on AWS and Azure environments.
• Active Directory Management and troubleshooting security issues.
• Proficient in troubleshooting database issues.
• Experience in IDERA and SCOM Monitoring and writing T/SQL scripts.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
• Team player with Good communication, interpersonal and business analysis skills.
• Provided 24 x 7 Production support for the database and application issues.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Exchange 2003, Linux, Unix.

Databases: MS SQL Server 2016/2014/2012/ 2008 R 2/2005/2000/7.0, Sybase, Oracle, MYSQL

SQL Server TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS), Change Data Capture(CDC)

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

Data Modeling Tools: Erwin, Redgate, Lite speed, fog lite, MS Visio

Languages: T-SQL, C/C++, Java, PERL, java script, Visual Studio2005/2003, XML, HTML, ASP.NET, VB.Net.

Applications: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Senior MS SQL SERVER DBA

Responsibilities:

• Responsible for configuration, updating, migration, security patches, performance tuning and providing 24x7 dedicated supports to all Production database administration.
• Configured and supported High Availability concept log shipping in 2008 and 2012 using Litespeed.
• Implemented High Availability Concept Always on Availability Groups, Transaction Replication and Clustering.
• Implemented full, differential, and transactional log backups for user created databases in production environments.
• Migrated SQLServers 2008 R2 to SQL Server 2014/2012, Reporting services (SSRS), SQL Server Logins, database permissions, jobs, SSIS packages, Database mail, linked servers, alerts, operators and server configurations.
• Involved in production support for SQL Serverenvironment.
• Working knowledge of Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service(SaaS).
• Configured Powershell script to monitor disk space, CPU activity and Index fragmentation.
• Day-to-day administration of live productionSQL Servers with monitoring and troubleshooting performance using DMVs,SQL activity monitor, Perfmon and Idera.
• Provided troubleshootingSQL Server related CPU, memory, I/O, disk space and other resource contention issues using native SQL Servertools, VMWARE monitoring tools, SCOM, Solarwinds, Powershell, Perfmon.
• Have the ability to facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
• Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
• Processed daily database related tickets in the production environment with formal Request, Change, and Problem Management processes using CISM/SCRM ticketing tool.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Participated in monthly on-call rotation and after hours daily database deployments.
• Approved and ran scripts for Quality Assurance and Production Releases.
• Implemented major DB upgrade plans across all environments. Upgraded servers fromMicrosoft SQL Server 2008/2008R2 to MSSQLServer 2014 & SQL Server 2016.
• Implemented and Scheduled Replication process for updating our parallelservers.
• Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
• Developed and created stored procedures, advanced queries, triggers, views, indexes, and functions for databases.
• Generated the weekly, monthly, and quarterly report by using SQL Reporting Services.
• Applied latest service packs and security fixes for all the servers (Prod & Non-prod).
• Provided on call support 24/7.

Confidential, Tempe, AZ

Senior MS SQL SERVER DBA

Responsibilities:

• Installing and configuring SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 SQL Server versions
• Experience and knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering (Active/Active and Active/Passive).
• Development of Automated notification when SQL Server Backups and schedule maintained jobs.
• Extensively worked on DATA center Migration.
• Extensive experience with AWS (AWS Cloud Formation, AWS ECS and EC2).
• Designed, Implemented and Migrated databases to AWS and Azure.
• Experience in Always On Availability group configuration, failover of availability group and failover of availability group mirroring databases.
• Configured and worked on Log shipping for PROD,UAT and DEV environments.
• Experienced on Snapshot replication, merge replication and transactional replication setup and its flow.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0, RedGate and SpotlIght, Foglight,SQL Backup,Symantic Net backups).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Configuring and Maintaining Database Mirroring and Database Snapshots.
• Excellent Communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.
• Performed Database Integrity Checks, Database Maintenance plans.
• Performed Re-indexing, Rebuilding the indexes, Statistics updates, online indexing for better performance.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production server.
• Used PowerShell to determine the number of DML Operations in Scripts and PowerShell Script to delete old files of SQL Server.
• Worked on SSIS, SSRS tools and involved in creating connection managers, building and deploying packages.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports usingSQLServer Reporting Services (SSRS),Tableau, Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• T-SQL Programing - writing new stored procedures, updating & enhancing the existing code.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Performed daily backups and developed recovery procedures
• Troubleshot issues with log file full and database size increasing beyond threshold.
• Experienced on performance tuning using SQL Profiler and also dealt with event viewer and SQL error logs for find out the issues with respect to SQL server, databases, stored procedures, views.
• Experienced in running Trace to find slowness of stored procedure, databases and also to find the deadlocks in SQL transactions.
• Worked on deadlocks and blockages in SQL server.
• Installed, configured Team Foundation Server (TFS). Also, Deployed code from TFS to SQL Server.
• Creation of new database, planning the location of data, index, and transaction log files on the disks.
• Involved in database decommissioning.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Consult with and advises management on high impact data or database management issues, influencing strategic direction.
• Monitoring service requests and communicating status to others on the team.
• Proactively monitored, determined and solved issues at SQL/database/server levels.

Confidential, Houston, TX

Senior MS SQL SERVER DBA

Responsibilities:

• Managed PRODUCTION, DEVELOPMENT, QA and UAT environments
• Worked extensively on Virtual and VMware Environments.
• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2000 to SQL Server 2008 R2 and from SQL Server 2008 R2 to SQL 2012/2014.
• Involved in Mapping data for safe and secure Data Transfer
• Involved in Quality Test (QA) of Data for successful Migration.
• Involved in Data Migration of servers from SQL Server 2012 to Azure environment.
• Created SSIS packages for various Data Source and Data Destination Mappings for transfer.
• Industry working experience in SQL Server and DB2 database management, maintenance, and troubleshooting.
• Knowledge on Micro Focus and CICS resources.
• Performed Administrative tasks in SQL Server usingPowerShell.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Worked on setting up and managing Snapshot, Merge and Transactional Replication
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Maintained various databases for Production and Testing using SQL Server.
• Use the third part tools such asRedgatefor comparing the databases and to overwrite any changes on the new servers.
• Worked with Transparent Encryption (TDE), table compression, database compression and merge statements using SQL server 2012/2014.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• Extensive use of SQL Server DMV's for Performance Tuning.
• Used Database Consistency Checks- DBCC commands for database maintenance.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks. Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Provided scripting services and production support services in UNIX environment.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012
• Created the backup and restore strategy for production and development environment.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Deploying the code, SSIS packages and SSRS reports in production servers.
• Created SSRS reports and taking care of deployment issues.
• Extensive Data Mapping and Migration of Data for Production Environments
• Created database logical/physical modeling with ERWIN
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers& maintaining Referential Integrity depending on user requirements and converting them into technical specifications.

Confidential, Nebraska

Senior MS SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 on clustered (active-active environment) and non-clustered environments.
• Developed PowerShell and T-SQL scripts for pre installation, post installation, pre migration and post migration checks for Data Center migration.
• Involved in the installation of SYBASE ASE 15.5 and ASE 15.7
• Migrating databases from SYBASE ASE 15.5/ORACLE server to SQL server 2012/2014 using the SSMA tool.
• Installed and configured and maintained failover clustering for SQL SERVER 2012.
• Developed scripts to script out existing replication topology in old data center.
• Recreated the stored procedures from SYBASE server to SQL server.
• Worked with QA on testing procedures and environment setup for testing.
• Schema conversion is performed using the SSMA tool and a timestamp column is been added for each table after the completion of migration.
• Developed SSIS packages to load data from different source systems in to data warehouse.
• Implemented and conducted training for client workplace staff on utilizing the CRM applications software.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability with the help of developers.
• Used Dynamic Management Views (DMV) for monitoring the performance of the server
• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
• Experience in SQL programming, logical and physical data modeling of the database in ERWIN and MSVISIO, Normalization, DE normalization, Database design, Performance Analysis and Production Support for very large (VLDB) in OLTP,OLAP Databases
• Performed online index rebuilds for critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
• Setup Log Shipping for production databases to carry out DR and failover.
• Created the backup schedule for production, test and development servers.
• Involved in database refresh from production to CAT/Dev and QA servers.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases.
• Created SSRS reports and taking care of deployment issues.
• Created Linked Servers for data retrieval using OLE DB data sources and providers

Confidential, TX

Senior MS SQL Server DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining SQL Servers database servers in prod., Dev, UAT, SIT and QA Environments
• Installed SQL Server 2008 R2 and SQL Server 2012 on windows 2008 R2 and 2012 servers, applied service packs and security fix for all servers.
• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2000 to SQL Server 2008 R2 and from SQL Server 2008 R2 to 2012.
• Build Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions
• Implemented Failover clustering for Active/Active and Active/Passive for High availability and Managed SQL Server Clusters in a SAN environment
• Implemented Database Mirroring on SQL Server 2008/2008R2 in Prod environments for DR/HA.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
• Implemented transactional replication for reporting database and Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2008/2008R2 to MS SQL Server 2012.
• Implemented Always on High Availability on SQL Server 2012 in Prod/ UAT environments.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Worked on project-based directives for client CRM environments.
• Conducted production environment developments, custom developments and reporting projects.
• Performed troubleshooting of client CRM issues and maintained documentation of all reported issues.
• Did technical research as needed for all reported issues and drafted reports.
• SCRIBE for understanding the well challenges for the CRM integration.
• Scribe Insight, a premise-based solution, and Scribe Online, a cloud-based solution, offer a range of pre-built connections and maps to jumpstart integration of your CRM system to a wide range of application
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
• Expert in IDERA and SCOM Monitoring and writing T/SQL scripts.
• Created the backup schedule for production, test and development servers.
• Involved in database refresh from production to SIT/Dev and QA servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Confidential, NEW YORK

Senior MS SQL Server DBA

Responsibilities:

• Managed 100+ Prod. Dev and UAT SQL Servers in Virtual and Physical Environments.
• Installed and configured SQL Server 2012,2008 R2 and SQL Server 2005 on windows 2008 R2 and 2012 servers, applied service packs and security fix for all servers.
• Worked extensively on Data warehouse set up on SQL server 2012 and also involved in warehouse deign using Kimball’s methodology.
• Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING
• Implemented system wide security policies and troubleshooting.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeeded. Maintaining SQL Script for creation of Database Objects.
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Installed and configured Sync and Async Mirroring for Production and DR environments
• Setup Log Shipping for production databases to carry out DR and failover
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Scheduled package execution in SSIS and installing packages on multiple servers in SSIS.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created solid stored procedures for Backup and Recovery process.
• Expert in Idera and Scom Monitoring and writing T/SQL scripts.
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Performance tuning, and optimization of procedures and queries.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases

Confidential, Herndon, VA

SQL Server DBA

Responsibilities:

• Provided 24/7 on call production support.
• Worked extensively on Data warehouse set up on SQL server 2008R2 and also involved in warehouse deign using Kimball’s methodology.
• Worked in migration of Non - Clustered instances from physical environment to VM Ware environment.
• Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
• Worked extensively on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.
• Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
• Implemented and tested the point in time recovery of the production databases.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Created Users and Roles, and managed security and permission of different SQL Server objects.
• Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
• Running DBCC consistency check, and fixing data corruption in user databases.
• Experience in Tuning Databases using Performance Dashboard.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Maintained stand by servers using log shipping and replication concepts.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Confidential, FL

MS SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008R2.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and troubleshooting.
• Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Involved in troubleshooting all the performance issues for different database applications.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Documented all the steps and procedures for future references.
• Interacted with concern application team in fixing the problems whenever needed.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot and transactional replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Provided 24 x 7 Production support for the database and application issues.

Confidential, Boston, MA

MS SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 R2 and on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Involved and Build in installation and configuration of SQL server 2005 on Dell Servers. Applied patches and service packs to keep the database at current patch level
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Planned and modified the permission issues in the server.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Interacted with concern application team in fixing the problems whenever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Deployed the SSIS packages on Prod/ UAT/SIT servers.
• Performance tuning, and optimization of procedures and queries.
• Created the backup schedule for production, test and development servers.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Creating, maintaining the users, roles and granting privileges.
• Monitoring and scheduled jobs on production and staging environment.
• Experienced in troubleshooting production servers and fixed the user and application issues.