SUMMARY:

A top - performing Certified SQL Server DBA having more than 7 years of experience as SQL Database Administrator /Developer and more than 6 years of experience as an application programmer. Hands on experience on Database Management and Development which includes installation, configuration, backup, restoration, HA/DR solution like Log shipping, Mirroring, Replication, and Clustering. Well versed in upgrading, migration, troubleshooting, supporting clients, Data Modeling, SSIS, SSRS, SSAS, Database Monitoring, Performance Tuning, Database Security, Database Programming, Patch Management, managing concurrent applications (managing Locks, Blocks, and Deadlocks) and using SQL Server, MS Access, and Oracle. Strong hands-on experience Migrate Data and Database into Microsoft Azure cloud Platform, Azure SQL Database and SQL Server on Azure Virtual Machine. Proficient in Transact-SQL, stored procedures, packages, triggers, views, Constraints, Cursors, functions, deployment and managing related security.

Full life cycle Software development (SDLC) with objects oriented analysis/ Design/Development/ Testing/Operational Maintenance and Upgrade. Experienced in design, develop, test, document, deploy and support multi-tier web-based/Client Server applications built on .NET Framework 2.0, 3.5, 4.0, using C#, IIS, ASP, ASP.NET, XML, HTML, CSS, ADO.NET, ASMX, OOD, JavaScript, VBScript as well as web services.

TECHNICAL SKILLS:

Databases:: SQL Server 2014, 2012, 2008R2, 2005, 2000, MS Access, MySQL and Oracle, Sybase.

SQL Server Tools:: SQL Server Management Studio (SSMS), Enterprise Manager, Business Intelligence Development Studio ( Confidential ), Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, BCP, SQLCMD, Upgrade Advisor, SQL Configuration Manager, Client and Server Network Utilities, Surface Area Configuration.

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Reports Development/Management:: Report Development, deploy, manage, migrate, and upgrade reports and Report Server. Strong expertise on configuring and managing Report Server such as SQL Server Reporting Service (SSRS), developing report using Confidential (Business Intelligence Development Studio), SSDT (SQL Server Data Tools), and Report Builder, using Microsoft Access and Microsoft Excel to map with SQL Server for data manipulation and Data Analysis

Data Modelling:: Toad Data Modeller, ERWin, SSDD (SQL Server Database Diagram.)

Programming:: SQL, T-SQL, Scripting, debugging, improved performance stored procedures, Functions, Triggers

SSIS/DTS:: DTS, SSIS Package create, manage, deploy, upgrade and migrate packages

Performance Tuning: Server Optimization and Performance Tuning, Query Optimization, Experience in resolving Dead Locks or long running queries. Experienced in using different Tools - Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Windows Performance Monitor, SpotLite, Idera SQL Diagnostic

Database High Availability:: Strong knowledge and experience in configuring and administering High Availability Database Solutions like Database Mirroring, AlwaysOn, Replication, Log shipping, Cluster Database

Windows Server and Active Directory:: Experience in administering Windows Server 2012, 2008 R2, 2003 R2, AD (Active Directory), Domain, monitoring user activities, VMware

Large Database/VLDB: Proven ability to handle Database of more than 3 TB in Size

Best practice: Knowledge of Microsoft Best Practices with regards to Server Configuration and Administration

Security: Experience with Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption)

Upgrade/Migrate: Migrated Oracle, MySQL, Sybase to SQL Server and Upgraded databases from MS SQL Server 7.0, 2000, 2005, 2008 R2 to higher version

Application Server: Administered IIS application server, deployed applications

Service Pack: Applied Service Pack (SP) and hot fixes for Databases and Operating Systems

Documentation: CHM, HTML, DOC, DOCX and PDF format

Third Party Tools: Idera, SpotLite, Erwin, Visio, Toad Data Modeller, and Toad for SQL Server Admin

Web Technologies: SQL, T-SQL, PL/SQL,XML, HTML, VBScript, ASP, .Net Technologies: VB. NET, ASP.NET

Development Tools: Visual Studio (VB), Visual Studio2010/2012, Confidential, SSDT

Networking:: Active Directory, TCP/IP, Network Switches, Network Hubs, Network Printer.

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server DBA

Responsibilities:

