SUMMARY:

• Microsoft Azure Cloud Certified Engineer & SQL Server Certified DBA | SQL Data Migration Analyst | ITIL Certified
• Confidential having 11+ years of Experience in IT industry which includes SQL Database Administration and support on all versions of Microsoft SQL Server and main skill set is in with Microsoft SQL Server Database Maintenance/Administration, SQL Server/Database Migrations, Performance Tuning and providing 24*7 database support.
• Currently working on AZURE Cloud Migrations that includes IAAS, PAAS methodologies.
• Also, have hands - on experience in using third party tools like DDBoost, Litespeed, Idera Diagnostic Manager and Simpana Commvault.
• As a SQL Server database administration Proficiency on Microsoft SQL Server 2000/2005/2008/2012/2014/201/2017 in Production (Physical) & Non-Production (Physical / Virtual) environments, including Installation Configuration and Maintenance on Windows Server 2000/2003/2008/2012 & 2016 in both standalone and Cluster Configurations.
• Database Design/Maintenance/Support of MS-SQL Server Databases/Instances and exposure to all MS-SQL DBA Activities.
• Having good troubleshooting and problem-solving skills including analysis, design, programming, implementation, performance tuning and maintenance of database applications.
• Hands-On experience in SQL Server Up-gradations, Migrations and implementing High Availability and Disaster Recovery systems with various SQL Server options for business continuity/disaster recovery including setup and maintenance of Always-On Availability Groups, SQL FCI, Database mirroring and Log Shipping.
• Hands-On experience in performing Database Migrations, Physical to Virtual (P2V) and SAN Migrations of physical/cluster SQL Servers from lower to Higher versions.

TECHNICAL SKILLS:

Operating Systems: Win Server 2003, Win Server 2008, Win-NT, Win-XP, Win 7, Win 2012

Work Flow Tools: BMC Remedy, Commvault, Quest Litespeed, NeverFail, SRM, SQL Idera Diagnostic Manager

Database: MS-SQL Server 2000/2005/2008 R 2/2012/2014/2016/2017

Cloud: Microsoft Azure

Job Functions Database: Design/Administration/Maintenance/Migration of MS-SQL Server Databases and exposure to MS-SQL DBA Activities performance tuning, migrations/up gradations, HADR Technologies and etc…

PROFESSIONAL PROFILE:

Confidential

Senior Engineer Database Administrator

Platform : Windows Server 2003/2008/2012.

Cloud: Microsoft Azure

Database Software: SQL Server 2000/2005/2008/2012/2014/2016/2017

Responsibilities:

• Azure Cloud Migrations from On Premises i.e. IAAS and PAAS migrations to Cloud.
• Performing Database Migrations from lower to Higher versions of SQL
• Performing Physical to Virtual (P2V) SQL Migrations.
• Performing Dedicated SQL server Migrations.
• Performing SAN Migrations of physical/cluster SQL Servers.
• Coordinating with Windows/Storage/Clients as part of OS Upgrades.
• Instance migration from one version to another version.
• Installing MS SQL Server 2005/2008R 2/2012/2014/2016.
• Implemented AlwaysOn High availability & Disaster Recovery solution and monitoring it.
• Setup and monitoring of SQL Cluster server.
• Configure linked server & remote server to execute remote procedures.
• Perform all aspects of database administration, including backup & recovery.
• Used SQL Profiler to analyze hampering activities.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance for all the environments.
• Performing the MSSQLServer failover Cluster installation and monitoring the failover cluster for any critical events and verifying the windows and MSSQLServer logs.
• Managing the User Privileges Administration.
• Patch Roll-out, Service packs and Hot fixes on MSSQLServer.
• Monitoring and setup of MSSQLServer daily and weekly Maintenance Plan.
• Performed database restore, refresh, and recover activities as needed.
• SSIS Configuration changes.
• Preparing the RCA for critical incidents and tasks.
• Handling critical incidents and tasks.

Confidential

Senior Engineer Database Administrator

Platform : Windows Server 2003/2008/2012.

Software: SQL Server 2000/2005/2008/2012/2014.

Responsibilities:

• Installation and Uninstallation of SQL, SQL related components, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted servers
• Take care of the Server/Database design and implementation as part of new Installation.
• Log shipping setup and maintaining the log shipped databases
• Cluster Creations, Upgradations and removal of nodes from SQL Cluster.
• SQL Database Mirroring setup and update.
• Building and implementing of SQL Always On, Add and Remove of AG Replicas which involves change of Listener dropping/creating and rename.
• Configuration Change of SQL related components.
• Daily Operations include: Daily Server Health check, Backup & Restore Status, DB Mirroring Health Check, Disk Space, Log File Status and Usage, Monitoring Application related Jobs
• Performing Database Refresh’s
• Automating Scripts, following and implementing best practices.
• Enhancements as part of SQL environment development.
• Index Performance and Tuning as part of Enhancement.
• Database Performance and Tuning as part of Enhancement.
• Capacity Management for all the Databases.

Confidential

Senior Engineer Database Administrator

Platform : Windows Server 2003/2008/2012.

Software: SQL Server 2000/2005/2008/2012.

Responsibilities:

