Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert)

Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert)

IT Consultant

Followers of Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert)647 followers
location of Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert)Tanzania

Connect with Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert) to Send Message

Connect

Connect with Eng. Elia Mtafya (OCP,EDB Postgres Advanced Server Expert) to Send Message

Connect
  • Timeline

  • About me

    Technical Lead at Ipel Infomedia Solutions Limited

  • Education

    • NIIT INDIA

      2009 - 2009
      OCA,OCP Oracle 9i OCP ,Oracle Database 10g OCP,Oracle Database 11g OCP
    • St.Joseph College of Engineering & Technology

      2006 - 2009
      Bachelor of Engineering (BEng) Computer Engineering
    • University of Strathclyde

      2015 - 2017
      Master of Science in Finance
  • Experience

    • RC SACOSS LIMITED

      Sept 2009 - Sept 2010
      IT Consultant

      1. Network Administration, 2. Problem Isolation (Troubleshooting) in Computer Network3. Preparation of Preventive Maintenance plan 4. Administration of Accounting Software (Quick Book and CRDB Financial Solution) 5. Developing Backup plan and System Recovery Procedures.

    • Bravo Enterprises Company Limited

      Oct 2010 - May 2011
      Assistant System Administrator

      1. Hardware and software systems support for computers and printers, Windows Servers/Microsoft Exchange/Active directory and Outlook management, 2. Manage all new installation of projects for window servers, 3. Configuration of Cisco switches, and other network resources, develop and update documentation, appraising users, administrating of vital information and website development, 4.Create user manuals and provided technical support sessions for new employees Administrated and maintained environment security. 5. Administering security alerts to staff and daily data backups and perform major and minor repair/ maintenance of Computers together with its peripherals, 6. Implementation and support of Network Systems (WAN, LAN & VLAN) and provide operational support to IT infrastructure Show less

    • NMB BANK PLC

      Jun 2011 - Jul 2013
      Oracle Database Administrator

      Oracle DBA on a Core Banking System(Oracle Flexcube Universal Banking System)Oracle 11gR3, OBIEE, Oracle 11g WebLogic ServerEnvironment: p595 IBM Hardware, AIX 6.1 Operating System with SAN and TSMResponsibilities: 1. Database Administration and Performance Tuning, Ensuring high performance of the database systems, Ensuring availability of the database systems, Proactive maintenance of the database and Proactive monitoring of the database.2.Supporting production as well as multiple development and test environments, Work as part of a team and provide 24/7 support when required3.Handling database upgrades, migrations and patching4.Backup and Recovery (RMAN), Establish and maintain sound backup and recovery policies and procedures5.Scripting - SQL, PLSQL and Shell Scripting6. UNIX (AIX 6.1) system administration and support7.SQL Tuning 8. High Availability using Data Guard 9.Database Monitoring using - OEM, lab128-v15916, Insider-3.2.1 10.Supporting Core Banking system (Flex cube Universal Banking System) and Supporting End of Day Activities as DBA. 11. Implement and maintain database security (create and maintain users and roles, assign privileges). 12. Setup and maintain documentation and standards 13. Plan growth and changes (capacity planning). 14.Perform general technical trouble shooting and give consultation to development team 15. Installation, configuration and upgrading of database server software and related products. Show less

    • Bank of Tanzania

      Jul 2013 - now

      ROLES AND RESPONSIBILITIES•Ensure Backups and Recovery arrangement for Business Continuity are viable and can be used for recovery of operations of the Bank of Tanzania in case of disaster or emergencies. •Ensure All Production Databases replicates with Standby Databases in really time for disaster recovery requirements and guaranteed Business Continuity.• Ensure all production databases running 24/7 and having good performance for daily business support based on business requirements•Perform Installation, configuration and upgrades of database server software and related products•Implement and maintain database security (create and maintain users and roles, assign privileges).•Perform capacity planning for all Databases (Plan growth and changes)•Perform administration of Oracle Audit Vault System for centralized security and control•Perform administration of Oracle Enterprise Manager 12c Cloud Control System for Centralized Monitoring of all Production and Standby databases•Perform Administration of Enterprise Ware House, Oracle Data Integrator and Oracle Business Intelligent •Perform general technical troubleshooting and provide consultation to development team on best practices in RDBMS. Show less DBA in Data Warehouse maintaining enterprise warehouse and business intelligence solutions and making sure that data architecture, data warehousing and business intelligence support is successfully delivered.Responsibilities: 1) Coordinating data warehouse development, migration of data through manual or ETL processes, revision and update of data marts and cubes, procedure development, troubleshooting, system configuration, security administration and account setup2) Installing, developing and upgrading data warehouse system and performing routine systems administration maintenance activities3) Developing data models and data maps for data warehouse system4) Developing processes and applications for migration/transformation of data from business systems to the data warehouse system5) Developing and maintaining data marts, data cubes, queries and reports6) Initiating processes and documentation of corporate data warehousing system and developing procedures to ensure security and integrity of data7) Coordinating and scheduling tests and upgrades to the data warehouse system8) Researching and evaluating software, system upgrades and enhancements and providing technical recommendations9) Providing assistance to end users and programmers on data warehouse related problems and issues10) Managing end-user accounts and accessibility and providing technical support to end-users Show less

      • Senior Database Administrator

        Jul 2019 - now
      • Database Administrator

        Jul 2013 - Jul 2019
    • Ipel Infomedia Solutions Limited

      Jan 2021 - now
      Technical Lead

      DATABASE MANAGEMENT SOLUTIONS • Oracle general Database Administration • Oracle Performance Tuning.• Oracle Replication Setup (Oracle Data Guard).• Oracle High Availability Architecture Setup (Oracle Real Application Cluster+Active Data Guard)• Oracle Real Application Cluster (RAC) • Consultation of Oracle Database Technologies• Training of Oracle Relational Database Management System• Oracle Enterprise Manager Cloud Control setup • Oracle Audit Vault setup • EDB Postgres Advanced ServerSYSTEM ENGINEERING & NETWORKING SOLUTIONS• State of art servers and storage system deployment, management and maintenance• High end operating systems Deployment, Patching, Management, and Performance Tuning• Data Centre Planning, Designing, Installation, and Management• Public and Private Cloud Deployment and Management• Automated and Manual Microservices systems Infrastructure Design, Deployment and Management• Dockers and Kubernetes Infrastructure Design, Deployment and Management• LAN/WAN Design• Network Security• Network Management BUSINESS CONTINUITY MANAGEMENT(BCM)• Conducting Business Continuity Management (BCM) awareness • Conducting Business Impact Analysis (BIA) to identify critical processes and recov-ery objectives • Conducting Risk Assessment and establishing a corporate risk profile • Establishing Business Continuity Strategy for recovering critical business process-es/activities • Preparation of Business Continuity Plan (BCP) • Conducting test of Business Continuity Plans (BCPs) • Conducting BCM maturity assessment of the organization • Establishing corporate risk profiles Show less

  • Licenses & Certifications

    • Oracle Certified Professional(OCP)

      ORACLE
      Nov 2009
    • Oracle Database 11g Administrator Certified Professional

      Oracle
      Dec 2012
      View certificate certificate
    • Oracle Database 11g Data Warehousing Certified Implementation Specialist

      Oracle
      May 2014
      View certificate certificate
    • Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist

      Oracle
      Jun 2014
      View certificate certificate
    • Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator

      Oracle
      Sept 2015
      View certificate certificate
    • Oracle Database 11g Performance Tuning Certified Expert

      Oracle
      Sept 2015
      View certificate certificate
    • Oracle Certified Associate, Oracle WebLogic Server 11g System Administrator

      Oracle
      Sept 2015
      View certificate certificate