Position: DevOps engineer
Category: DevOps
English level: upper
Years of experience: 11

Supported revenue management team during the database split-up from the parent company. Assisted the developers with data import using SQL*Loader, Unix power tools and bash. Further optimized recalculation routines with the usage of table compression, partition elimination technique, SQL optimization and changing data/process flow. Reduced execution to 2-5 times for different routines.

Volunteered to work on CID NaUKMA / INFOPULSE e-democracy pro-bono project. The project provided platform to test and implement various e-dem instruments proposed by CID NaUKMA and later allowed the creation of petition.president.gov.ua.

Performed PoC to make sure that we are able to handle all Oracle-database associated activities that we normally do for our customers and proved that we are ready to move to AWS when needed. The PoC included the creation of the necessary infrastructure to operate Oracle databases and followed best practices for Oracle published by AWS.

Implemented complex database solution using Data Guard and Flashback technologies when during the day the database is open and is used for reporting purposes and during the night it is a standby database and applies changes, cycling between these states. Worth noting that the whole solution was plugged to the monitoring.

Pinpointed hot parts of 15 TB OSS database using AWR reports and placed them on the high performance storage while keeping the rest of the database on cheap storage reducing the costs and still allowing for acceptable performance (ratio of 1:100 achieved).

As DevOps proposed to contribute to the other team's Helm chart instead of forking the project and collaborate the efforts. Effectively pulled the chart in a month to a level acceptable for inclusion to umbrella. Have been supporting the chart for over half a year adopting the changes for network policies, high availability control and load balancer services including IPv6 compliance.

Unable to settle for contribution model forked the chart of PostgreSQL from another team and changed it to have Patroni standby cluster support. After that as part of a team and personally responsible for PostgreSQL/Patroni developed in-house disaster recovery solution for a product using primarily Ansible playbooks.
3 years as DevOps.
17 years with Oracle, 15 of them as Oracle DBA.
3 years as PostgreSQL/EnterpriseDB DBA.
9i OCP, AWS Certified Solutions Architect -- Associate.

Have worked with Oracle 8i - 19c.
Have performed all kinds of general Oracle administration, DG, RAC, heterogeneous connectivity and performance tuning.
Have supported very large infrastructures with hundreds of databases (Kyivstar, Swedish PostNord) in mixed environments.
As DevOps I am currently developing a cloud product for a major telco customer using Kubernetes, Helm/Go tpl, Ansible and Git/Gerrit.

As a strong enterprise player I am always honest with the customer and maintain excellent communication with third parties involved.

I am looking for a job of Oracle/PostgreSQL/AWS DBA/DevOps, ideally a mix.