Position: Senior Database Administrator (DBA)
Category: SQL
English level: upper
Years of experience: 4

More than 40 + Tb Disk Space Optimization;
Solving a lot of bugs by using oracle support;
Quick response to incidents;
Manage Amazon Relational Database Service (Oracle Database in AWS)
 Create read-replica in PostgreSQL by AWS Database Migration Service (Replication
instance, DMS tasks)
 Help migrate stored procedures in java (describe, flowchart)
 Support Oracle Application ExpressOracle (APEX)
 Configure Oracle Database ACL with SSL
 Perform expdp/impdp with Amazon S3 bucket
 Use Flyway/Liquibase for automatization patches on db
 Manage Patroni PostgreSQL cluster
 Maintained Oracle databases (created and administered databases)
 Patched (minor updates)
 Upgraded version of Oracle Database (from 12 to 19)
 Fixed bugs by Oracle Support (patching, added parameters, etc.)
 Installed and created extract/replicat with Oracle GoldenGate
 Installed and added target to Oracle Enterprise Manager
 Maintained Exadata (software level maintenance, migrated from X8 to X9M)
 Maintained Oracle RAC (maintenance of 8 nodes)
 Created standby database with Oracle DataGuard
 Utilized SQL Tuning (SQL Tuning Advisor, query optimization by reading SQL Plan,
reading AWR, creating Tuning Sets)
 Used expdp/impdp (partitions, tables, schemas, tablespaces, databases)
 Utilized backup of Oracle Database (commvault and RMAN scripts)
 Administered Solaris, Oracle Linux
 Analyzed data for compression and deletion for optimization of storage space
 Used PL/SQL Developer, SQL Developer, Toad for Oracle, Lab128, SecureCRT, etc