TRACY HAMLIN
Birmingham, AL 35223
205-***-**** (h)
205-***-**** (m)
EXPERIENCE SUMMARY
I have over twenty years of technical experience in information systems support and development focusing on database administration. As a Database Administrator, I provide complete DBA support including development, process and analysis. I have worked extensively in both the Windows and UNIX environments and in all phases of the database lifecycle.
SKILLS SUMMARY
SQL Server 11 years SQL 23 years
Oracle 14 years Linux 1 year
Sybase 3 years dBASE/FoxBase 5 years
C/Pro*C/C++ 6 years ERStudio 9 years
DBArtisan 9 years Pascal, Basic, Fortran 3 years
ErWin 1 year UNIX , Sun and HP 6 years
SAS 1 year EDI 3 years
JOB HISTORY
December 2010 – May 2011 Hymel Brossette
Birmingham, AL
Senior Database Administrator
• Create SSIS packages to load data.
• Review and load third party data to incorporate into model.
• Data research/analysis.
• Performance tuning; TSQL.
• Harmonize data models and data value mapping.
• Database security and Auditing.
• Participated in Agile development cycle (sprints, PBI grooming, scrum, TFS).
Environment: Windows, SQL Server 2008/R2, ER Studio. SSIS
August 2010 – November 2010 Regions Bank
Birmingham, AL
Senior Database Administrator
• Install/upgrade SQL Server database servers.
• Review third party software for possible integration.
• Backup/restore databases.
• Provide 24/7 support for production environments.
• Push SSRS, SSIS from applications to production.
Environment: Windows, SQL Server 2000/2005/2008/R2, Idera.
April 2005 – August 2010 Medmined Services (Cardinal Health/Carefusion)
Birmingham, AL
Senior Database Administrator/Architect
• Install, configure and maintain over 65 SQL Server database servers with over 1000 databases.
• Provide initial database analysis, design and modeling for new projects and support SQL coding.
• Data analysis to determine trends and future requirements.
• Lead DBA group and manage tasks and training.
• Executed two Data Center moves and SQL migrations from 2000 to 2005 and 2005 to 2008.
• Increased scalability by consolidation of several clustered SQL servers into a virtual system with VMWare.
• Performance, capacity and architecture planning coordination with Software Engineers and Networking groups.
• Provided rotating optimization and maintenance of databases for minimal interruption.
• Oversee tremendous and sharp database growth from 30 clients to over 350 (1 database to over 1000), while maintaining performance.
• Handled database growth planning for SAN storage tracking.
• Maintained schema consistency between 700+ databases.
• Provide 24/7 support for production environments.
• Continuous performance improvements including set up of partitioning and replication.
• TSQL and stored procedure creation and tuning.
Environment: Windows, SQL Server 2000/2005/2008, .Net, Embarcadero DBArtisan and ERStudio.
September 2001 – April 2005 Xcitek Solutions Plus
Birmingham, AL
Senior Database Administrator
• Install, configure and maintain Oracle, SQL Server and Sybase databases on servers and clients for Windows.
• Provide initial database analysis, design and modeling for new projects using ERStudio.
• Provide support for clients’ production environments.
• Set up scripts to backup and monitor various statistics on the databases.
• Create documentation for installing software, administering the databases, and many other aspects of the DBA jobs to ease learning curves.
• Develop and maintain TSQL, stored procedures and views to support the Visual Basic/.Net application.
Environment: Windows NT, Windows 2000, Windows 2003. Oracle 8.1.7, 9.0.1, 9.2, SQL Server 7, 2000, Sybase 11.5, 12.0.3, 12.5, Visual Basic/.Net, Embarcadero DBArtisan and ERStudio.
September 1999 – September 2001 Open Systems, Inc.
BellSouth
Atlanta, GA
Senior Oracle Database Administrator
• Installed and maintained Oracle databases and clients on HP, Sun Solaris, Linux and NT servers.
• Provided database analysis and design for new projects.
• Supplied full database administration support to development, test and production environments(24x7).
• Created Unix scripts to monitor database activity and send alerts of potential problems.
• Worked on migration effort to move applications from HP-UX/Oracle 7.3.4 to Solaris/Oracle 8i.
• Maintained EBU hot backups in production including patch updates and created cold backup schemes for development and test.
Environment: HP-UX 10.20, Sun Solaris 2.6, Red Hat Linux 6.2, Windows NT, Windows 2000, Java, Oracle 7.3.4, 8.0.5, 8.1.5, 8.1.6, 8.1.7, OEM 2.1.1, 2.2, Embarcadero DBArtisan.
March 1999 - September 1999 Open Systems, Inc.
Atlanta Casualty
Atlanta, GA
Senior Oracle Database Administrator
• Created and supported several Oracle databases for development in the UNIX and NT environments.
• Provided Oracle database administration support for several production databases of purchased applications.
• Conducted performance monitoring and tuning of Oracle databases.
• Reviewed schemas and made recommendations for improvements in referential integrity and performance.
• Oracle instance backup / recovery planning and execution.
• Created database repositories and links to support Sagent, a data warehousing tool.
Environment: Oracle, SQL Server, Unix (HP, Sun Solaris and digital), Windows NT Workstation and Windows NT Server, Sagent Data Marts.
March 1997 - March 1999 DMR Consulting
BellSouth
Atlanta, GA
Senior Oracle Database Administrator
• Administered several development, test and production Oracle databases.
• Installed and configured Oracle for new production machines.
• Analyzed backup requirements, installed and implemented SQL BackTrack.
• Assisted in HP UNIX system administration and created shell scripts for automation.
• Wrote programs to automate a synchronization of application security with the UNIX system.
• Supported the data modeling effort using Designer 2000.
• Performance monitoring and tuning of production databases using OEM and Q Diagnostic Center.
• Aided maintenance with C++ and html updates, PL/SQL and Oracle Forms.
• Maintenance team lead , Project Manager of 2 projects.
Environment: Oracle, UNIX (HP), Windows NT Workstation, C++, html, perl, JavaScript, Designer/Developer 2000.
September 1993 - February 1997 Guardian Industries
Richburg, SC
Systems Administrator
• Rendered complete IT support for UNIX/ Oracle environment.
• Created and maintained C, Pro*C and Oracle Forms programs and reports.
• Installed and maintained a Novell NetWare network and communications servers.
• Installed, upgraded and maintained all software (Operating Systems, databases and tools).
• Installed, upgraded and maintained all hardware (PC’s, servers, HUBs, printers).
• Provided highly technical on-call 24x7 support for all users and all systems as necessary.
• Maintained EDI process including upgrading and programming/data support and enhancements.
Environment: Oracle, SQL/PLSQL, UNIX, Windows NT Workstation / 95, Novell NetWare, C, Clipper, FoxBase, EDI, Lotus Notes, Delphi.
June 1990 - September 1993 Health Services Review, Inc.
Birmingham, AL
Information Systems/Oracle Developer
• Developed system in Oracle using Oracle Forms in a VAX/VMS environment.
• Maintained system and provided enhancements including reports using SQL*RPT and VMS scripts.
• Gathered requirements, modeled database and created an Oracle database for a new system.
• Created a Bill Screening System in Oracle Forms and SQL*RPT.
• Conducted claims analysis and reporting using VMS and SAS.
• Provided complete user support for all software and hardware.
Environment: Oracle 7, VAX/VMS, SQLPlus, Oracle Forms, SQL*RPT, C, FoxBase.
November 1987- December 1988 BellSouth Advanced Systems
Birmingham, AL
Programmer/Analyst (Co-op Contract)
• Created and maintained the Sales Measurement System for sales operations in dBase.
• Designed sales reports and usage reports in dBase.
• Provided maintenance/update support for the Project Request System.
• Provided support for purchased system implementations.
Environment: PC’s, DOS, dBase
EDUCATION / PROFESSIONAL TRAINING
Bachelor of Science, Computer Science/Mathematics (1993), University of Alabama at Birmingham.
Online and in depth personal SSIS training with MVP
HIPPA certification, 2010, HITECH
SQL Server PASS Summit, 2009, 2010 Seattle, WA
PowerShell, 2008, Cincinnati, OH
Oracle Backup/Recovery, 2001, Atlanta, GA
Oracle Database Administration, 2000, Atlanta, GA
Sagent DataWarehousing, 1999, Atlanta, GA
Novell NetWare, Certified NetWare Engineer training course, 1996, Charlotte, NC
AWARDS / PUBLICATIONS / COMMUNITY
• Professional Association for SQL Server, Vice President, Director of Communications and Marketing, member, board member and volunteer, 2005-present, Birmingham AL
• Exceptional DBA 2010 Award Winner, International award sponsored by Red Gate
• Contributing author on Red Gate’s SQL Scripts Manager
• Blog: http://sqltracy.blog.com/