OBJECTIVE

• To excel career with a good organization, which would use my skills and allow me to gain expertise.

SUMMARY

• Total of 6+ years of experience.
• Around 6 years and some months of experience in the IT industry as SQL SERVER Database Administrator.
• Hands on Experience in Database Administration activities like Database maintenance, Security and regulatory compliance
• Disaster recovery (Log shipping, Replication, Database Mirroring, Always on availability group, failover cluster)
• Design and performance improvement, Documentation, Azure (IAAS AND Pass) Datawarehouse (SSIS, SSRS, SSAS)
• Having systematic and organized approach with excellent communication and problem - solving skills for increased efficiency and competence.
• Interpersonal Skills with the ability to work as an individual and a team player.

TECHNICAL SKILLS

Technology: .NET

Database: MS SQL SERVER 2017,2016, 2014, 2012, 2008, 2008R, 2005

Language: T-SQL

Tools: SSMS, Import/Export, Logshipping, SQL server profiler, IBM Tivoli Storage manager, HP data protector, Visual Studio 2013, Zabbix, SolarWinds, TDP, ItKPM, Service now, CMS viewer

Operating System: Windows Server 2008, Windows Server 2003, Windows server 2012

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA/BI—Administrator/Engineer

Responsibilities:

• Creation of New Databases, Tables, filegroups, store procedure, views, users and assigning permissions.
• Provided database Management services to client, who include backup and recovery, performance management.
• Checking Alert and Log for errors and making necessary actions to rectify them.
• Analyzing objects and schemas to improve the performance of the database.
• Checking the Data Files Consistency using DBCC commands.
• Monitoring the database for Memory, CPU utilization.
• Worked in Database Migration Project involves Backup and restore of databases
• Ensuring High Availability through Configuring / maintaining Log Shipping and Transactional Replication.
• Apply Patches for Production and Test Servers for legacy servers under a special project Vulnerability
• Addressed disk space issues and given permanent resolution for the same.
• Participated in a planned Disaster activity for bank and assisted with SQL DBA scope of work
• Configured AlwaysOn High-Availability on SQL server 2012
• Working on SSIS Jobs
• Working on SSRS reports
• Entry knowledge of Oracle DB
• Responsible for monitoring and tuning database performance.

Environment: SQL 2017, SQL Server 2016, SQL Server 2014, SQL server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000 Enterprise Edition, Windows server 2008 R2

Confidential

SQL DBA\Scrum

Responsibilities:

• Expertise experience in installing new instances of SQL servers 2008 R2, 2012 AND 2014 on Microsoft Windows Servers 2012 R2 and following best practices.
• Monitored and administered SQL Instances on standalone servers and Cluster environment
• Highly experience on handling VLDB such ranging from 500Gb to 3T on different VMs which added up to a total of 50T both in UAT/DEV & PROD environments.
• Installed and administered 2 Node cluster on Microsoft Windows Servers 2012 R2 Enterprise Edition on SAN storage.
• Strong experience in Database Optimization and Tuning, Backup/Restore, Troubleshooting, and Data Import/Export.
• Expertise in designing and implementing the processes and standards for database systems recovery and back-up checks as well as user performance and data security.
• Updated database systems by reviewing, planning, testing and installing database security patches and service packs.
• Expertise in troubleshooting SQL servers Agent jobs, Error Logs, Windows Logs to resolve failure job component.
• Strong experience using DMVs, DBCCs and SPs from Sql servers 2008R2 to 2014 for checking database health and performance.
• Expertise in monitoring performance using SQL Profiler, Activity Monitor, Perfmon in order to find locking, blocking and deadlock issues.
• Expertise in planning and managing SDLC projects such, patching, hot fixes and service pack upgrades and migrations .
• Experience with dealing with ITOPS change review meetings for changes to be approve for implementations on PROD environment.
• Experienced in recovering the databases from disasters and implemented Point-In-Time Recovery solution.
• Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Set up linked severs and troubleshooting any issues related to ODBC connectivity.
• Automated daily tasks including backup and restore tools by using Sql servers2008/2008R2/2012/2014 native SSMS tools.
• Experienced to work in coordination with different Teams (like Network Team, Windows Admins, Storage Admins, and other application Teams) as well with Stakeholders and customers.
• Experienced with High Availability solution such as Always On, Cluster, Mirroring and Log Shipping.
• Experienced in rewriting and restructuring store procedures and views with T-SQL.
• Expertise in writing technical reports for the management and for other of Production support.

Environment: SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000 Enterprise Edition, Windows server 2008 R2 standard Edition.

Confidential

SQL DBA

Responsibilities:

• Provided regular DBA support for the database servers.
• Monitoring disk space, logs file growth in regular interval.
• Creation of users, roles, granting privileges and profiles etc.
• Daily send the database Health report to immediate reporting manager.
• Configure Log-shipping, Mirroring in production server
• Created Linked servers to Oracle servers
• Worked in Database Migration Project involves Backup and restore of databases
• Participated in a planned Disaster activity for bank and assisted with SQL DBA scope of work

Environment: SQL Server 6.5, SQL Server 2000, SQL Server 2005, SQL Server 2012 Enterprise Edition, Windows server 2008, Windows Server 2003 R2 standard Edition.