Software Developer – Apex

#Hiring “Software Developer – Apex” in Toronto, ON. (hashtag#remote – candidate must be located in hashtag#Canada) for one of our direct Public Sector clients. Qualified candidates can share their resume at supriya.mokashi@intelliprogroup.com

Duration: 6 Months Contract + Possible Extension
5+ years of experience with:
·        Experience with advanced APEX features like interactive reports, charts, and dynamic actions
·        Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
·        Writing complex procedures/pkg/views/scripts to do data de-normalization, data extraction, data transformation(cleansing), and data loading.
·        Relational databases (Oracle, SQL Server), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
·        Advanced SQL skills (PL/SQL, TSQL)
·        Cloud technologies (Azure, Google, AWS)
·        Advanced skills and hands-on experience with Oracle APEX
·        PL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
·        Working knowledge of issue tracking system JIRA, Azure DevOps
·        Using Git hub for version control and data model changes
·        Oracle Enterprise Manager (OEM Cloud 12c, OEM 11g Grid), Oracle Names Server, Oracle Net Service, Oracle Connection Manager, and Oracle Advanced Security, Oracle RAC, Oracle Network, Names Server, Data Guard, Oracle Exadata, Oracle Warehouse Builder (OWB)
·        PL/SQL Programming for database change tracking and data warehousing
·        Data migration and data integration across different platforms (Windows to UNIX, Windows to Windows, UNIX to UNIX)
·        Recovery (Restore) and refresh production and Dev/UAT/Test using RMAN to SAN storage.