SUMMARY

• SQL Server Database Administrator/Developer having more than 6 years’ experience. supporting installation, configuration of MS SQL Server 2017, 2016, 2014, 2012, 2008 R2 in Production, UAT and Development Environments.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Backup and Disaster Recovery, Solid experience in SQL Server high availability solutions, including Log shipping, Mirroring, Always - On Availability Groups, SQL Clustering.
• Proficient in SQL/T-SQL, indexes, stored procedures, triggers and functions. Proven ability to identify root cause of database issues with expertise to troubleshoot and resolve issues promptly.
• Hold exclusive knowledge of database security including data encryption and decryption. Supporting also BI application team including SSIS and SSRS. Working knowledge of SQL server upgrades and migrate using various versions and editions.
• Expertise in using SQL Server tools as well as third party tools efficiently like ERWin, Toad Data Modeler, Idera, SQL Diagnostic manager, ServiceNow, NetBackup and SolarWinds.
• Over 6 years of working experience as a Database Administrator in MS SQL Server (2017/2016/2012/ 2008 R2/2005) in Prod, Dev and Test (Clustered, Stand Alone, and VM Servers) Environments
• Solid professional work experience in MS SQL Server installation, configuration, administration, and maintenance with effective monitoring and troubleshooting capabilities
• Experienced in upgrading SQL Server to SQL Server and migrating (instances and databases) from SQL Server, Oracle, MySQL to SQL Server
• Hands on experience in implementing, configuring, monitoring, and administering High Availability Solutions- SQL Server Fail-Over Clustering, AlwaysOn, Log shipping, Mirroring, and Replication
• Proven experience in monitoring, troubleshooting, optimizing, and tuning lock, block, deadlock, index fragmentation, slow running queries, etc. using native and third-party tools
• Extensive work experience in TempDB configuration, partitioning, shrinking, compression, and database optimization
• 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 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
• Good experience in configuring Database mail and automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent
• Extensive knowledge of Normalization and Relational Database Management Systems
• Expertise in need assessment, logical/physical database design, reverse/forward engineering using ERwin and native tools
• Experienced 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
• Strong Skills in ETL operations using SSDT/BIDS, SSIS, BCP, Import/Export Wizard
• Great working knowledge in configuring and managing SSRS, developing and deploying reports using SSRS and Report Builder 3.0/2.0
• Extensive work experience in Linked servers, applying latest Service Packs, patches, and hotfixes
• Having excellent experience in SQL Server and Database Architectures
• Providing 24X7 production On-Call support on a rotational basis
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments
• Having excellent verbal, written and presentation skills, Independent problem solving, team player, proactive, multi-tasking, task prioritizing, detail oriented and excellent interpersonal skills

TECHNICAL SKILLS

Operating Systems: Windows Server 2016, 2012, R2, 2008.

Virtualization: VMWare, and VSphere. Managed Database Servers and Databases in Virtual Environment

Database: MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2005, Azure SQL Database.

SQL Server Tools: SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler, BIDS/Data Tools, Database Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC, Index Tuning Advisor

Data Modeling Tools: ERWin, Toad Data Modeler

Reporting Tools: SSRS, Report Builder

Data Migration: SSIS, Backup/Recovery, Detach/Attach, Import/Export Tool

ETL: SSIS, DTS

Hardware/Storage: SAN, RAID

Third Party Tools: ERWin, Toad Data Modeler, SolarWinds, OpNet, Idera, SQL Diagnostic manager, NetBackup, Redgate

PROFESSIONAL EXPERIENCE

Confidential, Long Island City, NY

Senior Database Administrator/ Developer

Responsibilities:

• Worked as Production Support DBA to Supports day to day operational activities for the database platform like health checks, Implementation and Deployment, DDL & DML operation, managing Security for server and Database level, application developers, business analysts and users overseeing SQL Server 2012 to 2017/2016 on a very large scale Dealing with service requests tickets, C-Task, Incidents through Service-Now.
• Planning Capacity management, DB indexes maintenance, DB security, license usage, DB consistency, DB integrity checks and DB Backup and Recovery.
• Installed, Configured, and Maintained SQL Server 2017, 2016, 2014 and 2012 in Development, Test, UAT and Production Environment.
• Change Ticket, C-Task, Incident ticket, Technical Request Ticket, End user requests and automation of processes.
• Decommission Instance and Databases then update server & Database inventory portal, and raise different Tickets like as Technical request ticket, Task ticket, incident ticket, change ticket, CTask, DR ticket, Firewall ticket then Assign task to Group-wise using ServiceNow Ticketing System.
• Leadership working experience Data Migration projects from lower version to higher version of different SQL Products, 2008, 2012, 2014, 2016, 2017, change SQL version enterprise to standard and vice versa to minimize company cost, Always on High availability groups, database mirroring, Clustering, Replication, Server & Database credential, Backup and recovery, managing Storage and assigning Tickets, weekly team meeting, project update and deal with clients.
• Implement storage/Disk management strategies, Table Partition in order to archive data in database Warehouse, SAN, NAS and RAID Technology.
• Designing and hardening SQL Server Security (Server hardening, Auditing, SOX compliance and user/group access monitoring).
• Working with Application development team and QA to refresh their development and UAT databases.
• Effectively interface between the business and technology teams in order to ensure business objectives are met and communicated to senior management.
• 24x7 “on-call" Production support rotations.

Environment: MS SQL Server 2017, 2016,2014, 2012/2008 R2, Windows Server2016, 2012, 2008 R2, 2003 Enterprise Edition, SolarWinds, NetBackup, ServiceNow, ERWin, Splunk, SSIS, SSRS, BIDS, IIS 7.5, 8.5, Oracle SQL, Teradata, Big Data.

Confidential, Fairfax, VA

SQL Database Administrator

Responsibilities:

• Installed, Configured and maintain SQL Server 2005, 2008 R2, 2012, 2014, 2016 (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, 2016 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
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.
• 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
• Monitored Server Activity, Error Log, space usage and the solving problem as needed
• Rebuilding the indexes at regular intervals for better performance.
• Installed, configured and deployed SSRS reports from BIDs/SSDT. Provided access to SSRS reports.
• 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
• 24x7 “on-call" Production support rotations.

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