PROFESSIONAL SUMMARY:

• Microsoft certified SQL Server Database Administrator with more than 5 years of professional experience in developing, administering and maintaining SQL Servers 2005, 2008/R2, 2012, 2014 & 2016.
• Have expertise in troubleshooting, designing databases, HA & DR solutions, developing reports and ETL using SSIS packages, migration and upgrading databases, proactive monitoring, performance tuning, SQL/T - SQL queries and handling complex issues.
• Have in depth understanding of the business analysis with proven ability to deliver high quality products and services on a schedule.
• Self-motivated, team player with excellent verbal and written communication skills. Seeking for a position with a prospective company to utilize and expand my professional and technical skills and experience.
• Have solid professional knowledge and experience on Advanced Installation and Configuration, Monitoring and Health Check, Reporting, and Maintenance with troubleshooting capabilities.
• Have Strong working experience as a Database Administrator in MS SQL Server (2016/2014/2012/ 2008 R2/ 2008/ 2005) in Prod, Dev and Test (Clustered and Stand Alone) Environments.
• Extensive work experience in TempDB configuration, partitioning, shrinking, compression, and database optimization.
• Extensive work experience in applying latest Service Packs, patches, and hotfixes.
• Performed automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent.
• Conducted Performance Tuning, Monitoring Server & database health check, disk space Utilization, troubleshooting, optimizing, and tuning lock, block, deadlock, index fragmentation.
• Implemented SQL Server security, Managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices.
• Implemented Transparent Data Encryption (TDE) on Databases and Column level and Decryption.
• Managed Server, Database, Object, Role, and Schema Level Permission group service accounts.
• Hands on experience in Configuring, monitoring, and administering ‘Always On’ on SQL Server 2012/2014/2016
• Having strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, and Point-in-Time Recovery in accordance with RTO and RPO guidelines.
• Hands on experience in configuring and managing SSRS, developing and deploying reports.
• Hands on experience in Installation, Configuration, and administration of SQL Server Integration Services (SSIS)
• Performed ETL Operations, Batch Process, and Export/Import data from Excel File, Flat file, CSV file to/from SQL Server Database using DTS, BIDS, and SSDT.
• Experienced in upgrading SQL Server (2005/2008/2008 R2) instances to SQL Server 2012/2014/2016
• Hands on experience for migration of Database from MySQL 5.5.1 to SQL Server 2012/2014
• Export & Import data from My-SQL and Access databases to SQL Server and Vice Versa.
• Knowledgeable on 64/32 bit SQL Servers and Windows Server Systems.
• Proficient in writing T-SQL batches and developing Indexes, Stored Procedures, User Defined Functions, Triggers, SQL joins, Views, table variables, sub-queries.
• Have Basic knowledge on PHP, DHTML/HTML.
• Have wide knowledge and experience in Database Design and Development, and Data Modeling.
• Good knowledge and working experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2 including Active Directory Domain Services.
• Worked with team foundation server (TFS) Cloud/Azure.

SKILLS:

• Database Administration and Management
• Security and Encryption
• Performance Tuning and Database Health
• Disaster Recovery
• Reporting Tool
• ETL Tools
• Database Migration
• Database Design and Data Modeling
• T-SQL and Programming

TECHNICAL SKILLS:

Database Management System: SQL Server 2016/2014/2012/2008 R2, MySQL, MS Access 2007, 2003

Database Design & Data Modeling: Normalization, Erwin, SSDD (SQL Server Database Diagram)

Operating System & VMware: Windows Server 2016/ 2012 R2/2008 R2/2003 R2.

Languages: SQL, T-SQL, HTML, PHP

ETL Tools: SSDT/BIDS, SSIS/DTS, BCP, Import/Export Wizard

Reporting: SSRS (SQL Server Reporting Services), Report Builder (3.0,2.0)

Upgrade/Migrate: SQL Server to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server, SSMA

Third-Party Tools: SQL Sentry, Idera, Red Gate, ERWin, ServiceNow, Remedy.

Native tools: Activity Monitor, Performance Monitor, Extended Events, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Job Activity Monitor, Built-in Standard Reports, BIDS/DTS, DMVs & DMFs, DBCC, SQL Server Configuration Manager, Live Query Statistics, Query Store, SSMA

Networking: Active Directory, TCP/IP, DNS, WAN, LAN, HTTP/ HTTPS

Version Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential, NY

Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014 on Prod/Test/Dev environments
• Upgraded SQL Server 2005 and 2008 instances and databases to 2014/2016
• Migrated SQL Server databases to MySQL 5.1.23/5.5.6 databases to SQL Server 2012/2014
• Migrated SSIS packages from SQL Server 2008 R2 to 2014/2016
• Deploy Changes/SPs/Queries in Production Environment
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2012 with Synchronous Commit automatic-failover mode
• Applied SP (Service Pack) and patching on SQL Server 2012,2014 on a routine basis
• Worked on Database refresh in Dev/Test servers with Prod data and reinstate the server
• Configured, managed, and monitored Transactional Replication and Log Shipping
• Implemented SQL Server security, creating and managing users, granting/revoking access
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procs
• 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
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Performed regular backups, restores and automated different day to day tasks
• Installed, Configured, and administered SQL Server Reporting Services (SSRS) and Reports development, deployment, distribution and reports subscriptions.
• Developed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server 2014/2012.
• Worked with team foundation server (TFS) Cloud/Azure.

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Installed, configured, and managed SQL Server 2012 and 2014
• Upgrade SQL Server 2008 R2 database SQL Server 2012 and 2014
• Implemented Data Masking for Dev, UAT & Production environment
• Set up Jobs and Maintenance plan.
• Perform Database/Technical Refresh and Implement Data Masking for Dev Environment
• Implement Transparent Data Encryption (TDE), Dynamic Data Masking
• Applied SP/ HOT Fixes (Service Pack) on SQL Server
• Trouble Shoot performance issues related to query optimization, tempdb, and log file growing fast, identify and release Lock, block and deadlock.
• Used DMVs and DMFs to Diagnose Server Health and Improve Performance
• Developed Stored Procedure, Trigger, Views using SQL and T-SQL.
• Configured and Maintained Database Mirroring using Automatic Fail-Over options in SQL Server 2012 / 2008 R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Implemented Transactional Replication
• Created SQL Server migration analysis report that will publish the cost and time requirements for Migration using SSIS and SSRS