Data Oracle
Resume:
Suzanne Tchuenkam
adlhb7@r.postjobfree.com
SUMMARY: I have over 7 years working experience as an Oracle Database Administrator. I have completed system development life cycle knowledge including development, test, UAT and Production. Duties include Installation, Production support, project support, Instance configuration, upgrades, patches, migration, cloning, space management, backup and recovery, performance tuning, and database security. I have managed Oracle database administration assignments for diverse industry clients.
Certifications:
Oracle Certified Associate (OCA)
Certified Scrum Master(CSM)
Oracle Cloud Infrastructure 2019 Architect Certified Associate (OCI)
AWS Certified Solutions Architect Associate (SAA)
Certified SAFe 5 Scrum Master (CSSM)
CompTIA Security + certified
Oracle Database 12C certified professional
Azure fundamentals certified
Azure Administrator Associate certified
PROFESSIONAL EXPERIENCE:
USPS – Norman, OK July 2020-Present
Sr. DATABASE ADMINISTRATOR
•Install and configure oracle software from 10g to 18c.
•Migrate dev, test, cat and production databases from 11g RAC one node to 18c 2 node RAC
•Perform identity management and access tasks related to additions, modifications, and deletions to user accounts and access lists of various systems
•Perform database refresh from production to cat environment using datapump
•Perform additional assignments as required by the needs of the company or as directed by management
•Monitored and manage databases using OEM 13 C
•Scheduled my backups and other jobs using OEM 13c
•Review procedures in database management systems for making changes to database.
•Create, unlock delete user account based on the SLA of the company.
•Responsible for setting and managing user management and space management and granting required privileges to users.
•Creating and assigning appropriate roles and privileges to users depending on the user activity.
•Experience with Logical backups EXPDP/IMPDP
•Database maintenance, backups, recovery, patching, upgrades and performance tuning.
•Experience with daily activities, such as monitoring the alert logs, redo log status, monitoring the listener and checking the space for normal segments, rollback segments and tablespaces.
•Creation of database links to access the table data from one local database to remote database using distributed database features.
•Manage database up to 10TB
•Planning of database backups (operating system, full/partial backups, and export/import) using various types of backups and design of an organization’s backup methodologies.
•Production support for a deployment project.
•Good knowledge on all incident, change, problem management process & compliance process
•Provide technical expertise for developing, monitoring, and maintaining multiple databases or applications; diagnose and resolve data management problems and issues.
•Apply database changes and testing for vendor maintenance fixes and new releases, conduct tests, and evaluate database package tools.
•Provide technical support for database applications
•Maintain database management systems in compliance with cyber security requirements
•Monitor performance as well as effectiveness of database applications
•Analyze data in support of system configuration, and cyber security requirements
•Document databases and database management systems
•Responsible for integration, planning, system implementation, system operation, performance management, and customer support for Oracle and SQL technologies.
•Plan and manage overall system configurations to include defining system needs and requirements for both hardware and software.
•Perform database management development, documentation, and maintenance of all software, to include data communications, networking, system administration, and Web products.
•Participate in the deployment, implementation, and maintenance of software.
•Monitor and control the flow of data through a system to ensure data are accurate, timely, and meaningful
Citizens Bank– Johnston, RI July 2019-Present
ORACLE DATABASE ADMINISTRATOR
•Implemented IBM guardian database monitoring.
•IAM administrator (control user access to critical information within the orgnisation).
•Perform identity management and access tasks related to additions, modifications, and deletions to user accounts and access lists of various systems
•Serve as second-tier escalation support from the service desk for access issues
•Perform additional assignments as required by the needs of the company or as directed by management
•Experienced with Oracle Unified Directory (OUD/OID LDAP) for authentication and authorization
•Review procedures in database management systems for making changes to database.
•Create, unlock delete user account based on the SLA of the company.
•Create Generic ID and local user as per user’s request.
•Responsible for setting and managing user management and space management and granting required privileges to users.
•Refreshing Dev and Test instances with data from Production.
•Creating and assigning appropriate roles and privileges to users depending on the user activity.
•Experience with Logical backups EXPDP/IMPDP
•Database maintenance, backups, recovery, patching, upgrades and performance tuning.
•Creation of Oracle Wallets and implementation of Tablespace level TDE security.
•Experience with daily activities, such as monitoring the alert logs, redo log status, monitoring the listener and checking the space for normal segments, rollback segments and tablespaces.
•Creation of database links to access the table data from one local database to remote database using distributed database features.
•Manage database up to 10TB
•Planning of database backups (operating system, full/partial backups, and export/import) using various types of backups and design of an organization’s backup methodologies.
•Production support for a deployment project.
•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.
•Monitor and control the flow of data through a system to ensure data are accurate, timely, and meaningful.
AT&T– Oakton, VA August 2018 – July2019
Oracle Database Administrator
•Applying upgrade, and maintenance patches to all databases.
•Responsible for setting and managing user management and space management and granting required privileges to users.
•Refreshing Dev and Test instances with data from Production.
•Creating and assigning appropriate roles and privileges to users depending on the user activity.
•Experience with Logical backups EXPDP/IMPDP
•Scheduling RMAN backups, purge jobs, Maintenance jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab.
•Created indexes to improved performance
•Database maintenance, backups, recovery, patching, upgrades and performance tuning.
•Setup of unidirectional replication on oracle 11g databases using GoldenGate.
•Creation of Oracle Wallets and implementation of Tablespace level TDE security.
•Performance of logical backups using Export/Import and Data Pump.
•Experience with daily activities, such as monitoring the alert logs, redo log status, monitoring the listener and checking the space for normal segments, rollback segments and tablespaces.
•Creation of database links to access the table data from one local database to remote database using distributed database feature.
•Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
•Monitoring and optimizing the performance of databases through Database Tuning – Tuning Applications, Tuning Instance, and Tuning Disk Usage.
•Planning of database backups (operating system, full/partial backups, and export/import) using various types of backups and design of an organization’s backup methodologies.
•Participate in the deployment, implementation, and maintenance of software.
Cardinal Health – Dublin, OH April 2015 – April 2018
Oracle Database Administrator
Installation of Oracle 11g databases in production, development and test environments depending on project requirements.
Installation and Management of Oracle 12c Grid Control (OEM) for monitoring Production, Active Data Guard (DG Broker), Stage and Dev systems.
24x7 on-call support for 12 databases of 2.0 TB 2 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
Applying upgrade, interim, and maintenance patches to all databases.
Responsible for setting and managing user management and space management and granting required privileges to users.
Creating and assigning appropriate roles and privileges to users depending on the user activity.
Database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.
Set Up notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM.
Monitoring and troubleshooting database issues with OEM Grid Control.
Physical standby using RMAN Active duplication method as well for Disaster recovery site.
Database recovery using GRP (Guarantee Restore Point).
Setup of unidirectional replication on oracle 11g databases using GoldenGate.
Johnson Controls – Atlanta, GA December 2012 – April 2015
Oracle Database Admin
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
Performed troubleshooting of database using AWR and ADDM reports.
Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
SKILLS:
Operating Systems: Linux, Solaris, AIX
Languages/Tools: SQL, PL/SQL, TIRA, GRC, TPAM, SQL Developer, Toad, SQL plus, ITSM, ITSS, ServiceNow
Databases: Oracle (18c,12c, 11g, 10g), SQL Server 2012, familiar with postgres, Oracle exadata, IAM
Training: database administration, Agile, AWS
EDUCATION:
Bachelor of Science in Mathematics - University of Yaounde
Contact this candidate