SUMMARY:

• Over 8 years of experience in IT in Database Administration and Development for very large and complex databases in SQL Server 2014, 2012, 2008 R2, 2008, 2005 and 2000 .
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Datacenter Migration experience from SQL Server 2008R2 to SQL Server 2012/2014.
• Extensively worked on High Availability solutions like Always ON, clustered environment & Replication
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery and planning.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Having hands on experience in DR processes including Log shipping and Database Mirroring .
• Troubleshoot performance problems, fine - tuning of databases and index Analysis.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Experience in migrating SQL Databases to cloud environment like SQL Azure & Knowledge on Amazon Web Services (AWS).
• Having Experience on Data center servers and handling 22 TB databases.
• Experience in using tools like VEEAM Tool, SQL Sentry, SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
• Working knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert .
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in using PowerShell script Desired State Configuration (DSC) for installing SQL Servers, create Maintenance Plans & Post install Server configuration.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Experience in working with Analysis Services (SSAS) and Reporting Services (SSRS).
• Having VMware virtualization experience with vSphere 4.1 and 5.5 environment.
• Implemented different types of Replication models like Transactional and Snapshot.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support
• Worked on importing data from MySQL to SQL Server.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Worked on logical and physical data base modeling with UML and ERWIN tools
• Worked on Sales Force, Jira, BMC Remedy, Resolve, Virtual Ticket & Service Now ticketing system software’s.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, 2000

Programming: PowerShell Scripts, T-SQL, Visual Basic 6/5, C, C++ & SQL

DBA: database administration of SQL Server 2012, 2008R2, 2008, 2005, 2000

Operating System: Windows 2008/2003/2000 Advanced Server, NT & Windows 9x, Linux

Tools: VEEAM Tool, SQL Sentry, Backup Utility, SQL LiteSpeed, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential - Addison, TX

Sr. SQL Server DBA

Responsibilities:

• Installation & maintenance of MS SQL Server 2008/2008R2/2012/2014
• Datacenter migrations using Veeam tool end to end copying from Physical servers to Virtual machines (VM’s).
• Need keep the infrastructure and SQL Server Database uptime 98% and achieved 99%
• Set up Always ON high availability with windows cluster on SQL server’s 2012/2014 for newly created servers.
• Working on setting up Log shipping between PROD & COB environments.
• Implemented and managing SQL server security for Database users (Read/Write)
• Planning & Managing SQL Server databases backup and recovery strategy using Veeam backup tool.
• Planning & Managing capacity planning of production, development and test servers
• Diagnosing/Troubleshooting database issues on-day-to-day basis
• Planning, managing, creating POC’s and implementing/coordinating Windows & SQL Servers Patching and SQL Cumulative upgrades and Database maintenance plans
• One of the team member for core team which reviews Architecture and Design review team
• Designing & developing SSIS packages, SSAS Cubes, SSRS Reports and Applications
• Design, configure modify and enhance the applications as necessary
• Documenting database activities on-day-to-day basis
• Taking care of planning and communicating planned and unplanned downtimes

Environment: MS SQL Server 2012/2008R2/2008, SQL Lite Speed, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, SSRS, SSIS, BCP and Microsoft Cluster.

Confidential - Telecom, Southlake, TX

Sr. SQL Server DBA

Responsibilities:

• Analyzing the Database Infrastructure / servers / storage and provide technical recommendations for improving the SLA times with business users and implement optimization changes for better performance for applications.
• Migrated SQL2008 applications to SQL2014 with Always on high availability clusters for disaster recovery and reporting.
• Migrated few of PROD SQL Databases to cloud environment SQL Azure
• Implementation of Replication Models (for OLTP Servers) using Merge and Transactional (with updatable subscriber) on large terabyte databases.
• Involved in Fine Tuning and Performance and Query optimization of the Database as required by the application.
• Migrated few database servers to AWS (Amazon Web Services).
• Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size.
• Implemented 2 way Replication (Pub-Pub) between 1 Publisher and 3 Subscribers.
• Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
• Implementing the Security strategy for each environment and the required backup strategy as well.
• Use DMVs and custom scripts to tune performance of SQL Server queries.
• Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
• Installed standalone SQL Servers, create Service accounts, maintenance plans etc., using PowerShell scripts (DSC).
• 24 X 7 On-call support rotation for SQL Server database systems, products and services.
• Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
• Develop and deploy trace files to audit DBA activities, DDL commands and Security events in SQL Server. Automate the process of reporting unauthorized activities.
• Design and develop database backup and recovery procedures.

