Gabriel S. Lobo-Blanco, MSCS

Bachelors of Science in Computer Science, CCNA, OCP, MCSE, CNE, A+

Address: ***** *. ***** ****** **.

Sandy, UT. 84094

U.S.A.

Home Telephone Number:801-***-**** Mobile:904-***-****

E-mail: ad1hte@r.postjobfree.com

Work Experience Summary:

Over 24 years of focused IT experience and 25 years of Database Architecture experience.

Over 15 years as Data Architect, Data Integration and MDM.

Able to manage multiple and changing priorities effectively.

Developed data centric solutions that enabled stake holders to provide a full software lifecycle.

Database Dev-Ops, Oracle and SQL Server, CI/CD, Docker, Jenkins, and Terraform integration.

Maintained strong knowledge and expertise of current and emerging technologies such as NoSQL, Hadoop, AWS, GCP, HDFS, Ambari, HIVE, Pig, MapReduce, HBase. Apache Airflow, Kafka, etc.

AWS Infrastructure as Code automation using Terraform code repo’s.

Design and build pipelines that allow for the collection of data from multiple sources using Hadoop stack.

Data Governance, Data Lineage, Data Stewardship, Business Glossary

Installation and configuration of Relation Database engines and NoSQL Database engines such as MongoDB, Oracle, SQL Server, PostgreSQL, etc. Replica-Sets and shard to use x509, key files, LDAP, SSL/TLS.

Oracle Certified Professional, OCP. Oracle Security Administration definition and implementation

Design, Implementation, and maintenance of new and existing Application Data Models.

Oracle RAC implementation and installation on RedHat Linux AS, HP-UX, AIX, Solaris, True64. Oracle DataGuard and MAA implementation on many platforms.

Experience performing rolling upgrades on HA Database engines using Relation and No-SQL technologies.

Experience in various database technologies MySQL/MariaDB/’Oracle/Sybase/PostgreSQL/SQL Server, MongoDB/DynamoDB, AWS RDS.

AWS Cloud migration. Experience in Cloud Technologies like VPC, EC2, S3, Cloud, Data Center, and hybrid environments.

Design and implementation of automated Database CI/CD supporting Agile methodologies.

Design and implementation of Emerging technologies such as BigData, Hadoop, HDFS, HIVE, Pig, Ambari, NoSQL, ML, and how to implement in enterprise.

Experience with Non-SQL databases such as MongoDB.

Installation, support, configuration, upgrades, and maintenance of Oracle Databases ranging in size from 100 GB to over 4.58 PB.

Setup, configuration, patching and management of Wintel Servers running various versions of windows os.

Migration to multi-cloud platform, AWS, GCP

Installation, support, configuration, and maintenance of High Availability Database System using Stand-by Databases, Replication, and Parallel Databases (Real Application Cluster)

GoldenGate replication and database migrations and upgrade.

Installation, configuration, and implementation of MongoDB Databases and Shards on AWS environments.

MongoDB Schema Design and Data Modeling, MongoDB Replica-Set, and Shard

Skills Highlight:

Oracle Products: Oracle7, 8, 8i, 9i, 10g, 11g, 12c Enterprise Server; Personal Oracle 7, 8, 8i, 9i, 10g, 11g, 11gR2, Oracle RAC/OPS, Golden Gate classic and MA, Oracle Database Appliance, Oracle Data Guard/Standby, Oracle Streams, Oracle E-Biz Suite Technical Release 11, and, Release 12, PL/SQL, Oracle Enterprise Manager, Oracle Intelligent Agent, Oracle Server Manager, Data Pump, Recovery Manager (RMAN), Oracle Application Express, JDeveloper 3.0, Developer 6.0.

Operating Systems: Sun Solaris 6 - 10, Sun Cluster 3.x, Linux, IBM OS/400, IBM AIX 5, HP-UX, SCO Unix, Microsoft Windows Servers, Novell Netware.

Management/Leadership Skills: Technical Team Leader, Technical Mentor, Agile Project Management

Life Cycle Expertise: Requirements Analysis, Functional Analysis, Conceptual Database Design, Logical Database, Design, Physical Database Design, Test Plans, Testing, Implementation

