We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Austin, TX

SUMMARY

  • Over 7 years of experience, mostly Oracle Database Administration experience including 9i,10g, 11g, 12c,18c and 19c on Standalones, RAC and Exadata(X6 & X7) on Linux, AIX,& UNIX
  • Oracle Enterprise Manager (OEM) 11g, Cloud Control 12c & 13c Release 2 on Linux.
  • Installation, Upgrading, Patching, sizing, creating Oracle Databases, and Oracle database Objects, data migrations, Troubleshooting, Performance & Tuning, Backup & Recovery, and Database integrity and Security.
  • Experience in Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used ASH, AWR report, ADDM, SQL ADVISOR & EXPLAIN PLAN.
  • Excellent experience in installation, setup and configuration of Oracle 12c container databases on Linux,Aix,Windows & Unix.
  • Good at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 10g|11g|12c|19c databases.
  • Working experience in database cloning or duplication using RMAN.
  • Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.
  • Experience in TDE(Transparent Data Encryption) 12C Keystore on Tablespace/Columns Master Encryption.
  • Experience in designing and configuring high - availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.
  • Experience in Tables Partitioning & Materialed views
  • Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.
  • Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases.
  • Experience in Performance Tuning, tuned various large critical OLTP and OLAP databases.
  • Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.
  • Experience in the use SHELL Scripts and CRONTAB .
  • Experienced configuring and Maintaining Real Application Cluster (RAC) and good knowledge of Exadata, Automatic Storage Management (ASM) and SRVCTL utility.
  • Upgrading with DBUA, EXPORT/IMPORT & DATA PUMP and TRANSPORTABLE TABLESPACE

TECHNICAL SKILLS

Databases: Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, Oracle18c and Oracle 19c

Operating Systems: UNIX ( Aix, Hp Ux & Solaris), Linux and Windows

Database Tools & Ticketting: Jira, ServiceNow,, OEM 12C & 13c, SQL*Plus, SQL Loader, DBA Configuration Assistant) Toad, OEM Grid, RMAN, SQL Loader, Exp/Imp/Data Pump, Statspack AWR, Top, DBCA, DBUA, ADDM, JIRA, SERVICENOW, IPcenter, Active Directory, SRVCTL CRSTL.

Hardware: OEL(Oracle Enterprise Linux), Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers Sun StorEdge 6320, Hitachi, EMC, Dell Servers Red Hat Linux 7.0,7.6 & 8.0

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR/ADDM/ASH/TOAD, OEM, TOP, IOSTATS Active Directory, Networks, Troubleshoot, AIX, Operating Systems, UNIX, Application development, Upgrade, ASM, Oracle, Utilities, Backup, DBA, Validation, C, Oracle DBA, VMs, Capacity planning, Oracle Database, Hardware, Oracle enterprise manager, Data migration, PL/SQL, Database, Databases, Processes, Dell Servers, Reading, Designing, Red Hat Linux, Disaster recovery, Red Hat Linux 7.6, Documentation, SAN, FTP, Scheduling, HP-UX, Servers, Linux 7.0, Scripts, LINUX, Shell scripts, Linux 6.7, Solaris, Access, Sun Solaris, Windows, SQL, Migration, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle Database Administrator

