SUMMARY

• Over all 10 years of experience with 9 years of experience managing SQL Server DBA in PRODUCTION, DEVELOPMENT, QA and UAT environments
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2012/2008 R 2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.
• Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions(HA) using Database Mirroring and Log Shipping.
• Provided 24/7 and On - call Support for PRODUCTION environment
• Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
• Expertise in VMWARE and managing multiple SQL Server Instances on VMWARE
• Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE replication
• Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups
• Used third party tools like Redgate, SQL Litespeed and Netbackup for Backups
• Used IDERA, FOGLIGHT and SQL Sentry for Monitoring and Performance tuning
• Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2
• Expert in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD
• Extensive use of SQL Server DMV's for Performance Tuning.
• 5+ years experience in SSIS/SSRS
• Created heavy duty SSIS packages and deployed the packages from development to different environments
• Worked heavily on SSIS transformations and layed out strong SSIS packages
• Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.
• Performed Capacity Planning, Data Modeling and Logical/Physical database design.
• Performed Logical/Physical Modeling and Reverse engineering with ERWIN and VISIO
• Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
• Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Experience in resolving Database Performance, Capacity and Distributed data issues.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.
• Created extensive reports using SSRS (Tabular, Matrix)
• Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Data Warehouse concepts.

TECHNICAL SKILLS

Databases: MS SQL server 2012/2008 R 2/2008/2005/2000

Operating Systems: Windows NT/98/2000/XP/Vista/2003, 2007, VMWare

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE

Confidential, Durham NC

SQL SERVER DBA

Responsibilities:

• Production support for SQL server environment.
• Installing and configuring of SQL Server 2008, 2008R2 and 2012.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV’s).
• Worked with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
• Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Installed SQL 2012 for SharePoint services
• Patched server with latest SQL Server service packs and Cumulative updates.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Performed DBCC utilities and fixed data corruption in User databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers & maintained Referential Integrity.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, captured long running SQL/runaway queries.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Controlled user access rights, and managed data security.
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
• Implemented Backup and Restore in SQL Server using Third party tool LITESPEED,SQLSAFE.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Environment: MS SQL Server 2000/2005/2008/2008 R2/2012, Windows 2000/2003/2008 R2/2012, TSQL, Litespeed, SQL Job Manager, RegGate tools,Idera tools, Quest tools.

Confidential, Omaha, NE

SQL SERVER DBA

Responsibilities:

• Worked primarily as a PRODUCTION support DBA giving 24/7 Support
• Managed PRODUCTION, DEVELOPMENT, QA and UAT environments
• Worked extensively on Virtual and VMware Environments.
• Worked on ACTIVE/ACTIVE and ACTIVE/PASSIVE clusters
• 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 setting up and managing Snapshot and Transactional Replication
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring and Log shipping for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 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.
• Worked on creating SSAS cubes and laying out SSAS designs
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application. created extensive SQL Server Integration Services (SSIS) packages for ETL.
• Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2 created database logical/physical modeling with ERWIN
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Heavy migration using SSIS, DTS and Data Integrator.
• Used SSRS for daily client reporting.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2012/2008 R2/2005/2000, VMware, Virtualization, SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2000 and 2005 environments.
• Involved in Migration from SQL 2000 to SQL 2005.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
• Managing security tasks like granting and revoking permissions

Environment: Windows Server 2000/2003, VMware, SQL Server 2005, Windows 2003, DTS, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Database Administration for Development, Test and Production servers with MS SQL Server 2005 on Windows 2000/2003.
• Administered MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring user accounts, creation of groups, granting the privileges to users and groups.
• Created DTS package to export and import data from SQL Server to Access, text and excel files.
• Checked performance tuning, indexing and query optimization.
• Used database consistency checks using DBCC utilities.
• Implemented Snapshot Replication and Transactional Replication.
• Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: Windows Server 2000/2003, MS SQL Server 2005/2000, XML and Erwin.

Confidential

System Administrator Engineer

Responsibilities:

• Performing installation configuration and up-gradation of ATM machines for various financial institutes and banks.
• Installation of software & networking ATM’s.
• Upgrading hardware in ATM’s.
• Troubleshooting and break fixing in ATM’s on daily basic.
• Understands and performs the various customer Service requirements and elevates or escalates issues when appropriate, and/or according to established procedures.
• Communicates to all levels - Service/Installation Coordinator/Customer/Control Tower.
• Installing hardware like smart card readers, Encrypted Keyboards, memory’s and EPROM Chips
• Installing Mother Board, ssp board and NIC cards on the Phantom, Pele II Core machines
• Upgrading Encryption keys, IP Addresses local and remote systems with gateways address
• IP migration on the client systems