SUMMARY:

• Over 10 + years of experience in Database Design, Administration and Support for very large and complex databases in SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 along with Team Management experience
• I was a winner of three prestigious of Excellence awards at TCS and Confidential . I have worked various business domains like Auto, Financial, Insurance, Banking and Retail
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensively worked on multi node Clustering.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008R 2/2008/2005/2000 on Clustered and Standby Environments.
• Experience in supporting Very Large Database (VLDB) more than 16 TB and troubleshooting problems
• Expertise in Database Backup and Recovery procedures by using native and legato.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in using Performance Monitor, Profiler and Extened Events to identify Dead locks, blocking, long running queries.
• Experience in high availability (clustering, Always on, replication, log shipping and mirroring)
• Experience in data modeling like physical data modeling and logical data modeling
• Migration from SQL server and 2000/ and by using In - Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process.
• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
• Experience in Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV's and DMF's, Re-indexing, Updating Statistics and online indexing.
• Created linked servers between SQL Server,
• Experience in Restoring Database from Production to Dev/QA Boxes
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in opening the case to Microsoft for the environmental issue
• Experience in improving the performance by indexing, updating statistics, recompiling stored procedures and code tuning.
• 24 X 7 Production Database on-Call Support
• Experience in improving the performance by indexing, updating statistics, recompiling stored procedures and code tuning.
• Experience in Capacity Planning and tempdb optimization for better performance.
• Experience in using Dynamic management view and functions for trouble shooting the performance issues.
• Worked with Tivoli Storage for handling Production backups and Recovery.
• Experience in maintaining the SQL security per client standards.
• Experience in managing fragmentation of Indexes to achieve better query performance.
• Recognized and was included as an SME
• Received appreciations from clients and manager for prompt problem solving, implementation activities and valuable decision making activities

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 and MS access

Database Tools: SQL Profiler, SQL Query Analyzer, Performance monitor, Activity monitor

Operating Systems: Windows 2000 Advanced Server, Windows 2003/2008/2008 R2/2012 Server, Windows 7/95/98/XP/Vista, Unix

Tools: Argent scheduler, Control-M, Unix Shell scripts, vi editor, event Monitor BT tool, Peregrine, PL/SQL, REMEDY, Visual Interdev, Visual Studio.NET, DTS, Info scheduler, BizTalk sever Admin, Peregrine, Remedy, Ab Initio, ServiceNow, Legato backup tool

Software products/ Languages: C#, VB,.NET, XML, ASP.NET, MS Access, MS BizTalk

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota

Production DBA

Responsibilities:

• Take part in New SQL Server project planning and implementation and guiding the team members in fixing issue
• Space Management: Monitoring and working on alerts for the spaces on servers exceeding the threshold as per Mail alert
• Patch Management: This comprises research, installation of service packs, hot fixes, SQL Patches, testing and rollout to production environments
• Involved in the KT session of the SQL Server for which the team and me was held as primary responsibility of transitioning
• Responsible for creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/ Check Constraints.
• Responsible for the Development and Debugging of Stored Procedures, User Defined Functions, Triggers and Queries.
• Designed Scripts for Reorganizing and Rebuilding Indexes and for updating statistics.
• Very good experiencing in rebuilding system database and restoring the system databases
• Managed databases in clustered/non-clustered environments.
• Creation and management of Transactional and Snapshot Replication store environment
• Creating and managing mirroring in Canada Environment
• Backup and recovery of System and Application databases.
• Monitor NT Event log for system, application errors, available disk space, Backup registry, keep emergency repair disk
• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Creation, Development and Maintenance of SSIS Packages.
• Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers with Maximum Database Availability, Reliability & Investigate and resolve any Database Related issues /performance related issues with Minimal Downtime & Maximum Reliability.
• Review/test/apply all database changes to all environments including QA, Development and Production Servers.
• Installing and upgrading sql server version 2016/2014/2008/2005
• Fine tuning the Database Settings as well as the Server Settings.
• Involved in Backup/Restore.Involved in Disaster recovery and created disaster recovery plan . Took part in Disaster Drills and took other proactive measures and received appreciation from customers.
• Backing up master & system databases and restoring them when necessary and supported production environment.
• Monitoring Schedules for batches and also resolving incidents involving batch processes, which include system sync, card fulfillment, data loads.
• Monitoring report and schedule the reports with help of info scheduler
• Providing immediate solutions on Database and data warehouse ETL issues.
• Monitoring and identifying the root cause during the Application run time and also provide recommendation on the same for better performance
• Daily reviewing of process logs. Verify and ensure the progress of cyclic jobs We are also responsible to maintain/manage load jobs and data migration jobs Executing SQL queries to validate the data loads in different business critical tables.
• Escalate problems to Developers or Subject Matter Experts during the batch-processing environment.
• Provide daily updates to Clients and Superior for review.
• Experiencing in problem management and incident management
• Software Documents helps to store and retrieve process.
• Mentored juniors in SQL database and development of SQL.
• Ensure timeliness and quality of deliverables is a default expectation
• Preparation of MOM
• Preparation of Knowledge based document for rookies
• Given training to the new rookies, process oriented training and business oriented training too
• Work with the manager to develop/implement action plans to achieve desired performance levels.
• Propagate positive teamwork across work groups & drive business results.

Confidential

Sr SQL server DBA

Responsibilities:

• Responsible to provide 24x7 production support for over 200 applications and 600 databases.
• Implemented the disaster recovery models like Replication, mirroring, log shipping and Clustering.
• Experience in archiving and retrieving the backups from Tivoli storage manager.
• Responsible for maintaining the security by creating SQL Logins and Roles.
• Used SQL profiler to solve the blocking, dead lock issues and long running queries and made recommendations.
• Experience in coordinating and applying the service packs and hot fixes on Clusters and standalone servers.
• Developed and automated daily, weekly and monthly maintenance plans for database backups, rebuilding indexes and database integrity and cleanup.
• Responsible for configuring monitoring on SQL servers with database mails, alerts and operators.
• Responsible for Data refreshes on Test and Development Servers on a regular basis.
• Backing up master & system databases and restoring them when necessary and supported production environment.
• Monitoring Schedules for batches and also resolving incidents involving batch processes, which include system sync, card fulfillment, data loads.
• Monitoring report and schedule the reports with help of info scheduler
• Providing immediate solutions on Database and data warehouse ETL issues.
• Propagate positive teamwork across work groups & drive business results.
• Escalate problems to Developers or Subject Matter Experts during the batch-processing environment.
• Provide daily updates to Clients and Superior for review.
• Call Handling, Error Identification, Incident Management and Incident Resolution.
• Peregrine - for ticket logging with the capability to auto generate e-mail alerts on generation of incident ticket and effecting dispatch requests.
• Software Documents helps to store and retrieve process.
• Mentored juniors in SQL database and development of SQL.
• Ensure timeliness and quality of deliverables is a default expectation
• Involved in creating DTS Packages to load data from flat files.
• Given training to the new rookies, process oriented training and business oriented training too
• Propagate positive teamwork across work groups & drive business results.