SUMMARY

• 8+ years of experience in SQL Database Administration for very large and complex databases in SQL Server 2017 and SQL 2016/ 2014/2012/2008 R 2/2008/2005/2000 environments.
• Extensive experience in implementing high availability & disaster recovery solutions like SQL ALWAYS ON Availability Groups, Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on both physical and virtual machines
• Expertise in implementing efficient High availability like SQL Always ON, Replication, Log shipping, clustering (Active/Active, Active/Passive) and Database Mirroring.
• Extensive experience in upgrading & migrating SQL Servers to newer versions and applying Service packs and hot fixes and Unattended Installations.
• Implemented SQL server Side - by-Side Migration from SQL Server 2012/2014 to 2014/2016.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Extensively Worked on Transactional Replication, Snapshot and Merge Replication.
• Implemented the SQL Server concepts like Data partitioning, Snap shot isolation, database snapshot, online indexing, mail Setup, SQL jobs and alerts
• Involved in Logical data and Index Partitioning using SQL Server 2014/2012/2008 R2
• Experience in implementing SQL Server features like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
• Extensively worked on backup compression and data compression in SQL Server 2014/2016.
• Managed stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Experience in configuring and working Microsoft SQL server 2017/ 2016/ 2014/2012/2008 R2/2008/2005 on VMware environments.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Proficiency and expertise in Backup and Restore databases, Disaster recovery planning and Security Management.
• Expert in using Native tools like SQL server profiler, Database Tuning Advisor, Perfmon Counters.
• Developed and created various SSIS dtsx packages and deployed in into File System Server, Microsoft SQL Server using manifest file and deployed to SSIS catalog
• Experience in extracting and transforming data between homogenous and heterogeneous systems using DTSX packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
• Experience in creating SSIS packages using Control Flow Tasks like Data Flow Task, For Each Loop Container, File System Task, Execute SQL Task, Transfer Database Task, and Transfer Login Task etc... And Data Flow Transformations like Multi Cast Task, Conditional Split using Microsoft SQL Server Data Tool (SSDT) and BIDS.
• Experience in creating complex drill down, matrix, drill through, cascading and parameterized reports using SQL Server Reporting Services 2008R 2/2008 /2005. Configured and maintained reports using Report Manager and Report Server.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Expertness in trouble shooting database issues like space issues, deadlocks, performance and blocking.
• Explicitly used third party tools like Idera, Lite speed, Red gate, VERITAS net backup.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Good Knowledge on all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and testing.
• Experience in providing Production Support for 24x7.

TECHNICAL SKILLS

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

Databases: MS SQL Server 2017/ 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MYSQL, Oracle, MS Office Access 97/2000/2003/2010/2016.

Microsoft Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), PowerBI, SQL Server Data Tool, BIDS.

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

Third Party Tools: Erwin, Red gate (SQL Compare and SQL Data Compare), Lite speed, Fog lite, SSAM (System Status Alarm Monitor ),RS Scripter, DB Artisan, Idera, Veritas, Spot lite

Languages: T-SQL, C/C++, Java, java script, VB script, Visual Studio2015/2012, XML, HTML, C# and VB.Net, Power Shell.

Applications: Microsoft Office Suite, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Orange, CA

Sr. SQL Server Production DBA

Responsibilities:

• Administrated and Managed SQL Server 2017/ 2016/ 2014/2012/2008 R2 databases in Production, QA and Development environments.
• Implemented the high availability & disaster recovery models like SQL Always ON Availability Groups, Clustering, Transactional Replication and Log Shipping.
• Extensively worked on SQL Server Always ON, Transactional replication & Log shipping for synchronization of databases as part of SQL Server High Availability & Disaster Recovery.
• Extensive experience in Installing, configuring and maintaining SQL Server 2017/ 2016/ 2014/2012/2008 R2 Active/Active and Active/Passive SQL Clusters with latest Service Packs, Hot Fixes.
• Performed standalone & cluster installation of SQL Enterprise 2016/2014 versions on Windows 2016 and Windows 2012 servers
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabyte.
• Experience in migrating on premises SQL Server 2016 databases to Microsoft AZURE
• Extensively worked on SQL Server database migration from 2008R2/2012/2014 servers to the SQL Server 2012/2014/2016 servers as part of side-by-side SQL server migration.
• Extensively worked on DBA jobs like data loading jobs (ETL), Backups (Full, Differential & Transactional log), disk space, handling the maintenance jobs by checking the error logs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and database backup jobs.
• Experience in Configuring Database Mail for sending job failure notification through email messages from SQL Server Jobs.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users and configured contained databases.
• Extensively worked on Query Store, Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s) to resolve the performance issues like Index fragmentation, Locks, OS, Disk and Memory.
• Configured and deployed SSIS packages from development to UAT servers and from UAT to production servers to run successfully under proxy account.
• Experience in creating ETL (SSIS) packages to load the data from Oracle servers to SQL Servers using Control Flow and Data Flow task components
• Configured SQL reporting services (SSRS) in uat & production environment and deployed SSRS reports and shared data sources.
• Configured PowerBI report server and deployed the .pbix reports to AZURE cloud environment.
• Configured Idera monitoring tool and monitored the performance of the SQL servers and databases.
• Provided 24/7 Support for Production, Acceptance & Development Servers of MS SQL Servers

