We provide IT Staff Augmentation Services!

 staff Mysql Database Administrator Dba Resume

4.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY:

  • I am a fun, eager and passionate person ready for a new challenge - I have over +4 years’ experience with Datastax Cassandra, +10 years Mysql / Percona / MariaDb / TokuDB production experience in large scale Big Data infrastructure with data compression and worldwide data center redundancy .
  • +15 years of Oracle experience in production development and implementation of Internet applications in a large-scale, massively concurrent, highly available distributed systems in Unix environment such as Centos, Redhat, Sun, AIX env, My broad range of experience includes database administration, Site Reliability Engineer, application development, project management, systems programming and systems administration.
  • I am fluent in PL/SQL, bash shell scripting and some Perl. DNS configuration, yum repo config and installation setup.
  • My computer experience includes Cleversafe, SAN, VCS, Qnap, UNIX, Linux operating systems. My database experience includes high volume transaction OLTP database and data warehouse, utilizing many of Oracle's advanced features such as multimedia, advanced queuing, advanced replication, materialized views, transportable tablespaces and Oracle RAC.
  • I am skillful in system analysis, trouble shooting and database tuning.
  • My job experiences have helped me develop skills with an ability to develop good and fast results at all levels of interaction and to be an ideal team player for the group and the company. Eager to learn new technology .
  • I believe in: “work smarter not harder” and “simplify and script as much as possible”

TECHNICAL SKILLS

SOFTWARE: Datastax Cassandra 2.x, DSE 4.5.5 and 4.8.8, Percona MySQL Enterprise, InnoDB and TokudDB storage engine plugin, MaraiDb, MySQL Enterprise Dashboard Monitoring Tool, Java 1.7/ 1.8. Clustrix cluster db, Oracle Database Migrate Utility, Oracle Network Mgr, Oracle Server Mgr, Oracle SQL*NET v1-v2, Net8, Oracle Enterprise Manager OEM (Tablespace Mgr., Expert Mgr., Instance Mgr., Security Mgr., Schema Mgr., Storage Mgr., Performance Mgr., TopSession Mgr., Lock Mgr., Trace Mgr., Export Mgr., Import Mgr., Backup Mgr.) Oracle Enterprise Backup Utility EBU, Oracle Parallel Sever OPS, Oracle Symmetric Replication Symrep, Oracle Parallel Query OPQ, Oracle SQL*Plus, SQL*Forms, SQL*Reports, SQL*DBA, PRO*C, Oracle*ODBC, OracleWare, Personal Oracle7, Motif, X-Windows, GNU Emacs, VIP/IX, Uniplex, ALL-IN-1, Microsoft Visual Source Safe Database v5.0. InfoCrypt Secure Tunnel 3.06. Legato Backup and Storage Mgr, MS Query v2.0, Intersolve ODBC. Veritas Cluster Server (VCS).  Quest Shareplex database replication v4, v5, Toad Admin Utility, Teradata Enterprise Software for DW,  Erwin Data modeling, MySQLslap, Maatkit,MySQLsla, Mytop, MySQLtuner, Innotop, Sysbench, MySQLslap, MySQL Toad, MySQL Workbench, DBVisualizer, EMS SQL Mangager, FreeMascon, Webyog, MyDB Studio, Navicat 8, SQLexaminer, WinSQL Lite, Power*Architect, MySQLizer, InnoDBbackup.pl, Percona MySQL Storage Engine plugin, SQLyog, SQLmon, SQLworkbench, MyTop, MySqlizer, Puppet, chef, Docker automation tools

LANGUAGESUnix Shell programming Ksh, Bsh Csh, Perl, C/C++, Python, SQL, PL/SQL,

DATABASES: Cassandra 2.x, Datastax DSE 4.5.5, 4.8.8, Mysql v5.0.x - v5.7.x, MairaDb 10.0, TokuDB, Informix, Focus, Ingres, Access, MS SQL Server, Teradata, Oracle Rdbms  v7.3.x, v8.1.x, v9.2.x, 10g1, 10g2, 11g

NETWORKDNS, TCP/IP, LAN, X-25, DecNET, TCP/IP, Novell SPX/IPX, IPC, Named Pipes, Oracle ODBC, Intersolve ODBC, Oracle Nameserver, Oracle Tnsnames and Oracle Sqlnet configuration and Troubleshooting

HARDWARE+O/SLinux Redhat, Debian, Centos 5.9, 6 and 7, Ubutun, Sun Solaris, AIX, IBM RS/6000, HP 9800, SUN 4, Alpha OSF/1, DEC Risc Ultrix, DEC Vax/Vms, DG/UX AviiON, SCO Unix OpenSystem,

SPECIALICATIONHigh Performance Internet E-Commerce Saas,Systems, Internet Business Systems, Database Programming and Administration. Familiar with MySQL tuning and configuration, Cassandra installation and setup and troubleshooting, ORACLE DB memory (SGA, UGA and PGA)/process (background, foreground and server) /file (control, data and redo) structures, ORACLE data dictionary tables and views. SQL scripting. Familiar with Oracle Kernel internals. Oracle debugging tools. Oracle data block, segment and extent structures. Very comfortable at reading Oracle trace files, stack, system state and process state dumps, data block dump, control file and data file dumps to identify problems. Familiar with SQLNET V2, Net8 and Name Server. ODBC, JDBC. Familiar with Multiple Threaded Server and Dedicated Server concept. Backup/Recovery Strategies, Hot Backup. Failover, VCS, SAN Storage. Oracle Cost Based Optimizer. Oracle Data Warehouse (Bitmapped Index, Star Query, Direct path load, Parallel query). Distributed database concept, Oracle Advanced Symmetric Replication. Oracle8 New Features. Installation of and Migration to Oracle8. Heavily emphasis on importance of documentation of each actions and resolutions from error by step by step process how to implement or resolve known issues and problems. Also emphasis on establish quick communication via phone bridges and AIM chat sessions and how to quickly identify who should be called and notified to resolve any issues ASAP. 

WORK EXPERIENCE:

Confidential

Sunnyvale, CA

 Staff MySQL Database Administrator DBA

Responsibilities:
  • Fulltime MySQL DBA, primary responsible DBA for Production Anti - Spam, Financial, Flurry, Tumble, YAMs database environments and it s day to day operation. Manage SQL replication between 5 datacenter across the globe for the Yahoo cloud infrastructure. Develop and deliver configuration and automated deployment, improving functionality, availability and manageability. Gather data and metrics for automated monitoring tools.
  • Reduced the footprint of the Financial of 36 master and slaves down to 17 master / slaves to save network transfer cost and hardware cost for the overall servers involved in the global cloud environment Same approached was performed on the Changelog db environment as well on the old mail-anti-spam environment.
  • Created new cluster environment and planned phasing out old environment running on older hardware, Setup requirement and planned for execution and did the software installation from Mysql 5.5 to 5.6 and Mysql configuration and tuning of the cluster. Setup role based automation for grants and package updates to automate easy grant changes for development and requestors. Performed daily code reviews to improve performance and simplicity.
  • Setup Xtrabackup filer and storage for daily backups using once a week full backup and then incremental backups for the rest of the week . Then performed weekly backup restore of the named backup to test ensure the backup are valid and documented and script automated the restore process to get accurate ETA how long it would take to restore a full backup and it s incremental daily backups. Also tested and documented and scripted the binlog apply process for a Time based recover or Position and binlog recover scenarios
  •  Speaker at Percona Live 2017 Mysql conference in Santa Clara, CA. In-depth talk about Xtrabackup and how it s being used at Yahoo and pros and cons using it and using other tools or snapshots implementation of backups.
  • Managed Yahoo Cassandra evaluation and test environment, worked with developer and bring them up to speed how to use Cassandra and how to implement Cassandra applications. Tested new hardware configuration and gave advice how to take best benefits from using Cassandra database versus a Mysql database.
  • Worked in Yahoo-Tech team supporting MySQL and Oracle Clusters, Involved in escalation and troubleshooting whenever needed when brought to attention from alerts or internal customer request to help out, This was tracked and updated via the internal task web portal and tried to close out the request as soon as possible.
  • Wrote internal and personal tools to quickly troubleshoot and bring cluster back to normal operation, with Failover tools and automated fixing. Used Pogo and Brooklyn DNS rotation tools. Use GIT for version control of new code and GIST and SLACK and HIPCHAT to share ideas and solutions with co-workers and tech engineers,      
HIGHTAIL / YOUSENDIT

Campbell, CA

taff MySQL Database Administrator DBA

Responsibilities:
  • Primary Fulltime MySQL DBA responsible for Prod/Stage/Qa/Dev environments and it s day to day operational duties. Manage refresh of database environments for Dev/QA/Stage and purging and cleaning Production data from sensitive information and dead data no longer needed to speed up performance, memory config tuning and periodically revisit configurations settings and slow query log for new BAD Sql that is hurting the performance.
  • At Highttail I been working on the following software Datastax Cassandra 4.8.8, Amazon RDS MySQL, Percona 5.6, MariaDB 10, Java, Node - JS, Redis, Talent, ThoughLight, S3, AWS CleaverSafe, Softlayer, SendGrid, Pusher, LogStash, MailGun, CloudConverter, Imix, Github, Chef, Travis, Redis, NewRelic, Fastly, ActiveMQ, SnowFlake, Heap, ElasticSearch, Splunk, Nagios, Amazone AWS, Docker, Terabyte data implementation and Pegabyte file storage.
  •  Been working on moving and migrating database data from one Data center to a new better cost efficient new Data Center. Also been working on setting up MySQL in Amazon AWS and create replication slaves on premises data and to new data center for data ware house purposes. Currently involved in a project to move away from AWS back to in house own data center again because customer in different continents want to know where data is stored.
  •  Been the Lead Datastax / Cassandra man to go for operational and setup and installation of Cassandra from proof of concept to final deployment in PROD. Setup rollout plans and scripting for major upgrade of Datastax Cassandra 4.0.2 to 4.5.5 and have just upgraded to the latest 4.8.8 build in June 2016. Also upgraded Java 1.7 to 1.8 to take advantage of G1GC a bigger heap buffer Java 1.8 can handle and bumped up the HEAP size.
  • Automated daily Cassandra Snapshot backup and tested restore via AWS to remote on premises datacenter hosting our Staging Cassandra test cluster environment. Tested SSTabledump load tool to export data between two different Cassandra cluster that needed real Production data to run stress test on.
  • Deployed a 12 node Clustrix database cluster in QA/STAG/PROD setup and installation and configuration tuning for our need. Later we decided Clustrix was not for our company and reverted back to MySQL and deployed the stack to us Cassandra instead which was a much better fit for us and our application
  • Work closely with Unix SE to setup new Linux boxes and tune Linux to run most efficient for database application, using the right caching and I/O tuning and heap management to get a stable and fast running database servers. A strong believer in SSDs memory and fast disk layout. Write setup and install procedures documentations.
  •  Also the only person in charge for backup and recovery of all database types, Cassandra snapshot to disk and of load to QNAP disaster / recover solutions . Same goes for MySQL database where I wrote my own bash scripts in conjunction with Percona XTRA backup plugins. A strong believer in testing backups as well and to refresh QA and STAGE periodically. Most automated and scripted work hard once and then let the same scripts and procedures do the job for you over and ov
  • Deep knowledge and experience designing and maintaining relational databases using MySQL, Cassandra, Oracle, Redis. Familiarity with Amazon Web Services (AWS, EC2, EBS, S3, etc.). * Unix Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking, clusters and troubleshooting on Centos, Ubuntu. Storage engineering experience, including NAS, SAN, SSD. scripting language (bash, ksh, Python, Perl). 
Confidential

Foster city, CA

 Senior MySQL Database Administrator DBA

Responsibilities:
  •   Primary MySQL DBA responsible for Prod/Stage/Qa/Dev environments and it s day to day operational duties. Manage refresh of database environments for Dev/QA/Stage and purging and cleaning Production data from sensitive information.
  •   Setup MySQL backup and scripting to allow 10 days backup locally on disk and also allow remote backup to tape for fully disaster recovery scenarios.
  • Tested backup restore and recover functionality and scripted restore to have it handy if ever needed so the correct path and functionality was test and tried out in an event of disaster would occur. Wrote check script to reinsure the backups was error free and managed error handling via email alerts and progress only in case of error to minimize spam and unnecessary over information, but kept all log files on local disk for troubleshooting if needed.
  • Setup Percona Tool kit and Maatkit tools to fully utilize and integrate those tools in the environments. Used Zenoss, Cacti, Groundworks, Traksmart Liferay, Wiki and Jira to monitor and document changes and environments.
  • Used Jasper Reporting tool for dataware house purpose. Manage the data load and refresh of data on a daily or weekly schedule.
  •   Participate in the database design, implementation, optimization and ongoing management, responsible for requirements for functionality, scalability, availability, performance and reliability. Provide support for developers and engineers connectivity and troubleshooting efforts. Wrote step by step documentation for per coworker to cross train the hole time how to manger and install mysql in the best practice scenario and to avoid mistake or miss configurations of the database from performance and ease of user perspective.
  •  Setup Master Slave and Master Master Replication instances for Production and Reporting use.
  • Troubleshoot replication errors and slave delay and inconsistent data between instances, write script to do checking and automatic load. Move production mysql version 5.0.x to latest and greatest mysql 5.5.x version across all database environments. Installed and evaluated Percona Database Server instance to move future deployment on this new mysql flavor. Benchmarked current mysql installation against Percona performance server. Made recommendation for future installation and road map.
  •   Main focus on Mysql performance and optimization of mysq parameters and prober installation and setup of the mysql instance.
  • Used mysqlSLA and memory.pl script to help find bad SQL and optimize mysql memory parameters. Also used SQLmon, SQLworkbench, MyTop, MySqlizer,MySQLbalance to help identify problem SQL and find proper configuration values

Confidential

Mountain view, CA

Senior Oracle Database Administrator DBA.

Responsibilities:
  •  Hired as the first fulltime Oracle Database Administrator. Responsible for establish Database standards and bring current DB environment to an Enterprise standard.
  • Performed host setups and database installation of 10g1 and 10g2 32bit and 64bit enterprise versions. Set up a 3 nodes 10g2 RAC environment, upgraded 10g1 to 10.1.0.5.
  • Wrote report script and web reports to produce daily/weekly reports upwards to management.
  • Provided QA and DEV with test data and refreshes of databases with trimmed production data using oracle data - pump and clean out script that removed and null out sensitive customer data before handing it over to developer. Rewrote load procedures and trimmed down the process from +15 hours to less than 3 hours.
  • Tuned database using AWR and stats-packs reports or own written tuning scripts.
  • Responsible for contract and interactions with Oracle Sales and Support representatives and log support Service Request and follow up.
  • Set up a 4 node RAC cluster for a new Web Mobile phone service for Sprint cellular phone application.
  • Was involved from design to implementation of the hole system and gave input and knowledge from an database perspective how to design a 99.999% uptime Oracle RAC system and where data was shared among multiple database nodes.
  • Implemented new hot backup backup strategies and procedures rather than doing simple export, Oracle RMAN backup was setup to be able to do Point in time recover to last second or last archive log to minimize data loss. Sporadically tested this backups and documented all steps thoroughly to hand over to whomever comes after me.

Confidential

Sunnyvale, CA.

Senior Software Engineer / Production & QA Development DBA.

Responsibilities:

  • Responsible to set up Unix scripts and shell cron job to automate the cleanup procedures and backup procedures of the databases.
  • Wrote and maintained PL/SQL and SQL triggers and stored procedures for complex database issues. Performed Unix Admin tasks for the file system and the network, handle all kind of day to day monitoring and maintenance for all the Sun Solaris and Dec Alpha boxes that development, QA and Production are built up by.
  • Used Oracle Enterprise Manager to overview and implement changes on all databases in the network including Tablespace, Schema, Security, Data Instance, Storage, Performance, Top session, Lockmgr, Trace, Expert, Import, Export, Backup manager tools.
  • To summarize: Responsible for all data and content used by all Pointcast Clients to view graphics, pictures and raw text provided by Pointcast media sources via satellite and internet and feed into the QA and Production databases stored as compressed data as well as uncompressed as later to be delivered to the Pointcast clients over the internet.
  • In charge of delivering code and data on time to keep project within time frames and to ensure highest possible Quality Assurance for all Pointcast products.
  • Architecture performance tuning experience at the source and configuration levels.
  • Responsibilities include defining the database needs for the company's service referring to table sizing and storage demands for now and future growth. Established performance requirements and load estimates, define data models, document database server requirements to implement highest database performance and backup strategies and failover scenarios.

We'd love your feedback!