SUMMARY:

• Dedicated Database Engineer, experienced to own, track and service database requests, incidents and management.
• Solid experience in MySQL, Oracle and PostgreSQL along with Vertica and MongoDB. Accustomed to supporting 24/7 production systems; diagnosing database performance, server, network and app issues; responding to incidents and performing all database maintenance functions.
• Proactive and motivated team player, who rapidly learns new technologies and stays abreast of trends in the industry to deliver increased productivity.

TECHNICAL SKILLS:

Database: MySQL, Vertica, MongoDB, PostreSQL, mysqldump, Percona Xtrabackup, Percona Tools, MariaDB audit plugin, DRBD/corosync/pacemaker, Galera Cluster, SeveralNines ClusterControl, Tungsten Replicator, Oracle 7 - 11g (RMAN, AWR, ADDM), Veritas Netbackup, TOAD, Sybase, PRO*C, stored procedures, PL/SQL

Lnguages: Ruby, C#, .NET, C, C++, Visual C++ MFC, COM+, ATL, win32, WTL, JavaScript, XHTML, VBScript, Unix Shell Scripting, awk, sed, cron jobs, Perl, CSS, ASP, ADA, Pascal

OS: Linux (rhel, centos, ubuntu, fedora), UNIX, SunOS, Solaris, Unix System V, AIX, Windows

S erver platforms: Opscode Chef, OpenStack, GIT, Gerrit, Jenkins job builder, Icinga, Nagios, Jira, Apache, LAMP stack, Active Directory, PHP, WinCVS, sccs, CVS, Perforce, Visual Source Safe, RabbitMQ

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA / Palo Alto CA / Seattle WA

Senior Database Administrator DevOps

Responsibilities:

• DevOps DBA for production MySQL and Vertica instances, on OpenStack Cloud compute platform. Responsible for database installation, configuration and administration.
• Substantial experience troubleshooting prod incidents involving database response time, server load, network and ILO issues, often involving full application and enterprise stack troubleshooting.
• Experienced in OS level troubleshooting for IO, CPU, memory and disk. Using sar, vmstat and custom scripts.
• System, instance and query tuning using system tools, Percona Toolkit and custom shell scripting.
• Automate mysql install, upgrade and configuration via Opscode Chef Configuration Management.
• Design and implement sound HA and Failover systems via DRBD/corosync/pacemaker, replication and Galera cluster.
• Establish and maintain backups via xtrabackup, swift object store and test for recovery.
• Automate monitoring using Chef recipes, Icinga, shell scripts and Ruby.
• Provide on-call support to maintain 99.999% uptime.
• Implement security compliance via mariaDB audit plugin, security patching and kernel upgrades.
• Provide Database expertise and project manage across multiple teams, for database projects involving MySQL, Vertica, MongoDB, RabbitMQ and SQL Server databases.

Confidential, Alpharetta GA

Database Administrator III (contract)

Responsibilities:

• production support of 600+ DEV, QA, ST and PROD databases. database admin business critical 24/7 apps with multi-terabyte data sets.
• Install, configure and maintain MySQL, Oracle, Postgres databases on UNIX, Linux and Windows.
• Implement and monitor backup and recovery using mysqldump, Percona Xtrabackup, RMAN, Veritas Netbackup and Postgres pg dump/restore. implement HA solutions via MySQL replication and Oracle Advanced replication.
• Database tuning and performance monitoring via sar, vmstat, iostat to monitor system wait, IO, memory issues and identify slow queries and processes.
• Substantial shell and Perl scripting experience to provide monitoring, extract, import and data loads.
• Project Manage multiple simultaneous projects involving users, storage, sys admin, network and production support teams.
• Support DEV teams for SQL queries, procedures and schema design. wiki document procedures, implementations and solutions.

Confidential

Database and Systems Administrator

Responsibilities:

• DBA MySQL, Postgres database: replication master/slave, tuning, data load, install, patching, backups, disaster and capacity planning, networking, server build out and maintenance on Centos. manage MySQL instances for SugarCRM (customer relationship management), MANTIS ticket system and structural design databases. project management and structural condition reports. Building and planning permissions and Structural Surveys.

Confidential Atlanta, GA

Database Administrator & Technical Lead

Responsibilities:

• Responsible for Oracle database administration 9i-10g, for an Electronic Medical Records System ; deployed in Hospital, Clinic and State medical facilities throughout the US.
• Technical lead for the DBA and software developers - allocated work, architect designs, mentor.
• Oracle 10g installation on Linux and UNIX.
• RMAN, patching, SQL and instance tuning, datapump, cloning, DR testing.
• Schema design, indexes, constraints, stored procedures, session and user management, data load.
• Shell scripting to automate tasks, Oracle monitoring and RMAN backup and recovery.

Confidential, Tucker GA

Database Programmer and Admin Oracle and MySQL

Responsibilities:

• Oracle: Database design, data load, stored procedures and Oracle database creation on UNIX (Sun). User and session management. patching, RMAN backup and recovery. Stored procedures, PL/SQL, explain plans, SQL optimization.
• MySQL: database design, install, backup/recovery, capacity plan, tuning, SQL optimization
• Design and enhancement of corporate Lanier.com and several intranet sites and web applications using PHP, HTML, XML, XSLT, CSS, CGI, Javascript, flash and Oracle on Apache. Also maintained JSP/Tomcat sites.

Confidential ., Atlanta GA

Developer Architect

Responsibilities:

• MySQL DBA functions: install, database and schema design, tuning, backup/recovery, cloning.
• Developed Internet Explorer browser helper objects and window UI customization of Internet Explorer using COM, ATL, win32 and WTL (Windows template library).
• Developed add on application to TeamTrack (Business Process Management Software by Serena) using COM, ATL, Win32 and ISAPI.

Confidential, Atlanta GA

Senior Analyst Programmer

Responsibilities:

• Oracle DBA functions - Data load, explain plans and hints, query tuning, schema design, indexes, constraints, stored procedures, session and user management, data load. Shell scripting for Oracle monitoring and backups. developed substantial shell script (ksh, a/nawk, sed) and cron jobs to aid development and data moves.
• Architected and developed Web based information resource application TIMATICWEB.COM for the International Air Transport association, Netherlands. Developed using C++, Java/JSP, ksh CGI, HTML and JavaScript on a UNIX and Apache platform. developed Cargo tracking system for Saudi Airlines website, using HTML, JavaScript and an ASP/Perl module to the Apache web server.
• As part of 3-person team, developed Visa Application System for the governments of United Arab Emirates and Israel. Written in C++ with an ORACLE 8 database using PRO*C and ORACLE stored procedures. A real time system, communicating with users via screen templates at airports and foreign consulates.