OBJECTIVE:

• A DBA role in a Confidential environment having a predominantly Linux environment utilizing my experience and skills with MySQL and other Database Management Systems, leveraging my significant Systems Administration experience and my personal commitment to open source software.

TECHNICAL SKILLS:

Database Platforms/Primary: MySQL 3.2.3 - 5.5.12, Percona versions (inclusive of the present) and MariaDB 5.2; current beta versions, inclusive of the present.Oracle 8i-10g (8.1.5-10.2.0.3 )

Data Modeling and DBA tools: MySQL-Workbench, ERStudio, ERWin, Mogwai ERDesigner; Oracle Enterprise Manager, ToRA, Toad, ChyfoPro

Internet Software: Web Servers Application Servers and Servlet Engines: Apache Stronghold, JBoss, Weblogic Application Server, Oracle 11i, JRun, Tomcat

Virtualization Software: Qemu-KVM, Xen,VmWare

Source Control: CVS, SVN, Mercurial, Perforce, Clearcase

Application Environments: Java Language API, JDBC, CVS, ODBC, Visual Basic/VBA/Visual Basic Script, J2EE Web Applications, PHP Applications, HTML, DHTML, Javascript, XML, ICE, PerfectScript, Perl Applications, Software Internationalization

PROFESSIONAL EXPERIENCE:

Confidential

Database Architecture and DBA Consulting

Responsibilities:

• Migration from simple envirionment to MySQL/Heartbeat environment for CallCenter corporation.
• Pruning antiquated data for PCI compliance and other requirements.
• MySQL 5.n==> MariaDB Migration in an HA/High Availability, 70+ database server environment
• UTF8 conversion (legacy data predating 2001) procedures in an HA/High Availability environment
• Migrations from (early, buggy versions of) MySQL 5.0.nn to MySQL 5.1.nn.
• Deployments in cronjobs for Maatkit utilities, specifically for replication.
• Replacements of mysqldump backup configurations with Maatkit's mk-parallel-dump.
• Implementations of LVM snapshots for Replicant seeding.
• Troubleshooting and solving binary log file errors in replication with 'mysqlbinlog'.
• Delivery of scripted data conversions between database and CSV files.
• Testing and implementing InnoDB-specific and I/O appropriate my.cnf/server-configuration .parameters in a SAN, iSCSi and local-storage environments.
• Interfacing with MySQL support (when available) in round-the-clock fashion while troubleshooting bugs, often finding the solution independently.
• Performance Tuning for OLTP and Data Warehouse schema design, query design and server variable (my.cnf) configuration.
• Fielding ad hoc engineering requests for schema design, query construction and security best practices for internal reporting databases.
• Schema migrations for software releases.

Confidential, San Francisco, CA

Database Architecture Consultant and MySQL DBA

Responsibilities:

• MySQL DBA tasks for a hotchpotch, multi-datacenter, Social Networking gaming environment set comprising versions 5.0.27 - 5.1. n .
• Proselytized for and documented best practices and campaigned unassisted for Operation group ownership of DB and system layers in an environment that nurtures developer ownership of production resources.
• Spearheaded code cleanup to enable best-practices (post-20th century) read-write separation of DB access at the application level.
• InnoDB performance tuning (query, problematic threads/processes DB parameters for multicore systems, buffer sizing, stored procedures for transactional integrity).
• Performed filesystem/RAID performance analysis using bonnie++ and supersmack on new and existing systems; proferred capacity forecasts for business owners, along with recommendations.
• Implemented Maatkit tools and scripted backups using mk-parallel-dump for existing systems, replacing obsolete and downtime-generating backups that had no value.
• Introduced, implemented LVM standard for backups via LVM snapshot for all new hosts.
• Scripted binlog compression, file transfer and maintenance scripts for old a new DB hosts.
• Created and configured new slave databases for existing deployments.
• Created and implemented Master-Master replication for new and existing deployments, some utilizing MMM.
• Managed existing MySQL Instance Manager configurations and migrated them to either mysqld multi or standalone instances according to the prevailing business priority:resource ratio.
• Introduced first virtualized development environment using Xen virtualization suite.
• Implemented Cacti monitoring for MySQL and OS performance.
• Created Nagios configuration for new host deployments, adding replication monitoring and other facilities as relevant. Also maintained and updated Munin monitoring system.
• Consulted on compliance oriented reporting infrastructure with information architecture team, selecting storage engine. Evangelized for, configured and exposed open-source Pentaho Business Intelligence system for data analytics initiative.
• Collaborated on ad hoc system maintenance/update requests and provided 24/7 support for dynamic, fragile, transitional environment set bereft of any notion of either QA or Staging and which was owned by development principals rather than by Operations.

Confidential, Palo Alto, CA

MySQL DBA

Responsibilities:

• MySQL Database Modeling and Development for a stealth-mode startup emphasizing automated deployments
• RPM and bash scripting for MySQL 5.0 and CentOS 5 environments.

Confidential, Palo Alto, CA

