MySQL Senior DBA

Technical Knowledge

. Operating Systems

DOS, VAX/VMS, Windows 7, XP, 2K, NT, Server 2000, Server 2003, Server

****, *****, ***** - *********, ****** variants, CentOS (Redhat

variant), Debian variants, Suse, Solaris, HP/UX

. Hardware

Intel architectures (IBM conventional [xSeries] and Blade), Sun, 3-

Ware RAID controllers, IDE, SATA, Firewall Appliances, Cisco 3640

series routers, Cisco 7200 series routers, Cisco 2500 series

switches, HP switches, Livingston PM2 & PM3

. Server-Level (services) Software

SMB (Samba), email services (sendmail, postfix, pop3), named (DNS),

apache 1.3 & 2, Microsoft IIS, mySQL, Microsoft SQL, PHP (as apache

module and separate binary), Microsoft Exchange, IP Tables

. User-Level Software (Application)

Microsoft Office, Microsoft Visio, Microsoft Project, OpenOffice,

Ethereal, various IDE's

. Languages (including scripting)

C, Perl, PHP, awk, bash, sed, javascript (including AJAX

technology/implementation), HTML, CSS, 8086 Assembly

. Technologies

Hardware & software RAID, LVM, Veritas Clustering, VMWare, IBM

Virtualization with Hypervisor, Clustering, Redhat Xen, NAS, TCP/IP,

CSS, T1 & PRI, ISDN, Traffic-Shaping, IP Security, AJAX, DHCP, NAT

Soft Skills

. Enthusiastic and dedicated worker. I have worked as part of a small

and large teams. I have lead teams as well as a successful computer

technology company. I have worked and exceeded all goals when working

remotely or in an office environment.

. Skilled in Microsoft Word, Excel, Visio, Power Point and Open Office

applications as well.

. I have been doing public speaking since 10 years old (astronomy). I

have taught and trained many people from formal classrooms to one-on-

one employee and co-workers. I do not "hold back" any experience or

knowledge that would help others in their roles.

. I can dissect and identify in the critical components from non-

critical components in order to meet deadlines and overall project

objectives. I do not become crippled by project complexity or what may

seem like an endless stream of information.

Professional Experience

September 2011 to Present Bank of America - MySQL DBA Team Lead

. Accepted FTE Band 5 at Bank of America to be Team Lead for Enterprise-

Wide MySQL team.

. Responsible to lead team and train new team members on MySQL usage,

recovery, technical approaches, nuances, and how we work with internal

bank customers (other lines of business).

. Developed standard and one-off's backup procedures.

. Developed customized recovery processes.

. Responsible to integrate new customers (other lines of business) into

our security standards.

. MySQL 5.5.x and 5.6.x

. Master Slave Replication * Multiple Slave Replication * Master Master

Replication

. Disaster Recovery designs and testing.

. Discussed customer requirements and designed Enterprise-scale MySQL

solutions using various other internal services such as load-

balancers, FDNS, Redhat Clustering Services - HA

. Because of long-time linux experience, I often performed system

administration to support MySQL installations and maintenance.

. Some 150 servers with over 250 instances.

. Partioning

. Optimization

. Responsible to maintain Bank of America MySQL Security Baselines

. Developed stored procedures, events, and functions using the SQL

language (near ASNI-standard).

. As DBA, I instructed our customers in the use and syntax of SQL for

MySQL.

July 2010 to September 2011 TEK Systems - assigned to Bank of America -

Design Team Lead

March 2009 to April 2010 TEK Systems - assigned to Bank of America - Design

Team Lead

. Systems Analyst known as "DTL - Design Team Lead" at Bank of America.

. Combination of Technical Project Management and years of hands-on

Enterprise experience.

. Works with various business groups to understand software and hardware

needs in order to design an infrastructure solution that falls within

the needs of the business group and within the guidelines and policies

of the bank.

. Daily conversations with programmers to understand how their software

works and what they need from infrastructure.

. Required solid working knowledge of bank infrastructure including

security policies.

. Extensive communication skills to distill information from multiple

expert sources and then integrate their expertise into an

infrastructure solution.

. Used experience in various Enterprise environments to design

infrastructure solutions.

. Extensive and various levels of expertise with solutions used in

Enterprise-level environments.

. Extensive soft-skills: Word, Visio, Excel as well as project

management, and team coordination.

. Met or exceeded all delivery dates.

. Received multiple acknowledgements and notices of recognition.

. Interviewed applicants for similar role as bank's need for DTL's

increased.

. Designed the infrastructure to support include WebSphere, MSSQL,

mySQL, MQ, VM and a variety of hardware components such as SANS,

backup facilities, networking, load-balancing. Projects would include

multiple tiers in the designs.

. I have a unique background bringing together years of hands-on along

with high-level experience.

. Designs included production and contingency solutions including load-

balancing and DNS issues.

. Many projects required helping the business group understand how the

bank policies differed from where they had been working (acquired

companies). In many times, I had to work with the business groups and

get them "on-board" with those various policies.

. Experienced in Countrywide Datacenter Integration for over 6 months.

October 2008 to January 2009 TEK Systems - assigned to Bank of America -

MySQL DBA

. mySQL DBA. Managed over 100 servers running mySQL on Redhat RHEL.

Responsible for day-to-day operations of mySQL servers including

account management, upgrades, and trouble shooting. Server farms ran