• Installation and Uninstallation of SQL, SQL related components, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted servers
• Take care of the Server/Database design and implementation as part of new Installation.
• Log shipping setup and maintaining the log shipped databases
• Cluster Creations, Upgradations and removal of nodes from SQL Cluster.
• SQL Database Mirroring setup and update.
• Building and implementing of SQL Always On, Add and Remove of AG Replicas which involves change of Listener dropping/creating and rename.
• Configuration Change of SQL related components.
• Daily Operations include: Daily Server Health check, Backup & Restore Status, DB Mirroring Health Check, Disk Space, Log File Status and Usage, Monitoring Application related Jobs
• Performing Database Refresh’s
• Index Performance and Tuning as part of Enhancement.
• Database Performance and Tuning as part of Enhancement.
• Capacity Management for all the Production Databases.

Confidential

Consultant - Microsoft SQL DBA

Platform : Windows Server 2003/2008.

Software: Sql Server 2000/2005/2008/2012.

Responsibilities:

• Installation, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted servers
• Take care of the Server/Database design and implementation as part of new Installation.
• Development and scheduling of proper database maintenance plans and jobs for all databases. Ensure successful execution of these plans. Identification and resolution of all errors during execution. Integration of automated error notification.
• Scheduling and execution of all database Backups and Restorations, ensuring proper retention and cleanup of previous backup files. Identification and resolution of all errors during execution. Integration of automated error notification.
• Managing the storage structures of the database
• Managing User Security
• Managing database objects, such as tables, indexes, and views
• Performing upgrades and migrations of the database and software to new release levels
• Implementation and Monitoring of Database Mirrored Databases.
• Monitoring and administration of Clustered databases.
• Good knowledge about replication concepts and monitoring the replicated databases.
• Good Experience in Performance tuning like slow running queries, Fragmentation and re-indexing the fragmented indexes, placing server side traces, enabling profilers and perfmon to capture performance related issues.
• Respond, identify and correct all issues that impact the production databases, keeping within the established, severity based, SLA’s.
• Install, configure and utilize available monitoring tools to proactively identify and correct potential impacts to the production databases or servers.
• Creating, maintaining and documenting the data model. This includes the proper use of indexes and constraints to ensure the integrity of the data.
• Involvement in Change Management Process.
• Capacity Management for all the Databases

Confidential

Senior Engineer Database Administrator

Platform : Windows Server 2003/2008.

Software: Sql Server 2000/2005/2008.

Responsibilities:

• Handled this Project alone, Single MS-SQL DBA resource for this Project and provided 24*7 Support when required.
• Installation, upgrade, configuration, tuning and patching of the MS SQL Server database software on all Hosted eRAM servers
• Take care of the Server/Database design and implementation as part of new Installation.
• Implementation of Database Mirroring in Production Server.
• Development and scheduling of proper database maintenance plans for all databases. Ensure successful execution of these plans. Identification and resolution of all errors during execution. Integration of automated error notification.
• Scheduling and execution of all database Backups and Restorations, ensuring proper retention and cleanup of previous backup files. Identification and resolution of all errors during execution. Integration of automated error notification.
• Creating and Scheduling of Jobs related to Database’s
• Migration of the Database’s from Server to Server.
• Respond, identify and correct all issues that impact the production databases, keeping within the established, severity based, SLA’s.
• Install, configure and utilize available monitoring tools to proactively identify and correct potential impacts to the production databases or servers.
• Creating, maintaining and documenting the data model. This includes the proper use of indexes and constraints to ensure the integrity of the data.
• Maintaining the configuration tables as customers and customer configurations change.
• Creating and documenting all processes to collect the information and ensuring that it is properly added to the Hosted Database.
• Successful execution of all processes.
• Involvement in Change Management Process.
• Capacity Management for all the Databases.

Confidential

Systems Engineer

Platform : Windows Server 2003, Windows NT 4.0 Server

Software: Sql Server 2000/2005, BMC Remedy

Responsibilities:

• Performing Morning Checks on the Server’s.
• Perform day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Troubleshoot DTS Maintenance Plans
• Manage hierarchical security (access control, permissions) for databases and ensure data integrity using templates and schemas.
• Establish and maintain backup, recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Create database objects (tables, indexes, etc.)
• Performing Production BAU’s (Business As Usual) on CRM Tools like Navision and Cerillion Application.
• Involvement in Incident Management and Crisis Management Process.
• Following the process of Incident management in tracking the High/Critical issues and updating the teams within the SLA.

Confidential

Platform : Windows Server 2003, Windows NT 4.0 Server

Software: Sql Server 2000/2005, BMC Remedy

Monitoring and Support Jr-DBA

Responsibilities:

• Performing Morning Check’s on database Servers.
• Troubleshoot Infrastructure issues related to SQL database server such as memory, I/O, Disk, etc. Monitor log files to proactively resolve issues.
• Disk Management for the servers.
• Perform data Backup/updates and exports between SQL Servers, both internal and external as required.
• Collaborate with developers, network administrators, system administrators to implement secure, reliable database environments.
• Monitoring database/subsystem performance issues
• Monitor application related jobs and activities
• Product Engineer experience which includes handling Incident, Change, Problem, Event Management and owing end to end responsibility of the incidents.
• Monitoring of Routers, Servers and Billing Server’s used in Production Environment (Billing Servers, Database servers and Network Devices through monitoring tools-Netcool, Nagios).
• Tracking all Database related issues with Remedy Administrative ticketing system.