Hieu Nguyen

Database Administrator

**** ********* ** **** ****, Atlanta GA, 30338

aczjzl@r.postjobfree.com

(770) 833 - 5667

Professional Summary:

** ***** ** ********** ** database architecture, development, and maintenance of SQL databases.

Performed several data/server migrations

Performance tuning and load testing experience

Managed software releases from Development to Production.

Acted as BA and PM of many projects

Very motivated individual who is extremely reliable with very strong problem solving skills.

DBA skills include:

SQL Server 2000, 20005, 2008, 2008r2, 2012

Performance Tuning

Data Security, Backup & Recovery

Standby/Failover Administration

Data warehousing development/maintenance

Reporting services Management/Development

Analysis Services

Integration Services, ETL

Education Summary:

Georgia State University

Bachelor of Business, Major in Computer Information Systems

2004

Professional Experience:

Teavana, Atlanta, GA Oct. 2012 – Present

Database Administrator

Maintained multiple instances of SQL Server including 7 test servers, 9 production servers, and over 330 instances of SQL server express. Updated database permissions and processes to meet PCI and SOX standards. Primary focus on performance tuning and ensuring data properly migrated from system to system.

Responsible for managing daily administrative activities such as Backups, Performance Maintenance, application jobs and SSIS packages.

Managed environment of 11 test/development servers, 10 QA/UAT servers, 330 store instances of SQL Server Express, and 8 core production servers.

Maintained PCI standards across all PCI related database servers. Created processes that would check for violations of any PCI standard and immediately notify and take action on any violations. Ensured sensitive data was being maintained and secured.

Created many SSIS packages and procedures that automated several tasks performed by different departments. Tasks includes interaction between internal systems, Amazon, UPS, Responsys, Starbucks, etc.

Worked with Ecommerce department and updated database schema and procedures. Promoted changes from development to qa to uat and production.

Developed processes to collect performance monitoring statistics. Created reports and notifications based on those collated metrics. Took appropriate action when opportunities for improvement where found.

Provided 24 hour support to all management, team members, end users and customers.

Managed SSRS site, created reports and assigned permissions as needed. Updated reports as business rules and database schema changes were made.

Created and managed reporting server processes. Processes include identifying and hourly syncs of only changes made to a production environment with millions of records. Records that transferred to reporting servers would be strip of all PCI related information to ensure no violations to PCI Standards.

Data center migration of all database environments from Teavana Atlanta location to Starbucks Ashburn location. Migration tasks included building database boxes in Starbucks data center and transferring all tasks (i.e. jobs, users, database, SSIS/SSRS). Backup plans were also put in place in the event of failure.

Key Player with integration of Starbucks and Teavana Systems. Developed and managed many process and packages responsible for transfer and manipulation of data so both systems would function without interruption.

Worked with several users including BI team to help develop queries, performance tune queries and monitor transfer of data from reporting servers to data warehouse.

AdvancED, Alpharetta, GA Mar. 2006 – Oct 2012

Database Developer/Administrator

Manage core SQL Server production databases. Enhance database performance, perform restores, implement disaster recovery processes, handle performance tuning and conduct regular system backups. Design and develop database from scratch for new application and migrated data from old systems to new.

Vital to the Business analysis process in determining and gathering requirements for ongoing software development. Identified complex scenarios and provided business and backend processes.

Designed and architected database during SDLC processes. Updated schema on new design as business rules changed as well as updated old database procedures and schema to support transition of functionality.

Utilizing Redgate’s Sql Compare and Sql Data Compare, managed changes between development servers to QA servers to UAT servers and then to Production servers. Documented changes and developed processes to identify changes to be promoted in a CRUD environment.

Created 100s of stored procedures which managed calls between front end and back end. Procedures include simple CRUD calls and very complex search queries. Updated Procedures with changes in business rules.

Performed several data migrations for 3rd party organizations which allowed companies to fully utilize features provided by Advanc-Ed. Created complex SSIS packages and stored procedures to automate changes from different datasources. Datasources include fox pro, excel, access, sql server and oracle.

Assisted in development 1st version of webservice interface which utilized SQL Server’s xml functionality. Developed stored procedures that received XML as inputs, processed data and returned XML output.

Redesigned 1st version of webservice interface to utilized C# webservices to parse xml and pass data to database. This process simplified development and enhanced peroformance by 30%.

Worked with Java developers to redeign 1st version of website and replace webservices with hibernate.

Manage daily database routines including backups and maintenance. Implemented database mirroring and transaction log shipping to ensure minimal downtown.

Managed reporting services site and developed several canned reports.

Maintained day to day operations and helpdesk request. Provided 24 hours support.

Developed and maintained data warehouse. Ensured data from OLTP successfully moved to the data warehouse. Using analysis services developed cubes to consume data from data warehouse.

Developed SSIS packages that automated data flow from old legacy databases to new application databases.

Performed numerous load testing and bulk data loading. Performance tuned when necessary. Managed indexes/statistics by creating and removing them where needed.

Performed numerous SQL Server installations. Managed SQL Server version upgrades to 2005 and 2008 R2.

Fonix Telecom, Atlanta GA Feb. 2004 – Mar. 2006

Junior Database Administrator/Developer

Transition from intern to a Junior Database administrator. Responsible for maintaining/developing reports for reporting application. Created T-SQL and procedures to support software calls to database. .

Developed several canned reports using crystal reports and stored procedures. Updated reports as business rules and database schema changed.

Developed SSIS jobs that migrated data back and forth between various applications.

Managed backup jobs and maintenance jobs.

Worked with development team to create procedures and promote changes to production.

Assurant Group, Atlanta GA Mar. 2003 – Feb. 2004

Processor/Data Entry

Processed customer insurance forms for Chase Manhattan Mortgage.

Analyzed customer accounts and applied payments and disconnected accounts.

Entered data into systems.

Sears, Atlanta GA Jun. 1999 – Feb. 2003

Electronics/Computer Sales Representative

Assisted and provided services to customer looking to purchase electronic/computer products.

Led both Electronic and Computer departments in sales volume.

Recognized for excellent customer service.

Contact this candidate