Responsibilities:

  • Support Exadata databases running on both Oracle 12.2.0.1 & 19c on X7S & Standalones running on Linux 7.0 servers using Cloud Control 13C for monitoring.
  • Upgraded databases from 12C to 19C on a Linux Environment
  • Use both Jira, Service Now and R-Sam for ticketing
  • Providing Oracle DBA support for applications, including developing data migration scripts, data validation queries, and maintenance plan for various development versions of these applications.
  • Setup Data guard on a standalone database.
  • Work application teams and developers on testing the functionality of applications and resolve performance issues.
  • Work with application development team staff to develop & test database architecture and approve all production schema changes.
  • Often refresh from Production to Training, Test and UAT environment.
  • Tune database instances and applications and recommend changes to improve database performance.
  • Installation and configuration of Oracle 12C on Linux 7.6.
  • Manage RAC databases, instances, ASM and clusters with use of ASMCMD, SRVCTL and CRSCTL.
  • Handle all aspects including new projects, manage existing databases, performance and tuning, contact for vendors, and internal/external customers.
  • Support databases that interface with ODI and SCI applications.
  • Perform Installation and configuration of Oracle 12.2.0.1 database on Linux 6.7 VMs platform.
  • Constantly monitor dynamic performance Views (GV$) at peak load of Databases and checking RAC background processes log files & Trace files to troubleshoot performance.
  • Apply patches on both primary and standby running on 4 node RAC.
  • Use shell scripts to check status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Maintain data integrity and security using integrity constraints and database triggers.
  • Part of on call of 24X7 support for all production and development databases.

Confidential, Austin, TX

Oracle Database Administrator

Responsibilities:

  • Supported a HALF RACK Exadata on X6s from Dev, Training, Test, and UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux.
  • Constantly refreshed tables and schemas using Data Pump, expdp and impdp.
  • Also used RMAN to duplicate or clone databases.
  • Migrated databases from Oracle 9i on Window to Oracle12C running Solaris.
  • Planned Backup/Restoration strategy, planning and scheduling backups, taking logical backups (with Export/Import Data pump utilities).
  • Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
  • Managed agents using emctl utility and creating incident rules in enterprise manager 12c.
  • Configuring administration groups, and creating template collections in OEM 12c.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
  • Worked closely with Oracle developers for better performance in applications, in writing Packages, triggers and indexes on tables.
  • Used Secure SCP & FTP extensively for file transfers from machines to remote server.
  • Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor database performance on daily basis.
  • Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
  • Worked closely with System Admins, network support team & Application Developers Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final project performance Assessment/Evaluation.
  • Created database Objects, Tablespaces, Schemas as needed.
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

  • Support many Exadata databases running Oracle11.2.0.4 on X4s & Standalones Oracle 12.1.0.2 running on Linux 6.9 VMs servers and using Cloud Control 12C & 13C for monitoring.
  • Successfully performed data replication using materialized views and Oracle Streams in Oracle 11gR2.
  • Responsible for creating Users, Groups, Roles, Profiles and assigning users to groups and grant necessary privileges to relevant groups.
  • Supported off-hour on call support for database related issues.
  • Created logical and physical design installed and upgraded databases.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
  • Constantly monitor performance (V$ dynamic performance views at peak load) of Databases and viewing Alert log files & Trace files.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring scheduled jobs.
  • Applied patches 11.2.0.3 and 11.2.0.4 DATA GUARD running on 4 Node RAC.
  • Used to run scripts to check status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of databases.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained data integrity and security using integrity constraints and database triggers.
  • Created and implemented database designs and data models.
  • Administered supported and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided 24X7 supports for all production and development databases.

Confidential, Irving, TX

Oracle Database Administrator

Responsibilities:

  • Configured, implemented & Deployed Oracle 11g (11.2.0.4) & Oracle 12C on single instances, work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
  • Taking backups on scheduled time and monitoring scheduled backups.
  • Creating and dropping of users, granting and revoking rights as and when required.
  • Day to day Performance Monitoring and tuning of database.
  • Diagnose and Troubleshoot Database Problems and failures.
  • Involved in installation of Oracle 11g (11.2.0.4) on both Solaris and LINUX platforms.
  • Creation and maintenance of database.
  • Monitoring of database for growth and performance.
  • Defined backup procedures using daily hot backups and weekly cold backup.
  • Storage and space management including tablespaces and datafiles.
  • Creating databases and all database objects.
  • Database designing, designing tablespaces and rollback segments.
  • Management of tablespace growth, monitoring datafiles additions, extent growth.
  • Created scripts and processes for data integration and maintenance.

Hire Now