SUMMARY

• My current skill set and focus is MySQL, Postgres, Oracle, SQL server, Mongo, Hadoop, Cassandra,
• AWS and cloudtechnologies, Python, perl, java, Ruby, shellscripting, sysadmin,networking.
• In depthexperiencegained wifover 10 years of system and database design, development, and implementation of OLTP, data warehouse/data martsand NoSQLsystems.
• me have workedautonomously, collaboratively and managed large teams. me have workedin traditionalOracle envs and up to date new startups using MySQL, Postgres, Mongo, Spark at Confidential and other startups.

PROFESSIONAL EXPERIENCE

Web and Database Developer

Confidential

Responsibilities:

• Worked on multiple migrations to AWS and open source databases. Built web sited for clients and worked on various development projects
• Sole resource to troubleshoot service halting database performance problems. Using slow log implemented indexes using Percona online index builds, tuned queries and redesigned database to overcome bottlenecks 'choking' performance.
• Scripted many solutions in SQL, Borne shell for Nagios. Documented in JIRA, releases in Chef, puppet, ansible. Many DB tools implemented; monyog, sqlyog.
• Postgres databases supported and tuned, optimized for improved performance.
• Many NoSQL and big data solutions implemented; Mongodb, Hadoop, spark.
• Postgres issues wif hot tables and autovaccumresolved through redesign, indexing and SQL tuning. pgbadger implemented for in depth tuning of teh top queries performing poorly.
• Implementeddataface for online ad hoc reports for users to access on a simple to use intranet. SQL tables populated for reports in dataface, very RAD for business users who gained a high number of back logged much needed reports.
• Migrated all MySQL database infrastructure to AWS

Confidential, San Diego, CA

Database developer/architect

Responsibilities:

• Brought on board to automate all aspects of teh MySQL, postgres, Mongodb, Spark infrastructure. From installations, backups, to SQL tuning and replication; all of dis documented for support and existing SQL server admins trained.
• Scripted many solutions in SQL, Borne shell for Nagios. Documented in JIRA, releases in Chef, puppet, ansible. Many DB tools implemented; monyog, sqlyog.
• Worked wif report subscriptions in SSRS 2016 to send teh weekly run automated reports to end users.
• Developed code to automate day to day support for existing SQL server team.

Confidential, San Diego, CA

Database developer/architect

Responsibilities:

• Architect for a python and MySQL application for high volume highly numerical data input from various sources for hardware test measurements of a new product.
• Migration of existing bare metal MySQL databases to AWS, optimization of AWS resources.
• Concept, design, development of teh DB and application managed by myself to drive thedevelopment team and teh hardware engineers of teh new hardware product application.
• MySQL/Linux database system, accessed via python, matlab, R, Tableau, Mongo, Hadoop and other market leading tools developed by me wif other team members; a highly collaborative project.
• Consulted wif managers, developers and various stakeholders to gather requirements via face to face interviews and document reviews throughout.
• Support of PHP web site for ETL from mongo ingestions to SQL to MySQL DB back end.
• Postgres/Mysql upgrades/tuning/hot backups/logical backups

Confidential, San Diego, CA, US

MySQL/Postgres Database architect/admin

Responsibilities:

• Postgres (repmgr) and Oracles MySQL in production had scalability issues; me supported teh ongoing operations as well as providing procedures for ETL solutions, better scalability via adding more nodes, sharding, DB redesign, improved SQL, better tool usage.
• Python scripts developed to monitor teh database envs for uptime, performance and replication issues. ETL jobs written in Python wrappers for ETL loads to Mongo and hadoop warehouses.
• MongoDB installations carried out for multiple teams, query optimization, mongostat used to improve performance, other hardware software configuration for improved throughput etc.
• Pgbadger, pgbench used to benchmark and monitor all aspects of DB, from TPS to hot tables, index usage, stats, autovacuum issues and more.
• Development of teh Mongodb data warehouse project, responsible for designing teh Mongo Documents/Collections.
• Large volumes of log files loaded from Postgres and other sysadmin log sources to Mongo and Hadoop.
• Developed dashboards and reports from Mongodband Hadoop for business.

