Database Administration Oracle Dba
Resume:
M Naveed Asif
Email: ad04em@r.postjobfree.com
Phone: 773-***-****
Oracle Database Administrator
PROFESSIONAL SUMMARY
Oracle DBA with 7 + years of experience, worked extensively on Oracle 19c,18c, 12c, 11g, involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management, and security.
PROFESSIONAL EXPERIENCE
Build and managed Active Data Guard.
Build 13c OEM Cloud Control and managed OMS and OMR.
Configure 11g, 12c, 18c, and 19c Active Data Guard.
Implementation and maintenance of RAC.
Build DR using Oracle Data Guard.
Proficient in Oracle RDBMS – all areas of database administration.
Performed Data Cloning.
Performed backup, restore, and recoveries using RMAN.
Worked on Upgrade and Migration projects.
Performed various database administrative to keep databases healthy.
Worked with VLDB (Very Large Databases).
Worked on export/imports, and data pump tasks.
Worked on Database security, roles, grants, privileges, FGA, Data Vault, etc.
Worked on Virtual Databases.
Load balancing in RAC nodes using TAF.
Experience in applying CPU and PSU Patching.
Worked on Migration & Upgrade projects.
Possess experience in SQL Server Database Administration.
Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and regular databases.
Used tools like TOAD, DB Console, Grid Control to monitor database performance.
Transportable Table Space (TTS) migration AIX to Linux.
Worked as a lead in Data Centre Consolidation on large database systems.
Worked as primary support for database-related issues with clients.
Worked on multiple projects in parallel to daily DBA activities.
Worked with RMAN on various backup policies.
Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management, and Tuning SQL queries.
Database replication using snapshots, materialized views, and advanced Replication methods.
Worked on High availability of the databases including RAC, ASM, and Data Guard on Oracle.
Worked extensively on all database administration tasks on 10g and 11g R2, 19c Databases.
Worked on Oracle Security using Oracle Vault, Wallet, and TDE.
11g R2 Administration included: Installation of RHEL5, setting up group/users, installing Linux packages, and setting kernel parameters.
Upgrade from 10g R2 to 11g R2 & 12c to 19c.
Build 19c RAC from scratch including Linux OS installation.
Installed 11g,12c & 19c upgrade, and performed Hot Patching.
New features and enhancements of RMAN, Flashback.
SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management, and Database replay.
Build Materialize Views Servers.
Worked on data protection with Oracle’s Zero Data Loss Recovery Appliance.
Build Unidirectional and bi-directional GoldenGate replication.
Proficient in maintaining 10g, 11g, 12c, 18c, and 19c databases.
Proficient in writing UNIX Shell scripts to automate business processes and daily backup.
Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation, and different types of storage structures (SAN/NAS).
Installed Oracle versions 12c & 19c on environments AIX, & Linux.
Migrated databases from Oracle versions 11g to 12c to 18c and 19c.
Worked on OEM, DB console, Grid Control, and Cloud Control.
TECHNICAL SKILLS
RDBMS
Oracle 12c/11g/13 cloud control/18c and 19c, Oracle 11gR2 /12c Multitenant Databases, Real Application Cluster (RAC), ASM, MS SQL SERVER 2008/2012/2014.
Operating Systems & Administration
Red Hat Linux 5.x,6.x, AIX 5.2,6.1,7.1, O.E.L 6.4,6.7,7.3 and windows 2000/XP, HP-UX 10.x,11.x, Windows Server, VMware.
Languages
SQL, PL/SQL, Bash Shell Scripting, UNIX Shell Scripting.
Oracle Tools and Utilities
Data Guard, Golden Gate, Log dump, Web logic server, ODI, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup, RAC TOOLS ORACHECK, TFA collector.
Tuning Tools
EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor
Ticketing Tools
BMC Remedy, JIRA, NEWS, Service Now, HP Quality Centre
Others
Concepts and Administration Data Guard (Standby), Real Application Cluster (RAC). Automatic Storage Management (ASM) / RAID configuration. Recovery Manager (RMAN)Oracle Golden Gate / Materialized Views / Database Cloning Oracle Data Guard DR setup / Active Data Guard Oracle OCFS2 / ACFS Database Cloning via RMAN / Data Pump / DB Links etc. MS SQL Server / Log shipping / Mirroring / Replication / Installation 12c Cloud Control,12c Multitenant Databases Database Installation, OMF, Silent Install, DB installation via scripts / DBCA
Mapfre Insurance, Webster-MA Jan 2020 to Till Date
Oracle DBA
Responsibilities:
Setup Data Guard.
Worked on Databases using ASM on Linux and Aix Servers.
Worked on a 13c OEM migration project.
Installation/Creating new databases.
Cloned Databases using RMAN.
Installation, Configure, and setup of 4 node RAC cluster on Linux & Aix.
Supported database on Exadata X7.
Applied patches on computer nodes and storage cells.
Upgraded Databases from 11g to 12C to 18c and 19c.
Applied patches as per security needs and bug fixes.
Worked extensively on data center migrations on multiple database versions.
Designed, configured, and maintained backup and recovery policies using RMAN.
Worked on performance tuning.
12c OEM install/config Agents and deploying.
Used export-import and Data Pump.
Set up cron tabs to automated jobs as required.
Worked with Data pump to take the logical backups of databases and experienced in performing Point in time recovery using RMAN.
Familiar with Oracle GoldenGate concepts and replication techniques.
Written Shell scripts to automate purge.
Proficient in writing UNIX Shell scripts to automate business processes and daily backup.
Worked on OEM, DB console, Grid Control, and Cloud Control.
Worked on Oracle Materialize Views, Oracle Golden Gate, and Oracle Active Data Guard.
Worked on Flash Recovery Area.
Performed DR switchover/failover practices using Data Broker.
Patched Oracle databases using OPatch utility.
Worked on monitoring Database health, Bottlenecks, session information, table privileges, and permissions.
Monitored scheduled jobs for backups, gathering statistics, AWR reports, and data guard status reports, disk space utilization reports.
Generated triggers for data integrity, and created views to resolve complex queries.
Used RMAN duplicated database to clone.
Used export-import and Data pump to refresh schemas.
Identifying the poorly performing queries using Explain Plan and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
HCL, FedEx-New Jersey Feb 2019 to Dec 2020
Oracle DBA
Responsibilities:
Installed, configured, and maintained Oracle 11g and 12c on Linux and also Upgraded from Oracle 11g to 12c.
Performed the migration from Tandem to Oracle 11g and 12c.
Performed administrative maintenance, and monitoring on Oracle database systems in a global 24x7 operational environment.
Performed Database Refresh from Production to Development databases.
Database user backup using Export /Import Utility. And database backup using a data pump.
Production refresh to PRR environment and conversion environment when required.
Done partitions on tables and indexes to get better performance on large tables.
Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait for events reports using OEM and Custom scripts.
Configured OEM for performance monitoring and database administration.
Monitored indexes and analyzed their status for performance tuning and query optimization (Done a lot of SQL tuning).
Used SQL Trace, Explain Plan, AWR, and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams, and Data Guard.
Setup new database infrastructure. Install Grid Infrastructure /Real Application Cluster ware (RAC), database server software, and related products. Setup, configure standby databases, replication using Oracle Streams/Golden Gate, ASM for data storage, and RMAN for backup and recovery. Apply Oracle patch set/PSU.
Successfully upgraded and migrated databases for critical OLTP applications from Oracle 12c RAC infrastructure to Oracle 18c and 19c Grid infrastructure. Built Oracle 18c Grid infrastructure for all the regions from Dev to Prod. Worked in collaboration with AIX, Storage team in setting up Oracle 11g Grid infrastructure, Development team in performing application testing, and Load Runner team in performing Capacity testing.
Upgraded Oracle 10g and lower Non-RAC databases to Oracle 12c including data warehouse databases.
Migrated Oracle Non-RAC databases to Oracle RAC databases.
Migrated Oracle database from file system to ASM.
Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.
Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.
Perform database tuning and performance monitoring at the OS level, DB level, and SQL level. Analyze data and make recommendations relating to the performance and efficiency of data storage. Perform capacity testing before implementing a new major application release to the production environment. Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits, or other advice from OEM Grid control.
Work with the system administrator and storage administrator to perform software installations, and configure hardware and software so that it functions optimally with the Oracle infrastructure.
Monitor and maintain database security. Coordinate with Security administrator in adding, maintaining, and removing users’ accounts, administering quotas, auditing, and checking for security issues.
Interface with Oracle Corporation for technical support, and solution to problems by utilizing Oracle support.
Blue Cross Blue Shield, Newark-New Jersey Aug 2017 to Dec 2018
Oracle DBA
Responsibilities:
Installed, configured, and maintained Oracle 10g and 11g and 12c on Linux and also Upgraded from Oracle 10g to 11g to 12c.
Performed the migration from Tandem to Oracle 11g and 12c.
Performed administrative maintenance, and monitoring on Oracle database systems in a global 24x7 operational environment.
Performed Database Refresh from Production to Development databases.
Database user backup using Export /Import Utility. And database backup using a data pump.
Production refresh to PRR environment and conversion environment when required.
Done partitions on tables and indexes to get better performance on large tables.
Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait for events reports using OEM and Custom scripts.
Configured OEM for performance monitoring and database administration.
Monitored indexes and analyzed their status for performance tuning and query optimization (Done a lot of SQL tuning).
Used SQL Trace, Explain Plan, AWR, and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams, and Data Guard.
Setup new database infrastructure. Install Grid Infrastructure /Real Application Cluster ware (RAC), database server software, and related products. Setup, configure standby databases, replication using Oracle Streams/Golden Gate, ASM for data storage, and RMAN for backup and recovery. Apply Oracle patch set/PSU.
Successfully upgraded and migrated databases for critical OLTP applications from Oracle 12c RAC infrastructure to Oracle 18c and 19c Grid infrastructure. Built Oracle 18c Grid infrastructure for all the regions from Dev to Prod. Worked in collaboration with AIX, Storage team in setting up Oracle 11g Grid infrastructure, Development team in performing application testing, and Load Runner team in performing Capacity testing.
Upgraded Oracle 10g and lower Non-RAC databases to Oracle 12c including data warehouse databases.
Migrated Oracle Non-RAC databases to Oracle RAC databases.
Migrated Oracle database from file system to ASM.
Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.
Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.
Perform database tuning and performance monitoring at the OS level, DB level, and SQL level. Analyze data and make recommendations relating to the performance and efficiency of data storage. Perform capacity testing before implementing a new major application release to the production environment. Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits, or other advice from OEM Grid control.
Work with the system administrator and storage administrator to perform software installations, and configure hardware and software so that it functions optimally with the Oracle infrastructure.
Monitor and maintain database security. Coordinate with Security administrator in adding, maintaining, and removing users’ accounts, administering quotas, auditing, and checking for security issues.
Interface with Oracle Corporation for technical support, and solution to problems by utilizing Oracle support.
Cars, Chicago-IL Jun 2015 to Jul 2017
Oracle DBA Consultant
Responsibilities:
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, and packages using PL/SQL & 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.
Experienced with Space Management and Security.
Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
Performed automated backups and scheduling using scripting.
Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
Experienced with GUI and CLI to manage database farmhouse.
Rebuilding of indexes for better performance and maintenance of Oracle Database.
Configured and Maintenance of SQL Server databases.
Implemented 10g & 11g Physical Data Guard.
Importing data from flat files into a database using SQL loader and External Tables.
Written shell scripts to automate the tasks.
Supported 24/7 on-call pager support for mission-critical financial databases.
Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM.
Applied latest patches as per evaluation requirement.
Implemented Oracle database backup & recovery solutions using RMAN.
EDUCATION:
Computer Science Preston University
Contact this candidate