SUMMARY

• Oracle Database Administrator with over 6 years of experience.
• Performed day - to-day monitoring of Oracle databases and provided installs, maintenance and upgrades.
• Administered, managed and optimized development, test and production Oracle databases.
• Experienced migrating databases across servers and across different Oracle versions.
• Proficient developing, maintaining, configuring, and monitoring SQL database backup jobs.
• Experienced developing ad-hoc queries, scripts, and stored procedures.
• Experienced verifying and maintaining data integrity within databases.
• Knowledge of general DBA duties (install oracle software, create databases, table spaces, add redo log files, managing network environment).
• Administer oracle database on Oracle Virtual Machines.
• Performs daily database backup of development and test environments.
• Deep knowledge of Linux/Unix shell scripting.
• Excellent troubleshooting skills.
• Performance tuning and monitoring.
• Identify and make recommendations per database performance issues.
• Knowledge of managing Oracle on Windows.
• Knowledge of database design.
• Use DBCA to create and DBUA to upgrade Oracle databases.
• Knowledge of Microsoft Office ( MS word, access, excel, PowerPoint).
• Implement/maintain database security with roles and system privileges.
• Experience in customer service (ability to quickly deal with heated customer in various situations).
• Demonstrate ability to meet deadlines and set priorities.
• Strong communication and interpersonal skills.
• Ability and desire to learn new technologies quickly.

TECHNICAL SKILLS

Software/ Tools and utilities: Oracle 19c, 12c, and 11g Databases on Windows 2016, 2012, Linux Redhat/CentOS SQL*PLUS, SQL Developer, TOAD, OEM, RMAN, VMWARE, MICROSOFT OFFICE, PUTTY, MOBA XTERM, and CRONTAB

PROFESSIONAL EXPERIENCE

Confidential, Bowie, MD

Oracle Database Administrator

Responsibilities:

• Administer Oracle 11g, 12c,19c Production, Development, Test, UAT, and QA Databases in virtualization and on-premise environment.
• Created, implemented and managed custom Oracle databases on Linux and windows platforms.
• Applied quarterly Critical Patch Updates (CPU) patches along with major java upgrades.
• Worked closely with system administrators, the development team, and QA teams implementing new projects and database release upgrades.
• Performed Oracle 12c and 19c Database Refresh.
• Performed Oracle 12c and 19c Database Cloning.
• Installed and configured Oracle 12c Multi-Tenant Container Database and Pluggable Database format.
• Upgraded Oracle 11g R2 to 12c R2 and 12c to 19c Multitenant database environment.
• Created and maintained users, schemas, tables, views, sequences, and indexes that comprise the data dictionary; controlling user access and maintaining system security.
• Installed, configured, and upgraded database; other duties include managing tablespaces, data-files, redo log files, control files and parameter files.
• Managed database security and evaluating grants, restricted roles and privileges.
• Developed RMAN backup and recovery strategies and recovery policies and procedures.
• Performed daily monitoring of the databases and database space management.
• Performed a flashback and point in time recovery.
• Scheduled backups using the crontab utility.
• Performed data migration from a database in one server to a database housed on another server using database link.
• Migrated data using the data pump export (expdp) and import (impdp)
• Created non-default listeners for databases.
• Registering databases and listeners to OEM Cloud Control 12C.

Confidential, Gaithersburg, MD

Oracle Database administrator

Responsibilities:

• Performed setting of initialization parameters, monitoring of the rollback segments, configuring. on-line redo log, and administrating systems on multiple platforms.
• Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
• Migrated data from Production to Development using SDLC process.
• Managed deployment of rpm packages on Linux server.
• Provided Oracle database administrative support to various user groups (application developers, data managers.
• Created and maintained Oracle database objects (schemas, tables, indexes etc.)
• Analyzed and tuned voluminous SQL code.
• Designed, developed and implemented technology-based systems for a wide range of applications for different user groups.
• Performed capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance.
• Performed backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts.
• Using RMAN to restore and recover control and data files respectively.
• Performed a flashback and point in time recovery.
• Creating a database recovery catalog and registering databases to the recovery catalog database
• Scheduling backups using the crontab utility.
• Supported system administration groups with maintaining oracle database servers in pre-production, test, training, and development environments.
• Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
• Control and monitor user access to the database using roles, and profiles.