Specialty Skills: Data Architecture, Data Modeling, Conceptual, Logical and Physical database implementation, Database Security, Database Performance Tuning, High Availability Databases including RAC and DataGuard, Oracle E-Biz Suite Installation, Migration, Performance Tuning, Patch Installation, Oracle Parallel Server, OLAP systems, DSS systems, VLDB, Replication, Stand-By databases.

Other Products: Sybase ASE, Sybase Replication, GoldenGate, Postgres, MongoDB, MySQL, MS SQL Server, VMWarevCenter, Erwin, Power Designer, DB Artisan, MS SQL Server, T-SQL, Quest Software SQL Expert, Quest Software, Instance Monitor, Quest Software SQL Lab/Expert, HTML, Informix, Apache Airflow, Python, Kafka, AWS, EC2, S3, VPC, Terraform, Git, Sybase S-Designer, Microsoft Access, Visio, ODBC, JDBC, OCI, XML, Shell scripting, IBM ADSM Storage System, Platinum SQL Station, Platinum Desktop DBA, Perl Scripts, UNIX Shell Scripts, Java 2, Solaris LVM, EMC DASD, Veritas Volume Manager.

Methodologies: Agile, Erwin.

Project Experience:

September 2018 – February 2023

Global Payments – Enterprise Data Architect, Salt Lake City, Utah.

Responsible for visualizing and designing an organization’s enterprise data management framework. This framework describes the processes used to plan, specify, enable, create, acquire, maintain, use, archive, retrieve, control, and purge data. Analysis for product development and forecasting using Oracle, MS SQL Server, MongoDB, SAP, AWS, GCP, HIVE, MySQL, and PostgreSQL.

Translating business requirements into technical specifications, including data streams, integrations, and transformations, databases, and data warehouses.

Worked with developers to create and optimize Database Data Models

Defining the data architecture framework, standards and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees.

Architecture and implementation of Data Lake using GCP and AWS.

Defining reference architecture, which is a pattern that others can follow to create and improve data systems. Data Integration and MDM.

Database DevOps and automation.

Cross platform data integration and mapping.

Large scale Data migration projects.

Worked with stake holders in design and implementation of efficient data infrastructure utilizing latest technologies and providing automation processes at the data level for collection, archive, purge, cleansing.

Experience configuring Golden Gate downstream mining and integrated components for active-active replication

Experience configuring Golden Gate High Availability using Oracle DBFS and Active Data Guard.

Experience with Golden Gate Big Data or Golden Gate JMS

Utilized analytical, statistical and programming skills to collect, analyze, and interpret large data sets stored in relational database and NoSQL databases.

Worked with stake holders to design, develop, and maintain scalable data pipelines for products. Support for continuous increasing data volumes and complexity.

Developed processes, standards and best practices for data storage, archiving, retention, compliance, and governance.

Managed the availability, usability, integrity, and security of enterprise data using Data Governance Tools such as Erwin Data Intelligence.

Developed Data Governance program, DG tool selection and implementation. Collibra, Erwin.

Identified data stewards, Created Business Glossary, Data lineage, metadata.

Worked with stakeholders to identify opportunities for leveraging company data to drive business solutions.

Designed, planned and implemented data migration to AWS and GCP Cloud to hybrid-multi-cloud environment where our applications would be able to run on multiple cloud providers and replicate to our Data-Centers.

Worked with Dev Ops team to create VM’s on premise and in the cloud to host different types of Database servers including MySQL, MSSQL, MongoDB, Oracle, PostgreSQL, Python.

Implemented and managed automated database CI/CD Development into Development Life Cycle.

Worked with Dev Ops team to develop, implement, and migrate to cloud environments in AWS, and GCP

Maintained database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases;

Evaluated compliance requirements for data security such as PCI, PPI, HIPPA, and GDPR; implemented data obfuscation technologies on existing data sources so that data could be made available to all stakeholders without violating compliance.

Used predictive modeling to increase and optimize customer experiences, revenue generation, and targeting and other business outcomes.

Installed, configured MongoDB clusters in multiplatform cloud environment, AWS, Azure, GCP, across different regions.

Maintained strong knowledge and expertise of current and emerging technologies such as NoSQL, Hadoop, AWS, GCP, HDFS, Ambari, HIVE, Pig, MapReduce, HBase, Apache Spark, Kafka etc.

