Ntongai Bertrand Mihnkong

Bertrand Ntongai-| - Street 2, Mutengene, South West, Cameroon Professional Summary A Professional Oracle Database Developer with an extensive knowledge and proficiency in database development and analysis; object-oriented programing and business-oriented programing. Enthusiastic professional with excellent critical thinking, project management, problem solving and communication skills. Technical Skills Summary Databases: Oracle 11g, 12c & 19c, Oracle 12 RAC, Microsoft Access, MS SQL Server. Languages: PL/SQL, SQL, Shell Scripting Software: GitHub, Microsoft Word, Access, Excel, Outlook, Visio Operating Systems: Linux, UNIX, Microsoft Windows Work Experience Oracle PL/SQL Developer June 2019 – Present Ministry of Secondary Education, Tiko, Cameroon • Migrated legacy databases and flat files to Oracle database using PL/SQL and SQL. • Improved the performance of queries within stored procedures, functions, and packages by 98% - total execution time drastically reduced from hours to minutes and won accolades from managers. • Provide proactive performance tuning by creating optimal database object designs with excellent reference and data integrity, thanks to my expertise in logical, conceptual, and physical database modelling. • Perform routine SQL queries and PL/SQL code analysis as part of application tuning process. • Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational databases. • Administered database objects, including tables, clusters, indexes, views, sequences, packages, and procedures. • Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers. Infrastructure DeveloperOct 2015– June 2018 Government High School, Tabenken, Cameroon • Wrote PL/SQL codes and bash shell scripts in UNIX to generate trouble tickets when an alert is generated from the database and monitored by the Oracle Enterprise Manager (OEM). • Used excellent PL/SQL skills to create files and perform bash shell scripting for automation within the database. • Collected More detailed information about Oracle database alerts using PL/SQL codes embedded in scripts. • Worked to enhance optimal performance through database tuning. • Developed ER diagrams, schemas, logical to physical database mapping and data table parameters • Designed and implemented data definition language (DDL) and data manipulation language (DML) using SQL within PL/SQL stored program units (Procedures, Functions, Packages, Triggers). • Wrote pseudo codes, flow diagrams for easy interpretation and implementation by Junior Developers. • Setup Incident rules and corrective actions on Oracle database objects. • Administered database objects, including tables, clusters, indexes, views, sequences, packages, and procedures. • Troubleshooted problems regarding the databases, applications and development tools. Education • Bachelor of Science, Information Systems May 2014 University of Bamenda GPA: 3.50/4.00