SUMMARY

• A competent professional with over 10+ years of experience in MSSQL Database Administration and its applications.
• Proficient in MS SQL server Installation, Configuration, deployment of Service Packs/Patches & Administration for SQL Servers in Clustered (Failover) & Non - Clustered Environments.
• Involved in Up-gradation/Migration of DB objects from legacy SQL versions like SQL 2000/2005 to 2008/2012/2014.
• Well versed with the concepts of implementing HA/DR solutions like Failover Cluster setup, Replication, Log Shipping, DB Mirroring and Always ON.
• Involved in migration of DTS Packages to SSIS and troubleshoot migration issues
• Skilled in planning/configuring database backup strategies using native SQL tool and third party tools like Veritas, Data Protector and Legato
• Experience in managing complete Database administration like configuring DB admin policies/security policies, index maintenance, stored procedures/query optimization and Performance tuning.
• Extensive experience in controlling User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Experienced in Error and Event Handling using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Involved in scheduling SSRS reports according to business requirements and technical standards
• Participated in Disaster Recovery Planning, Execution and Testing.
• As part of 24/7 on Call Support for Production Databases, handled & resolved escalated incidents/fire-calls from Tier-2 engineer to fulfill the SLA commitments
• Involved in planning and execution of periodic BCP/DR test as per business requirement
• Good understanding of Information Technology Infrastructure Library (ITIL)process
• Experienced in Root Cause Analysis (RCA), fixes and documentation of those issues/fixes for future use.
• Expertise in building the knowledge management system for all the ongoing issues.
• Recognised for playing a key role in ensuring seamless delivery of projects, extended support during critical scenarios and proactive capacity planning for business critical application databases
• Proven ability to work effectively and collaboratively, with internal business and technical teams, vendors and consultants.
• Worked closely with application developers and business users to assist in the planning/execution of the database jobs across the Development, Test and Production environments.
• Holds the merit of working in different domains like Telecom, Beverages, Manufacturing, Logistics, Banking & Finance
• A keen communicator with honed interpersonal, problem solving and analytical abilities
• Pursuing DBA in MongoDB (Underwent MongoDB for DBA’s training under MongoDB University)

TECHNICAL SKILLS

Operating Systems: Windows 2012/2008/2003/2000 & NT Versions

Database: MS SQL Server (2014/2012/2008 R 2/ 2008/2005/2000 ) Versions

Tools: Idera SQL, SQL Lite Speed, Data Protector, Veritas, Legato, Remedy, OVSD and SM9.

Domain: Telecom, Beverages, Manufacturing, Retail outlet, Logistics, Banking & Finance

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Project Consultant

Responsibilities:

• Planning for new SQL DB server setup to facilitate customer’s business requirement
• Developing implementation plan for Installation/Up-gradation/Migration of SQL DB servers
• Installation of SQL server (Cluster/Standalone) as per requirement
• Implementing HA/DR concepts like Mirroring, Log-shipping, Replication and AlwaysON
• Up-gradation/migration of legacy systems (SQL server earlier versions to latest versions)
• Planning and analyzing migration requirement of each application by coordinating with various application support team.
• Performing/Analyzing Lab results for migration plans and proceeding with final cut over
• Coordinate with Application Developers on DTS package migration
• Deployment of latest service packs/hot fixes as per requirement on Test/ Dev & Prod environments
• Post migration/up-gradation coordinate with application team in resolving accessibility issues
• Configuring monitoring tools with required parameters to ensure DB server availability and utilization
• Planning and Configuring Backup strategies, Implementing Maintenance Plan, Troubleshooting and Performance Tuning Database issues
• Monitor/analyze DB growth and proactively provide recommendations to customer as part of capacity planning
• Active involvement in working with Application Developers, Business Analyst and Solution Delivery team in troubleshooting and resolving production issues
• As a SPOC involved in knowledge transition for new projects

