Ilya Shuldiner

Supported and upgraded Oracle databases, including ODA patching and encryption changes, and performed cross-engine upgrades (Oracle and MS SQL) with HA/DR practices. Managed migrations from on-prem Oracle to AWS-managed services (PostgreSQL RDS/Aurora, MySQL, and related ingestion to OLTP-to-WH). Built streaming and backup workflows for multiple RDBMS using AWS services and Python, and configured Oracle Data Guard and SQL Server log shipping.

Administered Oracle RDBMS upgrades and supported tuning activities across multiple Oracle versions with cloud platforms (AWS/Azure). Implemented Cassandra deployments on cloud infrastructure and developed/optimized SQL and stored procedures for database behavior. Managed data loading from OLTP systems to big-data and warehouse platforms using Hadoop ecosystem components and analytics tools, and performed schema conversion to PostgreSQL.

Administered Oracle databases and HA/availability features such as RAC and replication technologies, along with monitoring and operational support. Managed MS SQL on-prem and in Azure, including HA-related configuration and troubleshooting. Supported Oracle databases and Oracle EBS systems, performed migrations and conversions, and developed PL/SQL and T-SQL routines for application database needs.

Supported an IMS-to-Oracle migration project for a limited onsite engagement. Performed Oracle DBA responsibilities necessary to complete migration activities and associated database readiness work.

Supported Oracle ODA deployments and ongoing tuning tasks, including installation, configuration, patching, and troubleshooting. Maintained Oracle EBS environments and handled MS SQL tuning and HA/DR setup for client needs. Worked with Oracle OEM/WebLogic-related integration, and contributed to data loading to Hadoop, MongoDB, and Redshift while writing Java-based components.

Provided Oracle EBS administration including patching, cloning, upgrades, and ongoing maintenance for production environments. Performed database backup, recovery, and replication support using Oracle tooling and Unix automation, and managed upgrades across Oracle and MS SQL versions. Supported enterprise data and reporting integrations with ETL tooling and architectural artifacts used for data loading workflows.

Provided remote Oracle database tuning and troubleshooting on an ad-hoc basis for operational incidents. Supported performance and stability needs through weekend/remote engagements until issues were resolved.

Installed and configured Oracle RAC in support of an IBM environment as a short onsite contract engagement. Performed the deployment tasks needed to bring the cluster into a usable operational state for the client.

Built and maintained database components including stored procedures, packages, and triggers using Oracle PL/SQL and T-SQL. Tuned Oracle and MS SQL performance for a data-mart loading workload and supported reporting/reporting-related database objects. Developed Java interfaces for client/server behavior and assisted with application integration using Java and related J2EE technologies.

Introduced a data warehouse approach for an online gaming workload and implemented core database code using SQL/T-SQL and Oracle-compatible PL/SQL patterns. Developed reporting and integration components using PHP and web technologies, including data loading and monitoring systems. Built email sending and data processing workflows using server-side code and database operations.

Administered Oracle and HA-related features and supported Oracle Applications and Peoplesoft environments as part of operational database responsibility. Implemented ETL loading workflows into a warehouse using Informatica plus supporting database loading utilities and Unix scripting. Delivered performance support for Oracle stored procedures and maintained end-to-end operational stability across integrated systems.

Provided infrastructure and database support for billing application development environments, including operational tuning and maintenance. Performed database performance tuning using Oracle diagnostics tools and contributed to automated maintenance scripts using Unix and platform utilities. Supported customization and integration of front-end components using Java/J2EE-related interfaces alongside database operations.

Supported Oracle Applications as a DBA and system administrator, including installation support and client-site operational tasks. Developed and maintained Oracle stored procedures and customizations using Oracle Forms/Reports and related database logic. Built data loading routines and tuning changes for Oracle and MS SQL environments and supported system upgrades across application versions.