Design and build pipelines that allow for the collection of data from multiple sources using Hadoop stack.

Support and troubleshooting of MongoDB Replica-Sets and shards.

Installed and configure MongoDB Replica-Sets and shard to use x509, key files, LDAP, SSL/TLS.

Managed User Authentication and authorization in MangoDB to use LDAP, SSL/TLS, AD, etc.

Worked with developers to develop a proper aggregation pipeline in MongoDB for applications.

Developed and implemented Archiving systems in T-SQL, PL/SQL, and Java to archive and purge data from production environments running in MSSQL, Oracle, MongoDB, etc.

January 2021 – December 2022

Snap Finance – Enterprise Data Architect, Salt Lake City, Utah.

Worked with leaders and different stake holders to conceptualize and build next generation enterprise data platform. and implement automated solution with CI/CD pipelines for infrastructure, databases performance, and software build, deployment, and configuration.

Designed data platform architecture from end to end so that data from different data sources can flow into Data Lake.

Designed, architected, and implemented Data Lake using AWS infrastructure.

Architected data solutions and methodology across hybrid (cloud and on-premises) infrastructure to support data expansion, escalation, and high availability.

Architected cloud integration and enabled reporting and analysis platforms using data warehousing solutions such as GBT and SnowFlake.

Responsible for management of database technologies such as Oracle, SAP, PostgreSQL, MS, SQL Server, and MongoDB; Data Models and Data Governance.

Architected database automated CI/CD pipeline using flyway or liquibase, Jenkins, and Git to automate database changes deployment. Architected DevOps solution for Databases.

Collected and understood business requirements from different stake holders.

Designed and built data pipelines using python, java, and Airflow.

Experienced in database administration tasks, replication, and high availability.

Experienced in managing databases on prem, running on EC-2, and RDS environments.

Strong understanding of Unix server infrastructure, Unix/Linux-based operating system, commands and utilities, as well as Configuration Management Tools

Strong knowledge of large-scale data migration to the cloud on GCP and AWS platforms.

Strong knowledge of ETL and ELT tools such as DMS, Kinetics, Airflow, and Python.

Design and implementation of Enterprise Infrastructure on prem, in cloud, and hybrid.

Interviewed, and hired and provided leadership to analytics and data team members with right skills and assisted existing team member in growing skills necessary to excel.

Led architecture team in development, execution of cloud platform environments.

Developed a vision and strategy for stake holders and management to advance data strategy in acquisition, engineering, governance, safety, and integrity.

Developed strategy to implement and automate IaC using terraform and cloud platform.

Provided strong leadership creating test automation using Selenium, Cucumber, BDD, TDD, for databases.

April 2018 – October 2018

Central Logic – Data Architect – Consultant, Salt Lake City, Utah.

Worked as a principal data architect developing and maintaining scalable data infrastructure to support increasing data volumes and process automation.

Design, plan, and implementation of efficient data infrastructure to properly mitigate usage, performance and cost of the new AWS environment.

Design and build pipelines that allow for the collection of data from multiple sources using Hadoop stack.

Build CI/CD automation pipeline for developers using technologies like Python, Jenkins, Flyway, etc.

Strong knowledge and expertise on emerging technologies and products. AWS, GCP, NoSQL database, HDFS, Apache Spark, Kafka, Ambari, Hadoop stack, VPC, EC2, S3, Jenkins, docker, k8, Python.

Provided guidance in the use of diverse technologies such as PostgreSQL, SAP, Oracle, SQL Server, MySQL, MariaDB, MongoDB and advantages in use as applied to a varied use of applications.

Developed database data models using vaiours technologies such and Erwin and Lucid Charts.

Built decision making and BigData infrastructure using Hadoop, HDFS, Hive, MapReduce.

Worked with developers in the design of appropriate data structures and use of technologies that best suit applications.

Drove adoption of best practices, standards and process automation to provide for a full data lifecycle.

Solid understanding of the practical application of agile methods and human implications of creating and delivering technical solutions.

Mentoring on approach and execution of solutions, coaching on technologies, and establishing team comprehension of solution capabilities and direction.

January 2018 – August 2018

Wolterskluwer – Solution/Data Architect – Consultant, Salt Lake City, Utah.