MySQL DBA

Responsibilities:

• MySQL Database Administration for a 24x7, high-volume production environment's dual-master, replication tree comprising over 60 database servers sharing a 400GB dataset.
• Managing slice master roles for specialized application support.
• MyISAM, HEAP and InnoDB tables MySQL 4.0.27, 4.1.22 and 5.0.45 running on CentOS 4.4
• Master Promotion using (exising, custom) replication juggle tools
• Simple Perl scripting, shell scripting and modification of existing scripts in a hybrid Perl, Java and Ruby on Rails environment
• Performance tuning of server configuration variables to service data warehouse style queries running against the in-place OLTP schemas
• Advising developers on SQL statements; Performance tuning of new and existing queries
• Creating new indexes and rebuilding existing ones while rotating master
• Disaster recovery of replication discontinuity "by hand" using mysqlbinlog on master's binlogs to identify current log position of slave.

Confidential, San Francisco, CA

MySQL DBA and Systems Administrator

Responsibilities:

• MySQL Database Administration and Linux Systems administration for a social networking site in stealth beta mode.
• Developing scalable infrastructure architecture for high availability using MySQL replication.
• Developing redundant amplitude for backup and recovery.

Confidential, Mountain View, CA

Database and Unix Systems Administrator

Responsibilities:

• Installed, managed, migrated and upgraded 30 development and production terabyte-scale data-warehouse and OLTP Oracle 10G databases on RedHat Enterprise Linux 4 update 4 (RHEL4u4).
• Performed disaster recovery, handled datafile corruption, handled controlfile corruption. Interacted with Oracle Support and Oracle sales. Managed RMan configurations. Developed standardized responsefile implementation for Oracle installations. Applied Oracle DB patches.
• Installed, managed, migrated MSSQLServer 2005 databases for Mercury Interactive Quality Center QA applications.
• Installed, managed and migrated MySQL database from 4.n to 5.0.27 for OSS task-tracking system ProjectTraq.
• Performed Systems Administration for over 70 RHEL4u4 and CentOS Servers. Performed sundry tasks including installation and configuration of RAID levels 0, 1 and 5 with Adaptec and 3ware SATA RAID cards and Dell Storage Arrays using LSI SCSI cards.
• Performed Network administration for M5 BigIP load balancers, Fortigate Firewall, Netscreen Firewall, Black Diamond switches, Cisco Catalyst switches. Worked with complex network environment inclusive of 15 VLANs.
• Installed and Configured VMWare Server, VMWare ESX server. Created, managed and migrated virtual machines using SAN and NFS storage volumes.
• Performed Barracuda Spam Appliance administration.
• Performed MS Exchange and Blackberry Enterprise Server administration.
• Regularly documented work and procedures in XWiki.

Confidential, Brisbane, CA

Senior Database and Unix Administrator

Responsibilities:

• DBA duties for MySQL 5.0.18 databases running on RedHat EL4 WS for (Java) infrastructure license managment system
• DBA duties for MySQL 5.0.18, Oracle 9iR2 and Microsoft SQL Server data warehousing and datamart project employing CastIron Systems Appliance and DataDirect SequeLink Socket Server. Worked closely with Business Analyst and vendor consultants to troubleshoot integration problems related to each, including resourceful interactions with MySQL-ODBC code maintainer. Wrote Stored Procedures and Functions for project as needed.
• DBA duties for Oracle 9i RAC (using SAN) database serving as backend to BugTracking application and Ticket Tracking application.
• Unix Systems Administrator for failover mail system employing Balance, Postfix, Exchange and Barracuda appliance, where Unix systems ran Solaris 10.
• Unix Systems Administrator for various infrastructure servers utilizing Hitachi SAN. Deployed utilities to resize Logical Volumes; configured and queried Linux SAN drivers. Administered Brocade SilkWorm Multiprotocol Router (for optical fiber connections).
• Unix firewall administration with IPTables.

Confidential, San Mateo, CA

Database Administrator/Member of Technical Staff

Responsibilities:

• Responsible for the administration and management of (24x7x365) Oracle Production Server on Solaris and Redhat Enterprise Linux 3 for hosted (ASP) version of Sigabanet software suite.
• Installed and configured Oracle 9i Enterprise Edition on new 64 bit server and migrated from data from version 8.1.6.
• Configured Archivelog Mode and Export backup and recovery scheme with shell scripts to rotate database dump files and provide e-mail notification via cron utility.
• Responsible for debugging troubleshooting existing database stored procedures functions, triggers, and JDBC callableStatements and preparedStatements, performing rewrites and bug fixes in PL/SQL, Transact SQL and PG/PLSQL for shipping version of Enterprise Encryption software.
• Compiled and deployed new Linux version of embedded Postgresql database version 8.0 to replace release 7.3.
• Provided internal DBA functions for Development and QA environments in Linux, Solaris, AIX and Windows environments.
• Contributed documentation of the product's database schemas and explicated version differences for customers planning upgrades. Set up environment and validated product performance in the Database Replication environment for Oracle and MSSQL platforms.
• Collaborated with Customer Support for escalation of customer issues;
• Created custom ad hoc database reports for customer support requests.

