PROFESSIONAL SUMMARY:

• SQL Server DBA - 18 years
• SQL Server 7/2000 - 10 years
• SQL Server 2005 - 8 years
• SQL Server 2008 - 5 years
• Oracle DBA - 8 years
• Oracle 8i/9i/10g/11g - 9 years
• Production Support - 11 years
• Performance Tuning, Optimization - 10 years
• T-SQL, Stored Procedures, Triggers - 18 years
• DTS / SSIS- 8 years
• Quest SQL LiteSpeed-8 years
• Microsoft Reporting and Analysis Services -5 years
• Data Warehouse - 4+ years
• Sybase ASE 11/12.5/15 - 8 years
• Star Schema - 6 years
• Data Modeling - 6 years
• Erwin - 3 years
• Architecture - 9+ years

TECHNICAL SKILLS:

Software: MS DOS, WIN 95/98/NT/2000/XP, HP-UNIX, IBM AIX UNIX, SCO - UNIX and XENIX, PowerBuilder, Visual Basic 5.0, Visual FoxPro, BusinessObjects 5I, Query Analyzer, SQL Advantage, Sybase Central, Enterprise SQL Manager, DBArtisan, Spotlight, Log Explorer, TOAD, Rapid SQL, SQL Plus, PCAnywhere, Proxy, ERwin, Power Designer, Oracle 8i/ 8.0/7.3/6.0/5.0 , MS SQL Server 7.0/6.5, Sybase Adaptive Server 11.9.2 /11.5/11.0 , Sybase System 10/4.2, DB2, Informix

Languages: SQL, T-SQLC, C++, Borland C++, Visual C++, COBOL, Java 2, SQL, Perl, VBScript, KORN Shell and POWERSHELL

EMPLOYMENT HISTORY:

Confidential, Irving, TX

Senior Database Administrator

Responsibilities:

• Provide database administration support of SQL Server instances.
• Provided SQL Server database support and consulting to various application teams.
• Support includes on-call support, routine DBA tasks such as backup and recovery of full databases using SQL Safe and native backup tools, performance tuning of T-SQL and database performance tuning on Windows 2008 R2 multiprocessor shared database environments.
• Implementation of various SQL 2012 “Always On” instances with the help of Microsoft Engineer training. Setup Transaction Replication to send data to external client sites. Scale out implemntation of SQL 2012 Reporting Services.
• Implemented, documented and support builds of new clusters using SQL 2008 R2/SQL 2012 and Windows 2008/R2 on VMWARE systems. Installed and setup backup jobs using Idera's SQL Safe tool for SQL Server backups.
• Provided support for in house applications, Microsoft dynamics,CRM and SharePoint using SQL Server databases.
• Excellent Windows Power Shell scripting knowledge. Developed Powershell scripts to monitor SQL instances and also setup alerts. Setup alerts using service broker event notifications and also used SQL Sentry to monitor SQL Server databases.
• Installed/Upgraded builds of new SQL cluster 2008/2012 and stand alone instances on VMWARE virtual servers.
• Lead engineering effort, implementation and documented new installs, security and standards for all SQL Server environments.
• Job responsibilities included primary focus on SQL Server database administration.

Confidential, FortWorth, TX

Senior Database Administrator

Responsibilities:

• Provide database administration support of SQL Server and Oracle database instances. Provided Oracle and SQL Server database support and consulting to various application teams.
• Support includes on-call support, routine DBA tasks such as backup and recovery of full and partial databases using RMAN/NetBackup, performance tuning of T-SQL and PL/SQL code, system and database performance tuning on Windows 2008 R2 multiprocessor shared database environments. Setup SQL Log Shipping for disaster recovery and reporting needs.
• Implemented, documented and support builds of new clusters using SQL 2008 R2 and Windows 2008/R2 on VMWARE systems. Installed and setup backup jobs using Quest LITESPEED for SQL Server backups.
• Provided support for in house applications, Microsoft dynamics,CRM and SharePoint using SQL Server databases.
• Excellent Korn Shell and Windows Power Shell scripting knowledge. Developed scripts to monitor and also setup alerts using Korn and power shell scripting language. Setup alerts using service broker event notifications and also used SCOM to monitor SQL Server databases.
• Installed/Upgraded builds of new SQL cluster and stand alone instances on VMWARE virtual servers.
• Lead engineering effort, implementation and documented new installs, security and standards for all SQL Server environments. Job responsibilities included primary focus on SQL Server database administration.