Worked as a Senior Consultant to assist the client in their migration efforts to move their database installed base to the cloud using Amazon AWS. Designed technology roadmap that aligned with business priorities, scale for the future, and provide continual improvement and delivery values.

Provided expertise during planning, installation and deployment of the efficient architecture to properly mitigate usage, performance and cost of the new AWS environment and tools such as VPC, EC2, S3, RDS.

Process automation, CI/CD, Big Data technologies, BI Tools, Apache Spark, Kafka, etc.

Build CI/CD automation pipeline for developers using technologies like Python, Jenkins, Flyway, etc.

Provided knowledge and expertise of the AWS stack, migration tools, security model, etc.

Provided expertise in the migration of Oracle Advanced Replication to GoldenGate Microservices Architecture.

Provided knowledge and expertise in architecting, deploying and managing cost-effective and secure AWS environments across multi-zone and regions, leveraging AWS services such as EC2, VPC and RDS, S3 storage.

Provided expertise in planning, deployment, and configuration of Oracle GoldenGate 12.3 Microservice Architecture to migrate existing Oracle Advanced Replication environments to Oracle GoldenGate in the cloud.

Configured multi-master replication using GoldenGate 12.3 MA in a peer-to-peer model allowing multiple servers across multiple regions and time zones to replicate data back for forth among other servers.

Installed and configure Oracle Veridata and agent software. Created multiple jobs to validate data consistency and conflict resolution across multiple servers in same VPC and across VPC’s with minimal down time.

Oracle cloud user security. Commission and decommission of user id, configuration of password requirements, User access based on roles; configuration of user roles depending on geo-locations. Implementation of Oracle ID.

Worked with developers to tune and optimize existing application and PL/SQL code running in Oracle 9i and 10g to run in Oracle 11gR2 and take advantages of new features.

Worked with developers to update and tune existing application to run in AWS cloud.

Worked with developer to create, test, and implement PL/SQL packages, procedures, and functions, as well as tune and optimize existing stored procedures so that they could run efficiently under the new architecture.

Experience inspiring development teams. Advocate for a full DevOps approach to the development lifecycle.

July 2014 – September 2017

Fiserv/Randstad Technologies – Senior Data Consultant, Salt Lake City, Utah.

Worked as a Senior Sybase/Oracle Consultant installing and troubleshooting client installation of Sybase ASE Replication and Oracle Replication. Develop custom XNIX script to automate the installation and configuration of Sybase and Oracle RDBMS software at client’s site. Developed monitoring scripts and alerts system to monitor Oracle/Sybase databases.

Provided installation, back and recovery, database migration and troubleshooting of Oracle and Sybase databases.

Created multiple Unix/Linux scripts to automate Database processes using bash, Python, SQL, etc.

Created monitoring application to check the Replication environment running Oracle and SAP Replication or GoldenGate and send alert when necessary.

Worked with developers to create database data models using Lucid, DBML, and Erwin.

Provided complete database support, shell scripting, Python, performance and tuning for customers and developers.

Worked with Developers to create a SDLC and change management environment reflective of typical client environments for application testing and deployment.

Installation, configuration, patching, and management of Wintel servers running bare-metal and virtual configurations.

Data Center Management.

Build CI/CD automation pipeline for developers using technologies like Python, Jenkins, Flyway, Chef, etc.

Setup development environment using Java, Maven, Sprint, Subversion, and Eclipse to develop a utility to monitor database performance and send alerts to administrators.

Created documents to standardize client environment.

Created documents to formalize recommendation for CUnify application installation.

Documented implementation of high availability systems using GoldenGate and Sybase Replication server.

Automated re-materialization of Sybase ASE Replicated Environment using a custom Java application.

Worked with clients to tune up and resolve database performance issues.

Performed cross platform migration for Oracle/Sybase databases.

September 2013 – January 2014

Performance Tuning Corporation – Senior Oracle DBA – Consultant, Travel.

Worked as a Senior Oracle Consultant at client sites and remotely. Provided support for performance, installations, backup and recovery, and trouble shooting of database issues on various version of oracle RDMBS and platforms.

Lead team in migration of existing custom and COTS applications from MS SQL Server to Oracle database using Oracle Golden Gate.

Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.

