Catalin Dumitrache

Catalin Dumitrache

Senior Data Engineer
United Arab Emirates
English

About Me

Bogdan is a lead database (Oracle, PostgreSQL, Sqlserver, Elasticsearch, MongoDB) and Big Data architect with over eighteen years of experience in software design, development and systems architecture. Bogdan owns overal…

Experience

Senior Oracle Database Architect

siveco · Bucharest, Romania
Mar 2005 - Present · 21 years 4 months

Expertise and work efforts are focused on the analysis of the customer’s business goals, objectives and needs and the general businessenvironment.▪ Creates and implements programming scripts and procedures to maintain consistent and accurate data during transfer, storage andretrieval.▪ Estimates time frames, quality and quantity of resources required to successfully implement project; develops project planincorporating all project variables.▪ Monitoring and maintaining security of database and database software on corporate, application, database, role, program, and whenapplicable, table, view and column levels in co-operation with security expert and systems programmers.▪ Tuning Database.▪ Implements and maintains database backup and disaster recovery procedures.▪ Implements data security protocols.▪ Configuring Network Data Encryption and Integrity for Thin JDBC Clients▪ Config Oracle Dataguard in single mode and cluster▪ Implement level access with fine-grained access control.▪ Plan the relational design of the database objects and the storage characteristics for each of these objects. Design data model.▪ Plan the backup strategy for the database▪ Creation Shell Scripting▪ Creation of technical and non-technical documentation▪ Working with Oracle Advanced Security Features▪ Install and config Weblogic server – single server and cluster▪ Install and config Oracle VM Server, (network, storage, virtual machine)▪ Install and config Oracle OIM (OID,OAM,OIM,OHS)▪ Install and config JBOSS, Apache Tomcat▪ Maintain MySQL database instances and platforms including uptime SLAs, configuration, monitoring, maintenance, and assistingdevelopers▪ Designs, develops, installs, implements and integrates relational databases including user interfaces.▪ Design, develop API Oracle PL/SQL▪ Design, develop API Postgresql PSQL▪ Replicate databases with Oracle Advanced Replication and Oracle Streams▪ Participates as a team member on database design and development projects.▪ Migrate Oracle database to EnterpriseDB, Oracle database to SQLServer database▪ Upgrade Oracle database and EDB (Postgresql) to the newest version.▪ Manage and monitor installations, upgrades and patching of Oracle RDBMS using Oracle provided tools and utility▪ Install and config Postgresql database , BART tool config for backup▪ Install, configure, upgrade, patch, and manage Microsoft SQL Server databases▪ Represent SQL Server Database Administration team in Disaster Recovery and project activities▪ Replicate data with Shareplex Oracle to Oracle and Oracle to EnterpriseDB▪ Replicate data using Goldengate (installation,configuration)▪ Install and config and manage Elasticsearch (modeling indexes for a good performance, tuning action)▪ Create and implement data model structure for Elasticsearch. Provide optimal architecture for Elasticse

Database Manager & BigData Architect

Siveco Romania
Jan 2005 - Present · 21 years 6 months

