SUMMARY:

• I would like to obtain a full - time position as a Senior Database Administrator, supporting any of a multitude of database platforms from Oracle, MySQL, Microsoft SQL Server, PostgreSQL, as well as NoSQL databases, particularly MongoDB. My unique background of web development and database expertise building highly performant web applications sets me apart from most others in the database field as
• I can provide a thorough level of introspection into potential issues arriving at the database layer from any application, whether it is an online web application or mobile app or game.

TECHNICAL SKILLS:

Database Servers: MongoDB 1.8 3.2 Oracle 8, 10g RAC, 11g, 12c MySQL 4.0 - 5.0, Percona Server 5.1, 5.5, MySQL Cluster Microsoft SQL Server 6.5, 7.0 Sybase ASE Server PostreSQL

Database Development: MapReduce (development), Hadoop (development), HDFS (development), Oracle PL/SQL, Microsoft Transact-SQL, ANSI SQL

Database Monitoring: Oracle Enterprise Manager 10g/11g, Nagios, Microsoft SQL Server Nagios plugin, Percona Nagios Monitoring Plugins, check mysql health, check oracle health, logwarn, Percona Toolkit

Programming Languages/API: R language, Java 1.3, 1.4, 5.0, 8.0, Java Servlets 1.0-1.4, Java Server Pages (JSP), Java Custom Tag Libraries, Java Message Service (JMS), Java Mail, Objective-C (personal), TCL, XML, XSLT, XPath, WML, C++, Visual Basic, Active Server Pages (ASP), Microsoft ADO, Microsoft RDS, SOAP, JavaScript, VBScript, VB for Applications (VBA), HTML, Microsoft OLE DB, Microsoft DAO, Microsoft Remote Data Objects, ODBC

Scripting Languages: BASH scripting, Perl, Python

Server Software: Akka, Apache Kafka, Apache Storm (development), Apache Spark (development), Node.js (development), Apache Tomcat 4, 5.5.5, Jboss 3.0, 4.0, DoubleClick AdServer 4.0 Apache Web Server 1.3, Vignette StoryServer 5.0, Netscape Enterprise Server, Allair (Macromedia) JRun 3.1 Enterprise Edition Professional Edition Server, Microsoft Internet Information Server 5.0/4.0, Microsoft Transaction Server 2.0/1.0/COM+, Microsoft Index Server 2.0, Microsoft Exchange 5.5., Microsoft SMTP Services, Microsoft FTP Server, Microsoft Remote Routing Access Server

Cloud Environments: Amazon Web Services (production), Google Cloud Platform (development)

Server Management: Puppet, Chef, Capistrano, Vagrant (development), Packer (development)

Collaboration Software: Atlassian Jira, Atlassian Confluence

Application Service Providers: Falk AG Ad Serving, DoubleClick DART Ad serving

Operating Systems: Red Hat Enterprise Linux 3, 4, CentOS Enterprise Linux 3, 4, 5, 6, 7 (development), Sun Solaris, Network Appliance Data ONTAP 6, 7, IBM OS/400, iOS 3.0-8.0 (personal), Windows 2000/2003 Professional/Server/Advanced Server, Windows NT Workstation/Server 4.0, Windows 9x/3.1; UNIX AIX 3.25/4.1, Novell 3.1, OS/2 Warp 3.0/2.11

PROFESSIONAL EXPERIENCE:

Senior MongoDB Database Developer/Administrator

Confidential

Responsibilities:

• Designed MongoDB Document Models for Oracle to MongoDB transformation
• Developed Aggregation Framework queries for MongoDB 3.2 lookup functionality
• Setup Development MongoDB 3.0.6 and 3.2.0 Replica Sets for development teams and integration tests
• Architected Data Governance polices for use with MongoDB and all teams
• Analyzed query patterns and developed indexing strategy for MongoDB
• Programmer for Java transformation actors for Oracle pipelines to MongoDB transformation using Akka and Apache Kafka

Senior Database Administrator

Confidential

Responsibilities:

• Introduced Percona Server 5.5 (MySQL equivalent) into environment and drove the MySQL Upgrade project to bring current 5.0/5.1 infrastructure of over 310 MySQL instances to get to 75% of instances upgraded to Percona Server 5.5.27
• Supported 5 MongoDB production replica sets driving key Confidential sites, including one with international reach, having MongoDB nodes in the USA, England and Germany.
• NFS Removal Project - Worked along with other database administrators to refactor existing Perl and Shell scripts and infrastructure to remove dependencies on NFS file systems for all database hosts
• Developed InstantSite web application using an Apache, PHP, Zend Framework and MySQL stack for tracking of web site to database configuration metadata for database administrator support information
• Created framework for logging and parsing sysbench performance results to a database for analysis of different MySQL versions (5.0 Community, Percona Server 5.1 and 5.5). This testing framework acted as a baseline for application testing and vetting.
• Analyzed and worked with development staff for GameTrailers.com to improve read-only MySQL VIP usage for queries to increase scalability prior to high traffic spikes related to Electronic Entertainment Expo (E3)
• Monitored and initiated data refreshes for development and QA environments for Oracle 11g infrastructure.
• Supported Oracle 11g RAC and single instances dedicated to SAP and PeopleSoft applications.
• Decommissioned Spike Oracle 10g Real Application Cluster and aided in migration to NoSQL environment on MongoDB 1.8. Decommissioned The-N standalone Oracle instance and aided in migration to MySQL 5.1 Master-Multiple Replica configuration
• Created a TCL Probe for Cisco ACE load balancer used to connect multiple MySQL instances in a VIP which was responsible for determining the replication status and replication lag between replicas and the master instance—and reported whether a server was fit to be in service until replication issues were resolved.

