Senior Cloud Database Engineer (RDS/Aurora)

ILYA SHULDINER

Richmond Hill, ON, Canada **************@*****.*** 647-***-**** (SMS)

PROFESSIONAL EXPERIENCE:

DBA Oracle (15y), MS-SQL (8y), PostgreSQL (8y), MySQL (6y)

Oracle versions 6/7/8/8i/9i/19g/11/12c/19c, MS-SQL 2000 through 2021

OS: Unix/Linux (15y), AIX, HPUX, Solaris, HP, Windows, OS/2

Platforms: AWS, Azure, OpenNebula, Exadata, ODA

VM/Containers: VMware,Docker,Kubernetes,AWS ECS/EKS/Fargate

Cloud DBs: AWS RDS (Aurora/MSSQL/Oracle), Azure MSSQL, Dynamo, Redshift

Storage: S3, ZFS, EMC, HP-P6000, IBM HACMP/DS6000, NetApp, Veritas, Saturn

Expertise in SQL, PL/SQL (Oracle) and Transact/SQL (MS-SQL), CQL(Cassandra)

DBA for E-Business Suite(10y), Oracle Apps 10-11-11i-R12.1-12.2 (9y)

Programming: Java(8y), C++, C#, Python, Perl, PHP, R, Linux shell, PowerShell

Hadoop (5y) - Hortonworks, Cloudera, EMR : Hive/Hbase/Sqoop/Spark/Impala

NoSQL: Cassandra(5y), DynamoDB, MongoDB, CosmosDB, Redis

Streaming/messages: Kafka, Kinesis, Flume, Pub Sub, Akka, Golden Gate

ERP systems: SAP R/3 (2y), Peoplesoft (2y)

DBMS: MariaDB, SAP HANA, Redshift, Aurora, DB2, MemSQL

DevOps : Jenkins, Ansible, Terraform,SVN, CVS, Jira,,Slack,Splunk, Git

DB HA: Oracle DG, Streams, Shareplex, DBVisit, AlwaysOn

Backup/recovery: Oracle RMAN, Commvault, SnapVault, Veritas Netbackup

Oracle Performance Tuning: AWR, Statspack, ADDM, Performance advisors

Data Architecture, design tools (Sybase PowerDesigner, Oracle Designer, Erwin)

Monitoring tools: Oracle OEM (8y), Cloudwatch, Splunk, Grafana, NewRelic

ETL: Talend, Informatica, DataStage, OWB, DTL/SSIS, Pentaho, Glue

Scheduling tools: Crontab, Oozie, Airflow

BI/CRM: Salesforce, OBIEE, Cognos, Oracle Hyperion, Tableau

Business components/ORM: EJB/Hibernate/Spring

Input/Output formats: JSON,SOAP,ORC,Avro,Parquet,Yaml

Data Warehousing and OLTP systems, SDLC, Agile development, Waterfall

Oracle Fusion Middleware: OBIEE, OID/SSO, OAM, OIM, WebCentre, SOA, AIA, BPEL, LDAP, WebGate, SSO, AD, BI Publisher

Dev and other tools: Toad, PL/SQL Dev, MS Office, Visio, Wiki, Bit, Confluence

CERTIFICATIONS:

AWS

Cloud Practitioner, Data Analytics ( in process )

Acclaims

Oracle

Cloud Database Migration and Integration 2021 Specialist

Oracle

OCP DBA 10g/11g/12c/19c, EBS R12 Apps DBA, OCE RAC & Grid 11.2

Acclaims

Java

Java (1.4) (SCJP), SCBCD J2EE 5 Java SE 8 OCP

Acclaims

Microsoft

MCP

RELATED WORK EXPERIENCE:

Data Engineer/Cloud DBA Dealertrack, Mississauga, ON since 2020

Postgres/MySQL (Aurora/RDS), Oracle, MSSQL, Redshift, DynamoDB

Migrate Oracle on prem to AWS Aurora ( Postgres, MySQL ), Custom RDS Oracle

Upgrade Oracle databases 12c->19c, MSSQL 2012->2019 (with HA)

Patching/upgrading Oracle ODA

Conversion Safenet encryption to TDE (oracle)

Streaming data from on prem (Oracle) to AWS (PostgreSQL, Dynamo): Kinesis/SQS

Data Engineer/DBA Blackberry, Mississauga, ON 2018-2020

