Oracle Database Dba
Resume:
Asim Sr. Oracle DBA
****.********@*****.***
US Citzien
SUMMARY:
•10 years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions
•Proficient in maintaining oracle 19c,18c and 12c
•Proficient in oracle dictionary and oracle dynamic views.
•Managed and administered databases from command line and 12c/13c OEM
•Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance
•Tuning of oracle databases on UNIX, LINUX and Windows environments
•Upgrade databases to 11g to 12c to 18c and 19c
•Installed 18c database on OEL
•Build configured and managed multi node RAC Cluster on RHEL.
•Experience with setting up and managing standby database using Data Guard
•Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
•Tune queries using SQL Plan, SQL profiler, Baseline etc.
•Build RAC Clusters from scratch including deployment of Linux operating system.
•Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL Navigator, and SQL* Loader, Data Pump
•Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
•Experience in datacenter migration.
•Supporting development 24/7 production systems. Providing on call support for mission critical applications.
•Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
•Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
•Proficient in writing UNIX Shell scripts to automate business process and daily backup.
•Vast Experience with RMAN to implement Backup/Recovery strategies
•Clone databases using RMAN Duplicate.
•Implemented data replication through materialized views.
•Refresh database objects using Data Pump
•Good experience in SQL, PL/SQL, Shell Scripting
•Experience in Data Modeling using Data modeling tools such as Erwin and Toad.
•Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices
•Worked on SQL Server 2008 and 2012
•Experience with installing and maintaining Oracle 13c Cloud Control
•Build and managed ASM Disks and Disk groups
•Migrated non-ASM database to ASM.
•Experienced in RAID, storage technologies and backup solutions
•Supported the system 24x7. Ability to work beyond regular hours.
EXPERIENCE:
Company : GE Health Care
Location : Lombard,IL
Role : Oracle DBA
Period : Nov 2024 to present
•Proficient in maintaining 12c and 19c databases.
•Proficient in writing UNIX Shell scripts to automate business processes and daily backup.
•Managed databases on the AWS cloud.
•Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation, and different type of storage structure (SAN/NAS). Created and managed PL/SQL procedures to perform complex database operations and business logic.
•Defined and handled input and output parameters in PL/SQL procedures to interact with applications and other database objects.
•Migrated databases from Oracle Versions from 12c to 18c and 19c
•Worked on Incidents relating to GOLDEN GATE lag detection, replicate reports, abended status, ggserr.log
•Worked on OEM, DB console, Grid Control, and Cloud Control
•Coordinated with teams to ensure compliant changes.
•Performed periodic patches and updates for both DOMU and system patches.
•Build Database homes and databases using Cloud Plane.
•Worked on Oracle Materialize Views, Oracle Golden Gate, and Oracle Active Data Guard.
•Worked with Oracle Super Clusters and managed them with proficiency.
•Proficient in using tools such as celcli and dcli in Exadata.
•Build and managed RAC databases on Exadata
•Performed silent installation of databases on Exadata
•Working on supporting both OLTP and Data Warehouse environments
•Performed work with EDB Postgres Advanced Server
•Configuration, troubleshooting Golden Gate issues.
•Designed application framework and developed Oracle APEX Application.
•Provided support in cloning databases.
•Expertise in writing SQL from Oracle Dictionaries.
•Worked on Active Data Guard Configuration in multiple Data Centers.
•Developed 10 PL/SQL Packages from the scratch for monitoring purposes.
•Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries, and providing support to developers.
•Used data pump, RMAN duplicate database, and export/import for data moment.
•Set up 12C and 13C OEM for alerts and thresholds.
•Involved in 24x7 support for production RAC databases with on-call pager
•overall Exadata hardware maintenance
•Assisted in management and database administration of Oracle databases on Exadata platforms
•Supported production, development and testing databases of Multi Terabytes DB sizes.
•Installation of 11g, 12c clients/databases on Solaris and Linux.
•Complete Build of 4-node 11g and 12c RAC Cluster on RHEL 4 from scratch.
•Migrated 10g database to 11g R2 to 12c.
•Build and administer SQL Server 2008, 2012 standalone and cluster databases.
•Skilled with Statspack, AWR, ADDM, SAR, ADRCI to check health of database & hardware.
•Used Performance tuning tools such as Tkprof, explain plans, oradebug and trace files to tune SQL Queries.
•Performed database cloning to setup test and development database.
•Migrated databases to different data datacenter.
•Data Guard build.
•Build GoldenGate on ACFS and DBFS
•Kept clear records of JTF and CAB activities.
•Handled RAC Node hangs and node eviction issues.
•Maintaining schemas and partitioning tables.
•Led database migration projects involving 20TB of data, ensuring smooth transitions with minimal disruption.
•Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
•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 Redo Log Buffer.
•Provided System support for both development and 24*7 production environments.
•Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
•Performed automated backups and scheduling using scripting.
•Responsible for migration of databases.
•Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
•Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
•Involved in designing logical and physical data models using Erwin.
•Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health
•Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
•Created indexes to facilitate easy user interface implementation and tuning.
•Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM),
•Automatic Workload Repository (AWR) for monitoring database performance.
•Tested database performance issues (monitoring and tuning) to ensure database optimization.
•Full fill developers request to refresh schemas on a daily basis.
•Resolved DB performance issues.
•Worked as primary on-call DBA.
•Used TOAD for various database Administration tasks.
•Used SQL*Loader to move data from flat files into an Oracle database.
•Used SRVCTL utility for managing multiple instances and nodes.
•Worked with Real Application Cluster (RAC) databases.
•Applied various patches which includes quarterly critical patch.
•Upgraded oracle clients as per application needs.
•Applied DST patches on multiple platforms.
Company : Oracle Database Administrator at Wipro, Client Citi
Location : Irving, TX
Role : L2 DBA Global Prod Support Team,
Period : Sep 2020 – Oct 2024
•Backup & Recovery Maintenance, Database Performance Tunning.
•Good working knowledge of SQL,PL/SQL, and shell scripting.
•Maintaining Oracle RDBMS on UNIX, Linux platforms
•Manage Database on RAC and ASM
•Managed Database on Cloud support on DST
•Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary
Segments.
•Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tunning and korn shells, Unix Scripting.
•Configure, maintain and deploy the Data Guard and grid control.
•Maintained RAC cluster on both ASM and non-ASM file management
•Raised SR with Oracle Support.
•Managed and maintained product data, including CAD files, documents, and metadata
•Used Oracle Enterprise Manager (OEM) for administering several databases
•Used Oracle Enterprise Manager (OEM) for Metric alert Monitoring
•Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
•Restore and Recovery of database in case of databases crash, disk/media failure.
•Worked on Incidents relating to GOLDEN GATE lag detection, replicate reports, abended status, ggserr.log
•Working knowledge on UNIX administration on AIX server.
•Performed automated backups and scheduling using scripting.
•Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
•Demonstrated in-depth expertise in Oracle SQL and PL/SQL, focusing on performance optimization and efficient query execution.
•Performed administrative maintenance, monitoring on Oracle database systems in a global environment
•Involved in gathering requirements from end users.
•Security User Management, Privileges, Role, Auditing, Profiling, Authentication
•Extracted data from Oracle database into XML, HTML format for Application requirement.
•Implemented and managed Teamcenter workflows and business processes
•Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
•Index management for better performance, maintenance of Oracle Database
•Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
•Handled RAC NODE hangs and node eviction issues.
•Supported production, development and testing database of Multi Terabytes DB sizes.
•Provided 24x7 operational support.
•(BAU) Production Management.
•Proficient in Oracle Real Application Clusters (RAC) and GoldenGate, ensuring high availability and data replication across multiple environments.
•Managed user issue by joining bridge, Avaya, chats, and Emails.
•Daily Support on Incident Management using Service Now
•Performing on analytical analysis to give out RCA
•Communicating with team relating to shift hand over, follow-up points, SR, RCA, Outages.
•Utilized Teamcenter workflow capabilities, including workflow design, execution, and monitoring
•Following with in policies on daily Auditing compliances like ISAW, Justify.
•Shift assignee reports. Those reports consist of Autosys failed, on ice, dg, pilot report.
Company : Wells Fargo
Location : Chicago, IL
Role : Oracle DBA
Period : Jan 2018 – Aug 2020
•Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
•Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
•Have a good knowledge in Exadata.
•Experienced in ORACLE 11gzad12c installation, configuration, and upgrading.
•Experience with rolling upgrade to Oracle 12c RAC.
•Installation, Configuration, Upgrading, Migration and Maintenance.
•Configure, maintain and deploy the Data Guard and grid control.
•Installing and maintaining Oracle GRID CONTROL
•Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
•Specialized in SQL Tuning and Database Optimization for critical application areas such as schema design, data models, and best practices.
•Worked extensively on Oracle Streams.
•Troubleshoot OCFS2 install issues and working with Enterprise Manager.
•Design and implement Auditing and other security features for the existing Production systems.
•Raised SR and TAR with Oracle Support.
•Used Oracle Enterprise Manager (OEM) for administering several databases
•Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
•Restore and Recovery of database in case of database crash, disk/media failure.
•Applying patches and works closely with Oracle to make Application environment up to date.
•Backups & Recovery Maintenance, Databases Performance Tuning.
•Typically involved in database Designing, creation and maintenance.
•Good working knowledge of SQL, PL/SQL, and shell scripting.
•Created users and grant privileges according to the requirements.
•Working knowledge on UNIX administration on AIX server.
•Provided System support for both development and 24*7 production environments.
•Performed automated backups and scheduling using scripting.
•Responsible for migration of databases.
•Involved in designing logical and physical data models using Erwin.
•Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
•Performed administrative maintenance, monitoring on Oracle database systems in a global
•Provided expert guidance in setting up and maintaining Oracle RAC environments for high availability and disaster recovery solutions.
•Provided 24x7 operational support.
•Involved in gathering requirements from end users.
•Migrated database from 9i to 10g and 11g supporting various incremental releases
•Planned version control of production source code using Clear case.
•Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
•Security User Management, Privileges, Role, Auditing, Profiling, Authentication
•Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
•Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches.
Company: Sentry Data
Location: Madison, Wisconsin
Role: Oracle Database Admin
Timeline: May 2013 - Dec 2017
•Installation, configuration and troubleshooting of Oracle Database 10g and 11g on RHEL.
•Build ASM Disk Groups.
•Migrated database from non-ASM to ASM.
•Upgrading database from Oracle version 10g to 11g
•Setup Disaster Recovery site using Oracle Data Guard.
•Managed Database on RAC and ASM
•Worked on backup, recovery and disaster recovery strategy using RMAN.
•Involved in upgrading data warehouse database version from 10g to 11g.
•Monitored Oracle databases using Oracle Enterprise Grid Control.
•Extracted data from Oracle database into XML format for EDI requirement.
•Worked on logical backup using export/import and Data Pump.
•Implemented Oracle Failsafe to setup RAC environment on windows platform.
•Responsible for completing Database Refresh requests on both Oracle and SQL Server databases.
•Involved in User Management, creating new user ids, assigning them roles and privileges, monitoring their activity.
•Working with the automated DMA patching process which includes identifying, staging Patch Binaries, applying and rollback Patches.
•Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
•Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL, SQL performance tuning and korn shells, Unix shell Scripting.
•Managing Instances redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
•Configured and maintained RAC clusters on both ASM and non-ASM file management
•Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
•Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server.
Education details:
Associates Degree in Science – 2010
Lincoln College of Technology.
Contact this candidate