on physical and VM environments. High-Availability and failover.

. Lead training for overseas team on mySQL administration and

troubleshooting techniques.

. Took projects and developed plans so overseas team could perform work

for these projects.

. Daily interaction with customers to satisfy needs and issues.

. Developed system requirements documentation for mySQL process

automation application.

. Created and received approvals for multiple 'existing processes' to

streamline change control procedures for mySQL group.

. Designed various backup solutions depending on needs of business

groups within the bank.

. Integrated system administration knowledge to rectify various OS

issues related to mySQL implementation.

. Developed stored procedures, events, and functions using the SQL

language (near ASNI-standard).

September 2007 to March 2008 Powernet Global Communications - Wireless

Implementation Specialist

. Worked with wireless team bringing last-mile wireless solutions to

rural and city communities.

. Developed better speed tester for wireless technical support team.

Developed in C, AJAX, perl, and PHP. Platform was Fedora, apache web

server.

. Developed tool for collection of images from a variety of IP-based

security cameras and create JPEG-AVI movies based on criteria by

user. Supported various cameras by defining camera parameters as a

module. Platform was Fedora, apache web server. Developed in C and

PHP.

January 2006 to May 2007 Fannie Mae - Linux System Administrator

. Managed over 200 servers running Suse linux or Solaris.

. Loaded servers with OS and applications needed by customers.

. Implemented Veritas Clustering if required by customer.

. Implemented LVM if customer had need for frequent data space growth.

. Implemented connection to SAN if required by customer.

. Wrote many shell scripts to ease redundant procedures.

. Wrote perl scripts to parse syslog files to extract critical

information for storage. Solaris and linux had different layouts for

the data so wrote parsers to normalize all the information so users

were oblivious to what OS each report came from.

. I brought linux and PC experience into Fannie Mae, more specifically

into my team. I taught my team how to load, rack-mount IBM X-Series

4U and 3U servers, and what problems to expect as opposed to the

team's knowledge of Solaris.

. Responsible for communicating with departments that needed servers

created and maintained. Encompassed everything from loading the

Operating System to incorporating NAS devices, LVM, loading customer-

specific applications to eventual decommissioning of older servers

for future hardware upgrades.

. Performed duties to insure servers were running processes properly.

Diagnosed services not running properly and worked to resolve issues.

Communication necessary with other departments to determine problems

and resolutions. Mostly responsible for OS issues moreso then

hardware issues. Dealt with TCP/IP, file systems, security, user

accounts, SSH and other OS-related issues.

January 1992 to January 2006 Good News Computer Solutions dba Good News

Internet Services - CEO

. Good News provided connectivity (ISP, WISP), consulting, web

development, network support services.

. Managed a staff of 10 employees. Good News became third largest ISP

in Cincinnati region.

. Designed and built server room. Directed technical staff how to lay

cable, tie and label, punch down twisted-pair into patch panels.

. Implemented VLAN's using Cisco and HP switches.

. Built linux servers running varieties of Redhat from the hardware up.

Worked in in CLI and GUI mode depending if workstation or server.

. Designed corporate mySQL databases used for all data functions of

company. Compiled mySQL and installed on linux and Windows servers.

Implemented backup and restoration procedures. Wrote PHP and perl to

interface with mySQL both for staff and for our customers.

. Installed and managed apache on linux servers - versions 1.3 and 2.

Implemented SSL and E-Commerce solutions. Over 1000 hosting clients.

. Built strong relationships with Good News customers ranging from

providing all their IT services to managing projects for them that

required various vendors with differing professional services.

. Designed and implemented systems based on mySQL and Samba to replace

proprietary Microsoft solutions used by Good News clients.

. Designed and implemented apache and mySQL solutions to replace IIS

for Good News customers.

. Wrote proxy servers to give options to parents and businesses to

block adult websites. Wrote original code in perl later rewriting in

C. System integrated with mySQL to allow parents and business

managers to see what children/staff were viewing in their web

browsers.

. Developed stored procedures, events, and functions using the SQL

language (near ASNI-standard).

.

. Taught interns "real-world" programming in perl and PHP as well as a

variety of other technical skills.

1983 to 1992 Various Consulting Firms

. Contracted for GTE Mobilnet in San Angelo, Texas. Wrote PRV code to

authenticate ESN's and trigger phone services suspended if suspected

of stolen ESN. Worked with VAX/VMS. As other contractors came onto

project, I trained and supervised over them. Code developed in C and

scripting.

. Windows 3.1 Development using C. Also contracted to teach Windows 3.1

and NT programming to DFAS (Columbus, OH)

. Rewrote commercial astronomy program called EZ-Cosmos (Dallas,

Texas). Development in C.

. Microdynamics (Dallas, Texas) - part of team developing code for CNC

cutting of cloth. Development in C.

. Developed DOS Terminate-Stay-Resident (TSR) code as drivers for

serial data collection.

. Developed database aiding medical facilities in ICD-9-CM and CPT

coding. Built entire system. Wrote linked-list database routines from

scratch (before most commercial libraries existed). Determined

hardware solution. Loaded and did technical pre-sales. Provided

technical support training for staff and customers.

. Consulting ranged from teaching IT management techniques to teaching

C, Assembler, and various Operating Systems (Windows 3.1, Windows 95,

Windows NT, various flavors of unix, various distros of linux).

. Excellent interpersonal skills.

Contact this candidate