SUMMARY

• Skills Overview - - 17 plus years as software engineer
• Cloudera Hadoop admin and developer certified
• Echosystems: Hbase, Hive, Pig, Sqoop, zookeeper and MapReduce
• Hands on HDFS, Big Data, ETL for data warehouse projects
• Strong SQL programing, Hiveql for Hive, Pig and Hbase
• Strong Rad Hat, Linux admin skills, Worked wif Unix/Linux for last 14 years
• Strong production support DBA skills in RAC environmen, RMAN, Golden Gate
• Oracle DBA: including Erwin database design, development, testing, implementation and data warehousing
• Data Architect: system design, data model design, backup/recovery strategies, OLAP WH project
• Strong database performance tuning skills: OS kernel, database parameters, Sql statement
• System monitoring setup and configurations: Oracle Enterprise manager 12c, Nagio, Dynatrace

TECHNICAL SKILLS

OS: Red Hat, IBM AIX, Oracle Linux - RHEL 6, HP/UX 11, Centos 6.4

Networks: TCP/IP, Windows NT 4.0 Server

Software: Cloudera/Hadoop manager 4.5 Oracle Real Application Cluster (RAC) 10g 11gr2, Data Guard, 10g/11g database Oracle Enterprise Manager Grid Control (OEM) 12c, Golden Gate 10 CA Erwin R7

Hardware/software: ASM for Oracle RAC, NFS

Languages: PL/SQL, COBOL/COBOL II, Shell script

PROFESSIONAL EXPERIENCE

Confidential

Hadoop admin/developer and Oracle DBA support

Responsibilities:

• Installed and configured Red Hat/CentOS/Cloudera manager wif Hadoop multiple nodes
• Collected data from different databases( i.e. Teradata, Oracle, MySql) to Hadoop
• Created Hbase, Hive, Pig and mapreduce scripts
• Worked on Hive/Hbase vs RDBMS, imported data to Hive, created tables, partitions, indexes, views, queries and reports for BI data analysis
• Conducted introductory classes on Hadoop admin and Hadoop developer
• Troubleshooting and performance tuning on Hadoop system
• Installed, refreshed, upgraded 11g databases
• Production Support for any OLTP database issue
• Work closely wif Application teams to resolve performance issues

Confidential, Midland, MI

Oracle RAC admin and OEM 12C admin

Responsibilities:

• Installed and configured 11gr2 RAC and Oracle Enterprise Manager 12c (OEM) to monitor all 24 nodes 24/7 on cluster, ASM, listeners, databases, agents and performance tuning
• Setup notifications, admin groups, monitor templates, incidents rules, scheduled jobs for backups, database clone, SQL performance, AWR reports
• Production Support for RAC system
• Documented troubleshooting procedures

Confidential, Dodgeville, WI

Oracle Architect/DBA

Responsibilities:

• Performance tune production database: Solaris 10 kernel and Java application
• Created performance health check report using OEM Grid control to analyze data in conjunction wif AWR analysis by ADDM
• Heavy user interface wif marketing team to reorg data warehouse to support the Business Intelligence model, also completed many SQL store procedures for analysis and market trending and cleaned up, refreshed all images for company online sale.
• Installed and configured Oracle Golden Gate for bi-directional replication
• Production Support for all Erwin data models for company databases. Managed requirements and releases for all international marketing work tracks
• Designed new production databases merge strategies
• Configured Nagios for system-wide monitoring
• Re-designed company development architecture and refresh procedures on VMware

Confidential, Seaside, CA

Senior Oracle System Database Administrator

Responsibilities:

• Installed and configured OEM (Grid Control) for security system
• Designed and maintained relational database model, wif many sub models
• Monitored and performed troubleshooting for all US Air Force Base PIPS databases
• Performed SQL tuning for system statistics reports worked on Data warehouse project, ETL scripts and implemented.
• Setup policy for database security, such as audit vault, FGA and encryption
• Optimized system configuration related to daily performance and maintenance
• Provided solutions for data guard performance on network issues
• Installed Oracle 11g RAC on Linux RH, ASM
• Installed and configured Golden Gate to replicate Oracle 11g databases

Confidential

Senior Oracle DBA/HP-UX Administrator

Responsibilities:

• Provided architectural design for implementation of data warehouse to support massive credit card data repository
• Designed data ware house model, transformed it to a physical database and configured the system/database
• Worked closely wif the development team to tune ETL scripts. Performed verification on all database stored procedures, functions and triggers
• Created baselines for Unix servers
• Production Support for OLTP databases

Confidential, Mountain View, CA

Senior Oracle DBA/Architect

Responsibilities:

• Production and Development Support for PPM, worked wif 70 java developers
• Installed Sun Solaris 9 and Linux Red Hat 4.1 operating system
• System admin for UNIX Solaris, Linux, HP-UX, IBM IAX, Windows NT, 2003, XP
• Installed OEM Grid Control to monitor production Real Application Cluster (RAC)
• Completed Sql package, procedures and functions for upgrade software

Confidential, San Francisco, CA

Senior Oracle RAC DBA

Responsibilities:

• Production support: cron jobs, partition tables, shell scripts
• Monitored RAC wif 4 nodes using OEM Grid Control
• Implemented failover strategy (Server side TAF) for Oracle RAC
• Created ASM instance on each node, RAC database environment
• Configured Oracle RAC, ASM on RAW devices.
• Modified Oracle Recovery Manager (RMAN) configurations for databases.