Christopher Davies A.
Kitchener,ON
Summary
Efficiency-focused thought leader with over Ten Years expertise as a Oracle Database Administrator and Data Engineering. Proven talent for Database Administration, Data Engineer, Data Analysis, cross-functional team leadership. Exceptional administrator with keen interpersonal, communication, and organizational skills. Eager to build data processes with less human intervention that meets your organizational goals. Speaks advanced English and Intermediate French.
Overview
12
12
years of professional experience
1
1
Certification
Work History
SENIOR DATABASE ADMINISTRATOR (Lead)
247Labs
12.2023 - Current
- Data Modeling on MySQL on AWS.
- Unix Shell scripting for Automation.
- Data Migration Pipeline development with Python.
- Build Data Dictionary for all Databases for all applications.
- Setup and Manage Power BI reports Pipeline for Dev, QA, UAT, Pre-Prod and PROD environments.
- Working with developers to build complex and efficient queries for the applications using Python, SQL.
- Database Documentation with GIT and GITLAB, Jira, Confluence.
- Implemented BI solution framework for business intelligence projects.
- Developed a Retrieval Augmented Generator (RAG) Model to Chat with users using OpenAI.
- Managed vendor relationships, negotiating contracts for software licenses and support services while ensuring costefficiency.
- Worked on Database and Schema documentation using tbls open-source package.
- SQL Tuning across all databases and applications using tools like AWR.
- Database Performance Tuning.
- Data Modelling.
- Developed comprehensive documentation of database systems, facilitating knowledge sharing among team members and improving training initiatives.
- Ensured high availability of critical databases by implementing proactive monitoring and disaster recovery strategies.
- Built databases and table structures for web applications.
- Managed database performance tuning and optimization for high-availability systems.
- Led data migration projects ensuring seamless transition and minimal downtime.
DATABASE ADMINISTRATOR Lead
Appzone Group Limited
07.2021 - 08.2023
- Oracle, MySQL, MariaDB and MongoDB Database Migration.
- Migrated Core Banking Application Database from Sql Server to MongoDB.
- Built the ETL process to update Changed Records from Sql Server into MongoDB Collections, used Bit Bucket, Azure Dev Ops.
- Manage 10,000+ databases On Azure SQL, Azure MI and SQL on VM.
- Database Error Troubleshooting.
- Managed a team of over 10 DBAs.
- Serviced a customer base of over 8 thousand clients.
- Postgresql Database Management on GCP.
- Data replication from Postgresql to Big Query.
- Data Guard Setup, Always-On Availability Group Implementation.
- Data Replication Across several Data Centers Azure to AWS.
- T-SQL Scripting for Lending and Recovery.
- Installation of MongoDB, Oracle, PostgreSQL, MySQL on Linux.
- SQL Query Tuning on PostgreSQL, Oracle, MySQL.
- Backup and Recovery on MongoDB using mongodump, MongoRestore.
- Setup replica set on MongoDB for production.
- Develop PYTHON scripts for Data Migration.
- Build Credit Score Prediction Models for Loan Service Automation.
- Automation of Data Archiving Process with Python, PSQL.
- Building Database Metrics for Performance Monitoring.
- RMAN Database Backups, ADDM, AWR, ASH.
- Monitoring & Tuning Database Performance.
- Troubleshooting application User Errors.
- Design Databases and ERD Diagrams.
- Oracle EBS Patching, Cloning, Installation, OEM 13c.
- Converting Structured Data to Unstructured Documents MongoDB.
- Disaster Recovery – Oracle Data Guard, Availability Group.
- Database Security, Patching, Vulnerability Fixes.
- Data Archiving Scripts Development with Python.
- Converting Structured Data to Unstructured MongoDB.
- BI-Directional Data Replication on SQL Server.
- MongoDB Administration and User control.
DATABASE ADMINISTRATOR
First City Monument Bank (FCMB)
12.2020 - 07.2021
- Finacle Core Banking Database Administration on Oracle RAC 12.1., Oracle RAC 12.2.
- PLSQL, TSQL, Batch, Bash Scripting.
- Responsible for Enterprise Database Patching, Database Backup and Cloning.
- Responsible for Data Migration between Databases using PLSQL and SSIS Packages.
- SQL Server Database 2012, 2014, 2016, 2017 Administration and Database Security.
- Database replication and DR Build for Data Guard, Always On and Logfile shipping.
- ETL Scripts development with PLSQL, Python.
- Data Pipeline development with Python.
- Development of Apache AIR Flow Dags with Python.
- Data transformation with Python.
- Apply Database Patches on SQL Server, Oracle RAC and Single Instance.
- Configure Database environment for Applications, Flexcube, Finacle.
- Performance tuning of all Database environments to ensure efficient resource utilization.
- Perform backups and recovery with RMAN.
APPS & DATABASE ADMINISTRATOR
Plexada System Integrators (PLEXADA-SI)
08.2013 - 11.2020
- Orchestrate advancement and completion of Oracle database administration assignments for diverse industry clients.
- Responsible for Enterprise Resource Planning Application Patching (ERP R12).
- Responsible for managing Inventory, Account Payables, Supply Chain (ERP R12) on Wesstar Project.
- Install, Upgrade and Patch EBS 12.2 (12.2.5, 12.2.7, 12.2.8).
- Customer Report Build with Oracle Report Builder 11g for Weststar and Associates (Project).
- Database Design for Weststar and Associates (Project).
- Development of ER Diagram to show database structure.
- Database Modeling for Flexcube Core Banking on Oracle Database.
- Postgres Database Administration.
- Data Migration from Legacy System to Postgres on Cloud - Azure.
- Meet with clients to understand their data needs and proffer solutions.
- Database Performance Tuning, database restore, implement recovery procedures, Database backups.
- Handle support calls from clients, co-ordinate DBA team.
- Implementation of Oracle Siebel and Business Intelligence applications in Ecobank group Project OYSTER.
- Microsoft SQL Server 2012 Administration.
- Build real-time transaction monitoring with AngularJS, Ajax, and PHP 5.
- Oracle RAC administration for Access Bank.
- PLSQL Scripting for ETL process at Ecobank project.
- Develop SQL Queries for key management reports on Core banking Databases – Finacle and Flexcube.
- Configuring RMAN automated Backups for all Databases.
- Implement Enterprise Manager 12c, 13c for Proactive Database Monitoring.
- Database vulnerability monitoring and Resolution.
- Rebuild of Primary Database in a Data guard using SNAPSHOT Database.
- Point in Time Recovery of Database and Datafiles.
- Analysis customer’s data with Oracle Report builder 10g.
Education
Post-Graduate Certificate (PGC) - Big data solution architecture
Conestoga College
12.2023
Bachelor of Science (B.Sc) - Digital Technology and Innovation
Dublin Institute of Technology
12.2018
Higher National Diploma (H.N.D.) - Computer Science
Yaba College of Technology
12.2010
Ordinary National Diploma (O.N.D.) - Computer Science
Yaba College of Technology
12.2007
Skills
- Cassandra DB
- CouchDB
- Hadoop
- Oracle 10g
- Oracle 11g
- Oracle 12c
- Oracle 19c
- SQL Server
- Azure SQL DB
- PostgreSQL DB
- Maria Db
- MySQL Db
- Mysql RDS
- Amazon Aurora
- Azure Managed Instance
- Dynamo Db
- MongoDB
- Hive
- DocumentDB
- Snowflake
- PAAS
- SAAS Databases
- Red Hat Linux
- Oracle Linux
- Centos
- Windows Operating System
- Suse Linux
- AIX Unix
- Oracle Data Guard
- Oracle RAC 11g
- Oracle RAC 12c
- Oracle ERP R12
- Data Replication
- ODI
- Materialized views
- OEM 11g
- OEM 12c
- OEM 13c
- ETL
- ELT
- Oracle Reports Developer 10g
- Oracle Reports Developer 11g
- GITHUB
- Python Programming
- AWS Glue
- Data Flow Pipeline
- MSSQL Always On
- MSSQL Cluster
- EIM
- Microsoft Power BI
- Apache Airflow
- SSIS
- Azure Data Factory
- Excel
- MongoDB Compass
- Tableau
- Oracle Flexcube
- Finacle
- Ansible
- Nagios Tool
- GCP
- AWS
- Azure
- Apache Kafka
- Apache Flume
- Apache Spark
- Scala
- Software Versioning
- SCRUM
- Software Documentation
- Software Testing
- HTML5
- PHP
- CSS3
- JavaScript
- MS Word
- MS Excel
- MS PowerPoint
- JQuery
- Angular JS
- WordPress
- SAN Storage Management
- VMware
- VirtualBox
- AWS Cloud
- Apache Web Server
- Visual Basic
- XML
- Database troubleshooting
- Database security management
- Backup and recovery strategies
- SQL query optimization
- Data integration strategies
- Data modeling techniques
- Data migration techniques
- High availability solutions
- Agile methodology
- Linux operating system
- Python
- Customer needs assessment
- Relational database management
- Data privacy compliance
- Data audits
- ETL process development
- Cloud database management
- Continuous integration and deployment
- Writing queries
- Replication and clustering
- Coding data
- Data testing
- NoSQL database administration
- Cross-platform database support
- jQuery
- Resource utilization analysis
- Performance monitoring tools
- Query execution plans
- Database version control
- Apache tomcat
- Data warehousing solutions
- Indexing and partitioning
- Database analysis
- Big data technologies
- Automated database testing
- Database schema design
- Microsoft SQL
- Teamwork
- Time management
- Attention to detail
- Problem-solving abilities
- Multitasking
- Multitasking Abilities
- Reliability
- Excellent communication
- Critical thinking
- Organizational skills
- Team collaboration
- Team leadership
- Effective communication
- Adaptability and flexibility
- Decision-making
- Task prioritization
- Self motivation
- Analytical thinking
- Python programming
- Object-oriented programming
- SQL programming
- Strategic planning
- Time management abilities
- Data analysis
- Cloud services
- Data migration
- Problem-solving aptitude
- Database design
- Technical documentation
- Data governance
- Data recovery
- Data management
Certification
- Oracle Applications Database Administrator (EBS Apps Dba), Koenig Solutions, India
- Oracle Certified Professional (OCP), 11g
- Oracle Certified Associate (OCA), 11g, APTECH Maryland
- Oracle Enterprise Manager, 12c Cloud Control
- Complete Python Bootcamp, Udemy
- Complete Python Developer Course, Udemy
- Ultimate Pandas Bootcamp - Advanced Python Data Analysis, Udemy
Technical Acumen
Cassandra DB, CouchDB, Hadoop, Oracle 10g, Oracle 11g, Oracle 12c, Oracle 19c, SQL Server, Azure SQL DB, PostgreSQL DB, Maria Db, MySQL Db, Mysql RDS, Amazon Aurora, Azure Managed Instance, Dynamo Db, MongoDB, Hive, DocumentDB, Snowflake, PAAS, SAAS Databases, Red Hat Linux, Oracle Linux, Centos, Windows Operating System, Suse Linux, AIX Unix, Oracle Data Guard, Oracle RAC 11g, Oracle RAC 12c, Oracle ERP R12, Data Replication with ODI and Materialized views, OEM 11g, OEM 12c, OEM 13c, ETL, ELT, Oracle Reports Developer 10g, Oracle Reports Developer 11g, GITHUB, Python Programming, AWS Glue, Data Flow Pipeline, Hadoop, MSSQL Always On, MSSQL Cluster, EIM (Siebel CRM Application), Microsoft Power BI, Apache Airflow, SSIS, Azure Data Factory, Excel, MongoDB Compass, Tableau, Oracle Flexcube, Finacle, Ansible, Nagios Tool, GCP, AWS, Azure, Apache Kafka, Apache Flume, Hive, Hadoop, Apache Spark, Scala, Software Versioning, SCRUM, Software Documentation and Testing, HTML5, PHP, CSS3, JavaScript, MS Word, MS Excel, MS PowerPoint, jQuery, Angular JS, WordPress, SAN Storage Management, VMware, VirtualBox, AWS Cloud, Apache Web Server, Visual Basic, XML, Python
Languages
English
Native or Bilingual
French
Professional Working
Timeline
SENIOR DATABASE ADMINISTRATOR (Lead)
247Labs
12.2023 - Current
DATABASE ADMINISTRATOR Lead
Appzone Group Limited
07.2021 - 08.2023
DATABASE ADMINISTRATOR
First City Monument Bank (FCMB)
12.2020 - 07.2021
APPS & DATABASE ADMINISTRATOR
Plexada System Integrators (PLEXADA-SI)
08.2013 - 11.2020
Bachelor of Science (B.Sc) - Digital Technology and Innovation
Dublin Institute of Technology
Higher National Diploma (H.N.D.) - Computer Science
Yaba College of Technology
Ordinary National Diploma (O.N.D.) - Computer Science
Yaba College of Technology
Post-Graduate Certificate (PGC) - Big data solution architecture
Conestoga College