SUMMARY:

• 10 years of Oracle DBA experience working in a federal government site including strong technical background in Microsoft, Unix/Linux application. Daily support of corporate management systems including database management and administration, analysis, design, testing, production support and architecture in client/server and web - based environments.
• Configuration, installation and implementation of Oracle database 11g or 12c, Upgrades, Patches, Troubleshooting and performance tuning, Data pump utility, Database security, Backup and recovery, Data Guard, Data migration.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Washington DC.

• Provide DBA technical support to the OIG software development Team on issues, Oracle database installations, deployments and maintenance of our systems.
• Independently maintained and managed Oracle 11g Databases on 6 servers. Download Oracle Database software from OTN and performed a fresh installation of Oracle Database 12c software onto one of the OIG servers in a Microsoft environment. Create a new database for the purpose of 12c Oracle Enterprise Manager (OEM) Repository.
• Performed database space management and monitoring.
• Installed JAVA JRE on database 12c and ensure the JAVA security Update is maintained.
• Create users profile and password file for the encryption of user passwords and profiles to efficiently manage our system resources.
• Maintained the system DBA privileges on Oracle Database 12c and managed administrative user access into the OIG server operating system.
• Applied quarterly Bundle patches to OIG 12c Oracle Database for security fixes and perform backups of the database using RMAN tool.
• Planned and implemented High Availability solution using Data Guard for Disaster Recovery of our data.
• Setup, configured and maintained two Standby databases using 11gR2 databases on our OIG servers.
• Installed and configured Oracle WebLogic server for 12c OEM Domain. Installed 12c OEM unto OIG server for the management and administration of our databases from one single console. Deployed 12c Agents unto Target Databases to monitor the administrative tasks on those Hosts.
• Good knowledge on Amazon Web services (AWS). Amazon Cloud Services like Elastic Compute Cloud (EC2)
• Simple storage services(S3) Bucket, Amazon Simple DB, Amazon Cloud watch.
• Hands on experience with the AWS CLI and SDKS.
• Responsible for migrating 4 hybrid servers to EC2 instances in AWS.
• Detailed analysis of the business and user requirements by doing various information gathering techniques.
• Attention to detail and listen attentively to Clients needs and response in order to satisfy their expectations and consistently deliver positive feedbacks as the job proposition inquires.
• Provide Customer Service to our Clients, Agencies. Delivered a daily and weekly status reports on Database health check, Remote server’s connection, JAVA update and Database progress reports upon Client request which is normally conducted via email.
• Effectively communicate in English both orally and verbally. Attend scheduled Team meetings with both OIG employee Network Administrators and Oracle Database Administrator.
• I am an experienced, self-motivated Oracle DBA with skills in problem solving, organization and communication. Precisely engages in thorough research procedures on Oracle products and services and awaits final approval from the OIG employee Team Lead supervisor before an installation of a new software and/or application.

Oracle Database Administrator

Confidential, Washington DC.

• Managed backups of data and its validation.
• Security management for database, network and operating systems.
• Managed, access, retrieve data using DDL and DML commands on Microsoft SQL server and MySQL.
• Participate in application development project, database architecture and design.
• Knowledge and understanding of database design using Erwin Data modeling.
• Develop stored procedures and database triggers in support of application development.
• Responsible for the monitoring and uptime of our production databases.
• Experience in RMAN backup, Full and incremental backups, flashback technology, Enterprise Manager and Oracle OEM Grid control.
• Backup/Restore/Recover of databases/tables/schema using Data pump on Linux OS to take an export or import of a schema for data migration.
• Apply patches using Oracle OPatch utility, PSU to upgrade oracle home versions.
• Managing, monitoring and optimizing the performance of time databases on a periodic basis using AWR, ADDM reports and providing recommendations to developers and project team leads.
• Manage database security by creating new users, roles, profiles and provide privileges for implementation and maintenance of user security.
• Solid knowledge of installing and configuration of Linux 5.4, Oracle Linux 6.4 operating systems, Oracle 10g, 11g, 12c database.

Oracle Database Administrator

Confidential, Washington DC

• Performed upgrade and migration of Oracle databases from Oracle 10g to 11g.
• Applied PSU/CPU patches, Grid infrastructure patches, online patches and rolling patches.
• Design of databases following OFA: creating Databases schemas, profiles, synonyms objects as required to ensure data quality and security to comply with company’s business rules.
• Oracle scripting in Unix platform using OEM.
• Backup/Recovery methodology specification for mission critical databases.
• Performed hot and cold backups.
• Scheduled daily Exports/imports to serve as temporary backups.
• Installation and configuration of Oracle 11g and 11g Enterprises editions, OEM with Oracle and Tuning packs.
• Performed proactive and reactive tuning/managing database space utilization and growth.
• Manage performance of 30 databases, performed health checks and administered multiple instances of 10g and 11g databases running on Linux operating systems.

Computer Database Operator

Confidential, Washington DC

• Managed databases on windows and Linux platforms.
• Performed user account management such as account lockouts, password resets and account creation.
• Provide technical support for the database system issues and application performance enhancement/improvement using Windows as well as Unix shell scripts.
• Performed daily, weekly and emergency backup procedures using ultra backup software and ensure their accuracy.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.
• Scheduled jobs to automate database system backups, database health and backup verification.

TECHNICAL SKILLS

Skills: Microsoft, Linux, Oracle Database administration, Technical support, SQL*Plus, UNIX-Shell scripting.

Database Tools: RMAN, DBUA, DBCA, NETCA, Export-Import, Backup & Recovery, Oracle 11g or 12c, OUI, Oracle OPatch, Data Guard, Data Migration, Oracle Enterprise Manager automated tool for scheduling jobs and backup, Microsoft SQL server 2014, MySQL, Erwin Data Modeling Tool.

Hardware: Unix 5.2, Oracle Linux 6.4, Windows 2000 server/workstation, Windows 2008 Server, Windows 7.