We provide IT Staff Augmentation Services!

Mysql/mongo Dba Resume

5.00/5 (Submit Your Rating)

Datacenter Tempe, AZ

SUMMARY

  • Highly motivated IT professional with 15+ years of experience managing large scale database environments (OLTP/DW) with Oracle 11g/12c, PostgreSQL 9.3 - 9.4, MySQL 5.5-5.6 MongoDB 2.6-3.0, Apache Cassandra 2, SQL Server 2012, OpenStack, High Availability and AWS. Experience with
  • RDBMS & NOSQL Data Modeling and DevOps skills.
  • 14+ Years of experience in Linux (Redhat, Ubuntu, SuSe, CentOS) & Unix (Solaris, Aix, HP)
  • 14+ Years of experience in Oracle database technology performing Install, upgrades, setup of cluster, replication and Data Guard.
  • 7+ Years of experience with MySQL database technology performing HA configuration replication, Galera Cluster with multiple datacenter Setup and configured with Xtrabackup for high volume production environment.
  • 7+ Years of experience with PostgreSQL database technology Install, upgrades configuring SR replication up to 6 nodes with LB, backup & restore.
  • 3+ Years of experience with SQL Server.
  • 3+ Years of experience with Python.
  • 3+ Years of experience with experience with other AWS Services (RDS, EC2, S3)
  • 4+ Years of experience with MongoDB database technology.
  • 6+ Months of experience with Apache Cassandra.

PROFESSIONAL EXPERIENCE

Confidential, Datacenter Tempe,AZ

MySQL/Mongo DBA

Duties and Responsibilities:

  • Responsible for supporting 23 Private Cloud Production and 3 Development Environment for OpenStack Icehouse HA databases (MySQL with 3 nodes Galera Cluster, 3 Nodes MongoDB and PostgreSQL) and message broker (RabbitMQ).
  • Optimized Openstack database schemas and provided consultation to various service teams for query performance improvements.
  • Performance monitoring (datadog, ClusterControl, innotop, mytop, MySQL Workbench, MONyog) and tuning, backup and restore with xtrabackup/mysqldump.
  • PostgreSQL database Performance monitoring/tuning, backup and restore size of 1TB configured with
  • Stream-Replication and Load Balancing with pg-pool II and monitor by pgCluu/pgBadger.
  • Help Application Development team to tune DB stored procedures, triggers written in
  • SQL/PLSQL/PSQL/TSQL for query optimization, schema design issues for RDBMS and NOSQL databases.
  • Design and Implemented Enterprise Level MySQL Galera Cluster backup and recovery method on 23 cloud enviorment (23 MySQL/Galera Cluster environments)
  • Application Development team to tune DB stored procedures, triggers written in SQL/PLSQL/PSQL/TSQL for query optimization, schema design issues for RDBMS and NOSQL databases.
  • Upgrade Standalone MySQL databases from 5.1/5.5 to Galera Cluster/MySQL 5.6 and PostgreSQL databases from 9.1 to 9.4 and to design and deployed 5 nodes MongoDB release 2.6 shared cluster to production for mobile apps.
  • Completed 11 set (master + slave) of PostgreSQL Replication databases upgrade from 9.1 to 9.4
  • Completed 6 nodes PostgreSQL HA/Replication databases upgrade from 9.2 to 9.4 with pg-pool middleware upgrade from 3.1 to 3.4.
  • Developed architectural plan for MySQL database HA and Scale-out to accommodate growth.
  • Optimized database settings to improve overall system performance.
  • Developed and implemented a backup and recovery system using XtraBackup for Galera Cluster/MySQL.
  • Completed 21 migration of MySQL from 5.1 to MySQL database to 5.6 on AWS instances with Linux
  • Designed and deployed 6 node Cassandra NoSQL database in Cloud environment, the current size is
  • 10TB.,This is used for CRM data warehouse and BI.

Confidential , Coconut Grove FL

MySQL/Mongo DBA

Responsibilities:

  • Responsible for supporting 13 Private Cloud Production and 2 Development Environment for OpenStack Icehouse HA databases (MySQL with 3 nodes Galera Cluster, 3 Nodes MongoDB and PostgreSQL) and message broker (RabbitMQ).
  • Optimized Openstack database schemas and provided consultation to various service teams for query performance improvements.
  • Performance monitoring (datadog, ClusterControl, innotop, mytop, MySQL Workbench, MONyog) and tuning, backup and restore with xtrabackup/mysqldump.
  • PostgreSQL database Performance monitoring/tuning, backup and restore size of 1TB configured with Stream-Replication and Load Balancing with pg-pool II and monitor by pgCluu/pgBadge.
  • Help Application Development team to tune DB stored procedures, triggers written in SQL/PLSQL/PSQL/TSQL for query optimization, schema design issues for RDBMS and NOSQL databases.
  • Upgrade Standalone MySQL databases from 5.1/5.5 to Galera Cluster/MySQL 5.6 and PostgreSQL databases from 9.1 to 9.4 and to design and deployed 5 nodes MongoDB release 2.6 shared cluster to production for mobile apps.
  • Completed 11 set (master + slave) of PostgreSQL Replication databases upgrade from 9.1 to 9.4
  • Completed 6 nodes PostgreSQL HA/Replication databases upgrade from 9.2 to 9.4 with pg-pool middleware upgrade from 3.1 to 3.4.
  • Developed architectural plan for MySQL database HA and Scale-out to accommodate growth.
  • Optimized database settings to improve overall system performance.
  • Developed and implemented a backup and recovery system using XtraBackup for Galera Cluster/MySQL.
  • Completed 21 migration of MySQL from 5.1 to MySQL database to 5.6 on AWS instances with Linux RedHat 6
  • Designed and deployed 6 node Cassandra NoSQL database in Cloud environment, the current size is 10TB.,This is used for CRM data warehouse and BI.

Confidential, Miami, FL

Consultant Oracle/Postgres/MySQL/Mongo DBA

Responsibilities:

  • Provided day-to-day DBA services for Very large database operation environment consisting of 50 PostgreSQL 9 instances, Oracle 11g Rel2 RAC with 3 nodes, 300 Oracle 10g/11g Instances, 100 MYSQL 5.5 instances, 200 SQL Server instances, 5 nodes MongoDB 2.2 and Sybase ASE 15 Instances and a Oracle EBS 11i instance on Solaris/Redhat/Ubuntu Linux/Oracle Linux/Windows/AWS.
  • Proactively identified issues and make sure services are meeting SLA’s.
  • Monitored and Troubleshot performance issues for DW database size >40TB running on Red hat Environment.
  • Worked with development teams and vice versa to deploy the change in production.
  • Usage of AWR, ADDM, ASH and Precise for Oracle Tool to Monitor Production databases.
  • Worked with other Team Leaders to create, measure, and report progress towards established key performance metric.
  • Database support including System Maintenance, Patching and Upgrades.
  • Supported and ensure SOX and ITIL Compliance within the IT infrastructure as it relates to Database Areas.
  • Coordinated root cause analysis (RCA) efforts to minimize future system issues.
  • Managed licensing requirements and promote cost efficiencies for Oracle software products
  • Managed projects and tasks related to database and database server administration
  • Designed and deployed Space Monitoring the tool to monitor around 300 Oracle database using ksh and Python3/Cx, Oracle.
  • Upgraded Oracle databases from version 10g to version 11g Rel2.
  • Upgraded existing database backup & restore scripts to back-up around 200 servers developed by me and the same scripts runs in both Linux and Unix KSH shell environment.

Confidential, Miami, FL

DBA

Duties and Responsibilities:

  • Provides day-to-day DBA services for Very large database operation environment consisting of 30
  • PostgreSQL 9 instances, Oracle 11g Rel2 RAC with 3 nodes, 300 Oracle 10g/11g Instances, 50 MYSQL 5.3 instances, 200 SQL Server instances and a Oracle EBS 11i instance on Solaris/Redhat/ Ubuntu Linux/Oracle Linux/Windows.
  • Proactively identify issues and make sure services are meeting SLA’s.
  • Monitor and Troubleshoot performance issues for DW database size >40TB running on Red hat
  • Working with development teams and vice verse to deploy the change in production.
  • Usage of AWR, ADDM, ASH and Precise for Oracle Tool to Monitor Production databases.
  • Work with other Team Leaders to create, measure, and report progress towards established key performance metric.
  • Database support including System Maintenance, Patching and Upgrades.
  • Mentor, develop and train junior staff members as needed.
  • Support and ensure SOX and ITIL Compliance within the IT infrastructure as it relates to Database Areas.
  • Coordinate root cause analysis (RCA) efforts to minimize future system issues. Accomplishments:
  • Designed and deployed Space Monitoring the tool to monitor around 300 Oracle database using ksh and
  • Upgrade existing database backup & restore scripts to backup around 200 servers developed by me and the same scripts runs in both Linux and Unix KSH shell environment.

TECHNICAL SKILLS

Hardware: IBM eServer (p690, p520), Sun Ultra Enterprise E15K, E10K, Sun fire 6800, Dell

Virtual Manager: Oracle VM VirtualBox, Oracle VM Server for x86, VMware

Operating Systems: Ubuntu/RHEL/CentOS/SuSe Linux, Aix 6.1L, Sun Solaris 10/11Cloud: AWS EC2, EBS,RDS and S3

ERP/CRM: Oracle Business Suite 11.5.10, Oracle CRM 11.5.8, Compiere Rel 2.5

RDBMS: Oracle, PostgreSQL, MySql, SQLServerNoSQL: MongoDB, Cassandra

BIGDATA: Hadoop Framework

DW Tools: Informatica, Hyperion, Cognos, Business Objects, Oracle Discoverer

Languages: Python, Java/JDBC, C/C++, Pro*C, SQL, pgPL/SQL, PL/SQL, KSH,perl

Tools and Suites: Confio, Precise For Oracle Ver 9, Virtual Box 4.2, Golden Gate, Veritas Vol Manager and File Manager, Netbackup, Citrix and PCanywhere, Toad, Oracle Developer Suite SQL-Developer, DataDog, AutoSys

SCM: SCCS, GitHub

Web: Apache HTTP, Tomcat, JBOSS, Oracle iAS

Case Tools: Erwin 4, DBDesigner 4

Call Logging Tools: Jira, Clarify 8.0, Heat, HP Service Desk, UNICENTER Service Desk

We'd love your feedback!