PROFESSIONAL SUMMARY:

• Over 8 years of Database Administration and Development experience on MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000.
• Expertise include Administration, Database Design, Performance Analysis of highly transactional servers and production support for Large (VLDB) Complex and Critical databases.
• Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption.
• Extensive expertise with configuring High Availability and Disaster recovery scenarios like Always On, Clustering, Mirroring, Log shipping and Replication.
• Documented Disaster Recovery plans and participated in disaster recovery drills.
• Worked extensively on Multi - Subnet Clustering and Server consolidation. Troubleshooting Production issues, HA issues and AG alerts
• Experience in implementing advanced features like Policy Based Management, Resource Governor, Data Collector sets, and Backup Compression Techniques.
• Implemented the methodologies like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, Online Indexing,
• Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas. Working in both MOLAP and HOLAP environments.
• Worked extensively on DMV’s, DMF’s, Mail Setup, Jobs and Alerts, DTA, SQLCMD.
• Experience in data migrating (using tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
• Expertise in setting up High Availability and Disaster Recovery(HADR) solutions such as Active/Passive and Active/Active Clusters.
• Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive)
• Proposed various high availability options to maintain the high availability of SQL server on various environments.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, Proper usage of indexes, Index Rebuild, Reorg.
• Experience working with Profiler and Server-side trace.
• Expertise in reading and understanding Execution plan and fixing query to execute with low cost.
• Expert in handling parameterized Reports, Drilldown Reports using SQL SERVER REPORTING SERVICES 2005
• Designed effective Maintenance Plans for Backups (Full, Differential and Transactional Log) and RPO, RTO to recover point in time data in in case of disaster of server/center
• Expert in AZURE Blob Storage Management and migrating blobs.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in using GoldenGate to support data replication in oracle database environment. Proficiency using Oracle GoldenGate replication monitoring, tuning and capacity planning.
• Good Experience in Heterogeneous migration from SQL to Oracle using GoldenGate.
• Upgraded databases from MS SQL Server, 2012 and MS SQL Server, 2014.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Experience in SQL Server Reporting Services (SSRS) and Crystal Reports.
• Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Performed both single server and multiple server deployment of SCOM and its components.
• Extensively worked on Data tier applications, deploying and managing dacpacs.
• Hands on expertise on both Upgrading and Downgrading SQL Server to new versions and applying Service packs and Hot Fixes.
• Worked on DR exercise for Sybase server using flash copy function.
• Very proficient in Installing, Configuring, Maintaining and Monitoring Various Sybase DB products and tools and automate/schedule based on requirements.
• Expertise in implementing advanced methodologies like Transparent Data Encryption (TDE), Page Level Compression, and Column Stored Indexes.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Experience on Visual Studio team services (VSTS).
• Explicitly used third party backup tools like Lite Speed, Fog light and Red gate.
• Creation and maintenance of Databases, creating Roles and managing user permissions and Data Warehousing.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Develop and manage reports on SharePoint Server.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Monitoring and troubleshooting by checking Performance Monitor and Activity monitor.
• 24 x 7 Production Database on Call Support. Excellent Analytical, problem solving and communication skills.
• 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.

TECHNICALSKILLS:

Databases: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, SQL Azure and Oracle 11gr1, 11gr2 and 12c.

ETL & REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: Server Management Studio, SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL, Enterprise Manager, Perfmon, Index Tuning Wizard, Database Tuning Wizard, Export & Import, GoldenGate v10,v11. Precise i3 for SQL Server.

Third Part Tools: SCOM, Idera SQL Check, Companion, lite speed, Red gate, Veritas net backup, Erwin r7, TDE, Azure Storage Explorer, Cloudberry Storage Explorer. T SQL, C/C++, Java, PERL, java script, VSTS 2013 &2015, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net.

Ticketing Tolls: Service Now, Jira and BMC Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr Database Administrator

Responsibilities:

• Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2016/ 2014/2 R2/2005 on standby environments.
• Primary hands-on duties include MS Active Directory management, SQL DBA activities, Exchange management, GEMMS EMR management, Intertel telephone system management, Network Security management, application and report development and support.
• Installed latest service packs, applied hot fixes and cumulative updates.
• Migrated servers from and with In-place and Side-by-Side Processes.
• SQL Server Patching on 2005, 2008, 2008R2, 2012, 2014.
• Applied Patches and Service packs to update different versions of MS SQL Server in Clustered and standalone environments.
• Created linked servers between SQL Server 2005 and 2008, 2008R2 and 2012.
• Administering SQL Server High Availability features like Log shipping, Database Mirroring and Always On.
• Worked on Active/Passive clusters to manage cluster resources and troubleshoot errors.
• Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases and worked with Transactional Replication to achieve load balancing.
• Ensure backup and recoverability of all enterprise SQL server databases using Native SQL and Symantec NetBackup.
• Daily routine Developer/DBA tasks like handling user's permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs.
• Helped in Performing GoldenGate replication monitoring and tuning.
• Performed Initial load, extract, replicat, trial files and exporting data onto Repository Database using GoldenGate tool.
• Created Source definition files for SQL Server DB replication by using GoldenGate.
• Implemented the TDE (Transparent Data Encryption) in all the production servers to secure the customer credit card or payment details and in order to follow the PCI standards.
• Created Databases on Azure SQL Server and Migrated On-Premise databases to Azure SQL.
• Setting up High availability | DR solutions over Azure.
• Configured Azure SQL Server Firewall for Performance Tuning.
• Migrated the production SQL server schema to the new AWS RDS.
• Used Cloud watch for basic and detailed monitoring of AWS resources.
• Installed, Configured, managed security for SSIS, SSAS, and SSRS (2008 R2, 2012 &2014).
• Creating SSIS packages to load data across different servers.
• Re-Designed Siemens model cubes (SSAS) by partitioning the cubes yearly and then monthly.
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Develop/execution of automated scripts using Microsoft custom .NET framework in Visual Studio VSTS 2015.
• Responsible for tuning complex SQL queries and Stored Procedures to increase performance.
• Involved in integration/system testing and backup/restore testing for all components.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Experience with Team Foundation Server and BI Documenter tool.
• Used TFS for source control and managing development via tasks/bugs.
• Responsible for deploying code changes, code review and code releases in all environments with respect to release deadlines.
• On Call 24X7 support, request queue, daily maintenance and application support.

Environment: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , VSTS 2015, Visual Studio 2008/2010, BIDS, T-SQL, SSIS, SSAS, SSRS, Azure, Red Gate SQL Compare, Lite Speed, Performance Analysis (PA), HP Quality Center, Crystal Reports, TFS, MS-Excel, XML, Windows 2012/2008R2/2008/2003/NT/XP.

Confidential, Arlington Heights IL

Sr. SQL Server Production DBA

Responsibilities:

• Managed Production, Development, QA and UAT environments.
• Experienced in troubleshooting long running queries and resolving locking and blocking issues.
• Involved in migration from SQL Server 2008 R /2016.
• Implemented SQL logins, Roles and Authentication Modes as part of Organization's security policies.
• Setup build definitions and troubleshoot build failures for Projects developed in Visual Studio VSTS 2013/2015 IDE.
• Worked in integrating TFS with Visual Studio VSTS 2013 & 2015.
• Worked on Setting up and managing Snapshot and Transaction replication.
• Implemented Always On Availability Groups for High Availability and Disaster Recovery.
• Involved in Always On for High Availability and reporting purpose and created the documentation.
• Experience in Database backup and disaster recovery procedures.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Resolved issues related to creating & maintaining of databases, monitoring Disk Space, Database Security, Database integrity, Indexes management, blocking and daily checks.
• Setup & Automated Key Alerts on daily/weekly maintenance Jobs, Data Loads Jobs, Disk Space and CPU Monitoring, monitored server performance, trouble shooting and fixing performance issues.
• Developed complex business stored procedures, function and triggers.
• Extensively used SQL Server DMV's for Performance Tuning.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks.
• Created Backup, Restore and Verify strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• 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.
• Working with development teams in designing, finalizing and developing database schemas and objects.
• Monitoring and fixing of daily jobs and data loads.
• Backup, Restore and verify the critical databases on regular intervals.
• Validate and executing the scripts in test, UAT and Production environment.
• Installation, configuration and upgrade of MS SQL Server 2014/2012/2008 R2/2008.
• Updating Service packs and Security patches for the Servers.
• Analyzing data, Defining KPIs and publishing dash boards.

