| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: Sylvani Merlin TsaguePhone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLECertificationsORACLE CERTIFIED Street Address c.Oracle Autonomous Database Cloud Street Address Specialist .Oracle Cloud Infrastructure 2019 Architect Associate.AWS Certified Solution Architect.CompTIA Security + SYO-501 certificationProfessional SkillsI have over ten years of experience in Oracle Database Administration. I have supported database on versions 10g, 11g and 12c running on Linux, Windows, Solaris and AIX operating systems. Areas of expertise include Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Goldengate.Strong experience in Oracle database administration in heterogeneous system environment including solaris, unix and windows, supporting a variety of critical applications running on Oracle 10g, 11g, 12c and 18c.Replication of data using Oracle Golden gate and configure uni-directional, Active-Active replication and Performed Golden gate monitoring, tuning and capacity planning.Performing complete and incomplete recovery during disasters, failures and user errors.Creating and managing database object such as tables, indexes, partition tables and views.Refreshing of databases using Data Pump Export and Import utilities (expdp/impdp).Implemented backup/recover strategies using hot backup, cold backups using RMAN and Export/Import utilities and Wrote Shell Scripting for managing day-to-day activities and automation of backup.Data Guard administration and maintenance.Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.Installed and configured oracle Grid control (12cR1 and 11gR2) .Worked on Upgrade/Migration of Databases from Oracle 11gR2 to 12cR1.Scheduling the databases backup using Crontab and net backup.Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through RolesCloning of production databases as needed for testing, development using RMAN or scripts.Exposure in creation on an Oracle 12c Multi-tenant RAC data base with 2 node cluster and instances using ASM storage.Experienced to take backup on Oracle RAC database by using RMAN utility in a CDB (Multi-tenant) environment.Experienced on performing health checks in Oracle RAC & monitoring Oracle Instance.Identified and resolved performance issues caused by table fragmentation using segment Advisors.Creation of Users and granting them the required Roles and Privileges accordingly.Migration from Oracle 12c on premise to AWS RDS using AWS Schema conversion tool and AWS Data Migration Services.Installed the application on AWS EC2 instances and configured the storage on S3 buckets.Worked on installing and configuring Active Dataguard for AWS instances.Experience with SQL Server 2014+ (Plus)T-SQL and PL/SQL programming experienceStrong written and verbal communication skillsExcellent documentation and organizational skills.Work ExperienceOracle Database AdministratorEXELON Baltimore, MD FEB 2021- JUNE 2024-Oracle software installations and deploy binaries across servers-Database upgrade from 12c to 19c on single instances and real application cluster environments.-Implement backups strategies for middle size and bigger size database with DDboost appliance and implement point in time restore.-Ensuring pre-upgrade perquisites are met in for successfully migration.-Ensuring target availability with OEM notifications.-Monitoring metrics alerts, operating system mount points and Tablespace threshold.-Exposure to ZDRLA appliances for database backups, current and point in time restoration.-Database migration hosting high business values applications.-Point of contact for Oracle related issues and covering on call rotations.-Ability to clone or refresh development or test databases from production.-Develop and document standards, procedures, and work instructions that increase productivity for operations.-Perform necessary security patch implementations to ensure ongoing database security.-Experience with Oracle database in Oracle Cloud.-DB system management on OCI console and DBAAS command line.-GoldenGate exposure.-kornshell scripting-Expertly installed and configured Oracle E-Business Suite (R12) across multiple environments.-Experience working on Multi-tenancy database architecture (CDB & PDB) environment and understanding or mutiltenant architecture feature such as remote and local pdb clone, plug and unplug PDB to a different CDB or convert CDB into PDB.-Managed Oracle EBS databases, ensuring high availability, performance, and security.-Used Oracle Internal Directory or Directory manager for LDAP management.-Oracle Client Installation on Database and app server.-Support 100+TB databases.- Solid working level knowledge: RAC, Exadata, ASM, Grid Infrastructure, RMAN, working in a Unix shell, Oracle Enterprise Manager, Oracle database compliance framework, vi editor, working with Oracle Databases on Unix (Solaris) and RedHat/Oracle Linux.-Analyzed and mitigated the performance impact of SSL/TLS encryption on database connections.-Guide and plan implementation & configuration of Database software related services to support business requirements (OLTP, decision support, standby DB, replication) while keeping database security regulations, policies, and best practices in mind.-Database administration responsibilities include installation, upgrades and optimization, access control administration, backup/recovery, disaster recovery support, development and test environment support, documentation, recommend infrastructure and methodologies improvements.Oracle Database AdministratorGranite Telecommunications Quincy, MA January 2020 DEC 2020. Convert a single instance on Asm to Rac Database.. Setup Recovery catalog database. Monitoring Targets availability, setting up Metrics alert on OEM.. Setup Golden gate 19c in the heterogeneous environment from oracle 12.2 to SQL server.. Ensured security by implementing data masking on OEM.. Verifying replication impact on DML and DDL changes from Oracle to Sql Server with Visual studio.. Troubleshooting Golden gate, process abended.. Adding host and OEM and ensuring agent deployment on the target. Installing and upgrading SQL Server, Oracle, MySQL and related application tools Perform backup and restoration of databases Monitor space, availability, and performance Maintain Oracle and SQL Server system security Work closely with development team to optimize queries and processes Implement and maintenance replication and data integration in a heterogeneous environment Maintain documentation related to the database configuration, data flow, replication, data transformation and architecture Forecast storage and resource requirements for the database systems Automate day to day tasks Refresh user acceptance testing (UAT), development, and other environments when necessary. Conducted performance tuning and optimization of Oracle EBS environments.. Supported databases that were migrated to Exadata machine. Used the write-back cache to leverage the Exadata flash hardware. Created the new 12.1.0.2 Exadata based database and migrated our databases supporting both OLTP and OLAP workload to a new X5 database machine. Exported the source system metadata using the Transportable tablespace.. Moved stand-alone databases and rac databases to the Exadata X-5 database machine.. Upgraded our X5 Database Machine half rack to a full rackAdding more cpu, memory and hardware to cater to our growing environment. Evaluate SQL server/Oracle features and related products Present ideas or thoughts that would benefit Granite Telecommunications Work as part of a team and provide 7x24 support when required. Performed database migration from linux on premise server to Oracle cloud InfrastructureCITIZENS BANK - Providence, RI July 2017 November 2019Database Administrator. Support Oracle & MSSQL databases including security patching for RAC & Always on Availability groups.. Previous experience with common support tasks such as connectivity or performance problems. Storage responsibilities will include the support of Enterprise NAS/SAN storage infrastructure that requires 24x7 uptime Review/approve application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, reliability upon deployment. Co-ordinate database administration functions for development, test and production environments Investigate and resolve technical database issues. Participate in rotational 24x7 On-Call Support and assist/lead Root Cause Analysis reviews when applicable. Define logical attributes and data inter-relationships and design data structures to accommodate database implementation, storage, maintenance and accessibility to enhance performance. Good understanding of NAS storage operations, commands such as snapshot creation, restoration and be able to perform more advanced storage operations with guidance such as provisioning a new volume.Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)Experience working on POC of 12c new features like multiple indexes,on single column, Restore table through RMAN.Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.Supporting Multi node 11g RAC and Data Guard environment for HA,Troubleshooting errors using Clusterware logs.Involved in upgradation of databases from 11.2.0.4 to 12C in QA and DEV environments.Implemented ASM on RAC and standalone databases and managing disks and disk groups.Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.Experience in handling Multi-Terabyte Database migrations/Consolidations with minimum/no downtime.Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, Patch sets as per the Oracle recommendations.Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.Apply the oracle security patches (CPU patch / PSU patch) on standalone database, Oracle RAC and clusterware (oracle 11g - Grid Infrastructure).Automating tasks using cron for Goldengate restart.Successfully executed upgrades and migrations of Oracle EBS environments.Responsible to monitor database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control 11g/12c, generated reports as needed.Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.Monitoring and troubleshooting database issues with OEM grid control.Performed proactive and reactive tuning/managing database space utilization and growthImplementing Oracle ASM and resolving ASM related issuesDetailed analysis of the business and users requirements by doing various information gathering techniques.Managed application of critical patches and updates to Oracle EBSPerformed DBA activities using ADG in AWS are rolling upgrades and first patching on standby using physical standby.Working on taking incremental backups on ADG and load balancing, service management across the replicated databases.MOTOROLA - Sunnyvale, CA Mar 2013 Jun 2017 Oracle Database AdministratorSupporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.Refreshing Dev and Test instances with data from Production on a regular basis.Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.Thorough knowledge in setting up infrastructure for databases in huge datacenters.Installed Oracle 11g on Linux platform using ASM.RMAN point in time recovery and Instance recovery done on 11g.Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.Database monitoring/maintenance, replication process and performance tuning done using OEM (Oracle Enterprise Manager).Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.Participated in security audits and implemented recommendations for enhancing SSL/TLS configurations.Performed Data refresh activities using the export data pump utility.Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.Good hands-on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.Refreshed/cloned databases using RMAN utility.Managed user identities and access rights within Oracle IAM.Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on UNIX platform.Defined and enforced security policies using Oracle IAM.Involved in converting a single instance database to Oracle 11g, 10g RAC databases.Installation, Configuration and Troubleshooting of the GoldenGate 11g and 12c software.Lag monitoring, Handling Conflict detection and resolution in unidirectional and bidirectional GoldenGate topology.Hands on experience in Amazon RDS Aurora performance tuning.Deployed Oracle Rac on AWS-on-AWS DC2 by using API calls and commands using AWS CLI.EducationUniversity of Douala.Bachelors degree in Computer Science. |
