Database Administrator Oracle

Sylvain Kemtchouang

+1-240-***-**** *******@*****.*** https://www.linkedin.com/in/sylvain-kemtchouang Senior Database Administrator

Senior Database Administrator with over 15 years of experience optimizing large-scale environments on Oracle and AWS/Linux platforms. Expertise includes provisioning, tuning, and managing Oracle databases with RAC, ASM, and automation scripts, alongside extensive experience in capacity planning and backup/restore solutions. Proven track record in enhancing performance and ensuring security in critical systems.

EDUCATION AND TRAINING

National Advanced School of Engineering of Yaoundé, Cameroon Master's degree, Computer Science

Work Experience

Maximus Nov 2017 - Present

Senior Oracle Database Administrator Washington, DC Administered multiple Oracle database environments (production, staging, testing, and development) to ensure high availability and optimal performance, integrating advanced Oracle features (RAC, ASM) and enforcing rigorous security standards aligned with Federal guidelines.

• Installed, configured, and maintained Oracle database servers on Linux environments, leveraging shell scripting automation for backups, patching, and routine maintenance while ensuring robust security compliance.

• Optimized database performance and capacity by proactively upgrading and migrating Oracle systems (including Grid Infrastructure, ASM, and RAC databases) and tuning through regular monitoring with OEM Cloud Control 13c and DBMS tools.

• Resolved critical Oracle database issues including datafile block corruption and executed successful failovers and switchover operations, thereby maintaining system integrity and continuity.

• Provisioned and managed Oracle databases on cloud platforms (AWS and Google Cloud for proof of concept) and on VMs, demonstrating proficiency in cloud operations and supporting hybrid cloud deployments.

• Collaborated with development teams to configure Cloud AWS DMS connections for secure data replication and integration, enhancing application modernization efforts.

• Migrated Oracle 19c RAC Databases with TDE and Data Guard from RHEL 7 to RHEL 9, ensuring seamless transition and improved compatibility on updated Linux platforms.

• Upgraded Oracle Database 12.1 and 12.2 to 19c across various environments and documented the upgrade process, incorporating best practices for database installation and configuration.

• Enhanced data replication and change capture capabilities by upgrading Oracle GoldenGate from 12c to 19c and developing comprehensive upgrade documentation.

• Migrated Sybase 15.0.3 to Oracle 12.2 multitenant using GoldenGate, SQL Developer and SQL*Loader (ELT and ETL).

• Installed, configured and administered GoldenGate replication between SQL Server and Oracle DB

• Executed Oracle RAC database switchover operations and managed replication failover procedures to support distributed database requirements.

• Performed a comprehensive Oracle database upgrade from 11g R2 to 12c R2 multitenant, effectively remapping schemas to PDBs while addressing support fee challenges.

• Configured Transparent Data Encryption across Oracle versions (11g, 12c, and 19c) to safeguard critical data assets.

• Managed large-scale data migrations (e.g., migrating 40 TB from non-partitioned to partitioned tables) to improve database performance and scalability.

• Installed, configured, patched, and maintained Oracle Database RAC (18c and 19c) in R&D settings, ensuring environmental stability and update compliance.

• Developed and implemented automated monitoring scripts for database password expiration, reinforcing security protocols and regulatory adherence.

CTIS, Inc. Jun 2014 - Nov 2017

Database Administrator & Manager Rockville, MD

Directed all Oracle administration functions for Federal Clients, managing production systems maintenance, environment updates, and enforcing stringent database access and security policies.

• Utilized advanced shell scripting techniques on Unix/Linux platforms to enhance automation processes, including performance tuning and quarterly critical patch updates for heightened security and stability.

• Developed and maintained efficient data models and table designs that facilitated accurate data replication, optimized query performance, and supported evolving application data requirements.

• Duplicated and cloned production databases using RMAN and OEM (12c and 13c) and configured standby databases on-premises and AWS Compute to bolster robust backup and restore operations.

• Implemented a comprehensive Disaster Recovery failover strategy to ensure Oracle Server high availability with minimal downtime.

• Orchestrated an Oracle DB upgrade from 11g to 12c, effectively resolving compatibility issues and integrating new features to improve system performance.

• Patched and upgraded Oracle Fusion Middleware (WebLogic, Forms/Reports, OHS) and Oracle Database. CTIS, Inc. Feb 2011 - Jun 2014

Senior Database Developer Rockville, MD

Led the creation and management of relational database objects and provided expert resolution to client incidents, ensuring the integrity and performance of software applications.

• Utilized Oracle Forms and Reports functionalities to develop comprehensive data blocks, triggers, and runtime alerts, thereby facilitating efficient data capture and reporting.

• Coordinated a critical data migration project from AdEERS to CTEP-AERS, ensuring FDA compliance and smooth transition with immediate reporting capabilities.

• Delivered the project ahead of schedule, contributing to CTEP-AERS receiving the 2014 NIH Group Merit Award for excellence in database solutions.

IGMA Jul 2008 - Feb 2011

Freelance Database-Web Developer / DB Admin Douala, Cameroon Designed and installed robust database systems to support client operations, ensuring high-level security, controlled access, and effective permission management for database objects.

• Configured a redundant database setup with automated backup and recovery processes to maintain availability during emergencies and cyber-attack scenarios.

• Developed an enterprise-grade payroll system with advanced functionality that reduced processing time from several days to a single day, demonstrating strong database design and business process optimization. TECHNICAL PROFICIENCIES

• Administration: Oracle Database Administrator (7 to 23ai), Oracle RAC Administrator (11g to 21c), Oracle on VMs, Performance Tuning, Oracle ASM

• Backup: Export, DataPump, RMAN, Database Backup, Restore

• Integration: Oracle Forms (4.5/5/6i/9i/10g/11g/12c), Oracle GoldenGate 11g to 23ai, Oracle SQL Loader, OEM

• Cloud Ops: Oracle Cloud Infrastructure, AWS, Google Cloud Platform, Cloud Database Administrator, Cloud Architect, AWS Migrations, Scripting Language, DevOps Familiarity, SDLC, CI/CD

• RDMS: Oracle Database (7 to 23ai [classic and multitenant]), Oracle Data Guard (classic and multitenant), PostgreSQL, MySQL, Oracle SQL Developer, Quest TOAD, SQL/PLSQL

• Op Systems: Oracle Enterprise Linux 6/7/8/9, RedHat Linux 6/7/8/9, Windows

• Core Competencies: Analytical Skills, Technical Skills, Ownership Certification

• Oracle Cloud Infrastructure 2025 Certified Multicloud Architect Professional

• Google Cloud Platform Professional Cloud Architect

• AWS Certified Cloud Practitioner

• CompTia Security+CE

• IBM Artificial Intelligence Fundamentals

• Oracle Database 12c Administrator Certified Professionals (OCP)

• Oracle Autonomous Database Cloud 2019 Certified Specialist (OCS)

• Oracle Forms/Reports Developer Certified Professional (OCP)

• Oracle Certified PL\SQL Developer Associate (OCA)

• Certified Scrum Master (CSM)

Contact this candidate