SUMMARY:

• Over 10 years of Oracle RDBMS on Oracle/RedHat Linux, SOLARIS in a Oracle MULTI - TENANT Container environment; latest release of NoSQL MongoDB supporting production and Data Warehousing application development in APACHE HADOOP, including 2 BIG DATA migrations from Oracle 11gR2 RAC to Exadata 12c and MongoDB/HADOOP infrastructure cluster FARM on Red Hat Linux, and SOLARIS 10 Unix platforms.
• Analyzing, designing, developing and implementing projects using Oracle's family of products and associated technologies (JavaScript, JSON, Python.). MongoDB projects and technical administration. Tasks including data modeling using Erwin, code generation, PostgreSQL/MongoDB database creation/design.
• Manage the implementation of IS projects, (including Business Objects on MongoDB, ORACLE and PostgreSQL ), creating charters and work plans, leading cross-functional teams, and managing scope, issues, budgets, and risks associated with the projects.
• Develop business relationships and integrate activities with other IT departments to ensure successful implementation and support of Heterogeneous environments to create Enterprise replication using Golden Gate technology. Fluent in Spanish and Portuguese; US Citizen.
• Ability to work from a variety of verbal and written instructions, drawings, diagrams, rough sketches, formal assembly procedures, and process control documents.

TECHNICAL SKILLS:

UNIX Shell Scripts: Perl, Bash, Korn Shell

RDBMS: Oracle 11gr2 RAC, Oracle Exadata 12c; PostgreSQL 9.x, MariaDB

NoSQL: MongoDB (1 year), Apache Hadoop (1 year)

OS: Red Hat Linux , Oracle Linux, Oracle Solaris

Tools: Oracle Golden Gate Replication; Data Guard, RMAN, HIVE, Cloudera SKOOP

Developer Languages: JavaScript, HTML, CSS

PROFESSIONAL EXPERIENCE:

Confidential

Database Analyst

Responsibilites:

• Provide strategic leadership to the technological and business advancements of the enterprise data and business systems for Shared Services teams used by more than 30 mobile and online websites owned and operated by Confidential in Hadoop Distributed environment.
• Oversees the development, implementation and execution of project plans for BIG DATA development, enhancements and release of Hadoop infrastructure using extract and replication jobs.
• Participate in production on - call rotation for 100+ customer facing Oracle environments supporting mobile payments, payroll, and text messaging for Confidential customers.
• Work with engineering teams in the design and implementation of fail-over and recovery solutions MongoDB, Oracle Exadata 12C and pluggable databases.
• Budget & Financial Coordination of a $20 million capital and operating budget.
• Provide Development Disaster Recovery and/or Production support to code release schedule. This includes creating primary database storage structures, designing and creating primary objects in multi-tenant 12C architecture, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans.
• Monitor and optimize performance of the Exadata Oracle database, plan for backup and recovery of the MongoDB and ORACLE databases, and allocate system storage and plan future storage needs. Create database-related scripts and programs to support development and production environments. Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools.

Senior DBA

• As an Oracle/PostgreSQL/MySQL DBA in the Network Operations (NTK) team, I was responsible for the complete lifecycle of the management of 20 RDBMS databases in a heterogeneous environment for the Vitalnet on-demand service. This includes: 4 databases on 3-node Oracle 11gr2 RAC Cluster, MySQL Enterprise storage planning for VLDB’s, PostgreSQL database implementation on Linux and Solaris; maintenance coordination, ongoing configuration, and management of all Database hosts and instances within the Network data centers.
• Identification and resolution of hardware, software, or database problems/malfunctions in any of the Sprint/Nextel Corp. database instances and/or hosts, especially those that directly impact the production Vitalnet service.
• Analyzing systems errors or anomalies, as well as specific database performance issues and/or error messages, in order to ensure maximum uptime and service quality and assess trends that may ultimately result in degradation of service.
• Working internally within the larger Technical Operations organization to test planned databases upgrades / modifications, as well as provide input into long - range database requirements and operational guidelines, with a focus on improving the performance and reliability of the databases and the salesforce.com service overall.
• Formulating and implementing monitoring policies, procedures and standards relating to database management.
• Working with the Professional Services organization to resolve API/database issues, including the troubleshooting of 3rd party data integration services and/or other Web-enabled solutions.
• Support and perform operational tasks such as database cloning and renaming, upgrades, migrations, installations and others under senior DBA guidance and planning.

Pre-Sales Engineer / Sr. Oracle DBA

• Perform root cause analysis of difficult product problems and their solutions/technical escalation management of AppWorx software on PostgreSQL databases.
• Migrate information form Amisys Data warehouse to Appworx PostgreSQL repository for batch scheduling automation.
• Travel to Latin American countries to design, develop and implement batch scheduling solutions for Oracle E - Business Suite, Oracle Retail and SAP.
• Classroom presentations to prospects in Latin America of Appworx solutions - which lead to sales, implementation, and consulting revenue.
• Liaising with technical architects & delivery teams to ensure technical consistency.
• Develop thought leadership, advice and guidance on the approach to the design of scheduling applications and integration with Data Warehousing Applications.
• Produced over $1M in revenue in the first 17 months as a result

Confidential

Senior DBA/Manager of Database Operations

• Support day-to-day architecture, design and performance of Oracle 9i, 10g/MySQL Open source RDBMS in a heterogeneous environment configuration. The Open Source MySQl and PostgreSQL databases supported e-commerce for fantasy football websites for cbssportline.com (now CBS Digital Media).
• Implement Citrix Sever and support development tasks, administering and designing Sales reporting warehouse/data mart on Oracle 9i/SQL Server 7 using Informatica for ETL processing and design. Perform Oracle/SQL Server, and MySQL 4.0 software installations, replication, and 7 production upgrades to Oracle 10g, patch installations, network configuration, recovery efforts, and database backup - strategies on HP-UX, NT, and Windows 2000 platforms.
• Provide a mix of functional and technical expertise within an assigned business unit/area in the analysis, design, and development of business applications with SQL Server ; Developing organization-wide information models for use in designing and building integrated, shared software and database management systems. Convert specifications into design and convert design into deliverables on schedule.
• Physical design and implementation; Database configuration; Back-up and recovery; Performance tuning, including database tuning and application tuning, data modeling, and PL/SQL. Technical lead of a team consisting of 6 DBA's implementing High Availability back-end solutions for e-business websites, database and application deployment, and manage enterprise-class applications on the Internet and the corporate intranet.
• Install and maintain MySQL, PostgreSQL and Oracle 9i Server databases used for Business Objects Applications in complex High Availability environment and support upgrade to SAP 4C on Oracle 9i.
• Participate in a global team supporting on-call 24x7 coverage.
• Support the development and documentation of PL/SQL functions.

Confidetial

Principal Consultant Oracle Support

• Two successful implementations of Oracle Project Accounting Systems and Oracle Applications throughout 4 countries in South America. Oracle DBA Duties: Unix System Administration Tasks & Problem Resolution
• Manage software selection projects, including documenting business requirements, evaluating application software packages and technical lead of a 5 DBA team.
• Capacity Planning with Oracle Applications and HP or Sun hardware; Perform feasibility studies translating requirements into an appropriate design.
• Provided DBA support to the Oracle Latin American Division in Oracle Financials 10.7SC, Delivered Business and Oracle Manufacturing.
• Responsible for all aspects of OS - level system administration on Sun Solaris or HP-UX platforms including system tuning for application design, development, and production-Systems Administration duties including the following: Installation, configuration, maintenance and support of computer hardware and software, printing systems, security, disk space utilization, I/O contention management, backup and recovery, user setup and maintenance, Unix Kernel parameter setups & tuning, archive log setup, administration & maintenance, vendor coordination (Sun & HP), creation and maintenance of shell scripts, create and follow standard operating procedures, transition of customized Oracle Financials application from Sun Solaris to HP-UX.
• Upon implementation, contributed to the training of ORCL Latin America employees in several Oracle systems applications, speeding profitability.

Confidential

Oracle DBA

• Provided support as Jr. Oracle DBA on production tasks, and assisted in the design and modeling efforts from a database perspective Oracle 7.
• Maintained table privileges for the development of 10 100GB databases.
• Maintained current database users in both build and integration testing environments.
• Provided DBA support to the Honeywell Latin American Division in Oracle Financials, Delivered Business and Oracle Manufacturing.
• Work with Oracle/SQL Developers to roll out a custom Sales & Marketing application and Purchasing Application.
• Implemented Intranet site using Oracle RDBMS for the HR, Accounting, and Sales departments - speeding profitability. This application allowed users to publish news and content over the web.