Mark Hooper Email & Phone Number

I have 3+ decades of problem solving and solution building experience. I work with databases and software in a wide variety of information technologies. I have developed systems for: energy, finance, telecom, insurance, agriculture, manufacturing and transportation.I am the Chief Database Architect for Katalyst Data Management where I manage: design, development and operations of databases which host seismic, well, project and inventory related data for numerous multi-national energy companies around the world.I manage a DevOps team which is responsible for databases in: Calgary, Houston, London and Perth data centers. My team is responsible for the programming, availability, performance monitoring/tuning, upgrading/patching and safeguarding of these databases.I manage design and development of KDM's iGlass data model (based on PPDM v3.8). I design and manage database changes and programming from conception, development, testing to production deployment.I have vast Oracle database admin experience and have utilized technologies including: Data Guard and RMAN along with performance monitoring/tuning using Enterprise Manager and Foglight.I have extensive database programming experience and am extremely fluent in PL/SQL, PL/pgSQL, SQL and various shell scripting and programming languages. More recently I have embraced PostgreSQL (EDB AS) and have migrated Oracle databases to Postgres and converted significant amounts of PL/SQL to PL/pgSQL.I have significant experience in developing ETL procedures to handle data migrations from 3rd party databases such as Trango and ProSource to KDM's iGlass databases.Skill Set:Solution building/problem solving/troubleshootingPPDM data modelApplication/Process/Data work flow design/architectureOracle database admin (5 to 19c)EnterpriseDB PostgreSQL Advanced Server 12, 13 and 14SQL, PL/SQL, PL/pgSQL programmingData migrations/ETLData modeling/designOracle/PostgreSQL performance/query tuningOracle Data Guard/RMAN / PostgreSQL BART/BARMANDatabase replication/disaster recovery planning and implementationOracle Advanced SecurityOracle Spatial / PostGISLinux/Unix shell scriptingLinux/Solaris/Windows/AIXServoy, C, Perl programmingora2pgSQL ServerTeam management/mentoringSoftware change control systems

Listed skills include Databases, Oracle, Pl/Sql, Sql, and 46 others.

• 

  University Of Regina

  Computer Science