Data Dba
Resume:
Si Vuong
Houston, TX *****
*******@*******.***
EXPERIENCE:
SQL DBA, Deloitte – Dallas, TX
**/**** – Present
•Troubleshoot and/or execute tasks based on ServiceNow tickets.
•Deploy/Build database servers for new applications and disaster recovery efforts.
•Preparation work and testing of DR systems.
•Deploy code/SSIS packages to various environments. Environments are 75% VM and 25% physical.
•Tune and troubleshoot database servers as needed.
•Tune and troubleshoot SSIS packages for migration of data in preparation for final migration.
SQL DBA, Y&L Consulting – San Antonio, TX
6/2016 – 10/2018
Southwest Research Institute Assignment
•Create Auditing process for data load database that conforms to external auditing rules using triggers and secondary server for data history storage.
•Create performance baseline and provide recommendation for process improvement of database server.
•Implement plan for improvement of database server processes and provide hard evidence of what areas improvements were in as well as percentage of improvements from baseline.
BioBridge Assignment
•Perform discovery of environment for inventory and tuning efforts. Inventory consisted of SQL Server versions 2008 through 2016.
•Created baseline for all discovered production database instances for analysis for possible tuning efforts. Created a recommendations report for tuning efforts as well as consolidation efforts.
•Implement plan for improvement of database server processes and provide hard evidence of what areas improvements were in as well as percentage of improvements from baseline.
SQL DBA, Crius Energy/TriEagle Energy - Stamford, CT/Woodlands, TX
9/2015 – 5/2016
•Tune On-Premise (VM) and Off-Premise (Azure) SQL Servers (v2014/v2016) for data loads and transaction processing. Troubleshoot query response time degradation in daily data loads.
•Monitor and capture metrics to establish baselines for continuous systems response time improvement.
•Implement log shipping as an option to staging new DB systems into the environment.
•Troubleshoot daily processes relating to on-premise and off-premise database systems.
•Resolve daily SSIS package failed executions in a SQL Server 2012/2014/2016 environment.
•Establish documentation for database processes and create runbook for the resolution of critical jobs in the event primary support person is not present.
SQL DBA, Cognizant Technology Solutions - Houston, TX
10/2013 – 8/2015
EZCorp Assignment
•Tune and troubleshoot production queries with in house tools. Maintain and standardize indexes and related structures for optimum transactional throughput. Also troubleshoot related SSRS and SSIS errors.
•Acted as primary database resource for all conversion/migration projects.
•Create and automate central repository for code releases using GitHub. Created an automated process for stored procedure production releases.
•Troubleshoot coding issues related to performance involving distributed systems.
•Created Blocking monitor process to trap and notify team of blocking transactions that are critical to system throughput using combination of Event Notifications and Service Broker.
•Set up Service Broker to monitor disk and log growth to replace outdated monitoring processes to reduce resource consumption.
•Troubleshoot application issues that involve SQL stored procedures. Tickets were created by customers through company customer service.
•Monitor and troubleshoot Transactional Replication issues as they arise.
Xerox Assignment
•Perform SQL Server health check. Creation of standards document and implement Best Practice guidelines for current and new implementation.
•As part of ITOC member, provide root-cause analysis of Severity 1/2 database related issues on a daily basis.
•Code review of Stored Procedures and preparation of database build steps for weekly release cycle.
•Provide operational support for all Severity 1 issues. Primary On-Call DBA for weekend issues.
•Tune and optimize Reporting (SSRS) and Transactional stored procedures and troubleshoot SSIS package execution failures.
•Standardize maintenance and backup/recovery routines throughout database environment.
SQL DBA, HSF Affiliates LLC - Houston, TX
7/2012 – 9/2013
•Consolidate and migrate 6 primary production SQL Servers from current datacenter to Amazon AWS.
•Automate data conversion processes for HSF affiliates’ move to new brand.
•Move from SQL Server Maintenance Plans to a more customized backup\maintenance strategy using Ola Hallengren’s Maintenance scripts. Improve and standardize backup procedure and plan for data recovery in event of disaster.
•Build 2-Node Clustered environment for Proof of Concept projects.
•Create and automate task of setting up and failing over Mirrored databases for 800+ database instances.
•Maintained Always-On Failover Clustering for production SQL Servers before move to traditional Database Mirroring.
SQL DBA, Component Architectures – Austin, TX
10/2008- 6/2012
•Remote support of SQL2000/2005/2008 database servers.
•Worked with application support, and various groups to improve process efficiency of PeopleSoft Finance and HR modules.
•Troubleshoot database/server performance/nightly ETL/SSIS processes impacting daily transactions.
•Monitored and improved database integrity and nightly batch transactions and consistency checks.
•Perform system optimization, database performance analysis, capacity planning, and system sizing.
•Setup and configure 2 Node Clusters for High Availability. Update and revise procedures for DB Backups and Maintenance procedures.
SQL DBA, Ameriquest Mortgage / Citi Residential Lending (CitiRL) - Orange, CA
5/2003- 5/2008
•Maintain SQL2000/2005 database servers by continual maintenance and tuning to ensure maximum performance.
•Worked with application support, and various groups to improve process efficiency of PeopleSoft Finance and HR modules.
•Maintained PeopleSoft Financials HR and Financials databases.
•Designed processes in conjunction with other tools to improve nightly loads for PeopleSoft HR and Financials databases.
•DTS package design, maintenance, and troubleshooting. Worked on ETL team to cleanse and load data into staging tables in preparation for Data Warehouse load.
•Responsible as primary DBA for production databases. Providing 24x7 on-call support, answering severity calls, and resolving production problems.
•Create and maintain Transactional and Snapshot Replication.
•Perform system optimization, database performance analysis, capacity planning, and system sizing.
•Phased out SQL Server 2000 and prep for SQL 2005 migration. Configured and maintained SQL Server 2005 system.
•Built and maintained 2-node Active/Passive clusters. Supported over 100 production servers.
SQL DBA, IndyMacBank.com – Pasadena, California
4/2000 – 11/2002
•Manage SQL Server 7.0/2000 databases with an average daily transaction volume of 1200 Internet connections in a 24/7 environment.
•Maintained archive processes for main LOS database to manage size of database.
•Managed Transactional Replication environment on SQL Server 2000 databases.
•Designed and normalized databases for PeopleSoft HR and Financials to improve transaction processing. Maintained nightly batch processes to ensure completion and data integrity.
•Create and improve data extraction processes using a combination of VB scripting and DTS.
•Create and improve upon nightly data transfer processes. Create and improve upon ETL processes which are critical to daily Bank operations using Sagent Design tools.
•Work with applications developers on optimizing stored procedures, query tuning, and reviewing structural changes before final release into production.
•Designed the logical and physical model for the Treasury (TMS Project) Department using CA Erwin and Embarcadero ERStudio data modeling toolset.
•Implement standards for the creation of stored procedures that maintain optimal transaction processing in order to improve concurrency and reduce contention. Worked on SOX compliance initiative for main database environment.
SKILLS:
Powershell, Windows Server (2003/2008/2012) MS SQL Server (6.5/7.0/2000/2005/2008 R2/2012/2014/2016), SSIS, SSRS, SSAS, Computer Associates Erwin, Idera SQL Diagnostic, Foglight/Spotlight, SQL/Transact-SQ
REFERENCE:
Available upon request.
Contact this candidate