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