Confidential

MySQL/Postgres Database architect/admin

Responsibilities:

• Redesign of complex MySQL (Gallera, Tungsten), Postgres and MondgoDB environments to provide improved throughput and performance of master master/slave high transaction (10k TPS) very large DBs hosted on Linux, wif hardware and replicated standby systems.
• Postgres (repmgr) and Oracles MySQL in production had scalability issues; me supported teh ongoing operations as well as providing procedures for ETL solutions, better scalability via adding more nodes, sharding, DB redesign, improved SQL, better tool usage.
• Python scripts developed to monitor teh database envs for uptime, performance and replication issues. ETL jobs written in Python wrappers for ETL loads to warehouse.
• MongoDB installations carried out for multiple teams, query optimization, mongostat used to improve performance, other hardware software configuration for improved throughput etc.

Telmate,SanFrancisco, CA, US

BI/Data scientist/DBA

• Procedures written to handle ETL and aggregate teh largest tables to allow accurate timely denormalized reporting. Built BI dash boards for timely access to big data for business analysts, using tools me can turn around fast and other tools for user familiarity.
• Working closely wif devops in a scrum/agile env, all deploys reviewed and modified to work wifout harming system performance.
• Implementation of Hadoop and ETL loads set up for big data tables. Hive used for SQL queries and pig for easier map reduced jobs.
• Oracle 11g support in all envs. Oracle streams set up for replication, Oracle standby set up for failover. Grid control configured and deployed for alerts and monitoring.
• Application developed for Jasper, R, salesforce tools used by business analysts. Cassandra for titandb (graph DB) optimized for edge case reporting. Elastic search used across 10 servers, SSDs and fusion me/O cards, for BIG data reporting on larger tables (800 million rows)

Confidential, San Francisco, CA

Lead Database architect

Responsibilities:

• Remote support of high profile clients web sites; Pinterest, Hautelook, Zendesk, Activision, University of Berkeley, Chegg. DB systems included complex d/w to high volume terabyte OLTP startups using varying database platforms and versions
• Documentation of business rules via collaborating wif stakeholders and perform source-to-target data mapping, design and review in to Hadoop for map reduce multi-level aggregation.
• Hive and pig developed to make reports and map reduce easier for user communities.
• Support of many 11g/12c Oracle databases, rman backups, installs, configs tuning; all production systems supported. MS sqlserver 2005/2008/2012 , mysql (percona, Oracle, opensource) on 5.1.5, 5.5, postgres 8.1 wif SLONY replication, 9.1, 9.2, mongodb. Cassandra, hadoop, SQL Server.
• Responsible for many client projects and databases ongoing support, all aspects from backup to replication, ETL, production troubleshooting, performance tuning, sql optimization, upgrading, patching.
• Liaise wif multiple clients including onsite consultation to ensure new systems architecture is robust and able to grow whilst supporting existing multiple vendor database systems.
• Clients have varied environments wif some up to 10TB highly sharded wif ruby, chef puppet. Wif others at 10TB Postgres wif bare metal, others using amazon aws/rdsor rackspace hosting.

Confidential, Emeryville, CA

Lead DBA architect/developer

Responsibilities:

• Four Mysql Enterprise 5.5 architected and Installed using innodb/barracuda wif Percona tools for Oracle mysql 5.5 Enterprise. Database set up wif replicated slave standbys.
• High level of shell scripting daily using python, perl, shell scripts for automation of monitoring, data ingestion/ETL, load testing.
• MySQL databases from legacy 4.1 to 5.5 are supported and data migrated to and from MySQL as required.
• Oracle databases migrated to MySQL wif reduced downtime.
• Architected ETL solution for teh 4TB data warehouse for reporting system. PL/SQL used for ETL staging table cleansing and load optimization, using bulk collects, merge and append hints, query refactoring, mvs.
• Implementation and support of Hadoop, Cassandra and other nosql databases, databases deployed and ETL written to ingest and load, scrub data for reports and large data dumps.

