SUMMARY

• 10+ years of experience as SQL Server DBA in Production, Development, Test, Staging & Data Warehouse Environments (OLTP and OLAP).
• Expertise in working on SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 versions.
• Designed, Implemented and monitored SQL server Always ON as HA & DR solutions for various environments.
• Expertise in configuring and Maintaining the SQL Always ON as Hybrid AO & other AO types includes Option 1, Option2, Option3 & Option4.
• Migrated the SQL Servers from On premise to Confidential cloud (IaaS) environment for various business critical application.
• Expertise in configuring the WSFC clusters, Quorum &FSW on multi subnet environments.
• Deep hands on in Listener recreation, Connectivity issues, sorting the SPN creation &mapping issues.
• Extensively worked on AG group properties settings, AG replica synchronization issues, AG failover issues & adhoc issues.
• Designed, implemented and monitored the log shipping, Mirroring & replication on various environments.
• Expertise in configuring the Transaction& Merge replication, Sorting the issue very quickly includes latency, PK violation, Job failures & Adhoc issues.
• Analyzed and Quickly fixed the SQL Mirroring end point failures, Synchronization &failover issues.
• Strong T - SQL Developer skills including stored procedures, Indexed views, Adhoc queries, User Defined Functions, Triggers, and Distributed Queries for various versions.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon, DB Engine Tuning Advisor, Extended events, Auditing.
• Performed the in Place up gradation & side by side upgradation (Migration) for various versions includes SQL Server 2012/2008R 2/2008/2005/2000 .
• Working on applying the
• Good hands on in writing the Power Confidential scripts.
• Expert in working on Contained Databases, Change data capture (CDC), online index & Transparent Data Encryption (TDE)
• Planning the backup strategies, Maintenance plans using Native & Third-party tools (Lite Speed, Red Gate SQL Backup and Splunk).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in configuring and administering Integration, Reporting & Analysis services.
• Experience in migrating SSIS packages to higher versions and fixing the issues.
• Experience in BI Development and Deployment of SSIS packages from Flat files, Excel, Oracle, and DB2.
• Experience in providing Logging, Error handling by using Event Handler & Custom Logging for SSIS Packages.
• Expertise in SSIS package performance tuning by using the Row Transformations, Block and partial blocking Transformations.
• Extensive experience in controlling the User Privileges, Monitoring the security &audit issues.
• Experience in tasks automation includes monitoring Disk Space, Server Ping Status, and Database health checks using customized SQL scripts, batch file and Power Confidential .
• Experience in solving Database issues with Index fragmentation, Integrity checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Experience in analyzing SQL wait types, execution plans for troubleshooting performance issues.
• Provided extended support for business critical applications like SharePoint, Project Financial, Data hub and SCOM.
• Strong Communication &Management skills including best team lead role.
• 24/7 on Call Support to cover the production/other critical issues, weekend deployments.

TECHNICAL SKILLS

Databases: SQL SERVER 2014/2012/2008 R 2/2008/2005/2000 , MS-Access, DB2, Oracle Database 10g and 11g.

Operating System: Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2014, Unix, Linux.

Programming Languages: TSQL, PL/SQL, Power Confidential, C, C#, VBScript, HTML, XML.

SQL Tools: SQL Server Management Studio, SQL Navigator, Confidential Visual Studio 2008/2010/2012 , SQL Server Enterprise Manager, BIDS, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerfMon, SQL Configuration Manager.

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL DBA Lead

Responsibilities:

• Designed, implemented and maintained the SQL Always ON for the SQL 2014/2012 versions.
• Implemented the Hybrid AO & other AO types includes option1, option2, option3 & option4.
• Performed on premise to Confidential azure (IaaS) migration for the business critical applications.
• Implemented the Hybrid AO and helped the business teams with appropriate migration planning.
• Configured the multi subnet WSFC Cluster, Quorum & FSW as part of all AO configurations.
• Applied the monthly patches and service packs to achieve the security & performance metrics.
• Implemented the SQL Server Mirroring, Snapshot/Transactional replication on versions 2012/2008R2/200/2005 for various application based on the business requirements.
• Quick analysis and fixed the AO listener connectivity issues, listener recreation/swapping& IP mappings/changes.
• Performed the in Place upgrade and side by side upgrade (migration) for the various servers includes the versions 2014/2012/2008 R2/2008 by resolving any intermittent issues.
• Configured the alert systems for all HA & DR implementations which helps in monitor the status, changes and performance.
• Installed and configured SQL Server 2012/2008R2/2008Clusters by preparing the shared drives in WSFC cluster.
• Designed and Implemented the Hybrid SQL Always On for various servers and performed the post checks, fail over & fail back testing.
• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.
• Actively worked on performance tuning by analyzing the Windows, SQL, Memory &Query optimization by using the T-SQL debugging.
• Actively worked on capacity planning, submitted the best plans to customer for successful implementation.
• Resolved the Memory/IO/CPU/Temp DB bottlenecks to achieve performance by making use of Windows
• Extensively worked on Profiler, perfmon, SQL traces, DMV’s, extended events and Auditing.
• Design and deploy the SSIS packages intended for various functionalities includes importing data from Excel, Oracle, DB2 & MS Access.
• Managed the SQL Server and database securable by providing the appropriate access to objects.
• Developed Power Confidential scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
• Designed and Deployed SSRS reports, Scheduled reports to run on daily basis to send e-mails.
• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.
• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.
• Active focus on all critical tickets which are created in Service Now (SNOW)/ITSM to resolve them with in time and providing the RCA for the critical issues.
• Responsible for the implementation, documentation, and day-to-day support and reports to management.
• Managing the team in 24/7 support with rotational shifts and delivering the targets with in timeline by mentoring, task assignment and helping the team.

Confidential, TX

Sr SQL DBA

Responsibilities:

• Installed Sql Server 2012 and configured Always On with Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Installed SQL Server 2012/2008R2 on windows server 2012and migrated SSIS packages.
• Migrated databases from SQL Server 2005/2008/2008 R2 to Sql Server 2012.
• Implemented SQL mirroring, Clustering, Transactional replication and regular checks that include alerts, jobs failures, latency, and performance and fixing the adhoc issues.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Create triggers to keep track of changes to the fields of tables when changes are made.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Involved in Table designing whenever required.
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Used SSRS to create reports that draw content from a variety of data sources
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created SSIS/DTS packages for Finance application that would transfer data among servers to perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Confidential

SQL DBA

Responsibilities:

• Design, develop and maintain database administration tasks for administering SQL Server 2005/2008/2008 R2
• Installation and configuration of SQL Server 2000/2005/2008/2208 R2.
• Designed and developed DTS packages.
• Migrated DTS packages from SQL 2000 to SQL 2005.
• Worked on SQL server up gradation from SQL Server 2000 to SQL Server 2005/2008.
• Worked on ETL migration with required transformations like Derived Column, Data Conversions, Sort and Union.
• Designed, Configured and automated SSIS packages as per Business (LOB) requirement.
• Create and maintain various databases for development, testing, staging and production environments using SQL Server 2005/2008.
• Monitoring and Troubleshooting SQL 2008 Cluster.
• Hands on experience on SQL Server Log shipping, Replication and Mirroring.
• Written Stored Procedures, Functions, and Views as per DBA requirement.
• Troubleshooting query performance.
• Manage users including creation/alteration, grant of system/db roles and permissions on various database objects and object level permission.
• Creating & scheduling the maintenance plans.
• Developing the successful Backup strategies based on Recovery models.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Synchronizing Production and UAT environments.
• Hands on experience in IIS 6.0/7.0/7.5
• Installed and worked on F-Secure SSH Server, generating keys and exchanging with other teams to establish the connectivity for file transfer on daily basis.
• Shrinking the Data files and log files if more free space is available.
• Monitoring Database server, performing health check, SQL Jobs on day to day basis
• Creating and Scheduled SQL jobs as per the business requirements.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Perform Import/Export tasks using SSIS from different data sources like Flat file, Excel and DB2.

Confidential

Sr Project Engineer

Responsibilities:

• Planned and Installed SQL Server 2000, 2005,2008 on the Production, test and Development Servers.
• Configured the Log shipping and mirroring on SQL Server 2005/2008.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and
• Restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Logins, Tables, Clustered, Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Designed and created the DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

Confidential

Technical Consultant

Responsibilities:

• Installed and configured the SQL server 2000/2005 on various servers.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
• DBA activities like creating Logins, users &managing the permissions.
• Created the tables, views and T-SQL queries.
• Configured the SQL Server Log shipping, Mirroring for the databases.
• Performing the database backups, restores, data refresh based on the schedules.
• Calculate disk space and table space requirements, involved in capacity planning, estimating and sizing of tables.
• Involved in designing the SSIS packages to export data of flat file sources.
• Disaster Recovery Plans, Testing and analyzing and continuous update of documentation.
• Developed the basic stored procedures, Database testing, maintaining the data sets.