Responsible for patch packaging, testing and deployment using various Oracle provided tools.

Setup system and user profiles for Oracle E-Business Suite, administered concurrent manager and reports.

Performed and provided patching support including Financials, HR, Purchasing and Public Sector.

Developed shell and Python scripts and utilities for maintenance of multiple Oracle Applications environments, environment configuration, initialize environment, automated databases, Webservers, Form servers, and concurrent managers startup/shutdown process.

Provided support to developers and establish development cycle from development to production environments.

Process Automation and CI/CD automation using tools like Jenkins, Chef, Flyway.

Provided consultation to developers and created Oracle Workflow’s for custom applications.

Performed E-Biz Suite installation and configuration, migration, patching, and cloning across platforms.

Installation, configuration, patching, and management of Wintel servers running bare-metal and virtual configurations.

Data Center management.

Design, Develop and implement upgrades and enhancements using OA Framework.

Troubleshooting skills across modules of Oracle EBS.

Design, Development, modification and implementation of Oracle Workflow.

Met with customer representatives to determine customer needs and system availability during cut-over.

Analyzed and modified existing automatic deployment tools using MS Visual Studio to start using Oracle database and be able to deploy to an Oracle database using the same tools.

Used Oracle Migration Tools to seed the migration of various MS databases and consolidated them into Oracle schemas on the same databases.

Setup Oracle Security to satisfy existing and added security requirements for users, administrator, and shared objects.

Designed and implemented data migration process to completely eliminate any down time during the migration process using Oracle Golden Gate.

Designed and recommended replication strategy for post migration using Oracle Golden Gate.

Lead team during the migration of MS SQL Server Replication to Golden Gate Replication running on MS SQL Server.

Solid hands on experience on NoSQL Database (MongoDB). Replica Set and Sharing. Security measures, backup and restore.

September 2012 – March 2013

Marion County – Senior Oracle Apps DBA – Consultant, Salem, OR.

Served on major Oracle EBS upgrade, 11.5.10/12.1.3, and integration for Marion Country as an Oracle EBS applications consultant. Served as an architect for the discovery and assessments of customer existing Oracle E-business Suite and multi-vendor products. Identify opportunities for a complete upgrade.

Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.

Setup system and user profiles for Oracle E-Business Suite, administered concurrent manager and reports.

Performed and provided patching support including Financials, HR, Purchasing and Public Sector.

Developed scripts and utilities for maintenance of multiple Oracle Applications environments, environment configuration, initialize environment, automated databases, Webservers, Form servers, and concurrent managers startup/shutdown process.

Provided support to developers and establish development cycle from development to production environments.

Provided consultation to developers and created Oracle Workflow’s for custom applications.

Performed E-Biz Suite installation and configuration, migration, patching, and cloning across platforms.

Design, Develop and implement upgrades and enhancements using OA Framework.

Troubleshooting skills across modules of Oracle EBS.

Design, Development, modification and implementation of Oracle Workflow.

Responsibility for resolving all issues assigned in a timely manner.

Ensure that modules conformed to system and programming standards and were documented.

Administered, supported, maintained, optimized, and monitored complex database applications in a variety of environment.

Performed technical troubleshooting and Instance recovery for all E-Biz environments.

Worked as part of a team and provided 7x24 support when required.

Sound knowledge of Oracle backup and recovery scenarios.

Installation, configuration, patching, and management of Wintel servers running bare-metal and virtual configurations.

Data Center Management.

Provided consultation to team and management in code migration, database change management and data management through the various stages of the development life cycle.

Provided troubleshooting experience for the middle tier, database, tier, operating system, SAN, and network.

September 2011 – January 2012

Baker Hughes – Lead Oracle DBA/Architect – Consultant, Houston, TX.

Worked as The lead Oracle DBA building and deploying Oracle RAC Databases for the Beacon Project.

Responsible for the installation, configuration, maintenance, and monitoring of the Company’s database system using Oracle 11gR2 RAC database software.

Ensured system availability, usability and survivability.

Developed a Rapid Deployment Methodology that allowed for the installation of RAC in two days.

Developed policies and procedures in regards to security, backup schedules, restoration, and general deployment.

Developed conceptual, logical, and physical data models (3NF).