Confidential, Addison, TX

Senior Database Administrator

Responsibilities:

• Provide database administration support of SQL Server and Oracle database instances.
• Provided Oracle and SQL Server database support and consulting to various application teams.
• Support includes on-call support, routine DBA tasks such as backup and recovery of full and partial databases using RMAN/NetBackup, performance tuning of T-SQL and PL/SQL code, system and database performance tuning of Solaris, Linux and Windows 2008 R2 multiprocessor shared database environments.
• Provided support, installation, upgrade of Oracle Enterprise Manager Grid Control and Agents.
• Provided support for Oracle RAC and ASM, including applying patches, performance tuning, backup and recovery issues with RMAN/NetBackup and trace analysis Oracle instances on Solaris and Linux.
• Implemented, documented and support builds of new clusters to use Oracle 10g/11g/11gR2 and SQL 2005 and 2008/R2 databases on Solaris, Linux and Windows 2008/R2 systems.
• Installed and setup backup jobs using Idera and Quest LiteSpeed for SQL Server backups.
• Provided support for SQL Server in house applications and Oracle and Oracle Apps like PeopleSoft HR and Finance modules and Hyperion databases.
• Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g and 11g databases, including RAC (Real application Clusters ) databases on Solaris and Linux. Also, migrated few Oracle instances from Solaris to Linux systems.
• Excellent Korn Shell and Windows Power Shell scripting knowledge. Developed scripts to monitor and also setup alerts using Korn and power shell scripting language. Setup alerts using service broker event notifications and also used SCOM to monitor SQL Server databases.
• Installed/Upgraded builds of new SQL cluster instances on VMWARE virtual servers.
• Lead engineering effort, implementation and documented data masking project for NON-PROD SQL Server and Oracle environments.

Confidential, Addison, TX

Senior Database Administrator

Responsibilities:

• Provide database administration support of SQL Server, Oracle and SYBASE database instances.
• Administered ULTIPRO Payroll databases and doing ULTIPRO installations.
• Setup, managed SQL Server Merge and Transactional Replication in SQL 2005, ASE Replication
• Installed/Upgraded SQL instances on Citrix XEN and VMWARE virtual servers.
• Installed and maintained SQL Clusters (Active and Passive Setup).
• Administered SQL Server Data Warehouse databases
• Installed, upgraded and maintained (ASE 12/15 Sybase/MS SQL server 2005/2008/ Oracle 9i/10g/11g database instances) in dev, test and prod environments.
• Administered SQL Server versions 2005, 2008 cluster environment instances.
• Installed and setup backup jobs using Quest LiteSpeed for SQL Server backups.
• Administered Sybase 15 instances included bi-directional replication instances.
• Administered Oracle 9i/10g/11g Oracle instances.
• Responsible for Performance and tuning of SQL Queries and Stored Procedures.
• Participated as a member of Disaster Recovery.

Confidential, STAFFORD, TX

Sr. SQL Server Enterprise Production DBA

Responsibilities:

• As, Enterprise DBA/IT manager, had direct management responsibility for a team of three DBA staff members managing about 60 SQL Servers.
• Initiated and set up the disaster recovery procedures and methodologies appropriate for the information infrastructure and SQL to mitigate risks.
• Performed hardware upgrade to a production SQL server.
• Identified eminent network bottleneck on SQL Server due to application's design and database requests. Suggested design change in application. It was done, and problem was avoided.
• Set up enterprise wide systems and environment monitoring. For SQL Server, used the Maintenance jobs, coupled with monitoring, to ensure that good backups of the whole SQL Server were taken each night using SQL LiteSpeed.
• Provided swift response to production issues raised by Customer Support or Development teams 24x7.
• Responsible for High Availability Architecture and Setup
• Performed Cluster Architectural analysis for setting up high availability environment, Needs analysis, System analysis and Technology review.
• Clustered Active/Passive 64 bit environment using HP DL 380 2 Quad core processors.
• Implemented ten nodes in two cluster (6+1, 2+1) environments using HP DL 380 servers.
• Implemented two node (1 + 1 Active/Passive) cluster using IBM 390 servers.
• Performed Database migration from non-cluster to clustered environment.
• Installed and setup backup jobs using Quest LiteSpeed for SQL Server backups.
• Used SQL LiteSpeed log shipping tools to migrate 500 databases residing on ten different non clustered SQL server 2000 and 2005 environment to a clustered environment with a very little or minimal downtime.
• Responsible for Disaster recovery
• Utilized LiteSpeed Log Shipping to keep a warm spare ready to set up disaster recovery. Evaluated backup procedures.
• Implemented disaster recovery procedures using SQL LiteSpeed Log shipping.
• Responsible for Replication
• Analyzed requirements and moved all DTS jobs to transfer data from one SQL server to another by setting up transactional replication for various SQL servers at the enterprise level and was able to reduce the network traffic caused by huge data transfer using SQL jobs.
• Recommended topology and any necessary infrastructure changes.
• Provided replication training.
• Performed Initial implementation of replication.
• Periodic review of performance and operation of system.

