SUMMARY

• Career Objective: An experienced SQL Server DBA wif detail - oriented, analytical and troubleshooting skill, having more TEMPthan 8 years of professional experience in different Microsoft products as a SQL Server DBA. Skilled in SQL Server Database administration on Production, Test, Development environment and using SQL Server database 2016/2014/2012/2008R2/2008/2005 and Operating System.
• My expertise entails in database optimization, installation, backup/recovery, DR/HA, upgrade/migrate, database design, 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.
• me am self-motivated and initiator professional looking for a challenging position wif a prospective and growing company to utilize my professional experience and knowledge.
• Strong working experience as a Database Administrator in SQL Server 2016/2014/2012/2008R2/2008/2005 in Production, Development, and Test (Clustered, Stand Alone, and VM Servers) Environments
• Worked wif 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
• Has solid experience in SQL Server High Availabilityand 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 wif RTO and RPO guidelines
• Expertise in RDBMS concepts and constructs. Working wif 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 SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided bySSISsuch asData Conversion,Conditional Split,Bulk Insert,Union
• working Experience and the good understanding ofSSAS, 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 wif Microsoft and industry best practices
• Extensive work experience in TempDB configuration, partitioning, shrinking, Link server, compression, and database optimization
• Has working knowledge of Azure SQL Database(PaaS), SQL Server on Azure VM (IaaS)
• 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

TOOLS AND 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, Cristal 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, Mahwah, NJ

SQL Server DBA/Database Analyst

Responsibilities

• Currently working for the UPS’s SQL Team where my primary focus 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
• Has used dbatools for PowerShell Module to perform database administrative tasks
• Responsible for implementing different types of Replication Models such as Transactional and Merge
• Worked on Database refresh in Dev/Test servers wif 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, me/O, Memory bottlenecks, Backup and Restore, jobs
• Assisted Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• 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.
• Working wif 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
• Optimized the databases by creating various clustered, non-clustered indexes and indexed views
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2016/2014/ wif Synchronous and Asynchronous automatic-failover mode
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the 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 the Flat file (CSV, Excel) to SQL Server Database using EXP/Imp
• 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, 2008r2, 2008, 2005, AD, JavaScript, ASP.net, In-house Application, SQL Fog-light, TFS, SharePoint, Oracle, and DB2

Confidential, Honolulu, HI

SQL Server Database Administrator

Responsibilities

• 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 availabilityand 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
• Used DBCC commands to manage database consistency and repair as needed
• Used DMVs and DMFs to monitor health of SQL instance, diagnose problems, and tune performance
• 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
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the problem as needed
• Responsible for Database support, troubleshooting, planning and migration, Resource planning and coordination for application migrations wif project managers, application and web app teams
• 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, 2005, AD, JavaScript, ASP.net. Service-Now, BMC Control-M, TFS, SQL SentryOne, RedGate, Oracle, and DB2

Confidential, Suitland, MD

MS SQL Server DBA

Responsibilities

• Installed, Configured and maintain SQL Server 2005, 2008 R2, 2012, 2014 (Clustered/Standalone and VM )in Development, Test, and Production environment
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Upgraded/Migrated SQL Server 2005/2008 to SQL Server /2012/2014 and Transferred Logins, Data and Log files, backup files, and Jobs for side-by-side Upgrade/Migrate
• Data Encryption and Data Decryption for data security in Database & Column level
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security
• Configured, Monitored and troubleshoot Log Shipping/ Replication (Transactional, Merge)
• Configured and Maintained SQL Server 2012 Fail-Over Clustering and Always-On Availability group
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification
• Monitored Server Activity, Error Log, space usage and the solving problem as needed
• Rebuilding the indexes at regular intervals for better performance.
• Designed and created databases, tables, views, store procedures, function and indexes
• Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Installed, configured and deployed SSRS reports from BIDs/SSDT. Provided access to SSRS reports.
• Implement and manage Database Backup and Disaster Recovery procedure

Work Environment: SQL Server 2005, 2008R2, 2012, 2014, IIS 7.5 Windows Server, 2003R2, 2008, 2012, ASP, ASP.net, Java, AD, PeopleSoft Application, Oracle, My SQL, Service-Now, OpNet, and SQL SentryOne

Confidential, Washington, DC

MS SQL SERVER DBA

Responsibilities

• Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member wif other DBA\'s to ensure 24 hour x 7 day a week support of all corporate databases.
• Provide support to application developers in designing and implementing physical database structures
• Installed, configured, maintain and monitored troubleshoots SQL Server Fail Over- Clustering
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes
• Securing SQL Serversand Databases, Manage users, Data encryption, granting/ revoking access
• Has worked in database Performance tuning SQL profiler, Execution Plan, Database Tuning Advisor, Activity Monitor, Performance Monitor
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Used T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
• Manage and resolve trouble tickets (Remedy) for database-related issues submitted by customers

Work Environment: SQL Server 2005, 2008, 2008R2, 2012 IIS Server 6.5, 7.5, Windows Server 2003R2, 2008, 2012, ASP.net, Java, ETL and AD (Active Directory), Expand-IT, Track-IT, and RedGate

Confidential, Warren, NJ

SQL Server Database Administrator

Responsibilities

• Maintained and administered SQL Server 2000, 2005, 2008 and 2008 R2 in all environments
• Installed and configured SQL Servers 2005, 2008 and 2008-R2 in test and production environment
• Working knowledge wif Active Directory and Windows Server (2003-R2 & 2008)
• Managed database Mirroring and Replication
• Worked wif SQL, T-SQL, Stored-Procedures and triggers
• Assisted SQL developers to optimize SQL queries, Indexes and Stored Procedures
• Performed database monitoring and performance tuning, index and statistics management
• Monitored Servers activity and worked wif clients to solve different problems
• Managed SQL Server error Logs, space usage, growth pattern
• Managed bottleneck, block and lock
• Created backup jobs for different types of backup like FULL, Differential and Transaction Log
• Created maintenance plan for various jobs including index fragmentation, index rebuild and DB-statistics
• Worked on Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database
• Created and managed Index (Cluster/Non-Cluster) and Constraints
• Created and managed users, roles, security at object, Database and server level
• Work experience and strong knowledge in Log Shipping and Replication as disaster recovery
• Installed, configured, and developed reports using SQL Server Reporting Services (SSRS)
• Utilizing the SQL Server’s best practices to implement maintenance plans and regular maintenance tasks

Work Environment: SSIS, SSRS, MS SQL Server 2008/2005/2000, C#, Visual Studio 2008, MS Access, MS Excel, MS Office Access 2007, IIS 6.5, Service-Now, and SharePoint Server