Designed and implemented version control solutions using MVN and SVN.

Translated business requirements into an analytical solution.

Determined the Oracle RAC architecture.

Provided support of high availability database infrastructure including Oracle RAC and Data Guard Technology.

Supported team members and ensured that established deadlines and client needs were met.

Provided guidance on best practices and hardware configuration.

Configured ASM using RAW devices for CRS and database files storage.

Installed and tested Single Client Access Naming (SCAN) using DNS and GNS for connection failover.

Installation, configuration, patching, and management of Wintel servers running bare-metal and virtual configurations.

Data Center Management.

Installed, configured, and deployed Oracle Enterprises Manager repository and OMS Server for Monitoring and sending alerts.

Installed, configured, and deployed Oracle Enterprises Manager 12c repository and components for Monitoring and sending alerts.

Provided guidance on implementing Oracle Advanced Replication and Oracle Streams for replication.

Served as a guide to the team in the deployment of the application.

October 2009 – August 2012

Total Quality Systems, Inc. – Lead Oracle DBA/Architect – Consultant, Roy, UT.

Worked as the lead Oracle DBA and Database Architect designing software tools for the Department of Defense managing, implementing, and designing distributed application systems using Java stack of development, infrastructure, security, and operations tools while providing a solid foundation of high availability and clustered server environments, storage and back-up technologies using Agile framework.

Defined and implemented the selected Development Environment, including the specific development tool sets for development, packaging, and automated deployment of Java classes and Oracle Database scripts under a controlled Release Management environment.

Provided overall guidance and structure for creating and maintaining the whole application development software effort. Served as the single point of responsibility for the application solutions.

Served as a Project Manager using an Agile approach to development and the Agile methodology.

Defined the application architecture.

Developed Conceptual, Logical and Physical Data Models (3NF)

Developed Data Dictionary and established meta-data models, Heavy use of Data Modeling patterns.

Developed and implemented Data Management plan.

Resolved high-level functional issues.

Coached the Engineering team in the development of the application solution.

Served as a guide to the team in the development of the application.

Provided continuity in all major application solution decisions.

Determined how technology was applied to provide an efficient solution.

Recommended and implemented frameworks.

Installation, configuration, patching, and management of Wintel servers running bare-metal and virtual configurations.

Data Center Management.

Determined data requirements, structure, and distribution.

Conceptualized and developed frameworks for implementation of systems on projects and other work assigned.

Applied data architecture concepts and techniques to facilitate major technical decisions..

Designed and implemented effective version control solutions using MVN and SVN.

Managed the implementation of the architecture throughout the software development lifecycle and provided technical mentoring.

Installed and configured full Java development environment using Subversion, Maven, Eclipse, Spring, tomcat, Apache, and Oracle.

Created and performed unit testing of several Java classes used in DoD application using SDLC environment.

Configured Oracle Streams for high availability replication between 11gR2 2-node RAC databases geographically distributed.

Installed and configured Golden Gate replication between Oracle databases.

Researched the benefits of replacing Oracle Streams with Oracle Gold Gate software.

Provided support of high availability database infrastructure including Oracle RAC and Data Guard and Streams Technology.

Installed, configured, and managed EMC SAN network storage system using Fiber Channel Brocade switches.

Developed Web applications using Java, Java Scripts, JSP, and JSF technology.

Installed and administered Web application servers using various technologies such as Apache, Web Logic, JBoss, and Tomcat.

NoSQL database (MongoDB), Installation and configuration of MongoDB, Addition/Deletion of nodes, Replica Set configuration. Backup/Restore using Mongodump/Mongorestore utility.

Created custom scripts using various technologies such as Perl, SQL, Java script, etc., to assist with maintenance and administration of Oracle, Sybase, and SQL Server databases and various other systems.

Collected measurement and metrics for replicated environment.

Made changes to RAC databases and Streams configuration to take advantage of high availability features available.

February 2008 – October 2009

Corporation of the President – Senior Database Engineer, Salt Lake City, UT.

Worked as a Senior Database Engineer in a release management team to provide DBA services to application development teams, including designing of build processes, database design, database generation, coding, and database support using Agile framework. Other areas of my work include the following:

Provided support services monitoring and troubleshooting Production, Development, and Testing

Contact this candidate