Confidential, London, UK

Database develope

Responsibilities:

• Responsible for production 10g/11g databases 1TB, wif high transactions up to 8,000 per second for algorithmic trading. Many new features/solutions employed; partitioning, SQL tuning constantly. Multiple projects managed using daily scrums wif developers using JIRA project tracking to monitor tight deliverables and timelines including
• Complete Datawarehouse architecture, logical and physical design and implementation.
• Mysql 5.1 and Postgres database implemented for syslog and linux stats capture and logging. ETL process desgined for both databases for different teams, linux sysadmins and devops.
• Mysql and postgres systems documented and teams mentored on teh usage of syslog ETL systems to each database.

Confidential

Lead database developer/DBA

Responsibilities:

• Lead DBA and architect for Oracle, MySQL databases. Managed all Responsibilities of environment from SQL tuning to backup and restore best practices managing 2 DBAs and 7 developers. Resolved SQL, PL/SQL issues for performance wif development team daily.
• Management of four 9i/10G 2TB production databases for web sites on Oracle/Linux/netapps and supporting dev, test environments. 40 million members hosted on a three node 9i RAC environment wif OCFS.
• Architected and built 3TB Data mart for email to members and MIS reporting. Data replicated for reporting and mailing from four prod databases using MVs and streams.
• Hired two staff to support rapidly growing environment.

Confidential, SanFrancisco, CA, US

Senior Oracle DBA

Responsibilities:

• PL/SQL development using Oracle 10G to design and develop inter bank account transfer online application. Interface specification and Functional Specification documentation produced.
• Implemented Oracle streams replication to replace teh existing Quests Shareplex replication tool.
• Led many complex efforts to tune large batch jobs that were failing due to past 9i to 10g upgrade. Focusing on indexing; index cost adjustment, stats collection and SQL tuning to ensure teh batch jobs would complete.

Confidential, London, UK

Senior Oracle DBA/developer

Responsibilities:

• Designed and developed Mortgage Intermediary (TPI) application, allowing up to 15,000 mortgage brokers to quote RBS mortgage products online simultaneously.
• ETL for TPI developed and employed using unix arrays and Oracle Index Organized Tables to achieve efficient staged and re runable load process from larger General Mortgage system.
• Performance tuning and 24/7/365 support of 6 x 1Tb Oracle 8.1.7.4.0 GMC mortgage databases hosted on Sun Solaris F15 servers using EMC, SRDF linked SAN environment. Large team of 30 DBAs delivered teh Summit General Mortgage Compliance system.

Confidential

Oracle Apps DBA/developer

Responsibilities:

• Oracle DBA managing support and upgrade of 50Gb Oracle E-business Applications environments - AR/AP/GL/CM 10.7SC on HP 10.20 platform to 11.5.3/4 on Solaris 2.8. Shell scripts and PL/SQL developed for financial functionality wifin teh apps stack.
• Migration of 50 GB production Oracle Financials database from 10.7 SC on HP 10.20 to 11.5.4 on E450 Solaris 2.8.
• Implementation and development of Oracle Discoverer 3.1.3.6 for customised financial reporting.

Confidential

Oracle DBA

Responsibilities:

• Sysdamin team of 5 tasked wif implementing Oracle databases and Peoplesoft application throughout 28 European countries on a mixed platform of windows and Sun unix. Many implementations and upgrades handled solely and as part of a team wifin differing environments, Peoplesoft application implemented, databasebuilt, backups configured.
• Lotus Notes system developed to capture European system environments for hardware and software.
• Architectural design, install and support of large Oracle infrastructure wif 50 instances wifin teh sysadmin/dba team.

Confidential

Branch manager of high street branch

Responsibilities:

• Responsible for teh management of a Barclays Bank high street branch wif eight staff members. Highly professional customer service and relationship building used to increase branch profits and customer base.
• Increased profits in branch through new business and cross marketing to existing customers to exceed sales targets.