SUMMARY

• Twelve years of experience in Oracle database administration and maintain every aspect of the database for an organization in a group or single - handed.
• Experience in installation, database creation, backup and recovery, performance tuning, RAC, Data Guard, and database security implementation.
• Expertise in various Oracle versions from 12c, 11g, 10g and sizes up to terabytes and 200 databases for an organization in Windows and Linux operating systems for Department of State.
• Experience in RAC setup with 2 to 8 node clusters failover system using a Linux/Windows environment.
• Experience in Data Guard setup up to 4 standby databases on Linux or Windows.
• Experience in backup procedures implementation and monitoring using RMAN. Periodic Disaster Recovery testing for the recovery process.
• Create and modify database objects like tables, indexes, functions, procedures, triggers, and packages.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Install and configure Oracle 11g and 12c standalone and Data Guard databases in Linux and Windows environment.
• Upgrade and migrate databases from Oracle 11g to 12c in the Windows and Linux operating system. Use ASM for Linux operating systems. Use shell scripting in Liunx servers for cronjobs.
• Build physical standby databases in Linux, Windows, and SYNC them with primary for Data Guard environment. Setup Data Guard broker to manage the environment.
• Implement RMAN for full and incremental backups. Validate backups regularly for production databases.
• Periodically tested Data guard environment with switchover process.
• Perform performance tuning and monitor production databases regularly. Use AWR and ADDM report as required for any issues. Also, use OEM to monitor the databases.
• Refresh development/test databases for the development team to test new functionalities as needed.
• Monitor Space usage for all the databases, and plan for capacity. Clear log files as needed. Use sqlplus, Toad, and sql developer tools to manage databases.
• Apply quarterly security patches to all the databases. Apply database security changes as per the Department of State security guidelines for user accounts, profiles, roles, parameter values, etc.

Confidential, Falls Church, VA

Sr. Oracle DBA

Responsibilities:

• Install and configure Oracle 11g standalone and RAC databases in Linux/Windows. Linux configures with ASM. Migrate and upgrade oracle 10g RAC databases to 11g. RAC databases are 2 - 8 nodes clusters.
• Use Oracle advanced security for data encryption. Use Data Vault to control accounts and their privileges.
• Install OEM 13c, deploy an agent on the database server individually, and set up alert emails.
• Create new user accounts, profiles, roles, DB links for the users as needed. Create partition tables for performance improvement.
• Upgrade databases on Exadata. Manage tablespaces, shared memory, invalid objects, broken job issues.
• Use RMAN for incremental and full database backup. Verify backup notification email.
• Perform schema, table comparison for development databases, and work with the developers to apply the changes as needed. Refresh table, schema, database as needed for development verification.
• Perform performance tuning for production databases. Run AWR and ADDM report as needed.
• Refresh development and test databases and create clone copy to test new functionalities.
• Apply quarterly security patches. Change oracle/sys/system password regularly in every 60 days to meet the security guidelines for the Department of State. Apply DoS security changes to the databases as needed based on the checklist items issues by the security team.

Confidential, Crystal City, VA

Oracle DBA

Responsibilities:

• Support 10g, 11g databases in Linux and Windows environment. Upgrade production and development databases from 9i to 10g, 10g to 11g on Windows/Linux.
• Engineering, implementation, and support high availability solutions for RAC, Data Guard, Oracle advanced replication.
• Outline the backup plan. Take incremental, and full backup regularly using RMAN.
• Refresh the database as requested by the application developers for testing. Assists developers in writing/modifying existing queries for better performance of the application.
• Apply Oracle quarterly security patches and Microsoft Windows security patches regularly.
• Use flashback for testing purposes on the developing and testing environment for the unexpected incident.
• Write UNIX shell and PL/SQL scripting for triggers, stored procedures.
• Harden the database by following the DISA STIG (DOD).
• Support production databases 24x7 as needed.

Confidential, Alexandria, VA

Database Administrator

Responsibilities:

• Install and configure Oracle databases on Linux/Windows operating systems. Upgrade databases from 9i to 10g, 10g to 11g. Successfully manage databases in Data Guard, RAC environment.
• Use RMAN to take an incremental or full backup of the databases, and ensure the backups are successful.
• Support application teams for any database issues. Setup reporting for health checking of the databases and servers so that issues can be identified and fixed proactively.
• Apply quarterly security patches to all production, test, and development databases.
• Write stored procedures, triggers, and functions using pl/sql.
• Uses OEM to monitor databases, tablespaces, memory structures, etc.
• Documentation of standards and exceptions, along with daily work logs for tracking and reference.

Confidential, Ashburn, VA

Database Administrator

Responsibilities:

• Install Oracle software 9i, 10g, and create databases on Linux, Windows. Upgrade databases from 9i to 10g in a standalone environment.
• Perform performance tuning for the database using TKPROF, STATSPACK for optimum performance, and to meet user’s requirement.
• Apply Oracle security patches on the production and development databases regularly. Create users, roles, grant needed privileges through Twelve to each user and create profiles for user accounts.
• Handling development releases to the production databases and implementing change request for production. Assists developers in writing and tuning their queries to improve performance.
• Analyze database objects, indexes to get statistics. Analyzing the schema periodically, and database growth checks regularly. Configure auditing for database activity.