SUMMARY:

• Experience in installing Oracle software (11g, 12c and 1 9c) and creating databases on Windows/Linux platforms and ensured Oracle database systems operate efficiently and securely
• Experience leveraging DB availability tools and backup procedures to ensure database integrity (RMAN, Data guard, Data Pump)
• Experience in Development, Testing and Production Environments
• Experience in working wif TCP/IP and DNS and troublesho oting Oracle database network issues
• Experience in Performance Monitoring using OEM and Solarwinds, Troubleshooting, SQL Tuning, and Core Oracle Database Administration
• Experience wif Database upgrade migration from 11gR2 to 12c
• Experience in Oracle RAC, Data Guard and ASM Grid Control
• Experience wif installation and configuring oracle Grid infrastructure on Linux
• Experience wif Oracle Data Guard, creating and managing physical and logical standby database using RMAN
• Experience in installation, configuration and management of Oracle Enterprise Manager (OEM) 12C Cloud Control
• Experience wif extracting or inserting oracle readable copy of data and structures, using data pump and import and export utilities.
• Experience wif Database refresh and logical database backup, using data pump and import/export utilities
• Managed internal databases, from planning and testing through implementation and support
• Experience in teh writing of SQL, batch and Shell scripts for backups, SQL*Loader, export and import of database, as well as Open Database Connectivity (ODBC) connections
• Extensive experience designing, implementing, Optimization of Instance Performance, supporting disaster recovery and high availability plans, solutions based on Oracle 12c, 11g and 10g software on multiple platforms.
• Experience wif maintaining Oracle WebLogic Server (WLS) 12cR2 (12.2.1), Oracle Forms and Reports 12c (12.2.1) services.
• Experience wif Amazon AWS cloud services, creating users, storage buckets, assigning policies in IAM, spinning up new servers and creating rdbms databases on AWS cloud infrastructure
• Experience operating in traditional and Agile project models wif development teams

TECHNICAL SKILLS:

Databases: Oracle 11g/12c/1 9c, SQL Server and Amazon web services (AWS) cloud

Operating Systems: Windows 2000/2003/NT/XP, OS X, Solaris Unix, RedHat 6/7/8 Linux platforms

Utilities: OEM, TOAD, SQL p lus, SQL developer, ADRCI, DBCA, ASMCA, DATAGUARD, SQL LOADER, Fusion middleware, Solarwinds monitoring tool, ServiceNow ticketing system and Microsoft Office suite.

Core Qualifications: Exceptional Database Managing skills Strong logical and analytical skills Excellent communication skills in written and verbal Extraordinary work ethic, able to prioritize work assignments appropriately and handle teh conflict resolution Team lead skills and Altruistic minded individual 24/7 On call support

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Washington, D.C

Responsibilities:

• Administered Oracle Enterprise Manager Cloud Control 12c and SolarWinds monitoring system to investigate alerts, generate performance metrics, and manage database processes.
• Strong skills in applying Oracle Security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), and (One - off Patch).
• Installed and configured Oracle Database Gateway for Microsoft SQL Server and created database link from Oracle production Database to Microsoft SQL server production database.
• Performed query optimization by setting SQL baselines, used SQL trace, TK Prof, SQLTXPLAIN (SQLT), and SQL health check tool.
• Analyzed execution plans to determine root cause and provided recommendations to application developers on poorly performing queries to resolve database performance issues.
• Maintained database security wif teh creation and maintenance of users, roles, profiles, and assigned privileges as needed.
• Prepared SQL scripts to monitor teh replication process of teh Primary and Standby databases, and send status email to teh DBAs to ensure dat issues of redo log gaps are detected quickly.
• Ran AWR, ADDM and ASH reports, SQL tuning advisor to resolve database performance issues
• Gatheird statistics and implemented SQL profiles, indexes, and materialized views to aid in query and code performance issues, as well as contention in teh databases.
• Implemented Point in time recovery using RMAN and database refreshes using data pump export /import and worked wif teh application team to ensure smooth life cycle progress from development through testing and production implementation.
• Disabled Oracle’s Automatic Memory Management (AMM) and worked wif Linux Admins to configure Huge Pages and Automatic Shared Memory Management (ASMM) on databases.
• Established and maintained backup and recovery policies and procedures.
• Ensured absolute database security for teh protection of application data from unauthorized access, adhered to strict compliance to privacy and regulatory requirements of teh department.
• Maintained database integrity and remediated security vulnerabilities by applying patches to OEM agents and performed checks using Tenable Security center.
• Scheduled overnight batch jobs using CRON and OEM, created shell scripts to monitor Data guard replication for physical and logical standby databases.
• Represents Oracle DBA team at change management meetings, daily 7:30am me.T. infrastructure operations call and provided RCA (root cause analysis), and translated technical information on database issues to teh Federal management team.
• Maintained Oracle WebLogic Server (WLS) 12cR2 (12.2.1), Oracle Forms and Reports 12c, moved and compiled Oracle forms and reports against DBs for developers as requested.