Expertise and work efforts are focused on the analysis of the customer’s business goals, objectives and needs and the general business environment.
Coordinates project resources according to the plan.
Creates and implements programming scripts and procedures to maintain consistent and accurate data during transfer, storage and retrieval.
Estimates time frames, quality and quantity of resources required to successfully implement project; develops project plan incorporating all project variables.
Monitoring and maintaining security of database and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with security expert and systems programmers.
Tuning Database.
Implements and maintains database backup and disaster recovery procedures.
Implements data security protocols.
Configuring Network Data Encryption and Integrity for Thin JDBC Clients
Config Oracle Dataguard in single mode and cluster
Implement level access with fine-grained access control.
Plan the relational design of the database objects and the storage characteristics for each of these objects. Design data model.
Plan the backup strategy for the database
Creation Shell Scripting
Creation of technical and non-technical documentation
Working with Oracle Advanced Security Features
Maintain MySQL database instances and platforms including uptime SLAs, configuration, monitoring, maintenance, and assisting developers
Install and config Weblogic server – single server and cluster
Install and config Oracle VM Server, (network, storage, virtual machine)
Install and config Oracle OIM (OID,OAM,OIM,OHS)
Install and config JBOSS, Apache Tomcat
Designs, develops, installs, implements and integrates relational databases including user interfaces.
Design, develop API Oracle PL/SQL
Design, develop API Postgresql PSQL
Replicate databases with Oracle Advanced Replication and Oracle Streams
Participates as a team member on database design and development projects.
Migrate Oracle database to EnterpriseDB, Oracle database to SQLServer database
Upgrade Oracle database and EDB (Postgresql) to the newest version.
Manage and monitor installations, upgrades and patching of Oracle RDBMS using Oracle provided tools and utility
Install and config Postgresql database , BART tool config for backup
Install, configure, upgrade, patch, and manage Microsoft SQL Server databases
Represent SQL Server Database Administration team in Disaster Recovery and project activities
Replicate data with Shareplex Oracle to Oracle and Oracle to EnterpriseDB
Replicate data using Goldengate (installation,configuration)
Install and config and manage Elasticsearch (modeling indexes for a good performance, tuning action)
Create and implement data model structure for Elasticsearch. Provide optimal architecture for Elasticsearch.
Maintain and upgrade Elastic clusters and environments
Perform daily performance monitoring for Elasticsearch clusters and environments
Participate in engineering design sessions to understand dependencies and interactions with Elastic clusters
Plan resources and continuously optimize the infrastructure and configuration of Elasticsearch to ensure a healthy and high-performance production deployment
Working with Kibana (install,config,admin, development)
Install and administrate Kubernetes cluster with Rancher
ETL process creation to transfer data from RDBMS, CSV into Elasticsearch with Spark(Scala) , Python, Logstash,Kettle, NIFI
Operating system used : Linux, HP-UX, Solaris, Tru64 Unix, AIX, Windows

Database Manager & BigData Architect

Siveco Romania
Jan 2005 - Present · 21 years 6 months

Expertise and work efforts are focused on the analysis of the customer’s business goals, objectives and needs and the general business environment, Coordinates project resources according to the plan, Creates and implements programming scripts and procedures to maintain consistent and accurate data during transfer, storage and retrieval, Estimates time frames, quality and quantity of resources required to successfully implement project; develops project plan incorporating all project variables, Monitoring and maintaining security of database and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with security expert and systems programmers, Tuning Database, Implements and maintains database backup and disaster recovery procedures, Implements data security protocols, Configuring Network Data Encryption and Integrity for Thin JDBC Clients, Config Oracle Dataguard in single mode and cluster, Implement level access with fine-grained access control, Plan the relational design of the database objects and the storage characteristics for each of these objects. Design data model, Plan the backup strategy for the database, Creation Shell Scripting, Creation of technical and non-technical documentation, Working with Oracle Advanced Security Features, Maintain MySQL database instances and platforms including uptime SLAs, configuration, monitoring, maintenance, and assisting developers, Install and config Weblogic server – single server and cluster, Install and config Oracle VM Server, (network, storage, virtual machine), Install and config Oracle OIM (OID, OAM, OIM, OHS), Install and config JBOSS, Apache Tomcat, Designs, develops, installs, implements and integrates relational databases including user interfaces, Design, develop API Oracle PL/SQL, Design, develop API Postgresql PSQL, Replicate databases with Oracle Advanced Replication and Oracle Streams, Participates as a team member on database design and development projects, Migrate Oracle database to EnterpriseDB, Oracle database to SQLServer database, Upgrade Oracle database and EDB (Postgresql) to the newest version, Manage and monitor installations, upgrades and patching of Oracle RDBMS using Oracle provided tools and utility, Install and config Postgresql database, BART tool config for backup, Install, configure, upgrade, patch, and manage Microsoft SQL Server databases, Represent SQL Server Database Administration team in Disaster Recovery and project activities, Replicate data with Shareplex Oracle to Oracle and Oracle to EnterpriseDB, Replicate data using Goldengate (installation, configuration), Install and config and manage Elasticsearch (modeling indexes for good performance, tuning action), Create and implement data model structure for Elasticsearch. Provide optimal architecture for Elasticsearch, Maintain and upgrade Elastic clusters and environments, Perform daily performance monitoring for Elasticsearch clusters and environments, Participate in engineering design sessions to understand dependencies and interactions with Elastic clusters, Plan resources and continuously optimize the infrastructure and configuration of Elasticsearch to ensure a healthy and high-performance production deployment, Working with Kibana (install, config, admin, development), Install and administrate Kubernetes cluster with Rancher, ETL process creation to transfer data from RDBMS, CSV into Elasticsearch with Spark (Scala), Python, Logstash, Kettle, NIFI, Operating system used: Linux, HP-UX, Solaris, Tru64 Unix, AIX, Windows