Platforms/Tools: Oracle, Cassandra, MSSQL, MySQL, Postgres, SAP, AWS, Azure

Oracle(on premise & AWS) 11g/12c/18c/19c upgrades/tuning/coding

MS-SQL on Azure (Paas), Transcat/SQL coding,AlwaysOn config

Installing/config/tuning Cassandra clusters on OpenNebula & AWS EC2

Big Data/WH loading to Elasticsearch, Hadoop (HDInsight/EMR)

Data Streaming: Oracle GoldenGate, Debezium, Spark, Flume, Akka, Kinesis

Oracle Apps (EBS) – install, config, patching, upgrade to R12/12.2

Conversion Oracle data to AWS (Aurora/RDS Postgres/MySQL/Redshift) DMS/SCT

Data Consultant 407ETR /contracts GTA 2013-2018

Platforms/Tools: Oracle,MSSQL,MySQL,DB2, Peoplesoft,EBS, Hadoop, AWS, Docker

Oracle 11.2, 12.1 – DBA activity, RAC, DataGuard, Streams

MS-SQL 2008 R2/2012/2014/2016/AlwaysOn on-premise/Azure

Hadoop installations/upgrades: Hortonworks, Cloudera, EMR

OEM 12c/13c – installing, configuring, Weblogic maint

Oracle ODA + ZFS - install, configuring, patching, troubleshooting

Carried out conversion of 407etr.com database from DB2 to Oracle

Oracle Apps (EBS) – install, config, patching, upgrade to R12/12.2

Developed stored procs, triggers, functions: PL/SQL and Transact/SQL

Apps DBA Pythian, Ottawa, ON (remote) 2011-2013

Platforms/Tools: Oracle EBS 11i/R12, Peoplesoft, Oracle 11g/12c, RAC 11.2/12C, MySQL, NoSQL, Cassandra, Solaris, ODA, Exadata, OFM, Azure, AWS, Postgres, MySQL

Oracle ODA (x3-2, x4-2) install, configuring, patching, troubleshooting, tuning

Oracle Applications (EBS 11i/R12) - patching, cloning, upgrades, maintenance

MS-SQL 2005/2008/2012 tuning, troubleshooting, DR (AlwaysOn, Mirroring )

OEM 11g/12c – installing, configuration, troubleshooting

Development of packages, stored procedures and triggers (SQL, PL/SQL, T/SQL)

DR solutions with Oracle Streams/Dataguard,Golden Gate

Weblogic/OFM 10g/11g/Hyperion/OAM install/config/setting connectors

Work on client site (www.otpp.ca): DBA Oracle/MS-SQL/MySQL/OEM 12c

Load to Hadoop, MongoDB, Redshift (Java coding)

DBA/Data Architect Grove Systems, Mississauga, ON 2006 - 2011

Platforms/Tools: Oracle EBS, SAP R/3, Oracle 9i/10g/11g, RAC 10.2/11.1/11.2, OEM (Grid 10g/11G), MS-SQL 2000/2005/2008, DB/2 9.1, MySQL 5, Postgres, Sybase, Linux RH/OEL/Suse, AIX/HACMP), Solaris, HP-UX, Exadata, Cognos, SOA, OFM 10G/11G, SSRS, GoldenGate, Shareplex, PowerDesigner, Erwin, Informatica ETL Load

Oracle Applications (EBS 11i/R12) - patching, cloning, upgrades, maintenance

DB backup/recovery/replication using RMAN, Unix shell scripts, SAP Utilities

Upgrade Oracle databases ( 9i->10g->11.1 ->11.2) and MS-SQL (2000->2005)

Middle Tier:Siebel,Weblogic,OAS, Jboss5,Websphere, J2EE/EJB/Hibernate

Oracle & Java Developer Versa Systems, Toronto, ON 2004 - 2006

Platforms/Tools: Oracle 8i/9i/10g on Windows/Linux, MS-SQL 2000, MySQL, SQL Coding, Transact/SQL, PL/SQL, Oracle Forms/Reports 6/6i/9i, Java, J2EE, Crystal Reports

Developed packages, stored procedures and triggers (PL/SQL, Transact/SQL)

Performance tuning for Oracle and MS-SQL ( data mart loading system )

Developed Java interfaces (Swing, Eclipse, multi-threading, client/server)

