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. • Installed and configured MySQL 5.x/8.x on Linux and Windows environments. • Managing/Troubleshooting MySQL 5.x and 8.x in prod and dev environments on both Linux and Windows. • Effectively configured MySQL Replication as part of HA solution. • MySQL performance tuning on a daily basis for preventing issues and providing capacity. • Working with the ETL team using SSIS, Informatica and Pentaho. • Custom database monitoring using shell and SQL scripts. • Upgrading Oracle databases from 11g to 18c. • Performing MS SQL Server tuning using DB engine Tuning Advisor, Profiler, DMVs and SQLSentry. • Maintain and monitoring RMAN, NetApp/EMC Snapshots and export backups. • SQL Server Database Administration, including performance tuning, monitoring and Disaster Recovery. • Perform all database management responsibilities in Microsoft Azure for production and non-production workloads. • Creating and maintaining Always On availability groups (HADR/ Replica). • Develop SQL reports that meet client expectations for the application.

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. • Provided appropriate consulting, interfacing, and standards for DB management. Monitors transaction activity and utilization. • Conducted complete analysis of database capacity and performance requirements. • Linux servers administration, provisioned with Bash and Docker. • Implemented various automated UNIX shell scripts to invoke PL/SQL. • Designed competent PL/SQL programs using PL/SQL collections, Records types, Object types. • Supported day to day operations of multiple Documentum applications across EPA regions. • Developing Docker images to support Development and Testing Teams and their pipelines • Developing scripts for build, deployment, maintenance and related tasks using Docker, Python and Bash.

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. • Loaded the data into the Oracle tables using TOAD and SQL Loader. • Supporting management with different DB related decisions. Handling Release management and user acceptance. • Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.. • Assisted in designing, capacity planning, and security and accessibility functions of databases. • Participated in 24x7 on-call rotation to support critical business applications. • Unix Shell Scripting to automate various DB maintenance tasks like DB alerts, backup, restore and monitoring DBs. • Configuring Golden Gate replication from Oracle to Oracle and from Oracle to MySQL. • Installed and configured s3 client to upload backups to s3 bucket on AWS. • Maintaining and supporting the existing reports as per the requirements in the customer support portal. • Identify, recommend, and implement all new database technologies and license management. • Provided support to Quality Assurance team with troubleshooting of issues. • Conducted code reviews for peers to verify program logic and identify design flaws. • Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines. • Define and document database best practices.

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. • Working with Informatica Data Quality (IDQ) toolkit for analysis, data cleansing, matching and conversion. • Analyzing data and build reports using Informatica data profiling tool. • Performed DB health assessments and monitoring. Involved in fine Tuning / Performance and Query optimization. • Conducted reviews of database designs and system integration issues for further improvements. • Analyzing and tuning Informatica mappings and SQL queries to improve data retrieval and loading. • Maintained project documentation relating to testing, coding and logic of ETL processes. • Provided technical guidance and support to end-users. • Worked on Agile methodology and played scrum master role on rotation basis.

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 tool to build high performance data integration solutions including extraction, transformation and load packages for datawarehousing. Extracted data from the XML file and loaded it into the database.Analyzed database growth trends and planned for future disk, memory, and CPU needs; made recommendations to management. Reengineered batch steps to make them run in parallel.Wrote scripts to massage data and feed to MySQL/PostgreSQL/Sybase IQ/Oracle databases for alert generation and automated in batch cycle using autosys.Responsible for MySQL/PostgreSQL /SQL Server 2014 database development, architecture and administration.Designed and implemented shared environments for SQL Server/Oracle Development, QA Test/Staging and Production.Designed, developed and implemented complex Data Marts/Business Intelligence to support Sales/Marketing and Senior Level Management. Led the migration of Oracle Reports to SQR and Crystal ReportsDesigned and developed system using Oracle Forms, Reports and PL/SQL. Tuned SQL statements, Forms and Reports.Integrated and supported three 3rd Party vendors applications using SQL Server, DTS, T-SQL, Reporting Services, ASP.NET, Informatica and AutoSys. Integrated new central contact and client data services

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 data synchronization software.Used SQL Loader extensively for loading different types of data into Oracle. Extensively used SQL Server Business Intelligence Development Studio for data retrieval, analysis, design and development of reports. Experienced working on logical and physical data models using ERWIN 6.0Performed general MySQL/PostgreSQL/SQL Server/Oracle database tuningMonitored trends in disk space utilization, memory usage, and availability on key database servers.Created and managed database maintenance, backup and disaster recovery plans.Implemented Marketing and Sales processes covering Campaign, Leads, Accounts, Contacts, Opportunities, Forecasting, Quotes, Pipeline management etcImplemented a database roadmap to ensure long-term data scalability and execution viabilityTested and recommended hardware upgrades for cross-environment server migrations

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 functionality, including loading and modifying of data and retroactive business rule changes. Used import / export dataDeveloped the strategy for external data load in to Data Warehouse using Web Focus ETL Manager.Supported existing MySQL systems. Performed MySQL Replication setup and administration on Master-Slave/Master

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