We provide IT Staff Augmentation Services!

Oracle Dba/ Automation Engineer Resume

2.00/5 (Submit Your Rating)

New York, NY

Hire Now

SUMMARY:

A Certified Oracle Database Associate with 6 years’ experience. I have worked with different versions of Oracle ranging from 10g, 11g and some parts of 12C. I have done Golden Gate for data replication and have been part of major projects like Data Guard, Upgrades and RAC. I have worked on different platforms such as UNIX, LINUX, SOLARIS, AIX and WINDOWS 2008. During my career, I support production where I do performance tuning using different tools like AWR, ADDM and SQL Tuning Advisor. I have done cloning/refreshes using RMAN, Migration using data pump and transportable tablespaces, backup and recovery using RMAN, Installation, Configuration, Space Management, Database Security and troubleshooting.

TECHNICAL SKILLS:

  • IPCENTER
  • RMAN
  • RHEL 5 and 6
  • Oracle Enterprise Manager Grid Control
  • OEM Database control
  • PL/SQL
  • Shell Scripting and TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Oracle DBA/ Automation engineer

Responsibilities:

  • 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.
  • Good in copying automations from one client to another, establishing and testing connections between different clients
  • Proficient in Database Administration activities such as installation, configuration, database creation, sizing, backup and recovery, performance tuning and capacity planning.
  • 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.

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
  • Migration of database from one server to another server and also migration of non ASM database to ASM database.
  • Responsible for configuring Data Guard physical and standby database setup for high availability and handling synchronization issues between primary and standby.
  • Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
  • Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.
  • 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.
  • Conducting sizing and capacity planning for oracle databases.

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

  • Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
  • Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
  • 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.
  • Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship