WILLIAM G. SECREST Buford, GA 30519
[Send email using form at bottom] (678) 467-7251
OBJECTIVE
Telecom and Financial Database Architect seeks database work that will allow me
to use my skills to help you meet your goals.
SKILLS
22 years’ Telecom and Financial DBA and Development experience in
Telecom and Financial fields.
12 years’ database administration/architecture experience with the 5
major database platforms
13 years of UNIX experience
4 years of Configuration & Release Management experience.
Proficient in Oracle DBA - including RAC, Informix DBA, MySQL DBA, SQL
Server DBA – including clustering, PL SQL/T-SQL/SPL Developer, Perl Developer,,
Visual Studio Developer, Windows Administrator, Linux System Administrator,
Solaris System Administrator, and AIX System Administrator.
WORK HISTORY
CSC– Atlanta, Georgia
September 2007 – Present
Senior Oracle/SQL Server DBA
• Provide 24x7 on call support and problem resolution as necessary.
• DBA support includes: perform database capacity planning; create, administer
and maintain databases; install and patch
server software; upgrade and downgrade databases; implement disaster recovery
strategies; perform database backup/recovery and cloning; perform operating
system, application and performance monitoring and tuning; identify and resolve
any database bottlenecks proactively; respond to raised problems quickly.
• Monitor database log files, data block corruption, segment fragmentation,
performance issues, security threats, contention issues (deadlocks, I/O, memory,
CPU, etc.). Manage and maintain high volume transactional tables and indexes,
database reorganization
• Providing consultation on Oracle/SQL Server to our development team.
• Design, creation, configuration, recovery and support of Oracle/SQL Server
databases & clusters
• Performed 1st tier Production support by troubleshooting database issues,
performance monitoring/tuning, & capacity planning for Oracle/SQL Server
databases
• Provide database architecture, design, configuration, & development experience
with all database platforms
O/S Technology - HP/Linux/Windows 2003 Server
Database Technology - Oracle 9i & 10G, SQL Server 2005, Oracle RAC, SQL
Server Clustering
Development Technology - PL-SQL, T-SQL, Batch scripting
HARBOR PAYMENTS– Atlanta, Georgia
April 2006 – October
2009
Principal DBA
• Manage a team of 5 DBA’s supporting all of Harbor Payments database
platforms.
• Provide 24x7 on call support and problem resolution as necessary.
• DBA support includes: perform database capacity planning; create, administer
and maintain databases; install and patch
server software; upgrade and downgrade databases; implement disaster recovery
strategies; perform database backup/recovery and cloning; perform operating
system, application and performance monitoring and tuning; identify and resolve
any database bottlenecks proactively; respond to raised problems quickly.
• Monitor database log files, data block corruption, segment fragmentation,
performance issues, security threats, contention issues (deadlocks, I/O, memory,
CPU, etc.). Manage and maintain high volume transactional tables and indexes,
database reorganization
• Developed common set of tools to aid in troubleshooting & maintenance on all
Harbor database platforms
• Providing consultation on Oracle/SQL Server/Informix/MySQL to our development
team.
• Design, creation, configuration, recovery and support of Oracle/SQL Server
/Informix/MySQL databases
• Performed 1st tier Production support by troubleshooting database issues,
performance monitoring/tuning, & capacity planning for Oracle/SQL
Server/Informix/MySQL databases
• Provide database architecture, design, configuration, & development experience
with all 5 major database platforms
• Created Oracle Stream process to maintain data between 2 databases
• Set up Oracle’s Data Guard product to maintain a large standby database
O/S Technology - Solaris/Linux/Windows 2003 Server
Database Technology - Oracle 9i & 10G, SQL Server 2000/2005, Informix
10.x, MySQL 5.0
Development Technology - PL-SQL, T-SQL, Batch scripting
SBC Systems September 2005 – April 2006
Senior DBA/Developer
Performed database & application design changes to meet customer
requirements using industry standard SLC methodologies on SBC’s Benefits
Workstation product
Provide 24x7 on call support and problem resolution
Troubleshooting performance issues and fine-tuning queries and stored
procedures
Created & upgraded code for customer request enhancements
Converted PL/SQL code to T-SQL
Converted T-SQL code to PL/SQL
Tuned SQL, TSQL, & PL/SQL
Developed troubleshooting tools
Provided consultation on Oracle & SQL Server to our development team
Design, creation, configuration and support of Oracle & SQL Server
databases
Performed 2nd tier Production support DBA
Provided database architecture, design, configuration, & development
experience with Oracle & SQL Server
Helped maintain MS Exchange as a Windows Administrator
OPENET TELCOM May 2005 – September 2005
Senior Software Engineer/DBA
Performed database & application design changes to meet customer
requirements using industry standard SLC methodologies on Openet’s FusionWorks
Mediation product
Provide 24x7 on call support and problem resolution
Troubleshooting performance issues and fine-tuning queries and stored
procedures
Created & upgraded code for customer request enhancements
Developed tools to aid in troubleshooting
Provided consultation on Oracle to our development team
Performance tuning of SQL & PL/SQL
Performed 2nd tier Production support DBA
Provided database architecture, design, configuration, & development
experience for Oracle databases
Impact Solutions February 2005 – May 2005
Perl Developer/DBA (contractor)
Performed database & application design changes to meet customer
requirements using industry standard SLC methodologies
Provide 24x7 on call support and problem resolution.
Troubleshooting performance issues and fine-tuning queries and stored
procedures.
Created & upgraded code to automate repetitive tasks, monitor database
performance
Developed tools to aid in troubleshooting
Performance tuning of SQL, TSQL, & PL/SQL
Performed 2nd tier Production support DBA
Provide database architecture, design, configuration, & development
experience with Oracle & SQL Server databases
Intercall June 2000 – February 2005
DBA/Developer
Performed database & application design changes to meet customer
requirements using industry standard SLC methodologies
Provide 24x7 on call support and problem resolution.
Provided consultation on SQL Server to our development teams.
Performance tuning of SQL, TSQL, & PL/SQL
Created & upgraded code to automate repetitive tasks, monitor database
performance
Design, creation, configuration and support of
(Oracle/Informix/MySQL/SQL Server )
Upgrading and upsizing databases from earlier versions to the latest
versions (Oracle/Informix/MySQL)
Development & Test DBA for Oracle, Informix, SQL Server, MySQL, & MS
Access
Resolved SQL Server problems in conformance with SLAs
Performed release management & coordination for quarterly product
upgrades.
Performed 2nd tier Application support and administration, including
database backups using RMAN
Data migration (total DB restore to different machine)
New machine set-up and DB installation
Developed tools to aid in troubleshooting
Wrote HTML based documentation, procedures and standards for tools
Vendor management
Mentored Junior staff member’s
Created new CDR Mediation process to convert multiple conference bridge
billing record formatted (cdr’s) to a single, unified detail record. The CAS
system then determines the correct bill rate applicable for the owner and then
passes the final record to the Portal billing system.
Billing system conversion developer; converted in house system to
Portal’s Infranet
Provide database architecture, design, configuration, & development
experience with Oracle, SQL Server, Informix, & MySQL databases
Nextel April 1999 – June 2000
Migration Manager
Project manager supporting on a daily basis 16 concurrent subscriber
migrations requiring 15 day preparation cycles over the company’s dispatch and
voice mail switches
Performed 2nd tier Application support and administration
Wrote HTML based documentation, procedures and standards for tools
Vendor management
Mentored Junior staff members
Oracle Corporation October 1998 – March 1999
Principal Consultant
Recruited for experience in the telecom industry to provide consulting
services to clients for the world’s leading supplier of information management
software and the second largest independent software company with more than $9.7
billion in annual revenues.
Trained to be an Oracle DBA and learned various Oracle products until
the project lost its funding.
Provide database architecture, design, configuration, & development
experience with Oracle databases
Previously employed as Software Engineer with Ross Systems, Inc. (July
1998-October 1998); Technical Team Leader/Project Manager with SEMA Group Telecom
(September 1996-June 1998); Systems Engineer with EDS (February 1988 – August
1990).
EDUCATION AND SPECIALIZED TRAINING
School of Computer Technology
Programming Diploma, January 1988
4.0 GPA
Oracle 9I Certified Technician
EDS SED/Systems Engineer (April 1994)
EDS OPD/Operator (April 1989)
*References available upon request.
|