Confidential, WestLake, TX

Sr. SQL Server 2005 Production DBA

Responsibilities:

• Worked as a Sr. SQL Server/DB2 DBA.
• Used Star quest data replicator tool to extract data from DB2 to SQL server for reporting needs using Microsoft Reporting Services.
• Upgraded all the SQL 2000 environments to SQL 2005 (25 servers) to 32 and 64-bit environment. Implemented full backup schedules taken daily using backup, transaction log backup every hour.
• Used SQL LiteSpeed to take compressed backups and do table level restores.
• Installed new 64 bit 2005 SQL servers as well as maintained and administered 25 other servers and involved in the support of all the followings phases of database operations: Backup/restore
• Installed and setup backup jobs using Quest LiteSpeed for SQL Server backups.
• Monitoring Security
• Capacity planning
• Performance analysis and tuning
• Infrastructure planning and implementation
• ETL and archive routines.
• Upgrade and Service Pack applications.
• Responsible for all phases of data architecture including requirements gathering, data modeling, physical implementation.
• Provided production support of day-to-day SQL server instances operations in a clustered and non-clustered environment.

Confidential, Fort Worth, TX

Sr. SQL Server Production DBA

Responsibilities:

• Installed new 2000 SQL servers as well as maintained administered 40 other servers.
• Recommended SAN drives and RAID configurations.
• Performed data modeling, backups, recovery and transactional replication.
• Designed and implemented a disaster recovery system for the company.
• Full Backup schedules taken daily using backup, transaction log backup every hour. Installed and used SQL LiteSpeed to take compressed backups and do table level restores. Set up transactional replication from live to report server. Set up DTS packages to bring data from AS/400 for the company web applications and reported usage.
• Performance tuned stored procedures and changed table schemas. Created proper indexes based upon the commonly used SQLs and stored procedures.
• Used Microsoft Reporting and Analysis Services and provided the company reporting solution for reports, data warehouse and datamart solutions.
• Used Data Mirror tool to replicate live data from AS/400 to SQL.
• Tested Legato tool for High availability.
• Data migration from AS/400 and Oracle to SQL Server 2000.
• Recommendations on Hardware architecture for proper usage of SAN.
• Conducted case study for the upgrade to SQL 2005.

Environment: Windows 2000, Windows 2003, VBScripting, Quest Spotlight, ERStudio, Microsoft Visio, Excel, Access, SQL Lite for Backups and Restore, Microsoft SQL Server 2000, Dell Servers, Dell Storage servers, Data mirror, MOM, Spotlight etc.

Confidential, Bedford, TX

Sr. SQL Server 2000 Production DBA

Responsibilities:

• Installed new 2000 SQL servers as well as maintained 12 other servers.
• Data modeling, backups, recovery, stand by using log shipping and transactional replication.
• Designed and implemented a disaster recovery system for the company.
• Backup schedules were taken twice a week for full backup, daily incremental backup and 15-minute transactional log backup. Installed and Used SQL LiteSpeed to take compressed backups.
• Set up transactional replication from live to report server. Set up Microsoft Reporting and analysis services and provided the company reporting solution for reports, data warehouse and datamart solutions.
• Used DBArtisan tool version 8.0 Quest Spotlight, Lumigent Log Explorer etc. for daily database administration tasks.
• Created DTS packages and stored procedures to bulk load data for contract and claim files from different file formats into SQL Server.

Environment: Windows 2000, Windows 2003, DB Artisan 7.1, Quest Spotlight, ERStudio, Microsoft Visio, Excel, Access, SQL Lite for Backups and Restore, Microsoft SQL Server 2000