TECHNICAL SUMMARY

• 12 years of experience in IT Services and Operations with expertise in SQL Database Administration in a global 24x7 OLTP environment.
• Supported over 160 database servers of low to high complexity in Production, UAT, Test and Dev environments. Maintained 7 TB of database.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2008R2/2008/2005/2000/7.0 in standalone and clustered environments. Configured more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Experienced in migration of SQL Server from version 2000 to 2005/2008/2008R2.And documented the Upgrade process. Handful of Experience on SQL server new features like Microsoft SQL multi server administration, resource governor, performance data collector.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment. Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard. Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication Snapshot and Transactional with updatable subscriptions , Log shipping, Clustering Active-Active and Active Passive and Database Mirroring.
• Worked with Tivoli Data Protection TDP and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations , ETL Process Data Extraction, Transformation layer with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services SSAS , Reporting Services SSRS , Notification Services SSNS and MDX ad-hoc Reporting.
• Expertise on physical storage SAN configuration on different RAID levels.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Hands on experience with administering large databases, managed databases of size above 3 terabytes, database design, normalization and database application development using varied development tools.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Explicitly used third party tools like Litespeed, Fog light and Red gate, Tivoli Storage Manager TSM .
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Checking the threshold values and baselines and monitoring in perfmon and SCOM.
• Rebuilding indexes with different fill factors and updating statistics.
• 24 X 7 Production Database on Call Support.
• Experience in Database Security and Management
• Experience in Security Patches Hot fixes installation and management schedule-coordinate-install
• Experienced in performing various SQL Server 2000 2005, 2008R2 High Availability activities like Installation, Configuring and Maintaining SQL Clustered Servers Active/Active Active/Passive , Network load balanced servers, working with transactional Replication, Log Shipping and Database Mirroring.
• Created maintenance plans to perform Index De-Fragmentation, Re-Indexing and update the Index Statistics.
• Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, SSRS, DTS, BCP, BULK INSERT etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Good hands on experience on Resolving database performance issues and monitoring the growth of the database to ensure the smooth running of daily activities.
• Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the Tivoli Alerting System.
• Experience in strong SQL debugging skills, application level troubleshooting skills, experience with monitoring tools and techniques, good understanding of security practices.
• Experience in successfully resolving SQL Server problems in conformance with in SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security etc
• Experience in using tools like SQL Profiler and Performance counters for Monitoring, Fog light, Performance Analyzer and Tuning MS SQL Server Performance.
• Experience in working with Windows Server 2000/2003/2008.
• Experienced in creating/maintaining automation Scripts with SQL.
• Hands on experience in trouble shooting deadlock issues, resolving performance issues, data archival on every three months, rebuilding indexes.
• Self-motivated person with strong analytical, problem solving and communication skills. Capable of working under pressure and a good team player who can be flexible and work individually.
• Experienced in ITIL process Change Management, Release Management, Problem Management, and Incident Management and IT Infrastructure, Networking, and RAID environment.
• Experienced in query optimization, DMV's, Maintenance Plans, Upgrades
• Experienced in database designing, Normalization
• Assisted and supported customers, developers,QA's in database related issues
• Experienced scheduling all the alerts in database server using
• MOM,Tivoli,Maximo,Control-M,SQL default alerting system
• Experienced in writing SQLqueries,stored procedures, functions, triggers
• Upgrading to SQL Server 2008 Resources for SQL Upgrade with Consolidation /Virtualization experience
• TECHNICAL SKILLS
• Databases: MS SQL Server 2008R2/2008/2005/2000/7.0, Oracle, MYSQL
• Languages: T-SQL, C, C , C , vb.net, JAVA, ASP.NET, Visual studio2005/2003
• Technologies: VB.NET, .NET FRAMEWORK, ASP.NET, Microsoft Office Suite, Share Point.
• Tools: Active X, IIS, MTS, Litespeed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, SharePoint Designer 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM
• Operating System: Windows 2000, Windows NT, Windows Server 2003/2008/2008R2, Windows 95/98/XP/Vista/7.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

• Currently I'm handling 190 critical database, application, web servers. And 2000 databases around the globe. Our largest database size is 7TB.Our overall average database size is 50GB.In our environment 18000 transactions per second going on during business hours.
• Worked in Active passive cluster environment.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• SQL Server 2K8 R2, 2K8 2005 Database Administration.
• To handle the migration of SQL Server 2000 to SQL Server 2008 2K8 R2.
• Responsible to Monitor and troubleshooting Log Shipping.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Used Data Partitioning, Snapshot Isolation.
• Update statistics, database integrity check and Backup operations
• Expertise in SQL server Reporting Services SSRS
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Expertise in creating and supporting in OLAP Cubes
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Daily tasks of Developer/DBA like space issues on Production and Semi-Production Servers and handling maintenance Jobs handling and user's permissions.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Performed Performance Tuning of the Stored Procedures.
• Experience in trouble shooting database issues.
• Monitoring SQL server performance using profiler to find the performance and deadlocks.
• Experience in using ERWIN tool for designing the reporting databases.
• Performance Monitoring using SQL Profiler and Windows System Monitor.
• Backup Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• SQL Server installation, configurations, backup/restore handled large databases Monitoring SQL Server agent jobs and troubleshooting the Trouble tickets
• Space optimization Working knowledge of SQL Server advanced technologies e.g. Replication, Log Shipping
• Configuring perfmon, blocking analysis, Enabling of AWE and PAE, Maxdegree Parallelism.
• Installation of SQLSERVER 2005, service packs, hot fixes, Security patches, Litespeed.
• Practical experience in managing the internal and external MS SQL database security
• Install SQL Server instance and database including Service Pack , Upgrade SQL Server Service Pack
• Environment: SQL Server 2012,2K8R2, 2K8 2005 with clustering, Replication DBM

Confidential

SQL DBA

• Responsible for day-to-day support of SQL databases for all the mission critical credit card databases High OLTP
• To provide day to day support to user queries and customer advice Due to the nature of the environment, there is often a necessity to carry out scheduled work outside of Working hours.
• SQL Server Performance Monitoring and problem resolution
• Excellent team working skills balanced with ability to work alone and a positive attitude.
• Backing up System, User databases Complete Backup, Differential Backup, Transaction log backup and Scheduling
• Restoring Complete Backup file restore, Differential Backup file restore, Transaction logs backup files restore , Monitoring Error Logs, Jobs
• Trouble shooting Memory Bottlenecks log , D-drive space issue, Blocking etc Worked on basic Administration, DTS packages, Database Security, Performance Tuning, Worked on the KFS PCI SOX Compliance MAPI areas Managing Database vs. Data files .Mdf, .Log files Hands on Experience in Enterprise, Standard Edition, Developer edition Personal Edition Creating Databases, Database Size estimation, File growth, log data files System User Databases Maintenance and Administration Setting Database properties, SP Migration, Tables migration, Database Security Available production support for 24 7 whenever required. Worked on ITIL process Ticket handling, Change Management, Problem management, Incident management. Support International customers to fulfill their MS SQL SERVER DB Maintenance and Administration needs
• Expertise in SQL server Reporting Services SSRS
• Worked on tickets sent by customers for migrating objects and data from test server to production server, restoring and backing up databases in production environment.
• Environment: ASP, MS SQL Sever 2005, 2000 Windows NT/XP, VB, Query Analyzer, Enterprise Manager, MS Access and SSIS,Veritas net backup, Tivoli,Share Point.