CAREER OBJECTIVE:

An experienced SQL Server DBA with detail - oriented, analytical and troubleshooting skills, having more than 6 years of professional experience in different Microsoft products as a SQL Server DBA. Skilled in SQL Server Database administration on Production, Test, Development environments and have extensive experience in SQL Server 2017/ 2016/2014/2012/2008 R 2/2008/2005. My expertise involves in installation, database and server settings, backup/recovery, DR/HA, upgrade/migrate, database design, optimization, performance tuning, security management including data encryption/decryption, SSAS, ETL, SSIS, and SSRS. Ability to identify root causes of server and database issues to troubleshoot and resolve promptly. I am self-motivated and initiator professional looking for a challenging position with a prospective and growing company to utilize my professional experience and knowledge.

SUMMARY:

• Strong working experience as a Database Administrator in SQL Server 2016/2014/2012/2008 R2/2008/2005 in Production, Development, and Test (Clustered, Stand Alone, VM and Azure ) Environments
• Skilled automating SQL Server deployment, configuration and administrative tasks with PowerShell
• Worked in Hybrid Cloud Environment with Azure SQL Database(PaaS), and Azure VM (IaaS)
• Worked with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
• Proven experience in the areas of Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log
• Extensive work experience in Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the problem as needed
• Have solid experience in SQL Server High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and AlwaysOn
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Expertise in RDBMS concepts and constructs. Working with data modeler on Logical and Physical data modeling using ERwin and native tools
• Proficient in writing T-SQL batches and developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL joins, Views, Cursors, table variables, sub-queries
• Strong skills in reporting using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Excellent in High-Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Union working Experience and the good understanding of SSAS, OLAP cube and Architecture
• Hands on experience in upgrade/ migrate from SQL Server 2005/2008R2 to SQL Server 2012/2014/2016
• Good experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2
• Extensive knowledge of creating, supporting and maintaining database administration scripts
• Expertise in implementing SQL Server security, Managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices
• Extensive work experience in TempDB configuration, Table partitioning, shrinking, Link server, compression, and database optimization
• Good experience with the phases Software Development Life Cycle SDLC such as requirement gathering & analysis, design, development, testing, implementation & maintenance in the Client/Server
• Experience in TFS-Production Control, Production Support, and Upload & Check-in Documents, manage and update weekly/monthly release version
• Experience in supporting Very Large Databases (VLDB) and troubleshooting the problems.
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload
• Performed Production support in 24/7 and on Call duties

TECHNICAL SKILLS:

Database: SQL Server2016, 2014, 2012, 2008r2, 2008, 2005, MS Access 2007& 2003

Database Migration: From SQL Server/Oracle/MySQL/MS Access to SQL Server

Operating System: Windows Server 2012R2, 2008, 2003R2, VMware

Languages: SQL, T-SQL, XML, ASP, ASP.net

ETL/Data Warehouse: SSIS/DTS, SSDT, BCP, SSAS

Reporting: SSRS, Report Builder, Crystal Report

Third Party Tools: ERWin, OpNet, RedGate, SQL Sentry, DBArtisan, Precise, BMC Control-M, Idera

Networking: DNS, TCP/IP, LAN, HTTP

Hardware/Storage: SAN, RAID, ISCSI, Active Directory

Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL ProfilerExecution Plan, Activity Monitor, DBCC, DMV, BIDS/DTS, Job Activity MonitorQuery Analyzer, Database Tuning Advisor, Built-in-Standard Reports.

PROFESSIONAL EXPERIENCES:

Confidential, District of Columbia

SQL Server DBA

Responsibilities:

• Installed, Configured SQL Server 2017/2016 in Development, QA, and Production in On-Premise and Azure Cloud
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Automated different day to day tasks for Indexes maintenance, statistics, database integrity, database consistency, backups, restores using Ola-Hallengren script
• Automate audit process in Azure SQL DB in multiples server using PowerShell script
• Execute the Power Shell script for day to day activity like maintenance task automation, backup, restore, export/import, and connectivity
• Configured, administered and troubleshooting SQL Server Reporting Services (SSRS) and Reports development, deployment, distribution and reports subscriptions
• Perform in-place upgrade for SSRS from 2012 to 2016 and activated Inactive SQL Server reporting service instances
• Configured, managed and troubleshoot AlwaysOn Availability Group on top of active and passive failover cluster On-Premise to Azure VM
• Configured, managed, and troubleshoot Transactional Replication with FCI on premise to Azure availability failover group DB
• Setup, configured and maintained linked Server from On-Premise to azure VM (Iaas), and Azure SQL DB for different purpose like maintenance jobs
• Managed Security and User Privileges Granting/ deny/ revoke access Server and Database level in On-Premise and azure database security
• Worked with Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, Perf-Mon, and Activity Monitor, Sentry-One, database performance analyzer for monitoring, tuning, and troubleshooting purpose
• Monitored Server health and Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Optimized the databases by creating various clustered, non-clustered indexes and indexed views
• Have utilized DBCC and DMVs to monitor server health, diagnose problems, and tuning performance
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions, declaring Cursors and variables, CTEs
• Export & Import data from the Flat file (CSV, Excel) to SQL Server Database using EXP/Imp
• Have working Experienced in a virtualized environment On Premise and Azure
• Provided 7 x 24 Production support for the database and application issues

Work Environment: Windows Server 2012r2, 2008, IIS 8.5, SQL Server, 2016, 2014, 2012, AD, JavaScript, ASP.net, sentry-One, DPA(SolarWind), PowerShell, Azure IaaS/PaaS/SaaS, SharePoint, Service-Now, Slack

Confidential, Mahwah, NJ

SQL Server DBA/Database Analyst

Responsibilities:

• Worked with Confidential ’s SQL Team where my primary focused on performance tuning, troubleshooting and in-depth root cause analysis (RCA) for database related issues
• Installed, Configured SQL Server 2014, 2016 in Development, Test, 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
• 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, Backup and Restore, jobs
• Assisted Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Experienced in implementing operational automation using Power Shell
• Have used TFS to deploy script in different environments (prod/test/dev)
• Managed Security and User Privileges Granting/ deny/ revoke access Server and Database level
• Analyzed Failed Jobs and Provide resolutions including backup, monitoring database health, disk space management and backup verification etc.
• Worked with BI Team to deploy SSIS Package in the different environment on a daily basis
• Performed report migration from Dev to Test/Prod and adding Data source/ managing the 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, extended event and system SP
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2016/2014/ with different data center
• Maintain and troubleshooting different types of Replication Models such as Transactional and Mirroring
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the problem as needed
• Performed on call Production support for databases and application issues

Work Environment: Windows Server 2012r2, 2008, IIS 8.5, SQL Server, 2016, 2014, 2012, 2008r2, 2008, 2005, AD, JavaScript, In-house Application, SQL Fog-light, Power Shell, TFS, SharePoint, Oracle, and DB2

Confidential, Honolulu, HI

SQL Server Database Administrator

Responsibilities:

• Installed and Maintained SQL Server 2014, 2012, 2008, 2005on Prod/Test/Dev environments
• Upgraded/Migrated SQL Server 2005 and 2008 instances and databases to 2012/2014
• Transferred Logins using SSIS package, Data and Log files, backup files, and Jobs for side-by-side Upgrade/Migrate
• Worked on database refreshes from production to staging and on-demand refreshes from production to Dev/Test environments, involving SQL versions 2005, 2008, 2012, 2014
• Configured and Maintained of SQL Server high availability and Disaster Recovery solutions (Mirroring, Replication, and AlwaysOn)
• Created and maintained logins, users and manage security tasks like granting and revoking permissions for server, database and database objects
• Proactively monitored the production database(s) and optimize slow running query/stored procedures for better performance. Resolved lock/block/deadlock conflicts and resource utilization
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, index and fragmentation
• Executed Change management scripts on daily/weekly/monthly basis

Work Environment: Windows Server 2012, 2008, IIS 7.5, SQL Server, 2016, 2014, 2012, 2008r2, 2008