Environment: MS SQL Server 2014/2012/2008 R2/2008, SQL Lite Speed, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, SSRS, SSIS, BCP and Microsoft Cluster.

Confidential - Financial, Irving, TX

SQL Server DBA

Responsibilities:

• Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
• Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring and Log Shipping to provide multiple copies of production data that can be used for disaster recoveries.
• Set up Log shipping between Primary Server (PROD) & Secondary Server (COB).
• Installed SQL Server 2012 versions using PowerShell Desired state Configuration (DSC) and post install Server configuration.
• Worked on Cob tests during weekends to test COB environment by business users.
• Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
• Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment
• Extensively worked on auditing entire environment by building SQLMonitoring database to capture everything single thing in the prod environment.
• Deploying new code base release to UAT and Production Environments.
• Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
• Moved secured databases to AWS cloud environment from SAN.
• Provide expertise for using best RAID Technologies based on application requirement.
• Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
• Extensively used Service Now tool for any changes in the environment and also incidents.
• Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.
• Used SSIS to move auditing files from SQL server to Unix server.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential - Plano, TX

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
• Responsible for overall database environment and maintain operational uptime of 99.9%.
• Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
• Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism.
• Designing, Implementing and administering the transactional replication from Primary database server to the 6 search pool servers.
• Setup SQL Mail and integrate it with the application, design and manage replication.
• Install and configure SQL LiteSpeed for SQL Server to backup SQL Server database or setup database maintenance plan to back up all the databases locally on the disk.
• Creating Virtual Machines in VMware vCenter and maintain virtual Machine and performance.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
• Monitoring the servers using Idera third party software and backups using SQL Litespeed.
• Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
• Deployed SSIS packages and worked on Reporting services.
• Created logins and Roles with appropriate permissions for temporary and permanent access requests.
• Scheduling the Backups and performing the restoration. Support for huge Databases.
• Provided 24/7 on-call support on rotation basis for production database.

Environment: MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential - Financial, Irving, TX

SQL Server DBA

Responsibilities:

• Upgraded SQL Server 2005 to 2008R2 and SQL Server 2008 to 2012 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Performed Backups and restores on regular basis for Migration and other purposes.
• Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
• Use custom developed scripts to identify missing indexes.
• Common operations in all modules like Add, Modify, Delete, View, Chaining from one module to another, Search, First Row, Next Row, Previous Row and Last Row where set on Right mouse button.
• Worked with tickets like RFC’s for prod/UAT changes and VT’s for QA/DEV servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates.
• Database refreshes from prod to stage, test and development environments.
• Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
• Production and on call support on rotation basis.
• Solved issues related to server performance and disk space.
• Rebuilding the indexes at regular intervals for better performance.

Environment: MS SQL Server 2008R 2/2008/2005/2000, Visual Studio 2010/2005, SQL Lite Speed, Microsoft Visio 2003, SFTP and Windows Server 2003/2000.

Confidential - Coppell, TX

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005 and 2008R2 in production and development environment.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005/2008.
• Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Expertise in designing databases and capacity planning.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
• Creating documentation for error resolving fixtures.
• Worked with Jira ticketing system software to solve issues.

Environment: Microsoft Windows Server 2008/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed.

Confidential, Dayton, OH

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
• Database Administrator, Database Programming.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Deploying new code base release to UAT and Production Environments.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Worked with change management and change control procedure.
• Converting DTS packages into SQL Server 2005 Integration Services
• Solved issues related to server performance and disk space.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Support Development team in deploying and testing the application.

Environment: Microsoft Windows Server 2000/2003 32/64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases .
• Rebuilding the indexes at regular intervals for better performance.
• Manage replication and database modifications for replicated objects.
• Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Design, document and implement SSIS packages and stored procedures.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows 2003 Server, SQL server 2005/2000, Event Viewer, SQL Profiler, T-SQL.