Summary of Experience:

• 12 plus years of IT Experience in Database Administration, System Analysis, Design, Development & Production Support of MS SQL Servers 2008 R2/2005/2000, 7.0 and 6.5 in Production, QA, Development environments & Replication Environments.
• Microsoft Certified SQL SERVER Database Design and Implementation-70-229
• Testing and Distributed Database Environment.
• Experience in Data Modeling, Database Backup and Disaster Recovery procedures.
• Experience in MS SQL Server Installation, Configuration, Upgrading, Performance Tuning, Query Optimization, Backup/Recovery, Client/Server Connectivity and running Database Consistency checks Using DBCC.
• Experience in Supporting/Installing/Migrating Huge Servers/Databases in Clustered environment, troubleshooting the problems.
• Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge & Peer to Peer Transactional.
• Experience in Database Migration from 2000 to 2005/2008 & DTS to SSIS Packages.
• Experience in SSAS & SSRS
• Experience in Database Consistency Checks Using DBCC Utilities
• Experience in using Performance Monitoring tools Perfmon/Profiler/PSSD/Query Exec Plan/SQL Nexus/Spotlight Quest to solve Dead locks and performance issues
• Experience in configuring and managing Clustering in SQL Servers
• Experience in configuring and managing Log Shipping, DB Mirroring, Replication
• Strong analytical and conceptual implementing various projects on Client/Server applications.
• 10+ years of experience in MS SQL Server 2008 R2/2005/2000/7.0/6.5 Database Administration.
• Experience in Production Support (7 x 24), on call and Production environments.
• Experience in skills in database design, development and writing T-SQL Programming for implement Stored procedures, Functions and Triggers in MS SQL Server 2000/7.0/6.5.
• Extensive knowledge of Relational Database Management System.

Experience and understanding of Logical and Physical database design.

• Experience in working with Windows Server 2008 R2/2003/2000 Advanced Server and Windows NT Server
• VERITAS Storage Foundation VSF, EMC Netbackup (NBU),Sandpiper Backups, SFTP & NDM
• Excellent communication & interpersonal skills.

Education:

• Masters in Computer Applications
• Microsoft Certified Professional in SQL Server
• Project Management Professional.

Good Application Experience in

• Administration of MS SQL Server 2008 R2/2005/2000/7.0
• DBA Lead and maintaining multiple DBA’s/Systems
• Working on Clustering environment & On-call rotation basis providing 24X7 support
• Setting up Transactional Replication/DTS, SSIS, Database Mirroring, Log Shipping using Double Take in heterogeneous environment
• Working with Performance tools SQL Profiler/Perfmon/PSSD/SQL Nexus/Quest Spotlight
• Installed, configured and maintained more than 200 Servers of MS SQL Server 2008/2005/2000
• Maintained Windows 2003 /2008 Advanced Server and Windows NT.
• Sucessfully Upgraded/Migrated databases from MS SQL Server 2000 to 2005, MS SQL Server 2000 to MS SQL Server 2008 R2.

PROFESSIONAL EXPERIENCES:

Confidential,Dallas July 2010 to Till Date
Role: Sr. SQL Server DBA
Project: RETAIL COFEE Billing

The Frontier Converged Front End Engine - is a Billing Front End system for Finance Department which is used for viewing/adjusting the charges incurred by the customer towards his/her Voice, Data and Video lines, handling billing inquiries for the 13 States of the Frontier Footprint. Continuous enhancement and maintenance form the backbone of this project based on .NET Technologies and SQL Server. The Application supports Customer Payment Activity display, Follow-ups and Claims and Account Notations

• Monitoring and supporting 24X7 for 600 distributed servers (SQL Server 2012/2008 R2/2005/2000) on regular basis for 1200 databases with 20 TB databases.
• Leading teams of 5-10 people in size, help and mentor DBAs and managing the MS SQL Server teams
• Providing On-Call rotation with 24X7 Support
• Experience in database administration and support in MS SQL Server environments
• Administered MS SQL Servers by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Involved in creating Databases, Tables, Clustered/Non-Clustered Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions and Defaults
• Performed Database integrity Checks, updated Database Statistics and performed re-indexing on a daily basis
• Interact with various departments for new release and troubleshooting of applications
• Experience in migration and support of databases for Production, Integration and Development environments
• Working on Clustered environment and Log Shipping, Replication, DB Mirroring, SSIS,SSAS & SSRS
• Providing 24 x 7 Production support for the database and application issues.
• Experience in migration and support of databases for Production, Integration and Development environments (Change Management System).
• Experience in working with Data Modeling
• Working on Clustered environment and Log Shipping, DB Mirroring, SSIS
• Experience in Implementation of Production, Integration and Development environment, Hardware requirements and support
• In migration process involved into Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), Bulk Loading of Data through BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Experience on working with BRP (Business recovery plans) and capacity planning (number of boxes, amount of space, memory, rate of database growth).

