OBJECTIVE

• To be involved in work where I can utilize my skill and creatively involved with system that effectively contributes to the growth of organization

SUMMARY

• About 10 years of experience as a SQL Server DBA with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server and Operating Systems.
• Depth knowledge and experience in data modeling including gathering and analyzing business requirement.
• Solid working experience in managing large databases in 24/7 data processing environment including backup/recovery, performance tuning, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Strong knowledge in using database third party tools (lite speed, DDBoost, BPPM Patrol, Avamar backup, Jira, myIT Service now, HP Service Manager, HP Asset Manager etc.)
• Manual & auto Installation, Configuration, Upgrade, Migrade and patch management of SQL server 2008, 2008R2, 2012 and 2014, 2016 & 2017
• Developed, implemented, and managed backup/restore and business continuity plans including very large database of 19TB.
• Strong working experience with SQL Server HA/DR using Failover Cluster, Alwayson High Availability, Replication, Database Mirroring and Log Shipping configuration, administration and troubleshooting.
• SQL Monitoring, Tuning & Optimization, failed job, disk space, incidents etc.
• Analyzing and resolving blocking, deadlock & long running queries.
• Implementation of SQL Principle, Securable, Permission, Roles and authentication as a part of Security policies.
• Expert knowledge on SQL Dump file, Error log, Event Viewer, Profiler and Extended Event to easily find and troubleshoot various SQL issues.
• Expert knowledge on SQL server & database architecture such as data file, log file, tempdb, VLF, COP, MAXDOP, Index, Statistics, wait type, blocking, deadlock, Isolation, Concurrency, Execution plan, CPU, Memory, DMV etc.
• Worked with various teams regarding application & database development, testing and deployment in dev, test, cert and prod environment.
• Ensured solutions are designed to scale and grow over time as data volume grows and user requirements evolve.
• Wrote & reviewed T - SQL code, stored procedures, function, views and Trigger.
• Working knowledge on capacity planning for database migration
• Working knowledge on SSRS concept and report design
• Working knowledge on SSIS package development, deployment and troubleshooting

TECHNICAL SKILLS

Database: SQL Server 2017/2016/2014/ 2012/2008 R2/2008/2005

SSIS & SSRS: SSIS & SSRS using BIDS, Data Tools & Visual Studio

Operating System: Windows Server 2016/2012/2008 r2/ 2008/2003/ MS-DOS, VMware and Linux

Hardware/Storage: RAID, SAN and NAS and Troubleshooting any Hardware and Software related Issues.

Tuning: Performance Tuning with native tool and third-party tools.

DR/HA Solutions: Configuration, Troubleshooting and Administer Mirroring, Log Shipping, replication, Clustering and Always-On-Availability

Development: T-SQL programming, Windows PowerShell and SQLCMD

Cloud: Azure SQL - Iaas/Pass

Tools: /software: Service now, SharePoint site, HP service manager, Asset manager, BPPM Patrol, Avamar backup, CA-PAM, TFS, Power Keeper, Jira, Git Lab

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD.

SQL DBA, banking officer

Responsibilities:

• Installed, configured, upgraded & migrated of SQL server 2017, 2016, 2014 2012, 2008r2, 2008 & 2005.
• Acted as a database administrator in the full development lifecycle including analysis, design, development, testing, implementation, and maintenance of database solutions to ensure the smooth flow of data across the internal business system database.
• Worked closely with the IT project manager, solution architect, business analyst, and technical development team to ensure the integrity of the solution delivery while managing the expectations of the business user community
• Maintained security and integrity of data access policies, standards, and methods by establishing database recovery plans to minimize data losses and system downtime.
• Analyzed, configured and implemented best practice recommendations for performance tuning and optimization.
• Configured & managed/troubleshoot database Mirroring, Log shipping, SQL Cluster, AlwaysOn and Replication.
• Day to day database support including fixing failed jobs, disk space issues, finding root cause, resolving incidents, backup, restore, granting access etc.
• Extensively worked on blocking, deadlock, Index, Statistics, execution plan, wait type, Isolation, SQL Profiler, Extended Event, DMVs etc. to analyze and optimize queries for very large databases.
• Automated to reduce manual administrative tasks through use of PowerShell & T-SQL.
• Created, deployed, migrated and managed SSIS package
• Created various reports using SSRS Report Builder
• Managed/deployed change request (CR) in production environment
• Wrote T-SQL code, Stored procedure, Function, Views & Trigger.
• Created and maintained scripts and documentation for all aspects of administration’s repeatable process including SQL installation, configuaration, database design, implementation, encryption, disaster recovery and common problem resolution .
• Supporting 24x7 onshore and offshore model for over 2000 SQL servers.
• Automated report regarding database backup, drive space, CPU, memory and disk I/O, server health check, Log Shipping out of sync, Mirroring failed over etc.
• SQL installation and configuration over 800 servers
• Database backup standard for all SQL servers
• Securing database servers

Confidential

SQL Server DBA

Responsibilities:

• Installation, Configuration, Upgrade, Migrade and patch management of SQL 2005, 2008, 2008r2 & 2012
• Installed, Configured and Maintained Mirroring, Log Shipping, Replication & Fail-Over Clustering.
• Administered SQL Server security by creating user, roles, granting privileges, Changing SQL services accounts, removing privileges for NT account etc.
• Performed daily database tasks including backup, restore, refresh, failed job, resolving tickets, deployment, Change request, Work Order etc.
• Developed & automated routine tasks for backup, restore, server & database health check, failover, out of synch monitoring etc.
• Standardized Database maintenance plan and disaster recovery.
• Monitored, tuned, troubleshoote long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks, query time out etc.
• Writing T-SQL, Stored-Procedures, Function, Trigger & views
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Used PowerShell and SQLCMD commands.
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS.
• Installed, authored, and managed reports using SQL Server Reporting Services.
• Followed and maintained in-house documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution

Confidential

Database Administrator

Responsibilities:

• Installed and Configured and administered SQL 2005/2008/2008 r2/2012
• Windows and SQL patch management.
• Day to day database support including fixing failed jobs, disk space issues, finding root cause, resolving incidents, backup, restore, granting access etc. server and database health check etc.
• Scheduled jobs to automate different database related activities including backup, monitoring server health, disk space, backup verification.
• Used PowerShell for manage file system, services, processes, Registry etc.
• Provided status reports such as backup, CPU, Memory, disk space etc. as requested by management.
• Assisted in the development and documentation of database procedures, standards, best practices and change management processes.
• Recommended the procurement of new memory, CPUs and servers when necessary.
• Monitor database backups, schedule jobs, performance, capacities (space, memory), error logs, event logs, and general activity on the database servers.
• Implemented Transparent Data Encryption (TDE)
• Installed, Configured and managed Database Mirroring, Log Shipping and replication and windows failover cluster.
• Extensively used Activity Monitor, SQL profiler, Perfmon and third-party tools, DMVs for performance monitoring and tuning purpose such as blocking, deadlock, long running queries etc.
• Wrote T-SQL, Stored-Procedures, Function and Trigger