KEVINE CHOUAKO

• Installation, Configuration and Administration of Oracle 11g, 12c, 18 and 19c Databases
• Migrated standalone databases to 4-node RAC Cluster
• Worked as an administrator on PostgreSQL where I had extensive performance tuning at all levels
• Performed backup and recovery on PostgreSQL and done critical restore from backups
• Migration single Instance Databases to 4 Node RAC environments
• administers MySQL Server data systems and structures.
• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Managed databases via TOAD, SQL Developer and 13c
• Cloud control
• Implementation of High Availability solutions with
• Oracle 12c,18c and 19c on RAC and Data Guard
• Implemented ASM on RAC and stand-alone databases
• Managing disks and disk groups with ASM
• Applied PSU and one-off patches
• Refresh databases using RMAN, Export Import and Data
• Pump utilities
• Creating and dropping of users, granting, and revoking permissions to users/roles as and when required
• Involved in installation and configuration of Golden Gate for real time data replication
• 24/7 Production database administration support
• Worked on Data center migration
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Analyze and tuned long running jobs by working closely with the application teams to analyze objects, rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF and Explain Plan
• Clone databases using RMAN Duplicated
• Troubleshoot performance related issues
• Restore and recovered databases
• Resolved gaps in Oracle Data Guard
• Automating the daily routine activities and schedule maintenance jobs by creating / developing UNIX shell scripts and Oracle scheduler jobs
• Worked with storage admins to get disk space for Oracle
• ASM Disk groups
• Worked with Oracle support in resolving issues
• Working on upgrading database from 12c to 18c to 19c
• Used Data Pump to refreshed database objects
• Written scripts to automate repeating tasks
• Worked on snapshot standby databases
• Setup threshold in 13c cloud control for alerts
• Generated ASH, AWR, ADDM reports and worked with app teams on performance
• Partition tables.
• Employed vast knowledge of relational database concepts and PL/SQL coding to produce highly efficient data systems.
• Debugged systems and fixed program malfunctions quickly.
• Scheduled and tested system-wide upgrades to keep databases evolving with company needs.
• Used Unix and Windows operating systems to complete assigned tasks and create unique data solutions.
• Developed applications and designed processes for transformation and data management from company-wide databases.
• Generated reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse.

• Responsible for administration and supporting oracle 12c,11g databases
• Configured Alerts using 12c/13c Cloud Control
• Installing ASM environment and migrating database from
• NON-ASM to ASM
• Configure and manage tablespaces, tables, and users for custom applications
• Developed views, materialized views, functions, procedures, triggers, packages using DDL DML, PL/SQL, and SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting, and revoking permissions to users/roles as and when required
• Experience in supporting databases under all flavors of
• UNIX (Sun Solaris, HP UX Red Hat)
• Created users, roles and granted privileges per the business requirements
• Skilled with statspack, AWR, ADDM, SAR to check performance of database & hardware
• Restored and Recovered SQL Server Databases
• Performed database cloning to setup test and development database
• Migrated databases to different data datacenter
• Handled RAC Node hangs and node eviction issues
• Maintaining schemas and partitioning tables
• Worked on DB Monitoring scripts
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both
• RAC and standalone instances
• Created, upgraded, and cloned Oracle databases for
• Development and testing databases
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Worked in Tuning OS, Shared Pool, Buffer Cache, and
• Performed large batch jobs and tuning of SQL queries and database systems
• Created indexes to facilitate easy user interface implementation and tuning
• Automatic Database Diagnostic monitor
• Data Modeling, Database Design and creation using Erwin
• Operating systems on clustered / shared HP-UX UNIX,
• Linux, and Windows servers
• Database performance monitoring, Application performance monitoring, tuning database, and application with efficient database parameters
• Automated the replication process using materialized views for reporting databases
• Plan and acquire the new technologies and implementation, suitable for the applications regarding the specific future requirements of the company's business projections and growth.
• Established working relationships across various departments to understand existing and emerging IT requirements.

• Good knowledge on all incident, change, problem management process & compliance process

• Assist with database management development, documentation, and maintenance of all software, to include data communications, networking, system administration, and Web products.

• Design or implement Oracle projects such as packages, tables, procedures, views, and triggers.