SUMMARY:

• Expert advanced, certified database professional with an impressive history of installing, configuring, and managing large, complex databases in SQL and Oracle environments.
• Several - time Microsoft TechNet Guru Gold winner for publishing in-depth technical articles which can be found
• Rank in the top 3 among the top contributors in Microsoft Developer Network (MSDN) forums.
• Regular speaker at PASS local user group conferences. SQL Saturday events and other community contributions can be found
• Effectively handles multiple tasks in demanding production environments; strong background in managing large business critical databases.
• Proficient in creating in-house database monitoring & automation tools which replace expensive third-party tools.
• Adaptable professional with expertise in all database administration tasks - installation, configuration, backups/restores, migration, maintenance, and upgrades.
• Enjoys identifying, isolating and resolving complex technical database issues.
• Adept in managing database security, backups, mirroring, performance tuning, High-Availability and Disaster-Recovery procedures.

TECHNICAL PROFICIENCIES:

Languages & Tools: T-SQL, SQL, PL/SQL, Java, Visual Studio, SSIS, SSAS, SSRS, SSMS, Visio, Outlook

Databases: MS SQL Server 2017/2016/2014/2012/2008 R2/2005, SQL on Linux, and Docker containers; Azure SQL Database (PaaS), SQL Server on Azure VMs (IaaS), Oracle 12c/11g R2

Development Tools: Operating Systems SQL Server Management Studio (SSMS), Azure Data Studio, Visual Studio, DataFlux, BIDS Windows Server 2016/2012/2008 R2/2008/2003, Red hat Linux, Oracle Linux, Docker Containers

PROFESSIONAL EXPERIENCE:

Sr. Database Consultant

Responsibilities:

• Provided 24x7 on- call database support for critical application databases.
• Supported and educated application programmers to make the most of the new SQL Server features.
• Planned, coordinated, and enforced security measures to safeguard data in the SQL and Oracle databases against accidental or unauthorized damage, alteration or disclosure.
• Led and executed two Business-critical multi-million dollar projects which involved complex mixed configuration of
• Provided the leadership role in supporting four tier-1 most critical database applications.
• Led the SQL Server Foglight and Oracle Golden Gate project through development and promotion to production.
• Developed SQL replication monitoring tool using T-SQL which avoided purchase of expensive, third-party programs.
• Designed and implemented tier-one BizTalk 2013 SQL architecture & promoted it to new active-active SQL cluster.
• Designed the architecture and upgraded eClinical Works application database to SQL Server 2016.

Lead Database Administrator

Confidential, San Antonio, Texas

Responsibilities:

• Led all of department’s SQL Server projects (In-house and Client side).
• Developed a standard build procedure for SQL Servers which comprised complete pre-installation and installation steps, post-installation activities and best practices required to improve overall performance.
• Created customized interactive SQL Server repository with Windows PowerShell, T-SQL, SSRS and SQL agent jobs which took the place of expensive outside alternatives.
• Developed many centralized solutions such as missing-backup alert system, jobs failure alerting solution, centralized SQL jobs backup tool which used customized stored procedures & SQL agent jobs.
• Designed multiple in-house tools for blocks, deadlocks, performance monitoring, index maintenance, etc.

State Database Administrator

Confidential, Little Rock, Arkansas

Responsibilities:

• Provided technical and administrative installation, configuration and maintenance of Confidential ’s critical, government distributed databases.
• Supported SQL Server production, testing and development environments.
• Performed daily backups/restores, query optimization, memory management, performance management and tuning of database servers.
• Resolved daily database configuration, change tickets, incidents and requests issues.
• Used customized scripts & built-in tools to migrate hundreds of gigabytes of data from Informix database to SQL Server; Developed customized RMAN backup scripts.
• Automated processes to transfer data back and forth between SQL Server and Oracle Servers.
• Simplified the Database performance monitoring with interactive parameterized SSRS histogram & pie-chart reports.
• Identified and fixed high CPU, disk I/O, deadlocks & poorly performing queries on mission-critical systems.

Database Administrator

Confidential, Little Rock, Arkansas

Responsibilities:

• Designed, installed, monitored, performance tuned and maintained university’s SQL Server and Oracle database systems.
• Managed backups and recovery, security updates, resolution of unplanned database issues/outages and regular optimization of students’ critical data.
• Designed a process to revise & update UALR students’ data in the BANNER database for submission.
• Performed Data Quality measures that include data profiling, cleansing and standardization.
• Debugged and rewrote code that led to bad data flow in the database.
• Created several automated database maintenance solutions for the database instances.
• Assisted applications programmers to tune queries & programs and effectively use SQL Server features.

Database Administrator/Developer

Confidential, Dallas, Texas

Responsibilities:

• Designed and implemented database solutions as the database administrator.
• Used standard and advanced applications and tools to ensure high-availability, and recoverable databases.
• Worked on testing and implementing new SQL Server features in the production environment.
• Created enterprise data management warehouse in SQL Server.
• Designed and implemented production environment High-Availability and Disaster-Recovery solutions including database mirroring, failover clustering, log-shipping and replication. Provided 24x7, on-call production support.
• Used built-in and third-party tools for database performance monitoring, reporting, and optimization.