You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Bogdan OproescuBO

Bogdan Oproescu

Supermalter

Oracle and SQL Server SME

On-demand
1 project
Luxembourg, LU
15+ years

Average response time: 1 hour

About Bogdan

Bogdan is an IT expert, with more than 15 years of relevant technical expertise and international experience.
Bogdan possesses broad experience with data warehousing, and Microsoft SQL Server, including T-SQL and SSIS, business intelligence processes, SSAS, SSRS, PowerBI, and .Net. During his current engagement on a national security project (under NDA), Bogdan has been using .NET and C# and SQL Server with T-SQL, SSAS, and SSRS daily. Moreover, as a JiVS Technical Lead and Chief Architect at Genpact Romania, he created all required Microsoft SQL Server databases and the entire set of JiVS automation scripts in T-SQL and while doing this, has mastered Microsoft SQL Server 2008 and 2012, as well as SQL Server 12 and later versions using Transact-SQL (T-SQL) and concepts of advanced database administration. Additionally, he possesses considerable knowledge of Oracle SQL and PL/SQL and is an official SQL and PL/SQL instructor, having created his own SQL and PL/SQL courses for his former colleagues at Volkswagen in Germany. His other competencies include C#, C and C++, Python and Java. Bogdan also has experience working in a banking environment at Credit Suisse where, as a Senior Datawarehouse Engineer, he was involved in the Development and Support of Data Staging Processes with ETL/DWH and Data Modelling. He is a fluent English and German and Romanian speaker who is looking for new challenges in his career to demonstrate and sharpen his IT competencies in banking and/or high-tech and challenging environments.
  • English

    Native or bilingual

  • Romanian

    Native or bilingual

  • German

    Fluent

Can work on-site
Luxembourg (up to 50km)

Experience

  • Genpact Romania,
    Technical Lead and Chief Architect
    DIGITAL AND IT
    August 2018 - August 2022 (4 years and 1 month)
    Bucharest, Romania
    • Mastery of Oracle SQL and PL/SQL as well as Microsoft SQL Server 2008 and 2012, as well as SQL Server 12 (for SQL Server 2014) and SQL Server 13 (for SQL Server 2016) using Transact-SQL (T-SQL).
    • Creation and usage of parameterized SQL Server cursors, using the EXEC() function on locally set Transact-SQL (T-SQL) outer cursor local variables. These parameterized SQL Server cursors were used to process all base tables in certain JiVS databases or used to process all JiVS databases whose names matched certain patterns. These advanced SQL Server metadata scripts, in turn, generated 2nd-level SQL Server DML and DDL scripts that were then executed subsequently, for each targeted JiVS database and/or JiVS tables. This process was therefore made much more transparent and reliable than previous versions, since these 2nd level SQL Server DML and DDL scripts were executed linearly, therefore adding the capability to transparently visit the script output, for each of these SQL Server scripts, of the generated DDL and DML commands, for targeted JiVS nuclear databases.
    • Excellent skills in Linux and UNIX server-side shell scripts and configuration, as well as SQL query optimization involving using indexes, clustered indexes, materialized views, hints, and so on.
    • Deployment procedure for the priority Export Control (EC) classified nuclear data IBM Lotus Notes GE projects (according to Swiss EC law!) database import into JiVS archival system. Creator of all Microsoft SQL Server databases including T-SQL and SSIS, and Windows operating-system level automation intelligence for JiVS, for our EC-classified nuclear data IBM Lotus Notes GE projects migration into JiVS.
    • Extracted, transformed and loaded data from IBM Lotus Notes source systems to Azure Data Storage services using a combination of Azure Data factory, Spark SQL and T-SQL. Data was then ingested to one or more Azure services (Azure Data Lake, Azure SQL or Azure Storage).

  • NDA
    SQL Server SME
    DIGITAL AND IT
    May 2023 - August 2024 (1 year and 4 months)
    Bucharest, Romania
    • Working on a national security project using .NET and C# and SQL Server with T-SQL and SSAS and SSRS. Leading the ECRIS-V database team and re-vamped the previous table design from ECRIS-IV to a new and more concise table design for the table structure for the new ECRIS-V event management system. Created, documented, and explained in several courses to interested colleagues and to the client, the object mappings and dependency graphs for all tables, triggers, indexes, sequences, and views in ECRIS-V.
  • Bithat Solutions SRL,
    Java Technical Lead and Oracle DBA
    June 2022 - Today (4 years)
    Bucharest, Romania
    • Java technical lead overseeing and reviewing daily our pull requests on GitHub.
    • Providing various technical courses for internal colleagues: Learning SQL, mainly directed towards Oracle, Algorithmic Problem Solving with Python, Relational Database Design, Getting Started with SQL Server, Oracle Database Notes for Professionals, and a first course in Differential Equations.
    • Oracle and PostgreSQL DBA tasks: solid experience as an Oracle DBA (with versions 9i, 10g, 11gR2, 12c and 19c) on various UNIX and Linux platforms: database and user creation, RMAN and import/export utility, performance tuning, RDBMS patching, backup and recovery, security and OEM, performance tuning with TKPROF and EXPLAIN PLAN, creation of instances and tablespaces and data files, as well as rollback segments and creation of tables, synonyms, indexes, sequences and views, also creation of triggers, constraints and procedures. Proficiency with using SQL * loader, Log miner, and import and export utilities, and handling day-to-day DBA activities using Oracle tools and utilities, as well as monitoring memory and space requirements and memory tuning. Proactively checking Alert Logs and Archive Logs as well as Oracle trace files. Experience with migration of Oracle 10g databases to 11gR2 and to 12c. and with PL/SQL programming on databases from Oracle 9i and beyond.

Recommendations

Be the first to recommend Bogdan

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Oracle PL/SQL and Oracle Warehouse builder Seminars and Courses
    EBS Romania
    2025
    Oracle PL/SQL and Oracle Warehouse builder Seminars and Courses
  • Seminars and Courses
    CMMI
    2012
    Seminars and Courses

Categories