PROFESSIONAL SUMMARY:

• In IT industry over all 15+ years of experience as SQL Server DBA & Project Management.
• Experience working in the Healthcare sector, Banking, Insurance & Telecommunication.
• Worked with Data Architects and Clients for the purpose of business requirement.
• Coordinated with onshore/offshore DBA team.
• Primary DBA for few Tier - 1 applications, worked closely with developers. Main objective was to deliver projects within scope, time and costs by following standards, methodologies and guidelines.
• Coordinated on all compliance and patching requirements.
• Worked on Database migration project from Sybase to SQL, Oracle to SQL, MYSQL to SQL.
• Good experience in Migration from SQL Onprime to AWS cloud.
• Maintained over 1200 production and over 300 pre-production\non-prod SQL Server 2012, 2014, 2016, 2017, Standalone, Cluster, Always on and cloud environment for global customers with 24*7 support .
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Improved and maintained production servers with Disaster R ecovery management which includes Database Snapshots, Backups, Standby servers and high availability features.
• Highly expertise on implementing and troubleshooting high availability techniques like Log shipping, Replication, Mirroring and Clustering and Alwayson.
• Good Knowledge in AWS, POSTGRES.
• Worked in SSIS and SSRS packages
• Reviewed and approved any Change Management records impacting, or with potential to impact, the client, making sure the correct approval process is followed. Proactively manage changes in project.
• Having good exposure on SQL Server new features and worked on Server & Database maintenance routines, Troubleshooting Query Performance issues, CPU and Memory bottlenecks.
• Good experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries, Query plans and query performance. Worked with development team for fine tuning Query & Application optimization and Index tuning.
• Developed best practices and tools for project execution and management.
• Good knowledge on third party Backup tools SQL Lite speed & Commvault, Monitoring tools like SCOM & Idera and Ticketing tools HPSM, SNOW, Remedy.
• Able to Handle larger Databases more than 4TB.
• Act as SPOC for customer for any issue or escalation.
• Provide estimates for new requirements and work with customers to meet their Database needs .
• Ensuring High Availability through Configuring and maintaining.
• Possess sound analytical, problem solving and team leading skills. Customer focus and ability to take owner ship to resolve the issues.
• Good communication and interpersonal skills. Ability to work with rigid deadlines.
• Handle Production Support for Multiple customers round the clock.
• Planning, Creation and Maintenance of MSSQL Instances.
• Good Exposure on Clustering both Active-Passive and Active-Active Environment.

TECHNICAL SKILLS:

Operating Systems: MS - DOS, Windows 95/98, NT 4.0, Windows 2003 and Windows Server 2008, 2012

Programming Languages: Visual Basic 5.0/6.0, Power shell scripts, Windows Scripts. DBMS MSSQL Server 7.0, 2000, MSSQL Server 2005 & 2008 R2, 2012, 2014,2016,2017, Oracle7 Other Tools Citrix, AutoSys

Ticketing Tools: HPSM, SNOW, Remedy

Backup Tools: Commvault and SQL Litespeed

Monitoring Tools: SCOM

Performance Tools: Idera, Redgate

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

DBA Manager

Responsibilities:

• Production support for SQL server environment in Physical and Virtual Environments.
• Installing and configuring of SQL Server 2017,2016,2014/2012 and 2008R2.
• Performing upgrade and Migration of lower version SQL Servers to SQL 2017/2016/2014.
• Installing/Configuring SQL Server 2017/2016/2014/2012 Always on availability groups for high availability.
• Configuring and maintaining Zerto Replication for Disaster Recovery.
• Handling change/Incident management.
• Implementing different types of Replication Models like Snapshot and Transactional.
• Patched servers with latest SQL Server service packs and Cumulative updates.
• Managing Microsoft Active\Active, Active\Passive, and Clustered SQL Server 2005 /2008/R2/2012 environments.
• Installing and Implementing Async and Sync Mirroring / Log Shipping for Disaster Recovery.
• Using IDEARA, Diagnostic Manager and SCOM for monitoring SQL Servers.
• Working on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Performing Server, Application fine-tuning and troubleshooting.
• Monitoring MS SQL Server performance and network issues.
• Deploying and monitoring SSIS Package tools of SQL Server to populate data from various data sources.
• Scheduling backups for databases and Transaction logs. Performing restoration operations and suggested backup strategies.
• Controlling user access rights and managed data security.
• Involving in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMVs, Wizards and SQL Profiler.
• Maintaining multiple SQL Server instances with maximum availability.

Confidential, Glen Allen, VA

Sr. SQL DBA

Responsibilities:

• As SQL DBA Lead, responsible for infrastructure production support activities on SQL DB Servers.
• Performed day to day Database administration activities on production servers like backup checks, space usage
• Developed best practices and tools for project execution and management.
• Migrated from SQL server Onprime to AWS.
• Handled Postgres instances.
• Creating and providing RCA’s for repeated production issues.
• Help improve performance of queries by analysing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning.
• Configure Log Shipping, Replication, Mirroring and Always ON feature.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies.
• Setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Document Backup and recovery procedures.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.
• Coordinating with vendors for DB and cluster support.
• Preparation of documentation and procedures required for reference.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on AlwaysOn availability groups and replicas for reporting, backup and performance.
• Installing and Configuring SQL Server 2014/2012 AlwaysON availability groups for high availability
• Involved in Monitoring Performance of different production servers.
• Worked on PowerShell Scripting.
• Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• Extensive use of SQL Server DMV's for Performance Tuning.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.

Confidential

Sr. SQL DBA

Responsibilities:

• Onsite Transition lead for DBA tower.
• Transition of 400+ Applications and related Databases.
• Cross KT to offshore team.
• Technically guide team to handle critical P1 issues related.
• Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2
• Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on AlwaysOn availability groups and replicas for reporting, backup and performance
• Worked extensively on Virtual and VMware Environments.
• Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Worked on PowerShell Scripting.
• Planning the location of data, index and Transaction log files on the disk.
• Involved in Monitoring Performance of different production servers.
• Leading team to resolve the incident and problem, coordination with various teams, communication, organizing the bridge calls for high priority issue.
• Availability Management, BCP (Business continuity plan).
• Accountable for time based SLA clause.
• Leading team to resolve the incident and problem, coordination with various teams, communication, organizing the bridge calls for high priority issue and Maintain 300+ SQL servers.
• Problem Management and Process Improvement, Suggesting Automation.
• Leading turnovers and Change controls, Responsible for Change management.

Confidential

Sr. SQL DBA

Responsibilities:

• First phase of project creates the all object in the SQL Server Database from the Sybase source database. Sybase to SQL Server Migration Tool helps you migrate Sybase ASE (Adaptive Server Enterprise) T-SQL Procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL. SSMA is a first of its kind product with a productive migration environment that offers different type of Object can migrate using SSMA.
• Setup and Installation.
• Stored Procedures migrations.
• Triggers, Tables, Views migrations.
• Indexes User Defined Data types conversions.
• User Defined Defaults.
• Error handling. Data and High availabilities setup based on the client requirement.

Confidential

Sr. SQL DBA

Responsibilities:

• Worked as the interface between the onsite and offshore teams.
• Provided 24/7 Production support with L3 & L4.
• Review and approve any Change Management records impacting, or with potential to impact, the client, making sure the correct approval process was followed and SLA management.
• People management, Timesheet and Shift management and Provide Weekly and Monthly reports to the Client.
• Follow escalation procedures for all faults and incident management Motivate Delivery Teams to reach for excellence. Worked closely with helpdesk teams to achieve excellence.
• Planning, End to end support Monitoring for disk space, errors &Troubleshooting various SQL related issues.
• Installed and configured of SQL Server 2005 and 2008R2 in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment.
• Managed SQL Servers in Virtual and Standalone environments.
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Designed and implemented database changes.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas and assisting in set up of disaster recovery.

Confidential

SQL DBA

Responsibilities:

• Provided 24*7 Production support with L3 & L4.
• Handling performance issues and fine tuning the servers.
• Work with incident management & Problem tickets.
• Creating and providing RCA’s for repeated production issues.
• Configure memory for best performance results &Monitoring server performance and memory activities.
• Install and maintain Cluster Servers &Creating and scheduling Autosys job for Backup, rebuild index, DR copy etc.
• Providing on-call support to ensure that all environments are regularly maintained.
• Installation, configuration and maintenance of SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing & Monitoring the Scheduled jobs. Managing Security (Creating users, logins and roles, granting permissions).
• Worked on disk space alerts, Job failure alerts. Rebuilding the indexes at regular intervals for better performance. Dealing with performance issues on production servers.
• Moving objects from QA to Production databases.

Confidential

SQL DBA

Responsibilities:

• Administering Microsoft SQL Server 2000/2005/2008 Database
• Managing database instances and monitored server performance
• Planned and analyzed client requirements and documented technical specifications
• Involved in the administration tasks on SSIS and configured the SMTP mail on SSIS
• Involved in the administration tasks on SSAS
• Giving the support to the Database through the third party backup tool like Sql Lite Speed.,TSM ..
• Providing the support in the High availability areas like Log shipping and Replication.
• Involving the other administration activities like installation, database creation, shrinking, backup, restore, user creation, SQLMAIL configuration, database upgrade and migration in SQL Server 2000, 2005 and 2008 databases.
• Performed backup, recovery and performance tuning of database server and applications
• Installation of Test and Production Servers
• Installation of Microsoft SQL Server on both cluster and standalone environment and installing latest service packs and Hotfixes on the servers from time to time as they are released
• Attending and addressing client meetings.
• Working on Incidents, Service Calls and Work Orders that are assigned.
• Scheduling and Monitoring jobs on all production servers.
• Space Management - Working on database and transaction log alerts.
• Working on database maintenance jobs such as Backups, DBCC and Update Statistics
• Coordinating with Development Teams for Application Release and support issues
• Database Creation, Backing of Databases using different Backup Methods Native,
• Creation of users, roles and managing security. Implemented effective database security practices and procedures.
• Modify the database structure as required by the application developers.
• Monitor and optimize the database backup and restore planning strategies.
• Allocation of system storage and planning future storage requirements for the database system.
• Creation and configuration of Linked severs and Replication.
• Configuration and Maintenance of SQL Agent and Autosys jobs

Confidential

SQL DBA

Responsibilities:

• Worked as a Shift lead, taking owner ship of the shift ensuring response and resolution time are met with in the defined SLA, first level of escalation of issues in the shift related to both process and technical.
• Providing knowledge Transfer to the newly joined associates to better understanding about ML processes and policies
• Working with US and UK team and Management on Alert consolidation and weekly response calls.
• Maintaining a Track Sheet of Production releases performed during the month and associate effort metrics. And Regular DBA activities
• Installation of Microsoft SQL Server on both cluster and standalone environment and installing latest service packs and Hotfixes on the servers from time to time as they are released
• Database Creation, Backing of Databases using different Backup methods Native, SQL Litespeed, TSM, Legato and Database restore.
• Creation of users, roles and managing security.
• Implemented effective database security practices and procedures.
• Monitor and optimize the database backup and restore planning strategies.
• Allocation of system storage and planning future storage requirements
• Creation and configuration of Linked severs and Replication. Configuration and Maintenance of SQL Agent and Autosys jobs.
• Troubleshooting of Replication, Log shipping and clustering issues and Performance issues.