Oracle Consultant

Oracle Advanced Customer Services
Jan 2020 - Jan 2021 · 1 year

installation and configuration of Oracle 12c and 19c
installation and configuration of Oracle Enterprise Manager Cloud Control
implement RAC, Standby Databases Data Guard for High availability and Disaster Recovery
upgrade Oracle environments and migration of the databases using transportable database, unplug/plug PDB
data replication from/to different Oracle database version with Oracle GoldenGate

Oracle Consultant

Oracle Advanced Customer Services
Jan 2020 - Jan 2021 · 1 year

Installation and configuration of Oracle 12c and 19c, Installation and configuration of Oracle Enterprise Manager Cloud Control, Implement RAC, Standby Databases Data Guard for High availability and Disaster Recovery, Upgrade Oracle environments and migration of the databases using transportable database, unplug/plug PDB, Data replication from/to different Oracle database version with Oracle GoldenGate

Oracle Database Administrator & Software Developer

Secure Government Agency
Jan 2000 - Jan 2005 · 5 years

Database administration, a 24-hour open database on Windows or Linux platform
Analyze, Development programming for ORACLE 9I database
Monitoring and maintaining security of database and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with security expert and systems programmers.
Tuning database
Back up and recover the database
Granting highest level access right and revoking these rights, monitoring use of these rights.
Monitor looking to maximize concurrency
Grant and revoke privileges on the database as a whole, and on tables and procedures created within the database
Installing database software, if necessary, with systems programmers and network managers.
Understands customer requirements, project goals, and the technology required to fulfill them.
Modifying old code from application
Work with project manager to define and manage project scope. Estimate effort
Fully participate with the development team in designing, implementing, testing, and documenting code.
Implement the best methods for application, on design

Oracle Database Administrator & Software Developer

Secure Government Agency
Jan 2000 - Jan 2005 · 5 years

Database administration, a 24-hour open database on Windows or Linux platform, Analyze, Development programming for ORACLE 9I database, Monitoring and maintaining security of database and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with security expert and systems programmers, Tuning database, Back up and recover the database, Granting highest level access right and revoking these rights, monitoring use of these rights, Monitor looking to maximize concurrency, Grant and revoke privileges on the database as a whole, and on tables and procedures created within the database, Installing database software, if necessary, with systems programmers and network managers, Understands customer requirements, project goals, and the technology required to fulfill them, Modifying old code from application, Work with project manager to define and manage project scope. Estimate effort, Fully participate with the development team in designing, implementing, testing, and documenting code, Implement the best methods for application, on design

Skills

JBOSS Linux MySQL Oracle PostgreSQL Python Solaris Windows Microsoft SQL Server Scala Spark Elasticsearch Kubernetes MongoDB Sqlserver Oracle Enterprise Manager Cloud Control Oracle RAC Oracle Data Guard Oracle GoldenGate Oracle Advanced Security Features Weblogic server Oracle VM Server Oracle OIM Apache Tomcat Oracle PL/SQL Postgresql PSQL Oracle Advanced Replication Oracle Streams EnterpriseDB SQLServer Postgresql database BART tool Shareplex Goldengate Elasticsearch modeling Kibana Rancher Logstash Kettle NIFI HP-UX Tru64 Unix AIX SQL Server Oracle 12c Oracle 19c RAC Data Guard Transportable Database PDB unplug/plug Oracle Advanced Security WebLogic Server OID OAM OIM OHS JBoss PL/SQL PSQL Oracle RDBMS BART SharePlex NiFi Shell Scripting ETL Data Modeling
Report this Profile?