Gloria Chung Email & Phone Number

Mississauga, On

Senior database developer, Lawful Access Team• Key contributor in a team that develops and maintains a large data warehouse containing subscriber and services-related lawful access information, with emphasis on security of data and data retention• Database platform evolved from Oracle to Hadoop• Designed and developed ETL applications that source from different databases in the company on various platforms (Oracle/Postgres/Galera/Hive) into Hive data warehouse using Oozie workflows and Sqoop • Designed and developed processes to feed datamarts (Galera/Cassandra) from Hive data warehouse using Oozie workflows and Spark applications• Migrated relational databases from Oracle to other platforms such as Postgres and Hive• Advanced Oracle features used include: partitioning, subpartitioning, external tables with preprocessor, error tables, types with inheritance, virtual private database• Day to day maintenance of the databases to ensure data integrity, tracking down any potential missing data from upstream systems• Dealt with internal clients to transform business requirements to technical ones

Waterloo, On

Database developer, Manageability and Data, Research In Motion• Key contributor in a team that maintains data warehouses for data traffic and messages• Designed and developed ETL applications in Oracle using stored procedures, triggers, etc• Automated daily ETL processes using shell scripts and cron

Toronto, Canada Area

Database developer and DBA, SOMA Networks Inc. • In charge of development and maintenance of an Oracle database with 200+ tables• Oversaw any problems in all production databases• Designed and modeled database schema using Embarcadero ER Studio• Developed stored procedures using Oracle9i PL/SQL• Developed customized installation and upgrade scripts for the database and schema using Bash Shell scripts and PL/SQL• Worked with Java developers to advise on database usage • Performance tuning on stored procedures and overall database performance• Projects highlight: deployment of XML schemas in Oracle database, automation of schema upgrades, notification system using triggers and advanced queue • Role evolved from Java developer to Data modeler and DBA • Wrote Java applications with JDBC interfaces to Oracle database via stored procedures. • Products and technologies used: Oracle9i, PL/SQL, Oracle XDB (XML DB), Oracle Advanced Queue, JDBC, Jakarta Tomcat, Jakarta Ant, Web Macro, Bit Keeper (version control system)• Completed a technical evaluation of embedded database products for the company’s new system architecture. Presented recommendation to management team and got accepted• Wrote benchmark code using C to assess the performance of McObject’s eXtremeDB and SQLite3• Part of development team to write C modules for in-house network management CLI (Command Line Interface), using the Allegro CLI framework• Developed Solaris custom installation and upgrade scripts for various models of Sun servers• Created build scripts and process for migrating a Solaris 8 server to Solaris 10, also included migration of Oracle9i database to Oracle10g

Data Science Certificate

A 16-week accelerated training on the foundation and practical application of data science Mastered Python/R programming excelling in data.

Bachelor Of Applied Science - Basc, Computer Engineering