Mysql Dba Team Lead Resume
SUMMARY:
- 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.
TECHNICAL SKILLS:
Operating Systems: DOS, VAX/VMS, Windows 7, XP, 2K, NT, Server 2000, Server 2003, Server 2008, Vista, Linux - Slackware, Redhat 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
PROFESSIONAL EXPERIENCE:
Confidential
MySQL DBA Team Lead
Responsibilities:
- Accepted FTE Band 5 at Confidential 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 Confidential 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.
Confidential
Design Team Lead
Responsibilities:
- Systems Analyst known as "DTL - Design Team Lead" at Confidential .
- 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.
Confidential
MySQL DBA
Responsibilities:
- 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).
Confidential
Wireless Implementation Specialist
Responsibilities:
- 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.
Confidential
Linux System Administrator
Responsibilities:
- 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, 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.
Confidential
CEO
Responsibilities:
- 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.
Confidential
Responsibilities:
- Contracted for Confidential 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.