Confidential, San Francisco, CA

Senior Database Administrator/Engineer

Responsibilities:

• Responsible for the administration and maintenance of (24 x 7 )Oracle production database server, and production (24 x 7) and development Unix Sun Solaris 9 database servers for J2EE Internet application running in Jboss.
• Administered and maintained production (24 x 7) and development Unix Sun Solaris 7/8 Stronghold and Apache web servers.
• Upgraded from Oracle 8.17 on Solaris 9 to 9.2.0.4 on Redhat Linux 9 and migrated data structures.
• Managed user Security and Resource allocation for Production Database Servers. Created users and Granted user system and object permissions.
• Interfaced with Oracle Sales to aggressively renegotiate Database Server lIcense renewal, immediately saving the company $36,000.
• Researched Internet service agreements and successfully renegotiated a new contract for T1 line, saving the company $8,000 annually.
• Implemented backup and recovery scheme using Oracle Rman and Oracle exp with shell scripts run by cron utility.

Confidential, San Francisco, CA

Database Administrator, Systems Administrator

Responsibilities:

• MySQL, Redhat EL4/redhat 8 Systems Administration and PHP Scripting for Entertainment Website: Wrote cronjob scripts and implemented database backup and recovery scheme for bulletin board forum, file services and streaming audio/streaming video services
• Oracle Database Administration for Internet Direct Marketing Firm Markado Incorporated: performed disaster recovery on NoArchivelog Mode database server.
• Microsoft SQLServer and Windows 2000 Server Edition administration for three nonprofit organizations: Installed, configured and managed XMail server using remote administration tools.

Confidential, San Francisco, CA

Database Administrator

Responsibilities:

• Responsible for the administration and maintenance of three Oracle production databases, and production (24X7) and development Unix Sun Solaris 7/8 database servers, for J2EE Internet application Kinecta.net; administered and maintained production (24X7) and development Unix Sun Solaris 7/8 Stronghold and Apache web servers.
• Created all new data structures and physical structures for the Production Database Servers: Tables, Indexes, Triggers, Sequences, Views, Tablespaces, Datafiles, cross-platform Database Links.
• Managed user Security and Resource allocation for Production Database Servers. Created users and Granted user permissions.
• Upgraded from Oracle 8.1.5 to 8.1.7 and migrated data structures
• Interacted with Oracle Support to resolve emergency data recovery problem resulting from user error. Created and Managed TAR requests through Oracle Technet.
• Acted as sole Datacenter, Webserver and Network Administrator for Unix (Solaris, Linux) and Windows (NT, 2000 Server) production servers. This included Firewall (Firewall-1 for Nokia), Router (Cisco), HTTP server (Stronghold Apache), Application Server (JRun, Weblogic) and Sendmail administration, as well as managing TCP-IP addresses and routing internally and for NAT (Network Address Translation) and packed filtering for outside world. Managed DNS servers (both Production and Internal).
• Well versed in using command line editor to modify configuration files and documents from the terminal. Used shells (bash, csh ksh,sh) and X Server via ssh connection for remote use of graphical interface to monitor database and internet traffic for production services.
• Performed billable consulting services for customers using Oracle and legacy databases (Oracle Parallel Server, Replication).
• Identified and resolved performance bottlenecks within the production database server and on their Operating Systems (Solaris, Linux).
• Programmed database-related Java for JDBC-enabled, J2EE-compliant, and Information Content Exchange (ICE) standards-compliant Enterprise Java application ( Confidential Connection Server); wrote and tuned the application's queries to support Oracle SQL, Sybase T-SQL, Microsoft T-SQL, and MySQL SQL.
• Wrote stored procedures for Oracle, Microsoft SQLServer, and Sybase SQLServer, including procedures for dynamically creating database objects via a Java program; created a Visual Basic for Applications module for upgrade scripts shipping in product to enable compatibility with Microsoft Access; worked as part of a team to design a database adapter for exposing legacy content repositories to a syndication server.
• Independently developed and administered an intranet Oracle backend database application for internal bug tracking and workflow collaboration using Avensoft PerfectTracker server and PerfectScript for front end; created a specialized backup and recovery plan to meet the needs of business management.

Confidential, San Francisco, CA

Systems Integration Consultant/Programmer

Responsibilities:

• Created a collaboration application for Microsoft Exchange Server using Visual Basic and Visual Basic Script to enable LotusNotes functionality not otherwise provided by MS Exchange
• Designed custom Microsoft Word templates and styles for clients migrating from WordPerfect
• Developed a database-driven process engine application using Visual Basic and Microsoft SQLServer.
• Technical lead for project developing a custom automated document assembly application for law firm client using Visual Basic and Microsoft Word.
• Wrote HotDocs (markup and scripting) templates for integration with ProLaw docketing software and Sybase SQLAnywhere.