DBA (MS-SQL) Spiral Solutions Ltd., Israel 2002 – 2004

Platforms/Tools: MS-SQL 2000, Oracle 9i, MySQL, PostgreSQL, Windows, Linux, Java, SQL, Transact/SQL, PL/SQL, HTML, PHP, JavaScript, XML

Introduced DW for online gaming, developed database code (SQL, T/SQL, PL/SQL)

ETL data processing using DTS

Designed and developed web reporting system ( PHP, HTML, JavaScript)

Created web affiliate and advertisement analysis program for online gaming

Developed email sending system (PHP, Transact/SQL, J2EE )

Implemented data loading/monitoring systems ( Java, Swing, JDBC, .Net, DTS)

DBA Clalit Health Service, Israel 2001 – 2002

Platforms/Tools: Oracle8i/9i, Oracle RAC, Data Guard, Advanced Replication, MS-SQL 2000, Sybase 12.5, Oracle Apps 11/11i (Financial), Peoplesoft 7.5 (HRMS), Windows 2000/XP, Sun Solaris 8, AIX, Mainframe(AS/400), Unix scripts, Developer2000/6i (Forms, Reports), SQL, PL/SQL, RMAN, SQL*Loader, Informatica

ETL loading data to warehouse (Informatica, Unix scripts, SQL*Loader, Pro*C)

Provided support as Oracle Applications and Peoplesoft SysAdmin ( AS/400 )

Development/perf tuning for PL/SQL(TKProf, Performance Pack), Transact/SQL

Oracle DBA Amdocs, Israel 2000 – 2001

Platforms/Tools: Oracle8/8i, MS-SQL, UNIX (AIX, HP, Solaris),Windows NT/2000, Amdocs Ensemble, Powerbuilder, Java, Pro*C, SQL Coding, Unix scripts, PL/SQL, SQL, Developer 2000/4.5, J2EE (JDBC, Servlets, JSP, EJB), IBM WebSphere

Infrastructure support for development of billing applications

Performance tuning (TKProf, AWR,Statspack)

Designed and developed maintenance scripts (Unix & NT scripts, Pro*C)

Customization of front end (HTML, Java, J2EE, JSP, EJB)

Oracle DBA/ Apps Administrator Unitask, Israel 1998 – 2000

Platforms/Tools: Oracle Applications 10/11,Oracle7.3/8/8i, MS-SQL 6.5/7, Windows NT, UNIX (Solaris, HP, AIX), Java, SQL Coding, Unix scripts, PL/SQL, SQL, OAS, Tivoli

Provided support as Oracle Applications DBA/System Administrator at clients sites

Developed stored procedures for Oracle Applications (PL/SQL)

Designed and developed forms for Oracle Applications customizations (Oracle Forms/Reports)

Developed data loading and data procedures (Java, Pro*C, Unix & NT scripts)

Tuned Oracle and MS-SQL database performance

Upgrade Oracle Applications (10 -> 11)

Previous work experience (before 1998):

Worked as Oracle DBA/System Administrator/Programmer: mainframe IBM Systems/360 (IBM 3250), AS/400 (System/38), Unix (SCO/Aviion/Xenix),

Novell Netware, shell scripts, Oracle 5/6/7.3/9/8i, C, C++, FoxPro, MS Access, MS Exchange, Windows 3.11/95/98/NT

Short Term Contract Assignments:

Year

Customer

Position/Activity

Comments

2008

Ministry of Transport of Ontario

Oracle RAC Installation for IBM

2 weeks onsite

2009

Ministry of Health and Long Term Care of Ontario

Oracle DBA Remote support

Ad Hoc per call tuning and troubleshooting (weekends)

2013

CIBC Bank

Oracle DBA IMS to Oracle migration

3 months onsite

EDUCATION:

M.S. in Engineering Zaporizhzhya National Technical University, Ukraine

COMPUTER COURSES:

2016

Oracle ODA X5.2 Admin

Destech

Toronto

2010

Oracle RAC 11G Admin

Destech

Toronto

2002

MS-SQL 2000 Admin

Ramat-Gan College

Herzeliya, Israel

2001

XML for Web Applications

John Bryce College

Tel Aviv, Israel

2000

Oracle 8i DBA III (Performance)

John Bryce College

Tel Aviv, Israel

REFERENCES: Available per request

Contact this candidate