Oracle Database Administrator

Confidential Washington, D.C

Responsibilities:

• Configured database parameters (optimizer, memory, etc.) to achieve optimal performance
• Use various Oracle utilities to assist developers in tuning SQL statements wif teh goal of minimizing me/O as well as DB TIME.
• Provisioned Oracle Enterprise Manager Cloud Control 12c on an Oracle 11g EE database and deployed teh monitoring agents to ensure OFA Compliance.
• Worked wif stakeholders and PMO to achieve project goals in an AGILE work environment leveraging Multi-Cloud and Hybrid Environment architectures.
• Created functions, stored procedures, and triggers for production databases
• Implemented teh use of Oracle Recovery Manager (RMAN) and Oracle Recovery Catalog to back-up teh Database, using both Cold and Hot Backups.
• Revamped RMAN backup strategy to utilize merged Incremental Backups using Block Change Tracking feature .
• Managed teh RAC databases using various OS utilities such as srvctl, crsctl, asmcmd etc.
• Configured Java applications using JDeveloper to pair wif Oracle databases.
• Performed database refreshes by utilizing data pump (import/export) in different Oracle versions
• Performed quarterly patch analysis and applied patches to test, internal and external databases.
• Installation and Management of Oracle Database Using Grid and Database Control.
• Maintained/updated RESOLVER/PERSPECTIVE Security application.
• Monitored, Optimize and Allocate Physical Data Storage for Database Systems.
• Installed Oracle Grid Infrastructure (GI) and created ASM disk groups for disk redundancy.
• Performed bulk load into teh database using SQL Loader.
• Resolved issues wif Physical Primary and Standby databases using RMAN wif zero downtime, performed Switchover when required for high availability
• Used OEM to schedule jobs, monitor alerts in teh database, and manage various database processes.
• Tuned SQL queries for faster and better performance; also performed proactive database tuning.
• Managed Oracle database partitioning (Range, List and Composite).
• Documented database structure, changes, issues for key deployment procedures and future reference.
• Used teh Enterprise Manager Grid Control to monitor teh application server performance during application development, data loading, etc., so as to identify bottlenecks and resource usage of teh instance.

Oracle/SQL DBA

Confidential

Responsibilities:

• Performed Oracle 10g, 11g and 12c Database installation on Windows 2008 and Red Hat Enterprise Linux 5 and 6 Operating Systems.
• Performed database maintenance tasks and automated alerting processes for capacity planning and performance.
• Implemented and maintained database security wif teh creation and maintenance of users, roles, profiles, and assign privileges as needed in teh databases
• Successfully implemented a manual disaster recovery solution utilizing Oracle Database Software
• Monitored teh PL/SQL optimizer to rearrange codes for better system performance
• Scheduled backups, scripts, batch jobs, monitoring scripts, using Oracle Scheduler
• Used Gloden gate replication to create refresh group; setup master site and snapshot site for replication purpose, wif teh aid of setup wizard; setup teh snapshot group wif teh aid of teh snapshot group wizard
• Provided network troubleshooting and administrative support for staff development
• Setup TNS to ensure connectivity for Developers, Ensure data integrity wif constraints, Enabling archiving to prevent data loss, Covering data restore and recovery for Oracle 11g and 10g
• Initiated SQL script to create Tables, Indexes, Synonyms and Views to track Database movement.
• Served as a point of contact for escalated software and database issues
• Used scheduler to create automatic monitoring, schedule batch jobs, managing teh various processes, and monitor teh alert logs in teh Enterprise Manager Grid Control
• Performed Database Logical backup, using teh import and export utilities
• Troubleshooted, resolved, and analyzed teh root cause of some pending database related issues in teh enterprise environment, such as user account automatic locks, database instance crashes

Oracle Database Administrator

Confidential, Maryland

Responsibilities:

• Monitored and resolved tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored teh critical wait events, blocking sessions in teh database.
• Created users and assigned roles and database privileges to users as requested
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) Grid Control.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Data Pump, conventional export/import utility of Oracle for re-organizing Databases/Schemas/Tables to improve teh performance.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK
• Ensured overnight backups were successful to restore and recover databases if needed
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade on test and development from Oracle 10g-11g-12c
• Provided monthly and annual performance reports for trend analysis and capacity planning.
• Generated scripts for daily maintenance activity like analyzing teh tables/indexes, monitoring growth rate, monitoring teh TEMPeffective use of SGA.