SUMMARY:

• Technical, dedicated professional with 11 years of experience in oracle database. knowledge in database security, communication skills, and problem - solving looking for an oracle DBA position.
• Experience working mainly as a DBA for installation, database creation, backup and recovery, performance tuning, RAC, Data Guard, and security implementation.
• Expertise as a DBA in various Oracle versions from 12c, 11g, 10g and sizes up to terabytes and 300 databases in single environment in Windows and Linux operating systems.
• Experience in RAC setup with 2 to 8 node clusters failover system using Linux/Windows environment.
• Experience in setup Data Guard environment up to 4 standby databases on Linux or Windows.
• Experience in backup procedures implementation and monitoring using RMAN. Periodic DR (Disaster Recovery) testing for recover process.
• Created and modified database objects like tables, indexes, Functions, Procedures, Triggers and Packages.

TECHNICAL SKILLS:

DoD: Active Secret Clearance

Oracle Certified Professional (OCP): Oracle Database 12c

ITILv3: ITIL v3 Certified

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Install oracle 12c in Linux operating system and migrate databases from 11gr2 to 12c.
• Install and configure oracle 11g standalone and Data Guard databases in Linux and Windows environment.
• Build physical standby databases from scratch on Linux 7.3, and SYNC them with primary for Data Guard environment. Setup Data Guard broker to manage the environment.
• Create new users account, profiles, roles, database links etc. Partition tables as needed.
• Monitor archive logs, tablespace issues for primary and standby databases, and set up notification email.
• Setup job to backup databases using RMAN for full and incremental. Validate RMAN backups regularly.
• Perform performance tuning for production databases. Run AWR and ADDM report as required.
• Update/refresh development/test databases for QA team to test new functionalities.
• Apply quarterly security patches to all the databases. Apply security changes to the databases as per the department of State security guide lines.

Confidential, Falls Church, VA

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of oracle 11g standalone and RAC databases in Linux, Windows. Migrate and upgrade oracle 10g RAC databases to 11g. RAC databases are 2 - 8 nodes on RHEL.
• Use Oracle Advanced security for data encryption. Use Data Vault to control the privileges for all the users in the database.
• Install OEM 12c, deploy agent on the database server individually, and setup alert mails.
• Create new users account, profiles, roles, database links for the users as needed. Create Partition tables for performance improvement.
• Migrate/create databases on Exadata. Manage tablespaces, shared memory, invalid objects, broken jobs issues for databases.
• Setup cronjob for incremental and full database backup using RMAN. Verify notification if the backup is not successful and make necessary changes.
• 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 and QA environment.
• Perform performance tuning for production databases. Run AWR and ADDM report as needed.
• Update/refresh development databases and create clone copy for QA/development team to test new functionalities.
• Apply quarterly security patches. Change oracle/sys/system password regularly in every 60 days to meet the security guidelines for 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 for high availability solutions using RAC, Data Guard, Oracle Advanced Replication, and clustering solutions.
• Outline the backup plan, and take incremental, 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 regularly, and Microsoft Windows security patches regularly.
• Use flashback for testing purposes on the developing and testing environment for unexpected incident.
• Write UNIX shell and PL/SQL scripting for triggers, stored procedures.
• Hardened the database by following the STIGS of DISA (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 incremental or full backup of the databases, and ensure the backups are successful.
• Support application teams for any issues with 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, table spaces, memory structures etc.
• Documentation of standards and exceptions along with daily work logs for tracking and reference.

Confidential, Ashburn, VA

Database Administrator

Responsibilities:

• Perform installation of Oracle software 9i, 10g and create databases on Linux, Windows. Upgrade databases from 9i to 10g.
• Perform performance tuning for the database using TKPROF, STATSPACK for optimum performance and to meet user’s requirement.
• Apply the Oracle security patches on the production and development databases regularly. Create users and involve in database security by granting roles, privileges, and profile to users.
• Handling development releases to production database and implementing change request for production. Assists developers in writing and tuning their queries for improve performance.
• Analyze database objects, indexes to get statistics. Analyzing the schema periodically, and database growth checks regularly. Configure auditing to audit information about database activity.