Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
ClaritasCloud Database Administrator
Feb. 2019Cincinnati, Ohio, United States
Robert Half TechnologyOracle Database Administrator in Azure
May. 2018 - Feb. 2019Cincinnati Area, KY
SogetiManager Consultant
Oct. 2015 - Apr. 2017Cincinnati, OhioServed as the main Level III Project Database Administrator resource/backup Scrum Master of scrum teams for Data Lake Ingestion projects. Lead the database analysis, design, and build effort for the database migration from Teradata to Oracle 11g and Pivotal Greenplum databases. Tasks/achievements include but not limited to:
• Restructured the logical data model of the TX and DW pieces of the application from Teradata and moved the application schema changes to Oracle and Pivotal Greenplum databases using ERwin Data Modeler and ERStudio Data Architect.
• Ensured that the database designs fulfill the requirements, including data volume, frequency needs, and the long-term growth of data base3d from user stories filed in Jira.
• Assisted in deciding the cross-application data standards, data distribution standards, and tuning strategies.
• Worked with other architects to ensure that all components will work together to meet goals and performance goals as defined in the requirements. • Identified and communicated any cross-area or cross-release issues that may affect other areas of the project
• Ensured that the programmers and operations database administrators responsible for developing the database thoroughly understand the requirements and designs as part of IT Service Management • Reviewed the database deliverables throughout development to ensure quality and traceability to requirements and adherence to all quality management plans and standards. • Revised logical structures of application tables to make use of Oracle Materialized views and Query Rewrites to improve on SQL execution of ETL and ELT jobs for data lake data propagation.
• Served as an escalation for Oracle DBA issues related to the application.
Hewlett Packard EnterpriseData Engineer III
Aug. 2012 - Oct. 2015Cincinnati Area, KYLed Oracle Data Masking and Sub-setting project as the Technical/Solutions Architect involving HP and Oracle consultants using Oracle Enterprise Manager 12c and 11g to mask PII/PHI present in the databases as part of contractual obligations to the client. Served as the primary Data Architect and data modeler for the Affordable Care Act Implementation for the state of California. Tasks/achievements include but not limited to: • Worked with the customer and end users to define application and technical requirements based from ITIL V3 and CMMI standards
• Defined the structure of the application and technical architecture, ensuring that the structure meets the security business requirements and performance goals, and ensuring that the technical direction is consistent with the client’s long-term direction.
• Reviewed and integrated all requirements for the application, including functional, security, performance, quality, and operations requirements.
• Reviewed and integrated the technical architecture requirements for the development, execution, and operations environments. • Obtained stakeholder buy-in for application and technical designs.
• Reviewed application and technical architecture deliverables throughout development to ensure quality and traceability to requirements.
• Lead the application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.
• Ensured that the database designs fulfill the requirements, including data volume, frequency needs, and the long-term growth of data.
• Assisted in determining the cross-application data standards, data distribution standards, and tuning strategies.
• Performed basic Oracle DBA functions such as database refreshes using Oracle datapump, performance tuning, data modeling, availability,
backup, and recovery using RMAN, ASM, RAC, and database flashback, monitoring using Oracle Grid Control and other DBA functions as needed.
Hewlett Packard EnterpriseData Engineer III
Sep. 2009 - Jul. 2012NCR - National Capital Region, PhilippinesLed the HP Application DBA team for the EXADATA migration project that involved all Optima databases (DW and OLTP). Served as the main Siebel Application DBA. Tasks/achievements include but not limited to:
• Provided advance technical consulting and advice to others on proposal efforts, solution design, system management, tuning and modification solutions for DB performance issues. • Assisted the technical architect to plan and test disaster recovery actions.
• Built, tested, and implemented changes to the databases, analyzed and revised disaster recovery plans, and operations documentation needed by approved work requests.
• Designed, supported and enhanced design data dictionaries, physical and logical database models using ERwin Data Modeler, and performance tuning. • Maintained the Configuration Management database for the Data Management team
• Developed instructions and maintained operational documents and provided training for the operations domain to perform data dictionary back-up and recovery.
• Monitored database performance and space requirements, and perform or supervise database performance tuning.
• Provided instructions and trained operations team for routine maintenance and support tasks. • Provided second tier support for problems outside the scope of operations personnel and addressed all issues assigned vi HP Service Manager.
AccentureSenior Software Engineer
Oct. 2006 - Jul. 2009NCR - National Capital Region, PhilippinesLed the Advanced Application Support team for Rapid Application Development Project for a German bank. Spearheaded the conversion team in migrating the data of the Logistics application. Tasks/achievements include but not limited to:
• Led the team in customizing and supporting more than fifty strategic applications, which are written in different technologies such as Oracle PL/SQL, MS Access, VBA, Java, and T-SQL. • Monitored capacity allocation required in performing application support as needed and escalate capacity shortage as required to the Delivery Lead and ensured compliance with SOX Audit Requirements. • Developed good working relationship with internal clients to understand and address their needs. • Ensured all source control procedures are followed, technical and application project documentation is complete and up-to-date, and proper release procedures are followed. • Served a Quality Manager for the projects making sure all Development and Operational work and deliverables adhere to CMMI and ITIL standards and guidelines
Trend Micro (Philippines)IS Engineer
Jun. 2005 - Oct. 2006PhilippinesApplied all the knowledge learned from the apprenticeship period. Served as a Quality Assurance Engineer for the Customer Portal (Japan Account), and for the Pre-Official Pattern Release of the Company. Did basic network troubleshooting and responsible in maintaining strategic systems hosted on the company’s global servers.
Trend Micro Incorporated, TSSProject Coordinator
Jan. 2005 - Mar. 2005PhilippinesCoordinated with the different Global Sales Business Units regarding the status eDemo Leads requested by the different customers from different countries. Made reports regarding the eDemo Leads. Maintained the Technical Sales Services Portal. Assisted with the different projects of the Technical Sales Services Department.
Intch is a Professional Networking App for the Future of WorkSee more people like Harry on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1021098 people
17
Application Developer @ Nile27
16
Manager Solution Consulting @ Alkami Technology
16
Program Manager @ DISH Network
201442 people
17
Application Developer @ Nile27
19
Manager @ Epic Force
27
It person @ Texas Systems Admin