SUMMARY:

• 10+ years of experience as Database Administrator ( DBA) and Developer for large and complex databases in SQLServer 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2016\2014\2012\2008R2\2008\2005\2000
• Expertise in Cloud infrastructure including SQL Azure (IaaS), (PaaS), (SaaS), elastic pools, hybrid cloud and private cloud
• Implemented the mechanisms like backup/ data compressions, online indexing and Always ON.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Hands on experience on Query Store, Live Query Statistics, Transparent Data Encryption (TDE).
• Expert in Disaster Recovery plans by configuring Clustering, Log - shipping, Mirroring and Replication (Snapshot and Transactional).
• Handled up to 24 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different Raid Levels.
• MySQL Error handling, Log maintenance and troubleshooting.
• Expertise in handling MySQL Security, establishing MySQL Replication and MySQL Clustering between two or more MySQL Database servers.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Experience in configuring and troubleshooting the issues with transactional replication.
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning long running Queries and Store Procedures by examining the execution plans.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and bottlenecks caused by complex Queries.
• Expertise in Database optimization and developing MySQL Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Non-cluster), Constraints, Triggers, Buffer Pools, User Roles and functions
• Excellent skills in database Back Up, Restore, Recovery, updating statistics, Rebuilding and Reorganizing indexes, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle and Teradata Databases.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer’s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Expertise in using DMVs and DMFs to finding and solving Performance Issue.
• Expertise in Planning & Scheduling Maintenance Tasks and Scheduling Jobs & Alerts using Database Mail.
• Explicitly used third party tools like Lite speed and Fog light.
• Expertise in performance tuning with Ignite tool (database Performance Analyzer).
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, optimizing code and improving Efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Strong ability in Scheduling and deploying reports on Report manger.
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.

PROFESSIONAL EXPERIENCE:

Confidential, MA

Sr. SQL Server DBA

Responsibilities:

• Migrated databases from SQL Server 2008 to SQL Server 2016 and . Ran Database Migration Assessment (DMA) tool to find compatibility issues before migration.
• Performed the installation of SQL Server 2016 using GUI and Unattended installation.
• Deployed and Configured Maintenance Scripts related to third party (Ola Hallengren) on the servers.
• Configured SQL server services to run with GMSA to resolve the password expire issue on servers.
• Resolved Double Hop Issue by registering the SPN using Kerberos Configuration Manager.
• Configured High Availability feature called ALWAYSON on SQL Server 2016 servers.
• Migrated on-premises databases to SQL Azure Database using the tools available within Azure.
• Configured SSISDB catalog on SQL Integration service server and deployed them using SSDT.
• Configured DSN to pull data from different data sources for SSIS packages and involved in migrating the packages from SQL 2008 to SQL 2016.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Performed SSAS databases Backup and Restores and Process Clear the databases
• Configured SSRS on SQL Server 2016 and migrated SSRS from SQL 2014 to SQL 2016.
• Migrated SSRS subscriptions from one environment to another by developing SQL scripts
• Configured Query Store on SQL 2016 databases and analyzed the performance issues
• Configuration and Setup of various MySQL performance monitoring tools like Nagios, Datadog, New relic and PERCONA TOOLKIT.
• Performance Tuning done with a tool called Solar Winds Database Performance Analyzer.
• Configured Encryption at disk level using Vormetric Transparent Encryption Key tool
• Worked on incident tickets to resolve the issues created by the users.

Environment: MS SQL Server 2016/2014/2012/2008 R2, T- SQL, SSIS, SQL Azure, SSAS, BCP, SQL Profiler, Always On, Windows 2008/2012 Server, VTE, Ignite, SQL Server Kerberos Configuration Manager.

Confidential, WI

Senior SQL Server DBA

Responsibilities:

• Migrated databases from SQL Server 2000 to SQL Server 2005 and R2 and SQL Server .
• Individually developed and implemented database maintenance strategy with code of 2500 line for database Reindex/Reorganize and Update Stats procedure and deployed in production successfully.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Performed Server builds with SQL 2008R 2// 2012/2014/2016.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Tuned queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Configured Always on SQL server 2012/2014/2016.
• Successfully implemented the Capacity planning for different servers.
• Migrated DTS packages to SSIS packages.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active passive cluster environment.
• Tuned the MySQL queries using Percona pt-query-digest tool and analyzed database queries by slowness, CPU time and frequency to stop database spikes and tune bad queries.
• Cleaned and rotated/automated the error logs and slow query logs - MySQL log maintenance.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Implemented MySQL Enterprise Monitor, MySQL Replication Monitor and MySQL Query Analyser for improving query performance and capacity planning in MySQL OLAP databases.
• Daily routine Developer/ DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Performed Performance Tuning of the Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance
• Managing the backups with lite speed tool and Native SQL.
• Performance tuning done with Ignite tool.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Routine Developer/ DBA jobs like Backups and Restores
• Hands on experience in trouble shooting database issues.
• Responsible to Monitor and troubleshooting Log Shipping.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Performed Update statistics, database integrity check and Backup operations
• Used SQL server Reporting Services (SSRS) to create reports.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2005/2000, T- SQL, SSIS, SSAS, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, SMSQL, Windows XP/2000 and Windows 2003/2008 Server, Lite speed, Ignite

Confidential, CO

SQL DBA

Responsibilities:

• Involved to work with troubleshooting the stored procedures, functions, views, triggers and part to be increasing the performance tuning.
• Administrated and Managed SQL Server 2014/2012 databases in Production, QA and development environments.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Managing Storage engines: INNODB, MYISAM, Falcon, Percona XtraDB, MySQL Federated, MySQL Archive, Aria
• Database performance problems analysis diagnoses and optimum performance resolution - employing preventive measures to maintain high applications availability, performance monitoring, identifying and resolving database performance bottlenecks, SQL tuning, Explain SQL query, Indexing, MySQL and Linux OS level optimization.
• Implemented Always on Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS from SSAS Cubes.
• Involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs and building platform with the using of SSIS to feed in BIDS and SSAS cubes.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks and versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results.

Confidential, AZ

SQL DBA/Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T- SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T- SQL in order to design and tune T- SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking functionality of component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Generated Sub-Reports, Cross-tab, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Configured the report viewing security for various users at various levels using Report Manager