SUMMARY

• A senior Database administrator with 25 years of extensive experience designing, coding, testing and supporting next - generation relational and non-relational database. Proficient in an assortment of database technologies, including Datastax Cassandra, Oracle 9i/10g, MongoDB, Postgres, MS SQL, Redis, Windows and Linux, Redshift, Aurora, ElastiCache, MySQL RDS

TECHNICAL SKILLS

• Dbase III Plus Dbase IV Foxpro
• Redbrick Datawarehouse Informix Online version 7 to 7.33 Postgres version 11 MS SQL version 6.5, 2000
• Oracle 8.0.5 on Unix and Windows NT, Oracle 8.1.6 and Oracle Enterprise Edition 8.1.7, Oracle 10GR1, Oracle 11G
• MySQL 3.23.51, Mysql 4.0, Mysql 4.1, Mysql 5.1.17, MySQL 5.5, MySQL 5.6 MongoDB 2.5 to 3.1.2 with Wiretiger Datastax Cassandra 1.1, 1.2, 2.1 Redis
• ElastiCache with Redis Engine 2.8
• Veritas Storage Foundation 4.0, Veritas HA, Veritas Cluster File System
• Freebsd Linux
• Debian Linux
• Red Hat Linux
• CentOS Linux
• Solaris 7x and 8x and 9
• Windows NT 4.0, Windows 2000, Windows 2005 SqlServer 7.0 BMC patrol

PROFESSIONAL EXPERIENCE

Confidential, CA

Lead, Database Administrator

Responsibilities:

• Perform Root Cause Analysis troubleshooting database and application problem on PostgreSQL, Redshift, MongoDB and Redis ElastiCache
• Manage and design a scalable MongoDB data layer
• Help rebuild Confidential monitoring for PostgreSQL and Redshift
• Help resize and re-architect the existing Redshift data warehouse. Build script to identify Redshift tables in need of vacuum and analyze
• Manage user privileges on PostgreSQL, MongoDB, and Redshift
• Capacity Planning, Resource Planning, and Installation of Postgresql and MongoDB
• Troubleshoot bad performance and work with developers to cache frequently running queries reducing CPU usage from 98 percent to less than 17 percent
• Build and manage existing and new persistent data stores
• Persistent data stores performance tuning, including help in query tuning, index build, troubleshooting database problems Identify and create Scalability roadmap for all important data stores Investigate Postgresql sharding using Citus

Confidential, Mountain View, CA

Lead, Database Administrator

Responsibilities:

• Daily operations include: online schema change, archiving of data, snapshot backup and restore, parsing binary and general log to troubleshoot problems
• Perform Root Cause Analysis troubleshooting database and application problem. Problem solved: reduce Confidential 1.2 billion transactions per day to 100 transactions a day.
• Build a stable and scalable data layer, improving performance exceeding 300 percent in Q4 2016
• Help rebuild Confidential monitoring for Mysql and Redshift
• Help resize and re-architect the existing Redshift data warehouse. Build script to identify Redshift tables in need of vacuum and analyze
• Manage user privileges on Redshift through groups and default privileges
• Implemented MySQL Replications and MySQL Clustering
• Capacity Planning, Resource Planning, and Installation of MySQL databases
• Designing of Physical and Logical data
• Implemented MySQL Replications and MySQL Clustering
• Capacity Planning, Resource Planning, and Installation of MySQL databases
• Designing of Physical and Logical databases
• Sharding, replication, taking out master databases from service and promoting slaves as master.
• Performance and tuning bases

Confidential, CA

Manager, Database Administrator

Responsibilities:

• Designed, built and supported Highly Available database Architecture(relational and NoSQL) with multi region data center that scales supporting six million active users per day
• Served as Manager of the DBA team in the architecture and completion of large-scale implementations of MongoDB replica and sharded cluster servers and 96 ElastiCache Redis cluster for the Mobile Game Platform
• Built game platform for WB, supporting two to three million unique users per day per game, scaling to support hundreds of millions unique users per year per game
• Built and tested MongoDB profile Dashboard, profiling MongoDB slow query and errors in collaboration with Splunk
• Performed the following duties and responsibilities of a Senior DBA
• Worked with the Saleforce.com team to clean operation data for Auction.com
• Built 12 nodes Datastax Cassandra Cluster for Roku for their next generation Roku service
• Implement new monitoring system and alerts for monitoring MySQL 5.6 for Auction.com

Confidential, Redwood City, CA

Team Lead, Database Administrator

Responsibilities:

• Performed the following duties and responsibilities of a Senior DBA
• Identified root cause of database instability and low uptime implemented plans to correct the problem without loss of downtime.
• Made major improvements to the uptime operations of Confidential databases
• Performed the following duties and responsibilities of a Senior DBA
• As DBA Manager at Glu Mobile, architected, built and supported a multi-tenant database platform that supports that tens of millions of user transactions daily
• Supported over 31.4 million monthly active users and over 2.9 million daily active users
• Supported platform hosting Kim Kardashian game, generating over $100 million in revenue for Glu Mobile
• Built and supported all missions critical features requiring a database backend
• Increased Glu’s Service Level Agreement and uptime to 999.9 percent uptime with over six hundred database servers
• Support several hundred MySQL, 14 nodes ring cluster of Datastax Cassandra, MongoDb, Postgres, Redis, Memcache servers

Confidential

Sr. Database Administrator

Responsibilities:

• Performed the following duties and responsibilities of a Senior DBA
• Convert Mysql servers from 5.0 to 5.1.40 Enterprise
• Perform Installation, configuration, patch installation and RDBMS upgrade including upgrade for a new CCR Digital Mysql cluster
• Monitor, tune, size, backup, recover, analyze, defrag, and migrate
• Support developers in tuning DB and apps for optimal performance
• Install, setup and configure Mysql Enterprise Monitoring Dashboard
• Performed the following duties and responsibilities of a Senior DBA
• Designing and implementing database solutions based on customer requests and needs
• Tuning and troubleshoot Mysql servers
• Perform Installation, configuration, patch installation and RDBMS upgrade including upgrade
• Monitor, tune, size, backup, recover, analyze, defrag, and migrate
• Support developers in tuning DB and apps for optimal performance
• Monitor DB growth and provide DB capacity planning for apps expansion
• Design and implement backup methods and disaster recovery strategies
• Migrate DB between software versions, platforms, and DB products
• Work with Qa to benchmark application performance on MSSQL and Mysql

Confidential, Mountain View, CA

Sr. Database Administrator

Responsibilities:

• Performed the following duties and responsibilities of a Senior DBA
• Designing and Implementing database solutions based on customer requests and need
• Tuning and troubleshoot Mysql servers to ensure that daily SLA is met
• Installing database software, maintaining appropriate maintenance levels and tuning
• Installing and configuring tools for event monitoring, capacity planning, performance monitoring, etc. and making recommendations
• Troubleshooting and resolution of database problems
• Performing database backups and recoveries
• Producing documentation for use in configuration, repair, and troubleshooting of managed database systems
• Responding to outages both during normal business hours and in an after-hours, on-call capacity
• Coordinating and interfacing with colocation personnel during regular maintenance windows.
• Respond to end-user requests for database support
• Perform code reviews for newly developed database applications
• Assist the quality assurance department in testing applications and services which interact with MySQL
• Take direction from the VP of Engineering and project management staff in assisting on projects as needed
• Support developers in tuning DB and apps for optimal performance
• Monitor DB growth and provide DB capacity planning for apps expansion
• Design and implement backup methods and disaster recovery strategies
• Responsible for the upgrades of all QA and Dev servers from Oracle 8.1.7 and 9.2 to Oracle 9.2.0.7 using Solaris 10
• Replication experience in high volume/high availability environments using Veritas HA for Oracle
• Responsible for the creating snapplan, testing and implementing the use of EMC Flashsnap to clone 300 GB of data from production DW to Qa machines
• Work with developers and qa on monthly DB and application releases
• Responsible for the quarterly cloning of two dozen QA and Dev servers from production and staging hot backup
• Responsible for working with developers and qa on the setup, configuration, and tuning of Installshield self hosting server
• Responsible for documenting and running bi-weekly audio and video catalog generation to update catalog to Confidential .com