Environment: SQL Server 2014/2012/2008 R2/2008, MSSQL, MS Access, Windows Server 2012R2/2012/2008 R2, Windows Server 2003/2000, VMware, RedGate, SSIS, SSRS, SSAS, Clustering, Mirroring, Log Shipping, Replication

Confidential, Cedar Rapids, IA

Sr. SQL Server DBA

Responsibilities:

• Installed SQL Server 2014/2012/2008 R2/2008/05 on Windows Clustered and standalone environments with latest service packs.
• Upgraded SQL server Databases from 2000/ R2/2012
• Experience in working and troubleshooting2TB Very Large databases (VLDB) in OLTP Environment.
• Configured Always ON availability groups in SQL server 2012
• Configured log shipping for multiple databases as a part of DR.
• Configured Replication and database mirroring.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
• Analyze long running slow queries and tune the same to optimize application and system performance.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Reorg/Rebuilding the indexes at regular intervals for better performance
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Involved in trouble shooting and fine-tuning of databases for its performance.
• Improve the performance of SQL Queries and stored procedures using SQL Profiler.
• Configuring TEMP DB on files and file groups and capacity planning of databases.
• Configuring and deploying SSIS packages and SSRS reports.
• Documenting procedures in run books.

Environment: SQL Server 2014, 2012, 2008R2, 2005, Windows 2012, 2003 Server, Symantec NetBackup, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, WI

Sr.SQL Server DBA

Responsibilities:

• Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.
• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2005/2000.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Design/ developing SSIS (ETL) MDX developing components.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Created the logical and physical data modeling using Erwin tool.
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Responsible for production backup and recovery strategy using RMAN.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.

Environment: Windows 2000/2003, MS SQL Server 2000/20, Oracle10g/11g, SSRS, DTS, SSIS, BCP SQL Server Profiler, QNXT, Care Advance, Biz Talk, TSQL, Database engine tuning Advisor.

Confidential, Minneapolis, MN

Sr SQL SERVER DBA

Responsibilities:

• Interacted with various customers on day to day basis and analyzed their SQL server environments.
• Analyzed various SQL server environments and suggested best practices for better performance.
• Administered the space usage of the various databases for various applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Installed and configured SQL Server Reporting Services.
• Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.
• Proposed various high availability options to maintain the high availability of SQL server on various environments.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created various automated processes to update the Reporting services databases on a regular basis.
• Suggested and implemented various SQL Server Reporting services environments.
• Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.
• Upgraded SQL server 2005 to SQL server 2008 on a Clustered environment.
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool ).
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.
• Implemented various high availability options for SQL server 2005/2008 including replication.
• Tested point in time recovery of the production 2008 databases using the traditional backup/restore technique.
• Setup replication for high availability.
• Make modifications/and add new MDX queries to cubes.
• Installed SQL server and implemented resource utilization on the server.
• Converted many DTS packages to SSIS packages during the up gradation of the servers.
• Involved in performance tuning and query optimization.
• Fixed and rebuilt many SSIS packages during the migration.
• Analyzed many databases in various environments for performance issues.
• Monitored network for bottlenecks.
• Involved in tuning various reports generated using SSRS.
• Documented the various observations made and suggestions on various environments.

Environment: Windows 2000/2003, MS SQL Server 2000/2005/2008 , SSRS, DTS, SSIS, SSAS, VB 6,Erwin, SQL Server Profiler, T-SQL, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.

Confidential

SQL server Developer

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports using Crystal Reports
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, Business Objects, T -SQL, BCP.