Oracle Database Administrator

Confidential

Responsibilities:

• Database Installation, Monitoring and Administration
• Installed Oracle 10g 10.1.0.3 Real Application Clusters on 6-node Red Hat Enterprise Linux read-write cluster for use by production web site
• Installed Oracle 10g Enterprise Manager and database node agents for 24/7 monitoring of production, QA, and development database environment and hosts with web based reporting
• Performed physical and network installation of Oracle 10g node hardware into colocation facility
• Initiated Oracle 10g 10.1.0.4 rolling maintenance upgrade with complete uptime and database availability throughout installation process
• Initial tests of fully online database migration from separate Internet server co-location facilities from San Jose (Globix) to Los Angeles (Peer1 Network) using Oracle Streams, eventually dropping down to database exports because of failure of Oracle Streams to maintain a satisfactory transaction update rate
• Troubleshooted Cache Fusion issues with concurrency due to high OLTP traffic from the application with high write and high read activity centralized on one dedicated set of tables
• Performed Oracle 10g 10.2.0.1 upgrade using database exports
• Oracle 10g 10.2.0.2 upgrade using Oracle DataPump export/import
• Storage
• Performed setup and configuration of Network Appliance Filer FAS270 and higher redundant FAS3020, implementing volume setup and scripted snapshots and SnapRestore to enable quick refreshes of data to development and QA environments from production data
• Performed setup of Network Appliance Filer FAS3020 for better database scalability of clustered storage of database files and quorum files
• Networking
• Partitioned networks used by Oracle 10g RAC databases on Dell and Cisco enterprise switches for use for internal and external communication between nodes and client servers
• Wired patch-panels to database nodes and NetApp Filer shared cluster storage
• Researched hardware and operating system alternatives comparing 64-bit x386 Linux, Windows, and Solaris architecture, taking into account performance, flexibility, and maintenance requirements relative to 32-bit environments
• Management
• Used Oracle 10g Enterprise Manager utilizing ADDM and AWR reports to manage ongoing performance of production
• Configured backup and recovery of Oracle databases using Oracle RMAN
• Used Oracle Scheduler to manage real-time updating of film view summarization of content impressions, and other content related data summarization tasks
• Devised data management of new and archival impression data involving more than 600 million database records using Oracle Partitioning also utilizing exchanging tables and partitions
• Performed emergency database debugging and immediate recovery from database node failure, tracking down network connectivity and hardware issues
• Implemented content aware full-text indexing and content retrieval of web content using Oracle Text, stored procedures, and developed a custom Java API for use by other developers

Manager of Applications Development

Confidential

Responsibilities:

• Directed a team of 4 Senior Vignette/HTML developers and 1 Oracle Database Administrator in the development of administration tools and channel page refactoring allowing dynamic addition of new site additions with variable layout structure and numerous display components for content promotion
• Designed and developed first Confidential business to business content distribution and syndicated skinned partner player environments for Disney and Showtime
• Philips Interactive integration of daily updating content with Stremium Internet connected television set-top device.
• RealNetworks RealOne player development of complete viewing experience with full-screen quality 500 KB/s subscription content of Confidential Plus+ exclusive service
• Lead investigation of next generation of database infrastructure with test implementations of MySQL Cluster, from initial CVS builds available at the time, and Oracle 10g Real Application Clusters with the goal of scaling the database read-write capacity for all future large scale growth estimates
• Managed complete server migration of co-location facility from Globix (San Jose, CA) to Peer1 network (Los Angeles, CA) using a mirrored hardware and software architecture, resulting in a minimal downtime of less than 2 hours.

Senior Engineer

Confidential

Responsibilities:

• Contributed to the design and library usage in major code implementation converting from Vignette StoryServer to Caucho Resin Java Application Server and a unified J2EE web architecture
• Lead evaluation of open-source Java Application servers for cost-effective migration to Apache Tomcat, JBoss, and other freely available enterprise application servers
• Implemented initial and evolutionary use of Hibernate starting with early versions post version 1.1 using Data Access Object patterns
• Used Struts and later Stripes for full MVC implementation with current use of JSP, XML, XSLT, and other presentation languages
• Evaluated potential migration of codebase to use Java Server Faces (JSF) and other alternative MVC frameworks from OpenSymphony and Apache—and determined possible effects on all levels of developers from Senior Engineers to front-end HTML and JavaScript developers
• Championed the use of Yahoo User Interface JavaScript library for next level of Web 2.0 interactions and UI functionality
• Oracle
• Abstracted out the database layer, firmly implanting a business logic tier, for Vignette StoryServer 5 application developers by initiating Confidential ’s use of Oracle 8 Stored Procedures, Functions, Packages, Triggers, and Views to replace Vignette StoryServer template database commands, which previously anchored database logic to the application layer
• Developed and performed Engineering department technical for organization-wide development standards and best practices/restrictions for Oracle 8 stored procedure creation and use in Vignette StoryServer and Microsoft IIS application server environments.
• Created and maintained Oracle 8 relational database schemas using ERwin based on business/data requirements for http://www. Confidential .com, http://www. Confidential .com, http://www. Confidential .com, and SpecMarket script service, for the purposes of high concurrency and high availability.
• Performed data analysis of Muzetm data integration into a combined Confidential .com and Muzetm schema for http://www. Confidential .com relaunch
• Performed SQL and index analysis of existing and in-development queries
• Vignette StoryServer
• http://www. Confidential .com
• Lead Engineer in the planning and evelopment for the Confidential .com June 2001 relaunch.
• Programmed Confidential, Web Film, and People administration tools, which integrated Vignette security (users, roles, and groups), to manipulate Muzetm theatrical, video, and DVD data and Confidential supplied content for use in Vignette content delivery templates.
• Analyzed and developed the componentization of code through Vignette libraries and components in high traffic areas—including film, people, and channel pages.
• Designed in-memory/disk based caching strategy for high concurrency using a combination of Vignette/TCL namespaces and Perl shell scripts for maintaining and refreshing data and content, throughout the day over a cluster of Sun Sparc/Solaris servers that scaled from 12-50 over the life of that infrastructure
• Browser integration with HTML embedded players of Windows Media Player, RealPlayer, QuickTime, and Flash media with full specified functionality for all major browsers on Windows, Macintosh and graceful degradataion on minor browsers on each platform to maximize market reach
• Developed system for dynamically generated RealPlayer SMIL, QuickTime SMIL, and Windows Media Player ASX play lists of Confidential IStream ads and streaming media. This was one of the first uses of pre-roll and post-roll video advertising in Internet video, becoming a primary driver of revenue for Confidential, responsible for 40-50% of income.
• http://www. Confidential .com
• Technical Project Manager of SpecMarket script service, leading a team of engineers in the design of development of administration tools and delivery templates
• Engineered administrative tools for use by non-technical users for the maintenance of user registration, message board moderation, and film screening rooms.
• Developed content delivery templates for customized user, film, writer, and script tracking.
• http://www. Confidential .com
• Developed user customized calendar system for scheduling film screenings, appearances, and events fro film festival attendants and tools for filmmakers for project submission.
• Designed and developed administrative tools for non-technical users to create and customize reports for delivery to subscribers to Confidential ’ reporting service
• DoubleClick
• Using DoubleClick AdServer 4.0, created multiple new advertising based revenue streams for the organization, based on Confidential ’s IStream ads (streaming media or Macromedia Flash) for all streaming media, popup interstitial ads, Java applets, and banner packages.
• Created system for delivering IStream information, using DoubleClick’s ad serving capabilities, which allowed for normal reporting of impressions through traditional client means
• Akamai
• Analyzed Akamai media/content caching requirements and interface.
• Developed Tcl Akamai ARL generator for dynamic creation in Vignette StoryServer templates
• Analyzed architecture and integration requirements of Akamai EdgeSuite and FreeFlow services into existing Confidential infrastructure.

Confidential

Responsibilities:

• Designed and developed an N-tier Microsoft DNS Intranet security and application framework for Human Resources Manpower Planning System, with Program customization, and trainee progress tracking.
• Created database schema for Hardware Tracking Inventory of all computer and restaurant register equipment
• Developed online/offline Learning and Programs for restaurant General Managers and staff regarding operating and back office software procedures, general computer /troubleshooting.
• Performed systems analysis and planning of Company Financial Information Reporting System.
• Developed Management Objective Tracking database and backend AS/400 data pipeline program using COM/DCOM components and executables

Web and Database Developer

Confidential

Responsibilities:

• Analyzed legacy Java project for site and recovered User Registration to be used for future redesign
• Designed and developed schema for Versus skater competitive trick match polling mechanism
• Migrated user poll data from legacy Microsoft SQL Server to MySQL Server
• Used Java Servlets, JSP and Flash form integration for front-end with enforced user security
• Integrated model with existing structure of code developed by the previous development team
• Created dynamic real-time reports of trick competitive match-ups to be used by business users to monitor progress of active contests
• Refactored legacy content admin tools for use by new poll preparing for Versus II skater contest