• Installed, Configured SQL Server 2008 R2, 2012, 2014, 2016 in Development, Test, UAT, and Production environment
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Strong hands-on experience Migrate Data and Database into Microsoft Azure cloud Platform, Azure SQL Database and SQL Server on Azure Virtual Machine.
• Used Native Tools, Query Analyzer, Execution Plan, Live Query Statistics, Query Store, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, Resource Monitor and Activity Monitor for monitoring, tuning, and troubleshooting purpose
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Used DMVs and DMFs to monitor the health of a server instance, diagnose problems, and performance tune
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions, declaring Cursors and variables, CTEs
• Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Have used TFS to deploy script in different environments( prod/test/dev)
• Migrate/Upgraded SQL server instances from SQL Server 2005/20, 2014/2016
• Managed Security of SQL Servers and Databases Logins, Users, Granting/ deny/ revoke access and Database Encryption/Decryption
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space management and backup verification etc.
• Optimized and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Worked with BI Team to deploy SSIS Package in different environment on daily basis
• Involved in report migration from Dev to Test/Prod and adding Data source/ managing security of report and create data driven subscription
• Fine Tune and improve Database Performance using SQL Server Profiler, Execution Plan, DMV, DBCC, indexes, Activity Monitor
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2012 with Synchronous automatic-failover mode
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Developed, maintained and implemented database backup and recovery plans for Production, Test and Development environments including mission critical databases
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Imp

Environment: Windows Server 2012 R2, 2008 R2, IIS, SQL Server 2014, 2012, 2008 R2, and Application in JavaScript, ASP and ASP.net, J2EE, SSIS, SSRS. Service-Now, TFS, SharePoint, DBartisan, SQL SentryOne, Oracle, ETL Processing

Confidential, Michigan IL

MS SQL Server

Responsibilities:

• SQL/TSQL/ Database Programming:
• Created stored procedures, functions, Queries, views and other database objects.
• Executed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• ETL/SSIS: (SQL Server Integration Service)
• Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat File to MS SQL Server by using SSIS services.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• SSRS (SQL Server Reporting Service):
• Installed, Configured, and administered SQL Server Reporting Services.
• Developed and Deployed Reports using SSRS.
• Developed periodic SSRS reports in Confidential used to generate daily, weekly, monthly and quarterly reports.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Installed, Configured, Managed and applied Service Pack to SQL Server 2014 and 2012, 2008R2 in development, test and production environment.
• Backup/Recovery:
• Performed different daily routine backup jobs by using maintenance plan.
• Carried Out manual and automation schedule backup job.
• Performed tail log backup for a point in time recovery based on the disaster recovery.
• Restore Database from backup file Server to production.
• Database Upgraded/Migrated (development, testing, and production environment)
• Created documentations for an upgrade and migrate databases.
• Solid hands-on skills in migrating/upgrading SQL Server /2008R2&SQL Server 2005, 2008/2008R2 to 2012 and 2014 and applying service packs.
• Database Monitoring/Performance Tuning:
• Monitoring Server and databases Performance tuning (Disks space, lock, and block, query running slow).
• Schedule jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.
• Monitor SQL Temp DB, Server Error Log, and Usage space.
• High Availability:
• Configured and Maintained AlwaysOn in 2012 on Virtual machine.
• Configured Manage and maintain Transactional Replication.
• Managed and maintained two NODE active-passive clusters.
• INDEX:
• Created, modify tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views, Developed different Maintenance Plans for database monitoring.
• DMV command to check database conditions, Rebuilding indexes and other database Maintenance purposes.
• Performed database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
• OTHERS:
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Applied SP (Service Pack) on SQL Server 2008 (SP4), 2012(SP3).
• Created Trace file using SQL Profiler then review it for further steps.
• Tune queries which are running slow using Perfmon, Profiler, and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Worked with Windows team to failover the cluster when needed after Windows patching.
• Created jobs, Scheduling Jobs, Alerts using SQL Server agent and handle error logs for troubleshoots.
• Performed partition for efficient management of database tables.
• Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server Profiler .

Environment: SQL Server2014, 2012,2008R2, Windows Server 2012, 2008 R2 64 bit, SQL Profiler, PerfMon, Execution Plan, Activity Monitor, ASP.NET, HTML, SSIS, T-SQL, SQL Agent