EXPERIENCE
Oracle Developer
PL/SQL development, maintenance.
Agile Scrum software development processes.
SQL and PL/SQL tuning for performance optimization.
Gainwell Technologies 11/21 – 03/22
Senior Oracle Consultant / Development DBA
Debug packages/functions and making modifications.
Agile Kanban software development processes.
Build, maintain and enhance packages/functions in PL/SQL to support existing application and processes.
Creation and modifications of complex SQL queries, using custom and analytical functions.
SQL and PL/SQL tuning for performance optimization, bulk collect.
Erwin for documentation and reverse engineering. Creation and altering of database objects.
User/security maintenance: scripts to maintain stable user list on databases on multiple servers.
Installations of DML/DDL to support ongoing testing on multiple databases. DevOPS.
Warner Music 06/17 – 10/21
Senior Oracle Consultant / Development DBA
Maintenance and enhancements of Oracle based applications. Batch loading: weekly, daily, real-time using PL/SQL.
Maintenance and enhancements of Oracle based ETL processes for input of data, output, copying, etc.
Maintenance and enhancements of MySQL based application. Use of views, triggers, constraints, etc.
Data modeling: Logical and Physical design of new tables and processes. Databases: Oracle and MySQL. Performance tuning of PL/SQL, SQL, and T-SQL. Erwin.
Release management and installations. Backup and disaster recovery of PL/SQL, DDL, DML changes and new processes.
Power BI; Datawarehouse development; dimensions; daily; weekly jobs; PL/SQL; working with Cognos and Power BI teams.
Custom Application Database upgrades, and installations. DevOPS.
LA Care Health Plan 09/14 – 05/17
Senior Oracle Consultant
Support for implementation of JAVA / Oracle 11g based OLTP application for release into production. Debugging of applications and databases. PL/SQL, functions, procedures, triggers, shell scripting.
Maintenance of Linux Oracle 11g databases. Cloning of databases and schemas of Prod/Dev/Test environments. Monitoring of system events and proactive adjustments. Performance tuning of SQL, PL/SQL, partitioning and system parameters.
Automation of comparison of Schemas in same database and different databases. Reporting differences.
X12 EDI 820, 274, 824 mapping, modeling and testing. Generation of data sets for transmission.
Prior experiences:
Intuit Senior Oracle Consultant / Development DBA
Pacific Gas and Electric Application Architect, Consultant
ValueClick Oracle DBA / Developer
Accenture Oracle Developer / Data Architect
EDUCATION
BS / MS Computer Engineering Moscow Aviation Institute, 2001
SUMMARY
10+ years of Oracle Development in Onsite and AWS.
5+ years of MySQL Development
Logical/Physical Data Modelling
ETL, data cleansing and mining.
OLTP and Data Warehouses.
Performance tuning of SQL, PL/SQL
EDI x12 transaction 850, 857, 810, 820, 274, 824.
Liquibase, GIT, Jenkins