TECHNICAL SKILLS:

Operating Systems: MS DOS, WIN 95/98/NT/2000/2008,2012 and 2016, Strong knowledge of Windows Active Directory, HP - UNIX, IBM AIX UNIX, SCO - UNIX and XENIX

Software: 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 2016/2014/2012/2005/2000/7.0/6.5, SYBASE Adaptive Server 11.9.2 /11.5/11.0, SYBASE System 10/4.2, DB2, Informix and TERADATA. Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. Expert in creating cubes using SSAS. Proficient in using Visual studio 2010,2012 and 2015 to create reports, packages and cubes, Microsoft Dynamics AX - 2012 - R2.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server(TFS) Proficient.

Programming Languages: SQL PLUS, T-SQLC, C++, Borland C++, Visual C++, COBOL, JavaScripting Languages: Perl, VBScript, BASH, KORN and C Shell, POWERSHELL and Python

PROFESSIONAL EXPERIENCE:

Technical Consultant

Confidential, Dallas, TX

• Provide database administration support of SQL Server instances in SQL 2008, 2012, SQL 2014 and SQL 2016 and Oracle 11g and 12c instances, MongoDB instances and support for Golden Gate Replication for SQL Server. SQL deployment using TFS and PowerShell automation scripts.
• Lead the project for Disaster Recovery exercise using Log Shipping and database mirroring features of SQL Server.
• Setting up hardware, Maintaining users and groups for SQL Server in Active Directory, Participate in On-call rotation to support production databases.
• Design, Setup and Implementation of various SQL 2014 “Always On” instances for high availability and disaster recovery.
• Design, setup and implementation of SQL 2016 cluster 2 nodes for BIZTALK application.
• Maintaining and Setup Transaction Replication with remote distributor with more than 30 publications and subscriptions to push data catering to various application needs including data warehouse and reporting usage.
• Created stored procedure using nodes method to load XML file data into SQL server tables. Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Created SSIS Packages/SSAS Cubes projects to move data mining data from source to destination using Visual Studio 2013. Created logic and indexed tables/views/stored Procedures based on the business requirements.
• Developed new and modified existing SSRS reports for Microsoft Dynamics AX 2012.

Confidential, Austin, TX

Senior Database Administrator/Lead

• Provide database administration support of SQL Server instances in SQL 2008, 2012 and SQL 2014 and TeraData instances.
• SQL and TeraData deployment using TFS and PowerShell automation scripts.
• Setting up hardware, Maintaining users and groups for SQL Server in Active Directory, Participate in On-call rotation to support production databases.
• Installation of SQL instances using Azure and AWS storage.
• Created stored procedure using nodes method to load XML file data into SQL server tables. Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Created SSIS Packages/SSAS Cubes projects to move and data mining data from source to destination programmatic by using Visual Studio 2012. Created logic and indexed tables/views/stored Procedures based on the business requirements.

Confidential, Los Colinas, Irving, TX

Senior Database Administrator

• 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 implementation 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. Install, Upgrade, administration and configuration of Microsoft Dynamics AX 2012 for production and non production environments.
• 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 Always On,SQL cluster 2008/2012/2014 and stand alone instances on VMWARE virtual servers.

Confidential, Fort Worth, TX

Senior Database Administrator

• 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.I nstall, Upgrade, administration and configuration of Microsoft Dynamics AX 2012 for production and non production environments.
• 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.

Confidential, Addison, TX

Senior Database Administrator

• 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. Participate in On-call rotation to support production databases.

Confidential, Addison, TX

Senior Database Administrator

• 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.
• Participate in On-call rotation to support production databases.
• Participated as a member of Disaster Recovery.

Confidential, STAFFORD, TX

Sr. SQL Server Enterprise Production DBA

• 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

• 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

Consultant - Contract

• 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

• 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

Consultant - Contract

Confidential, Irving, TX

• Designed new job process, new database maintenance plans, DTS programs to export and load data into SQL Server and did performance tuning of the existing processes.
• Designed and developed automated process for data extraction and loading for Data warehouse process.
• Performance tuned and rewrote stored procedures for data extraction for Data warehouse process.
• Installed and configured SQL server for a data warehouse project. Installed and setup backup jobs using Quest LiteSpeed for SQL Server backups. Recommended Hardware for the set up of the SQL Server.

Environment: Windows 2000 Data Center Server, Microsoft SQL Server 2000