Martin Sofroniev

Troubleshot database issues to create and resolve trouble tickets.

Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.

Wrote and maintained technical and functional specifications to document database intentions and requirements.

Patch ,migrate Oracle GoldenGate Microservices.
Monitoring ,ensure there is no lag .
Installation of OEM (Oracle Enterprise Manager)
Install and configure Oracle Internet Directory and Oracle Gateway for
DB2 and MSSQL,OEM (Oracle Enterprise Manager) ,RMAN Catalog
Onboarding of new Azure MySql/PostgreSQL Flexible Server
(Migration from Single to Flexible)

Migration from non cdb Oracle 12c to 19c cdb databases

Integration of Grafana monitoring system
Commvault backup solution
Work on service requests from end users
Oncall

Designed and developed scalable data pipelines using Python and PySpark, supporting data transformation and processing tasks for business insights.

Debugging issues with existing synapse pipelines , python notebooks (PySpark,Pandas),stored procedures ,analysis services models.

Maintenance and Support: Conducted regular maintenance, tuning, and troubleshooting for optimized system performance.

Migration of old DataBricks notebooks to Synapse notebooks. Create or update existing relationships/metrics in AAS cubes according to bussines requirements.

Develop GitHub actions for deployment of ARN templates and python wheel file from Dev to UAT/PROD environments .

Install and configure required cloud resources for the application (on-premises data gateways,aas etc)

Maintaining 12c, 18c and 19c Oracle databases

Dataguard environment on standard and enterprise edition

Monthly refreshes (dev test preprod environments)

Preparing monitoring reports using shell scripts (crontab, opcon)

Debugging of existing shell scripts

Security vulnerabilities

User requests

Oncall

IT Support Oracle database environment for Siemens
24/7 environment, updating procedures for 1st level
Migration of old environments (windows, aix, solaris with 11g version of Oracle) to red hat 7, 19c oracle version
Patching databases using ansible
Resolve security vulnerabilities according to company standards
like patch level of oracle databases, oracle agents, user password
complexity, server access managed on database level
Support RAC and active DataGuard environments
Networker and Avamar backup solutions

Support and maintain databases for main company software
Including upgrading, patching, writing PL/SQL procedures and
blocks
Apply new changes provided by data architects and tuning teams
Dataguard on standard edition
Data refreshes between environments (dev test preprod etc)
Oncall

IT Support Oracle Databases 10g, 11g, 12c (RAC, RAC one, Oracle
single instance) ASM
Build new environments, upgrade and patching of existing
environments
Restore, recover and clone databases using RMAN
Migration and refresh with datapump
Dataguard management, Exadata disk management, Service guard
Task scheduling and change planning preparing procedure for
24/7 support team
User request (new users, performance issues etc)
Data protector, NETBACKUP, TIVOLI