Ilya Rubijevsky Email & Phone Number

Rancho Palos Verdes, CA, US

San Diego, CA, US

• Working as Oracle/SQL Server/PostgreSQL/MySQL/Hadoop DBA.
• Optimize Oracle/SQL Server/MySQL/PostgreSQL queries and fixing issues with slow running queries.
• Database migrations from Oracle, SQL Server, MySQL to PostgreSQL.
• Performance monitoring and optimizing SQL queries by using Naigo’s, PEM and New Relic.
• Implementing of logical and physical backups, logical restore and PITR.
• Installation and configuration Barman, repmgr, pgBadger, pgBouncer and pgAudit.

US

• Installed, configured, tested, monitored, upgraded, and tuned new and existing PostgreSQL databases.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Database migrations from Oracle, SQL Server, MySQL to PostgreSQL.
• Established and maintained security and integrity controls.
• Data Migration using SQL Loader and UTL FILE.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

Roseland, New Jersey, US

• Administered full phase cycle of the MySQL DB. Administered Development, QA, UAT, Pre-Prod and Prod envs.
• Installed and configured MySQL on Linux and Windows environments.
• Management and Administration of Oracle, MySQL system from design architecture to Replication implementation.
• Performed new DB design, configuration, backup/recovery, security, upgrade and schema changes, tuning.
• Effectively configured MySQL Replication as part of HA solution.
• Developed Oracle stored procedures, functions, triggers, Unix/Linux shells.

Orange County, CA, US

• Responsible for Graphite and Elastic Search/Logstash/Kibana (ELK) scaling and operation.
• Administration of MySQL/PostgreSQL /SQL Server in AWS platform.
• Created SSIS packages to populate data from various data sources.
• ETL, data profiling, data quality and clean ups for SSIS packages.
• Developed numerous ad-hoc reports for day to day financial reporting and generate custom SSRS.
• Analysis, design, development, implementation, testing and support of DW using Informatica Powercenter.

Round Rock, Texas, US

Involved in building the ETL architecture and Source to Target mapping to load data into datawarehouse.Worked on Query Optimization and ETL performance tuning for improving the performance of the datawarehouseWrote complex SQL queries and PL/pgSQL, PL/SQL procedures to perform database operations according to business requirements. Used SQL Server SSIS.

Aliso Viejo, CA, US

Database administration and schema design for MySQL, PostgreSQL, SQL Server and Oracle.Linux (RHEL, CentOS) system administration and repository development.Strong experience in developing ETL packages on data from various sources into Data Warehouses using Informatica, SSIS, and shell scripts. Maintained and re-factored custom ETL (Perl, Python, Bash) and.

Participated in the full life cycle development of an Operational Data Store System (ODS).Responsible for ODS Data Transformation Process and ODS-to-Data Warehouse Transfer Process using PL/SQL, T-SQL packages, SQL Loader and Unix shell scripts.Participated in writing automated scripts for regression testing.Wrote stored procedures to provide extra.

Los Alamitos, California, US

- Actively involved from initiation to completion of an Oracle DataWarehouse project- Data Conversion and Mapping from mainframe to Oracle Tables using SQLLoader control files

Alhambra, California, US

Designed and developed CAO’s Billing System

Pasadena, California, US

Loma Linda, CA, US

Developed Pulmonary Function, Echocardiographic Entry Form, Fiscal Data Storage Systems using Oracle Form, Reports and applications for the Web using Oracle WebServer, Java and Visual Café

Bs, Computers Science

Ms, Mathematics Science