| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Oracle Database Administrator
Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLE
Certifications: Oracle Database Administration Street Address c Certified, Oracle Database 12c Administration Certified Associate, Oracle 12c SQL Fundamentals, Oracle Autonomous Database 2019 Certified Specialist, Oracle Cloud Infrastructure 2019 Architect Associate
Overview:I have over 7 years experience as an Oracle Database Administrator. This experience includes extensive knowledge and proficiency in Oracle Database (DB1 & DB2) 23c, 21c, 19c, 18c, 12c, 11g with platforms like LINUX (red hat), Z Linuz on IBM, UNIX, Windows and AIX. I Specialized in Database UPGRADES/Installations, OEM 13.4, PATCHING, EBS (E-Business suite 12.1, 12.2.9) applications (ERP, Financial, Procurement, supply chain Business Modules, SCRIPTING (Unix/Linux shell scripting), SQL/PlSql, PERFORMANCE TUNING AND QUERRY OPTIMIZATION, CLONING/REFRESHES, BACKUP AND RECOVERY(RMAN)/COMMVAULT Apps, SECURITY AND AUDITING, MULTITENANT DATABASES, RAC/DATA GUARD, MIGRATIONS, AUTOMATION, PRIMAVERA P6, GOLDEN GATE etc. I educate myself as new oracle versions are released and take up related exams to stay current with technologies. Including all aspects of implementations, automations, upgrades, project planning and team management. I am a proactive team player who is fast at picking up new technology and thriving in a fast-paced environment.
COMPETENCIES Patience, meticulous attention to detail, a logical approach to work, ability to prioritize tasks, problem solving skills, good organization skills as well as great communication skills. Installations, upgrades (DBUA/Go Live), migrations (data pump), configuring logical/physical architecture on DB1 and DB2 databases. Performance tuning and query optimizations (improved performance by 80%). Back-up/recovery methodologies (native & third party). Reduced backup time from 8 hours to 45 mins by BCT. 24/7 Support for all database systems including Multitenant DBs, Physical and Logical database, RAC, DB1, DB2 etc OEM 13.4/Agents and all aspects of upgrades, configurations, monitoring, and tuning. Patching and database updates (OPatch utilities).
Implement Transparent Data Encryption (TDE) for Security, many other DB security implementations and measures. Planning & implementing Disaster Recovery. PLSQL/PostgreSQL for developing databases and applications, running administrative tasks, and creating integral environments. Design, implementations, and automatic storage management (ASM) Data warehouse (SSAS) setup, install, security & deployment. Multitenant databases (CDB & PDB) maintenance, management. RAC (real application cluster) methodologies and implementations. Use Primavera for project/opportunity/resource management, risk analysis, collaboration, and control capabilities etc. Golden Gate replication and maintenance by extract processes/extract pump.Skills/Tools: Oracle 23c, 21c, 19c, 18c, 12c, 11g, AIX V6.1, UNIX SHELL/BASH SCRIPTING, LINUX RHEL 7.2, IBM Linux system Z, PLSQL, SQL* Plus/SQL*Loader/Net, OEM 13.4, TOAD, SQL DEVELOPER, DATA PUMP (expdp/impdp), MPUTTY, SECRET SERVER, KEEPASS, COMMVAULT, SecureCRT. Programming languages: Visual Basic, JavaScript, and knowledge on .NetWork Experience:Oracle Company Inc. Austin Texas (Remote)Principal SR Technical Support Engineer May 2023 - PresentResponsibilities.
Installed and configured Oracle databases (versions 12c, 19c, 21c or relevant versions) on different platforms (Linux, Z Linux, AIX, Windows, Unix).Performed Oracle RAC, Multitenant DBs (CDB/PDB) and ASM setup for high availability and scalability.Installed Oracle Data Guard for disaster recovery and high availability configurations.Managed multiple Oracle databases across production, development, and testing environments.Provided 24/7 support for mission-critical Oracle databases, ensuring high availability and performance.Performed routine database administration tasks like backups, recoveries, performance tuning, patch management, and cloning databases.Experience with Oracle Enterprise Manager (OEM) for centralized monitoring and management of databases.Optimized database performance by analyzing AWR (Automatic Workload Repository) reports, ADDM (Automatic Database Diagnostic Monitor), and SQL execution plans.Tuned SQL queries to improve response times and reduce resource consumption.Monitored database performance using Oracle Grid Control and made necessary adjustments to improve performance and system efficiency.Experience with memory tuning, I/O optimization, and tuning SGA, PGA for large databases.Implemented robust backup and recovery strategies using RMAN (Recovery Manager) and CommVault to ensure data safety and availability.Performed point-in-time recoveries and flashback technology to recover from logical errors or data corruption.Conducted regular backups, ensured recovery testing, and validated backup policies.Managed user accounts, roles, and privileges to ensure data security and compliance with corporate standards.Implemented Oracle Transparent Data Encryption (TDE) and Database Vault to protect sensitive data.Performed database auditing and monitoring for unauthorized access attempts.Applied security patches and monitored Oracle Critical Patch Updates (CPU) to safeguard against vulnerabilities.Configured Oracle Data Guard for creating standby databases and managed switchover and failover scenarios.Used Oracle Real Application Clusters (RAC) for high availability and scalability in clustered environments.Set up Oracle Goldengate for real-time data replication and synchronization across multiple environments.Performed database upgrades and migrations from legacy systems (e.g., Oracle 12g to 19c and 19c to 21/23c) without downtime, ensuring data integrity.Utilized Data Pump for large data transfers, schema, and database migrations.Implemented zero-downtime upgrades with rolling upgrade techniques.Developed and maintained automated scripts for database maintenance tasks (backups, monitoring, alerting).Used Oracle PL/SQL for scripting administrative tasks and developing stored procedures, functions, and triggers.Automated routine jobs with Oracle Scheduler and Crontab for efficient task management.Worked closely with application developers to optimize database designs and enhance application performance.Provided database support for software development, QA teams during SDLC.Assisted in writing efficient queries and optimized SQL for better integration with the database.Documented database configurations, upgrade processes, recovery procedures, and performance tuning activities.Generated reports on database health, usage statistics, and storage requirements to ensure proper capacity planning.Donaldson Company Inc. Bloomington, Minnesota
Sr Oracle Database Administrator June 2020 May 2023Responsibilities.
Succeeded in installation, configuration, and monitoring of 23c, 21c, 19c, 18c, 12c oracle databases including EBS R12.1 and R12.2 application servers (front end and backend) in AIX, LINUX, Linuz Z, UNIX, WINDOWS, and day to day support (24/7 PROD/NON-Prod environments) for business continuity.Expertise in Oracle database and application server performance tuning, troubleshooting and query optimization using different tools like OEM, SQL developer, toad etc.Successfully Upgraded Oracle Enterprise Manager Cloud control and AGENTS from 13.2 to release 13.4 along with the grid infrastructure and oracle databases from 12c to 19c for both stand alone and RAC databases. Configuring databases and applications servers for monitoring withing OEM cloud console.Proficient/expertise in applying oracle database patches (OPATCH) in standalone and RAC as well as application patches ADPATCH and ADOP life cycles in 12.1 and 12.2 respectively, as well as WEBLOGIC server patches.I have knowledge and experience in AZURE cloud administering and working on Database, networking, storage, compute, analytics, AI and machine learning using development tools and Devops.Achieved successful database migrations using oracle server utilities like data pump (impdp and expdp), and OEM. Database Cloning & Refreshes from Production to Test Envs.Proficient in carrying backup and recovery strategies like Incremental and differential backups using COMMVAULT OR RMAN and other utilities following SLAs.Support application developers/data analyst in planning preparation, load analysis and backup and recovery of data, Deploying PLSQL scripts/codes to perform data updates/changes using SQL developer, toad, or SQL plus.Excellent communication skills, exceptional ability to interact with users and all levels of management, incident management + change management (planning & execution).TOPBUILD COOPERATION Daytona Beach, Florida
Oracle Database Administrator January 2020 June 2020Responsibilities.Installation and configuration of oracle software for 12c, 18c and 19c on both Windows, Linux, AIX & UNIX platforms using Oracle, DBCA, DBUA
Successfully completed database migration/upgrade from 11g to 12c and to 19c using the Oracle Data pump & DBUA respectively.Improved Performance of queries by 80% - execution time drastically reduced from 1 minute to seconds using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports, ADDM and explain plan, maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics, and won accolades from managers and executives (Database sizes range 100GB to 22TB)
Worked with Development, Production teams and Oracle support to facilitate problem resolution and support strategic EBS initiatives.Revised & implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Applied block change tracking (BCT) which reduced the backup time from 8hrs down to 45mins.Carried out day to day administration (backup, restore, recovery, troubleshooting), automate business processes and application systems resulting in lower risk high saving long term results with closed lope system.Installed and administered Oracle Physical Standby Database for single & multiple instances to achieve high availability & DR solution (DATA GUARD)
Partnered in the installation and configuration of 11g Real Application Clusters (RAC) / ASM on Red hat Enterprise Linux 7.3
Capacity planning to meet the demands of the dynamic aspects of storage and ASM for the databases.
Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using OPatch utility to install, test, and deploy patches to all database instances.Revised Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption/Guardian to encrypt columns, tables, and Tablespaces. I also implemented the triple A (AAA) and database auditing policies as well as data reduction.Designed and implemented the ETL utilizing PL/SQL and Talend Administration SuiteExperience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.
24x7 remote and on-call Database support for Database developers & end-users.HONEYWELL Minneapolis, MinnesotaOracle Database Administrator July 2017 December 2019Responsibilities.Successfully migrated data from Oracle 11g (10.2.0.4) to Oracle 12c databases using RMAN tools and OEM.Cloning databases of Oracle E-Business Suite 12.1.3 from production environment to Test. Worked as a part of a team in Data Center Migration for four months. Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.Worked with applications, technical support and operations team in the golden gate design, development, and implementation of service request. Assisted with several enhancements, development, management, and organization of golden gate replication.Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security-related tasks including Transparent Data Encryption.Expert in working with PL/SQL including Procedures, Functions, Cursors, and Triggers.Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using OPatch utility to install, test, and deploy patches to all database instances.Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecturePerformed database administration tasks including scheduling backup, verifying night backups and recovery through RMAN. |
