About Bogdan
English
Native or bilingual
Romanian
Native or bilingual
German
Fluent
Experience
- Genpact Romania,Technical Lead and Chief ArchitectDIGITAL AND ITAugust 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).
- NDASQL Server SMEDIGITAL AND ITMay 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 DBAJune 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
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Oracle PL/SQL and Oracle Warehouse builder Seminars and CoursesEBS Romania2025Oracle PL/SQL and Oracle Warehouse builder Seminars and Courses
- Seminars and CoursesCMMI2012Seminars and Courses