Environment: MS SQL Server 2017/ 2016/ 2014/2012/2008 R2, Windows server 2016/2012 Enterprise edition 64-bit, Transact-SQL, SQL Idera monitoring tool, SSIS, SSAS, SSRS, PowerBI, TFS (Team Foundation server).

Confidential, Santa Ana, California

SQL Server Production DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R2/2008 databases in Production, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Extensively worked on SQL Always ON to synchronize the databases between Primary server and Secondary servers
• Extensively worked on Installing, Configuring and Maintaining SQL Server 2012/2008R2 Active/Active and Active/Passive Clusters with latest Service Packs, Hot Fixes.
• Extensively worked and Implemented High Availability technique like Replication with Transactional Replication, Transactional Peer-to-Peer Replication and Snapshot Replication topologies.
• Extensively worked on Migrating SQL Server 2008/2008R2 databases to SQL Server 2012 and mentored team technical staff and documented.
• Created Logins at Windows Authentication and SQL Server Authentication server level, Users at database level and assigned database roles to the particular Users.
• Used native tools like Database Tuning Advisor, Profiler and Activity Monitor for performance analysis.
• Expert in using and implementing DMV’s, DMF’s, data partitioning and Indexing
• Checked the configuration and troubleshoot performance of existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance.
• Created and configured SQL Maintenance Plans for database backup’s (.bak) files, transaction log backup’s (.trn) files, database integrity checks and maintenance Cleanup tasks for both user & system databases
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc.… depending on scenarios.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor
• Scheduled regular Backup Jobs and kept track of database by receiving the emails on Alerts
• Created Service Accounts, Credentials and Proxies to run the SSIS jobs under the Proxy Account and scheduled the job in SQL Server Agent.
• Configured Database Mail for sending job failure notification through email messages from Jobs and Procedures.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Server Database Objects and data.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Configured TNS client connection and created Linked Servers between Oracle servers and SQL 2014 and 2016 servers
• Configured and monitored SQL server performance using Spot Lite monitoring tool
• Worked on SQL side by side migration from SQL Server 2008R2 to MS SQL Server 2012 standard and enterprise editions
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Provided 24/7 Support for Production, Acceptance & Development Servers of MS SQL Servers

Environment: MS SQL Server 2012/2008R2/2008/2005, Windows server 2008R2/2008/2003 Enterprise edition, Transact-SQL, SQL Red Gate, Spot Lite monitoring tool, SSIS,SSRS, TFS(Team Foundation server), SSAM monitoring tool, RS Scripter.

Confidential, Los Angeles, California

SQL Server Production DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R 2/2008/2005/2000 databases in Production, QA and Development environments.
• Experience in troubleshooting the blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Configured and Troubleshooted SQL Server Active/Active Cluster and Replication in production environment
• Configured and Troubleshooted SQL Always ON in production environment on standard edition
• Extensively worked in creating backup jobs, database integrity checks and statistics update through maintenance plans.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked on supporting the databases like monitoring the data loading jobs, Backups (Full, Differential &Transactional), disk space, and database status, handling the maintenance jobs and checking the error logs.
• Used Performance monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Worked on migrating the SQL Server databases from 2005 server to the SQL Server 2008R2 servers and SQL Server 2008R2 server to the SQL 2014 servers
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file
• Experience in monitoring the Quest Spotlight performance monitoring tool
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: MS SQL Server 2012/2008R 2/2008/2005/2000 , Windows server 2008R2/2008/2003 Datacenter and Enterprise edition 32-bit and 64-bit, Transact-SQL, SSIS, SSRS, TFS (Team Foundation server), Spotlight.

Confidential, Chattanooga, Tennessee

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Installed and configured SQL Server 2008R2/2008/2005 on new servers with service packs.
• Experience working on Active/Passive Failover Clustering solution into HP EVA 3000 SAN environment for SQL Server Consolidation.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server Disaster Recovery.
• Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Setup Database Security and maintained accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Monitored SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Maintained Production and Test Database Environment in SQL server 2008R 2/2008/2005.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating drill down, parameterized and cascading reports using SQL Server Reporting Services 2008R 2/2008/2005.
• Experience in generating Adhoc reports using SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: MS SQL Server 2008R 2/2008/2005/2000 , Windows server 2008/2003 Datacenter and Enterprise edition 32-bit and 64-bit, Transact-SQL, SQL Lite Speed, ADO.net, VB.net, SSIS,SSRS, TFS