SUMMARY:

• Around 8 years of experience as a SQL Database Administrator with Banking, Clinical and Financial Sectors.
• Good Experience in installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with hot fix and service packs
• Good experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, clustering and Mirroring on physical and virtual machines.
• Solid experience in MS SQL 2008 R 2/2008/2005/2000 database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Good experience on MS SQL Server 2012 server builds and up gradations from lower editions.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2000/20 R2.
• Proficient with client tools SQL Management Studio, Configurations Manager and Upgrade Advisors, BIDS, report builder 2.0.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard .
• Good Experience on scheduling database maintenance jobs like DBCC Check DB, Update statistics and Index rebuild jobs and troubleshooting failures.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.
• Strong understanding of components of SQL Server Architecture and Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping and creating Linked servers and troubleshooting the same.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Proficient with database backup and recovery models.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, Blocking, accessibility and efficiency.
• Experience in Troubleshooting all database related issues.
• Expertise in Installs, deployments, renewals, service accounts resets, add patches, performing upgrades / migrations, process job tickets & bugs, test verify backups and recovery.
• Expert in performance tuning and handling blocking situation and dead lock situations.
• Experience in troubleshooting blockings and log space issues and Tempdb issues.
• Experience in Migrating SQL Server 2000 to SQL Server 2005 and higher versions.
• Assist Internal DBA’s with SQL server 2012 builds (100+ SQL Servers) Installation, and configuration
• Storage Management and provisioning Backup/Restore Setup, Process and Documentation using NetBackup
• Server Monitoring, Compliance, Alerts and Notification Setup and documentation
• Set up SQL cluster and Availability groups and Always on technologies
• Act as a backup to internal DBA’s assist in test efforts
• Assist with maintenance setup SQL databases, Replication and Link Server setup
• Experience with 2005 new concepts like data partitioning, online indexing, DDL triggers, DMV, DMF, DTA, SSIS and performance dash board.
• Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Good experience with Integration, Reporting and Analysis Services.
• Good experience in analyzing the execution plan and index management for better Query Optimization.
• Good experience in Identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Explicitly used third party tools like Lite Speed, Fog light and BMC Patrol.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Actively involved in management of Change Control Requests.
• My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Databases: MS SQL Server R 2/2008/2005/2000

T: SQL, VB.NET, C# ASP. NET, C/C++, Java

DBA: Database Administration of MS SQL Server 2012,2008, 2005,2000

Operating System: Windows 2000/2003/2008/ XP/VISTA/7, Sun Solaris 9

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, MS Office Suite

Tools: Performance Monitor, Backup Utility, BMC Patrol, SQL LiteSpeed, FogLite

EXPERIENCE:

Confidential, NJ

SQL Server DBA Consultant

Responsibilities:

• Providing 24/7 support for critical production databases.
• Providing Primary DBA responsibilities for around 10 applications.
• Migrated the SQL Server 2008 to SQL Server 2012.
• Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
• Managed 200+ databases and few huge databases which are more than 5TB.
• Installed of MS SQL 2012 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications (begin to end support)
• Monitoring the data files, log file space issues, blockings, Tempdb space issues.
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.
• Working with BMC Patrol(Monitoring tool) and Litespeed(Backup tool)
• Administering the MS SQL Server 2012, 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Performed Physical and Logical Data Modeling using Erwin tool for databases of varied sizes including VLDBs.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Migrating the database from existing 2000/ R2/2012 servers.
• Involved in General Database Administration, Query Performance tuning.
• Involved in projects like(Script Automation & ESM Remediation)
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC Utilities like DBBCC DBREINDEX,DBBCC INDEXDEFRAG, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012 , Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working with Nexus Tickets (Any changes on staging and development environment need to Create Nexus Tickets)
• Working with Change Request(Any changes in Production database need to Create CR Tickets this should be approved by Global DBA team after changes made in stage and development environment)
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Environment: Windows 2008/2003/2000/ NT4.0, MS-SQL Server 2012/2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight and BCM PATROL LiteSpeed.

Confidential, Chicago, IL

SQL Server Production DBA

Responsibilities:

• Involved in installation, configuration, and upgrade MS SQL Server 2000/2005/2008 servers.
• Involved in Data modeling, designing and building Relational Databases using Tools like Erwin and SQL Database Diagrams.
• Performed huge data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
• Heavily involved in writing stored procedures with complex logic for both Reporting needs and DBA Script libraries.
• Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
• Setting up monitoring through batch scripts
• Installing, upgrading and applying the latest service packs/hot fixes.
• Provided High availability through Clustering, Mirroring, Replication (Transactional)
• Production database administration of highly critical databases.
• Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments.
• Installation of SQL Server 2005. Upgrading SQL Server 2000 to SQL Server 2005 using side-by-side methods

Environment: Windows 2008/2005/2003/2000/ NT4.0, MS-SQL Server 2012/2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, BMC Patrol, LiteSpeed.

Confidential, PA

Database Administrator

Responsibilities:

• Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS (ETL).
• Created DTS packages for the data cleansing/transfer (ETL) and transformation.
• Designed Database Schema using third party tools.
• Created job schedules to automate the routine tasks.
• Performed Database Normalization.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Generated report using Microsoft report analyzer.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Migrated old DTS packages into SSIS packages.
• Determine the problems such as dead lock, blocking and fix the problem.
• Partitioned tables, Views to run query faster.
• Administering the MS SQL Server 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Monitoring and troubleshooting blockings and log space issues and Tempdb issues.
• Supported 24*7 production support and solved all kinds of critical problems.

Environment: Windows 2008/2005/2003/2000/ NT4.0, MS-SQL Server 2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, BMC Patrol, LiteSpeed.

Confidential

Jr SQL Server DBA

Responsibilities:

• Migrated the SQL Server 2000/2005 to SQL Server 2008 versions.
• Installed of MS SQL 2008 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications (begin to end support)
• Monitoring the trace files, and Alert log file.
• Responsible for troubleshooting of the connectivity problems for end-users
• Working with Fog light(Monitoring tool) and Lite speed(Backup tool)
• Administering the MS SQL Server 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Migrating the database from existing 2000/ .
• Involved in General Database Administration, Query Performance tuning.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012 , Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working with Nexus Tickets (Any changes on staging and development environment need to Create Nexus Tickets)

Environment: Windows 2008/2003/2000/ NT, MS-SQL Server 2008R 2/2008/2005/2000 , SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Foglight, LiteSpeed.