Environment: SQL Server 2012, 2008 R2, 2008, 2005, SQL Server 2000 ,Windows Server 2003/2008 R2 Advanced Servers, SSIS, SSAS, SSRS, VB.Net, XML, BMC, VERITAS Storage Foundation VSF, Netbackup, SFTP,NDM,IIS,CMIS, EMC Backups,Perfmon,Profiler,PSSD,Spotlight performance tools, Runbook, Citrix Framework.

Confidential,TX Aug 2009 to June, 2010
Role: Sr. SQL Server DBA
Project: COFEE Billing Support-Project North

COFEE developed Application for Verizon Billing Operation. This system has been transformed from Mainframe Application to Client/Web Based Application Using .Net and SQL Server 2000/2005. Retail COFEE Ordering and Billing East and West is the primary order negotiation Verizon\'s National Desktop Application system for the East/West footprint. COFEE is used to take orders for consumer and general business LOBs and handles Voice (copper and Fiber), Data, Video and VASIP products and services. The target was to merge all the 34 East Regions Sections to be in 8 clustered box of each of total of 16 boxes. The Power of DTS (ETL) makes the loading the Daily Bills of approx. 50 GB in timely manner and was expecting the data for 4 regions of 40 TB for the whole year. The System was perfectly designed to fit the requirement of Bill Enquiry Application, where the Reps. create the Voucher Adjustments from any part of the Country. The query response time? Excellent Configuring, Performance Tuning, Back up Strategy, Planning and Designing, Physical Hardware Fact Sheet Preparing, On Call Support.

The purpose of this National Desktop Metrics portal is to monitor and observe key application measurements to help management make correct decisions to improve application performance. ND Metrics comprises of a suite of applications that provide metrics related to various applications in the National Desktop organization. The externally visible views of ND Metrics daily automated reports produced and distributed.

Responsibilities:

• Monitoring and supporting 24X7 for 130 East & West distributed servers (SQL Server2008/2005/2000) on regular basis for 4 TB databases.
• Providing On-Call rotation with 24X7 Support
• Experience in migration and support of databases for Production, Integration and Development environments (Change Management System).
• Experience in working with Data Modeling
• Working on Clustered environment and Log Shipping, DB Mirroring, SSIS
• Migration of databases from MS SQL server 2000, Oracle, MS Access to MS SQL server 2005.
• Experience in Implementation of Production, Integration and Development environment, Hardware requirements and support
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• In migration process involved into Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Working with MS DTC for the windows server 2003 and in cluster environment.
• Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), Bulk Loading of Data through BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.

Environment: SQL Server 2008/2005,SQL Server 2000 ,Windows Server 2003,2000 Advanced Servers, VB.Net, XML, BMC, Veritas 5.1, SQL Light Speed, IIS, CMIS Web

Confidential,TX Feb 2009 to Aug 2009
Role: Sr. SQL Server DBA
Project: VZQE CRMM

CRMM is web service used for qualifying different bundles, packages, products for a customer. It will handle the following modules. Qualifies the following things for a customer taking his geographical details.
Bundle Qualification:-
A combination of minimum of two out of VOICE, DATA and VIDEO forms a bundle. List of supported bundles and other geographical information comes from marketing department to the IT. Processing all the geo graphical filters for any input can qualify or disqualify a bundle.
Promotion Qualification:-
Promotion is an offer given to the customer when he takes a bundle. List of supported promotions and other geographical information comes from marketing department to the IT. Processing all the geo graphical filters for any input can qualify or disqualify a promotion for a bundle.
Responsibilities:

• Monitoring and supporting 24X7 for CRMM distributed servers (SQL Server2008/2005/2000) on regular basis for 1 TB-60 gb databases.
• Providing On-Call rotation with 24X7 Support
• Experience in migration and support of databases for Production, Integration and Development environments (Change Management System).
• Worked on Clustered environment SSIS, Replication
• Experience in Implementation of Production, Integration and Development environment, Hardware requirements and support
• In migration process involved into Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Working with MS DTC for the windows server 2003 and in cluster environment.
• Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
• Created SSIS packages to transfer data from SQL Server to Access, Excel, and text file
• Extracted data from SQL Server for report, backup, testing purposes
• Developed SSIS packages to download data from Oracle and flat files to SQL server.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, SSIS, DTS (i.e. Import and Export), Bulk Loading of Data through BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Experience on working with BRP (Business recovery plans) and capacity planning (number of boxes, amount of space, memory, rate of database growth).

Environment: SQL Server 2008/2005,SQL Server 2000 , NDM, Secure Plus, VSS, Windows 2003 Advanced Servers, VB.Net, XML, BMC, SQL Light Speed, IIS, SSIS Packages, SQL Litespeed, SQL Toolbelt