We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Brookfield, Wi

SUMMARY:

  • Oracle Certified Associate database administration with over 5 years of hands - on experience working on DBA/Architecture, Production 24*7 support, Implementation, Configuration, Upgrades, Replication, Performance Tuning/ Optimization/ AWR, ADDM, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Database Migration,

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinSCP

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import

Others: Remedy, Connect Wise

PROFESSIONAL EXPERIENCE:

Confidential, Brookfield. WI

Oracle Database Administrator

Responsibilities:

  • Configured Oracle Data Guard to ensure disaster recovery and RAC for high availability and data protection
  • Excellent experience in Performance tuning of oracle databases using different tools like AWR, ADDM, SQL TUNNING ADVISOR and tuning of SQL scripts using SQL Trace and Explain Plan
  • Proficient in Database Administration activities such as installation, configuration, database creation, sizing, backup and recovery, performance tuning and capacity planning.
  • Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
  • Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
  • Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
  • Strong Knowledge and experience in database security. Creating Users, creating and managing tables, views, and indexes, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
  • Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases
Confidential, Fayetteville. NC

Oracle Database Administrator

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g, 11g and 11gr2 to 12c.
  • Migration of database from one server to another server and migration of non ASM database to ASM database.
  • Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
  • Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
  • Installation, setup and configuration of Operational Data Store for use with Oracle Golden Gate. Resolving issues related to Network Congestion, Memory (SGA and PGA) CPU & IO and other oracle related issues.
  • Applying Quarterly Security Patches (CPU/PSU) and applying Patch set and One-off Patches.
  • Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Monitoring several databases of varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
  • Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
  • Expertise in UNIX Shell Scripting and automated many common tasks using CRONTAB including: Backups, exports and imports, archiving old records and verification of such processes.
Confidential, Greeley, CO

Jr. Oracle Database Administrator

Responsibilities:

  • User creation with proper roles and privileges.
  • Responsible for integrity and concurrency of data.
  • Create a PL/SQL function, stored procedure, package to support reports.
  • Refreshing and manipulating data in tables using PL/ SQL procedures.
  • Written stored procedures, functions and triggers.
  • Testing, Debugging and Documentation.
  • Estimating table sizes, table spaces.
  • Created database objects like tables, tablespaces, buffer pools, indexes
  • Performance monitoring and tuning.
  • Analyzing tables and indexes for performance tuning.
  • Creation, maintenance, backups and restoration of databases.
  • Creation of logins and user ids and setting up privileges and procedures
  • Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size
Confidential

Jr. Oracle Database Administrator

Responsibilities:

  • Monitor performance of database systems resources and query throughput
  • Optimize SQL Code as necessary
  • Monitor and maintain database storage resources
  • Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
  • Oracle RDBMS Installation, Upgrades, Migrations and Configuration
  • Install database software service packs and cumulative updates as necessary
  • Maintain database documentation as required
  • Maintain and administer database security access
  • Perform database Ad-hoc backups and restores
  • Trouble shoot and resolve database connectivity issues

Hire Now