We provide IT Staff Augmentation Services!

Oracle Dba Resume

5.00/5 (Submit Your Rating)

Boston, MA

Hire Now

SUMMARY:

  • Around 5 years of experience in Information Technology with proven expertise on Oracle 10g/11g/12c D Confidential bases, Technical & System Administration.
  • Experience with Oracle 10g/11g/12c Installation, Administration, Monitoring, Performance Tuning, D Confidential base Backup and Recovery using RMAN utility.
  • Refreshed Oracle d Confidential base from Production to Test, Development and QA instances.
  • Managed Oracle Net Configuration, Monitoring Alert Log Files, Listener Log, Redo Log Status
  • Managing d Confidential base security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Worked on Two node Oracle 12c RAC cluster with ASM file system.
  • Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.
  • Planed for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
  • Performed automatic monitoring of users, tablespaces, tables, indexes & Auditing of d Confidential base
  • Extensively used Oracle utilities Export/Import, Explain plan and Wrote SQL*Loader control files for uploading the d Confidential
  • Routine checks of log and trace files to see whether there are any problems requiring action.
  • Designed d Confidential base for the application and Created Tables, Indexes, Views, Synonyms, Sequences, Constraints, D Confidential base links, Roles and Privileges
  • Proactively helping to the Development team for their regular deployments DB code migration and application code migration.
  • Applied the d Confidential base patches using Optach utility.
TECHNICAL SKILLS
  • Operating Systems: Windows 2012 R2, Linux 5.0/6.x
  • Languages: C, PL/SQL, Unix Shell scripting
  • RDBMS Technologies: Oracle 10g/11g/12c, RAC, OEM, D Confidential guard, ASM, MySql
  • Web Technologies: HTML,XML, Apache webserver
  • DBA Tools: SQL Developer, Toad, Oracle Grid control, DDBar

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Oracle DBA

Responsibilities:

  • Installed the Oracle binaries and Configured the 10g/11g/12C d Confidential bases.
  • Configured the d Confidential base backup’s using RMAN Utility.
  • Performed the D Confidential base refresh from Production d Confidential base to non - production d Confidential base and masked the production d Confidential after the refresh.
  • Performing logical backups using export/imports and d Confidential pumps in PROD and Non-PROD environments.
  • Writing shell scripts and cron job for proactive monitoring of application and d Confidential base & sending mails.
  • Planning and coordinating the tasks with Project Management team.
  • Performed the regular DBA support activities like Creating D Confidential base, Managing Table spaces, Sizing Objects, Creating Schema Objects, Managing Users, and Granting Privileges.
  • Routine checks of logs and trace files to see whether there are any problems requiring action.
  • Managed Oracle Net Configuration, Monitoring Alert Log Files, Listener Log, Redo Log Status and Trace files for the d Confidential base and analyzing STATSPACK Report at regular intervals to ensure good d Confidential base performance
  • Allocated system storage and planning for future storage requirements for the d Confidential base systems and resolved the performance problems
  • Uploaded the d Confidential to Oracle d Confidential base from flat files using SQL* Loader utility
  • Maintained D Confidential base security by creating Users, Roles, Privileges, Quotas and Passwords.

Environment: Oracle 11g/12c, Linux 6.x, RMAN, SQL Developer, Windows 2012 R2

Confidential

Oracle DBA

Responsibilities:

  • Installed Oracle d Confidential base software, created the d Confidential base and configured the clients with the server
  • Designed d Confidential base for the application and Created Tables, Indexes, Views, Synonyms, Sequences, Constraints, D Confidential base links, Roles and Privileges
  • Performed DBA activities like Creating D Confidential base, Managing Table spaces, Sizing Objects, Creating Schema Objects, Managing Users, and Granting Privileges.
  • Refreshed d Confidential base from production server to Development and Testing servers using hot/cold backups
  • Routine checks of logs and trace files to see whether there are any problems requiring action
  • Wrote PL/SQL stored procedures, Functions, Packages and d Confidential base triggers for the application
  • Uploaded the d Confidential to Oracle d Confidential base from flat files using SQL* Loader utility
  • Maintained D Confidential base security by creating Users, Roles, Privileges, Quotas and Passwords
  • Created d Confidential base instances for development, testing and provided the support to testing Team
  • Scheduled the Backups and taking Logical Backups using Export/Import utilities
  • Allocated system storage and planning for future storage requirements for the d Confidential base systems and resolved the performance problems

Environment: Windows 2000, Linux 5.0, Oracle d Confidential base 10g/11g, TOAD, SQL Developer

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship