Dmitriy Kotkov show contact info
Walnut Creek, CA 94596
LinkedIn: linkedin.com/in/dmitriykotkov/
Summary
Over twenty-five years of extensive experience in database administration, engineering, designing and development. Collaborated with Business, Management, Security, Audit, QA, Development and Sys/App Support teams to design, create and maintain databases with the highest level of reliability, scalability, security and performance achieving the SLA. Broad experience in database upgrading, patching, capacity planning and cross platform real-time data migration.
Education
Masters in Computer Science
Work Experience
Sr. Database/ETLEngineer
testRigor
San Francisco, CA
10/2024 –07/2025
•Implemented secured multi-factor AWS role-based access policy using IAM and Auth services. Completed SSO configuration.
•Installed Oracle 19c/21c and Grid Infrastructure (GI) 21c and completed ASM storage configuration for Oracle databases.
•Applied CPU, PSU and SPU to Oracle 19c and GI 21c.
•Performed installation of RH Linux 9 and Goldengate Microservice 23ai.
•Maintained AWS MySQL and Aurora PostgreSQL databases enhancing application performance, availability, security and scalability.
•Upgraded Oracle environment to utilize advanced unified authentication and auditing.
•Troubleshooted various performance issues using AWR/ADDM/ASH reports, SQL Trace, Oracle TFA collection tool.
Sr. Database Administrator/Engineer | SME
First Republic Bank
San Francisco, CA
07/2015–07/2023
•Hands-on experience in advanced configuration of Oracle Database Appliance in Data Center, including network and ASM/ACFS storage setup.
•Ensured 100% security CIS benchmark compliance for MySQL, Oracle and Postgres databases, enhancing security measures. Launched a CIS-CAT monitoring system, elevating system security and efficiency.
•Engineered an integration of MySQL, Oracle clustered (RAC), Postgres database monitoring into corporate Solarwinds and Imperva systems using PL/SQL improving system efficiency, reduction in system incidents and reducing time for root cause analysis.
•Managed MySQL, Oracle 11.2/12.1/12.2 RAC and Postgres databases migration and upgrade to AWS RDS achieving a significant cost saving.
•Implemented High Availability and advanced backup strategy using RMAN and Disaster recovery strategy using Dataguard for Oracle and multi master/slave replication for MySQL. Achieved 100% success in all DR Test.
•Utilized AWS CloudTrail, CloudWatch, and Performance Insights to identify and resolve database bottlenecks reducing time for analysis of situation.
•Supported the enterprise backup tool Cohesity for MySQL, Oracle and Postgres databases. Deployed and upgraded agents on OS.
•Troubleshooted and resolved number of technical and performance issues using various tools such as OEM, Solarwinds, Foglight, AWR/ASH/ADDM reports, Operating System commands.
•Worked on various deployment automations using bash scripting and Ansible.
Sr. Database/ETL Engineer
Sogeti
Redwood City, CA
11/2014–06/2015
•Deigned and configured data workflow by integrating Oracle with Postgres achieving a significant increase of conversion efficiency.
•Engineered real-time data ETL replication from Postgres to Oracle, MS SQL and MySQL leveraging Oracle Goldengate enhancing data integrity.
•Configured secured connection and data transfer using SSL/TLS.
•Automated report generation, data load/extract from DB2 database using OS, Python scripting and DB2 export and import utilities.
•Streamlined DB2 database refresh process leveraging OS scripting and db_backup and db_restore commands.
Application/Database DBA
Chevron
Concord, CA
10/2024–11/2014
•Automated key data import/export processes reducing processing time through UNIX/DOS PowerShell scripting and PL/SQL.
•Applied strong security options to store sensitive data in databases and outside on operating system levels.
•Troubleshooted and tuned database performance achieving a notable reduction in query response times and maintenance tasks using AWR/ASH/ADDM reports and OEM.
•Worked on SSO integration of the application and corporate security system.
Sr. Database Architect
Aepona, Inc.
Sunnyvale, CA
01/2012–10/2012
•Installed and configured Oracle RAC database on Linux resulting a high-performance and stronger database reliability and availability.
•Designed and implemented Virtual Database solutions to secure data and improve access efficiency.
•Worked with Git as version control system
•Deployed MySQL database platform for the application as part of global cost and performance optimization strategy.
•Tuned multiple MySQL and Oracle database and ETL processes and queries.
•Cloned and refreshed Oracle database in different environments using RMAN and expdp/impdp.
Sr. Oracle/SQL DBA
The Gymboree Corp.
San Francisco, CA
10/2011–01/2012
•Increased database query response times through meticulous SQL tuning with Explain Plan and TKPROF tools.
•Implemented robust RMAN backup strategies via Veritas NetBackup ensuring 100% data recoverability for enterprise systems.
•Installed and configured Grid Infrastructure 11g. Migrated Oracle databases from regular file system to ASM using RMAN and cascading standby.
Sr. Oracle DBA | Architect
Royal Bank of Scotland
Chicago, IL
05/2009–07/2011
•Tuned database and queries performance using various approached such as OS and database parameters, database objects or query revising.
•Automated processes for database maintenance or business tasks using combination of OS bash, PL/SQL, Python scripts.
•Implemented a real-time NAGIOS monitoring system enhancing operational efficiency through proactive issue detection.
Oracle SME | Architect
Bank of America
Chicago, IL
04/2007–05/2009
•Worked as lead database architect for Transition Service Agreement enabling seamless migration and integration of ABN AMRO BANK databases into Bank of America’s environment.
•Designed and implemented a robust migration between Data Centers ensuring data consistency and integrity for 20 TB databases using Oracle RMAN, expdp/impdp, Python and shell scripting.
Oracle Database Administrator
Bank of America
Chicago, IL
07/2003–04/2007
•Built backup/recovery strategy, integrating Oracle Standby/Dataguard and Network Appliance elevating RPO and RTO.
•Configured 2/3/4-nodes RAC databases. Efficiently distributed work load across nodes to achieve better performance and database accessibility and reliability.
•Cloned and refreshed databases using RMAN, expdp/impdp, exp/imp.
•Created various reports for management using Crystal Reports.
Oracle Database Administrator
E-Research Technology, Inc.
Bridgewater, NJ
07/2001–03/2003
•Installed, patched and cloned databases. Performed regular database maintenance and support using Oracle Enterprise Manager (OEM)
•Optimized number of database objects (SQL-tuning) and parameters (Database tuning)
•Developed and deployed numerous reports using Crystal Report 8.0/8.5
Skills
•Oracle 10g/11g/12c (Rel.1/2), 19c, 21c, Oracle RAC, Oracle Database Appliance, MySQL, PostgreSQL, DB2, MongoDB, MS SQL Server
•RedHat EL, Oracle RedHat EL, IBM AIX, Sun Solaris
•Oracle Automatic Storage Management, ASM Cluster File System, Network File Systems, Oracle Cluster File System
•Oracle Designer, Quest Toad Modeler, Embarcadero ER/Studio
•Dataguard, Goldengate, Informatica, Oracle Gateway, ETL, Tableau
•Quest SQL Navigator, Quest Toad, SQL Developer, Spotlight, Oracle Enterprise Manager (OEM), RMAN, SQL*Net, SQL*Loader, SQL*Plus, Connection Manager, Statspack/AWR/ADDM, NetBackup, Solarwinds, Foglight, Imperva, Data Performance Analyzer, NAGIOS, Commvault, Cohesity
•SQL,PL/SQL, Unix/DOS shell, Git
•Database, Operating System, Network, storage tuning and troubleshooting
•Advanced Security, TLS/SSL, SSO, Fine-grained auditing
•AWS, Aurora Postgres, RDS for Oracle, Oracle Integration Cloud