Environment: MS SQL Server 2005/2008R2/2012/2014, Windows 2003/2008/2012 , SSIS, DBSPI, DataProtector and Idera.

Confidential, Warren NJ

Senior DBA

Responsibilities:

• Planning/installation of new SQL DB servers to facilitate business requirement
• Involved in planning/implementation for Up-gradation/Migration of database objects from legacy versions like SQL 2000/2005 to latest versions like 2008 R2/2012
• Involved in implementation of HA/DR features like Failover Cluster setup, Log shipping, DB Mirroring, Replication and AlwaysON.
• Planning and coordinating with application team on application DB migration across Test/Pre-Prod/Prod environments through phase by phase approach till final cut over
• Coordinate with Application Developers on DTS package migration
• Deployment of latest service packs/hot fixes as per requirement on Test/ Dev & Prod environments
• Involved in Configuring/monitoring day to day database management tasks like DB refresh, Validating DB maintenance jobs, troubleshooting, performance tuning, DB users security validation
• Configuring DB monitoring tools with required parameters to ensure DB server availability and utilization
• Involved in devising/implementing Backup strategies and other DB Maintenance Plans
• Monitor/analyze DB growth and proactively provide recommendations to customer as part of capacity planning
• Active involvement in working with Application Developers, Business Analyst and Solution Delivery team in troubleshooting and resolving production issues

Environment: MS SQL Server 2005/2008R2/2012, Windows 2003/2008/2012 , SSIS, Veritas backup.

Confidential

Senior SQL DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Configuring, monitoring and troubleshooting Log shipping, transactional replication, Database mirroring and AlwaysON in production and QA servers.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
• Involved in resolving Database issues like Index fragmentation, CPU Bottleneck, I/O Bottleneck, DBCC checks, Optimization of Query and Index tuning.
• Coordinating with application team and resolving slow running queries
• Working with development and application teams to perform application and database tuning.
• Responsible for DB refresh in DEV, pre/post application releases.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production/QA Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Design, document and promote security "best practices", policies, standards and protocols.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Prepared Documentation for the Disaster Recovery plan
• Creation/Maintenance of Enterprise DB server inventory with solution/contact details for application databases
• Month end report generation (Server availability report, Month-end metrics dashboard, Share point maintenance) and involved in creation of SOP/CIP

Environment: MS SQL Server 2005/2008R2/2012, Windows 2003/2008/2012 , SSIS, DBSPI, Veritas, SQL Lite and DataProtector.

Confidential

Senior SQL DBA

Responsibilities:

• Proactive monitoring of the MS SQL server 2008/2005 in the clustering environment both active/active and active/passive
• Configuring mail alerts for monitoring data/log file full, disk full, job failures (both maintenance & application)
• Verifying the consistency of the backup set by periodic restoration test
• Configured/monitoring log shipping between the Primary and Secondary stores to ensure synchronization
• Involved in high availability concepts Replication/Mirroring between HQ to Primary store servers
• Checking the integrity of the databases to avoid crisis, also configuring automated jobs for the same
• Regular Monitoring of error logs, Database status, available free spaces to avoid the failure of applications
• Monitoring the event viewer logs to ensure the cause for cluster fail over due to hardware issues incase if found have to coordinate with OS team and resolve the same
• Proactive monitoring & Tuning SQL Server
• Executing DBCC commands periodically to check database consistency, and rectifying the errors if reported
• Involved in handling DB server security like creation/deletion of new login account and providing/maintaining DB access/privilege across the DB servers
• Developing Month end and User entitlement report
• Problem management (Incident trending)
• Month end report generation (SDR, Ops metrics & Internal ticket auditing)
• Coordinating with the team to ensure 100% SLA

Environment: MS SQL Server 2005/2008R2, Windows 2003/2008, SSIS, DBSPI, Legato, Veritas, Tivoli

Confidential

TL/SQL DBA

Responsibilities:

• Proactive monitoring of the MS SQL server 2008/2005/2000 in the clustering environment both active/active and active/passive
• Creating, maintaining databases and database objects
• Regular backup of databases using native tool, VERITAS and DP integrated backup
• Configured log shipping between the production and DR nodes to ensure high availability
• Involved in high availability concepts Replication/Mirroring in both Prod/Dev environment
• Deployment of DTS packages in Staging/Production environment
• Configuring and monitoring DB maintenance jobs like integrity/optimization
• Monitoring scheduled application jobs in both database and OLAP server
• Configuring alerts/jobs for monitoring error logs, Database status, available free spaces to avoid the failure of applications
• Monitoring the event viewer logs to ensure the cause for cluster fail over due to hardware issues incase if found have to coordinate with OS team and resolve the same
• Proactive monitoring, troubleshooting & tuning SQL Server
• Executing DBCC commands periodically to check database consistency, and rectifying the errors reported
• Performing internal audits, Ticket auditing
• Involved in SLA reports generation and month end reports generation (SDR, Ops effort tracker, KPI data and maintaining internal team share-point site)

Environment: MS SQL Server 2005/2008, Windows 2003/2008, DTS, DBSPI, Veritas, Legato and DataProtector.

Confidential

SQL DBA

Responsibilities:

• Installing SQL Server 2000/2005 Deployment of wraps, patches and hot fixes
• Creating, maintaining databases & database objects
• Proactive monitoring, Regular backup of databases using VERITAS
• Regular backup of databases, checking the integrity of the databases to avoid crisis, also configuring automated jobs for the same
• Monitoring user access to the databases regularly by configuring audit jobs for capturing activities based on events
• Executing DBCC commands periodically to check database consistency, and rectifying the errors reported
• In order to support high availability, configuring log shipping and monitoring the same
• Modifying the database structure, as necessary, from information given by application developers
• Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, notifications etc.

Environment: MS SQL Server 2000/2005/2008 , Windows 2003/2008, DBSPI, Veritas, Legato and DataProtector.

Confidential

SQL Database Administrator

Responsibilities:

• Proactive monitoring of the MS SQL Server 2000 in the clustering environment both active/active and active/passive
• Creating, maintaining databases and database objects
• Providing support during Wintel OS patching in the cluster environment
• Monitoring scheduled application jobs in both database and OLAP server
• Regular backup of databases, checking the integrity of the databases to avoid crisis, also configuring automated jobs for the same
• Configured log shipping/replication in development environment
• Regular Monitoring of error logs, Database status, available free spaces to avoid the failure of applications
• Monitoring the event viewer logs during cluster fail over to ensure Node health status, incase if hardware issues were found have to coordinate with OS team and resolve the same
• Proactive monitoring & Tuning SQL Server
• Executing DBCC commands periodically to check database consistency, and rectifying the errors reported

Environment: MS SQL Server 2000/2005, Windows 2000/2003, Foglight, Veritas, Legato.

Confidential

SQL Database Administrator

Responsibilities:

• Installing SQL Server 2000, Deployment of wraps, patches and hot fixes
• Creating, maintaining databases & database objects
• Regular Monitoring of error logs, Database status, available free spaces to avoid the failure of applications.
• Regular backup of databases, checking the integrity of the databases to avoid crisis, also configuring automated jobs for the same
• Periodically identifying mismatch, orphan ids and fixing the same.
• Proactive monitoring & Tuning SQL Server
• Monitoring user access to the databases regularly by configuring audit jobs for capturing activities based on events
• Executing DBCC commands periodically to check database consistency, and rectifying the errors reported
• In order to support high availability, configuring log shipping and monitoring the same
• Modifying the database structure, as necessary, from information given by application developers
• Automating Administrative Tasks by creating alerts, jobs, scheduling jobs, notifications etc.
• Based on transaction volumes and Database size growth, analyze and advise on capacity planning

Environment: MS SQL Server 2000/2005, Windows 2003, DTS.