SUMMARY

• Talented Senior Level Oracle DBA with 10+ years of excellent analytical and problem - solving skills along with strong communication skill. I have the ability to manage multiple concurrent issues with minimal supervision & direction; including the ability to quickly learn and adapt to changes in database technology.
• Core DBA/Architect for Oracle Database Grid Infrastructure; upgrades/ migrations, standby disaster recovery site, advanced security strategy and RMAN backup and restore, recovery objectives, including Data Guard standby architecture, software implementation, testing, deployment and documentation
• Working knowledge of Agile SDLC process including JIRA
• Provide technical roadmaps and database solutions to better position the business to meet new technical and competition challenges.
• Implemented & maintains multiple production critical Oracle database Environments (11gR1,11gR2, 12c), including logical/physical design and Data modeling.
• Technical lead in system design with Oracle RAC and ASM; Capabilities to provide 24x7 High Availability (HA) solutions for Oracle Grid Infrastructure.
• Participate in 24x7 on call rotation including mgmt./cross training of off-shore DBAs.
• Experience with IBM AIX,HP-UX, RedHat/CentOS, eva SAN and NAS storage in conjunction with Oracle Database systems deployments.
• Provided performance tuning recommendations to application design team utilizing Oracle Grid Control.
• Implemented Oracle Data Guard for standby Disaster Recovery (DR) site
• Implemented Oracle RMAN backups to disk/tape (NetBackup/DDBoost data domains) and local disk storage (zff)
• Implemented and supported Oracle RAC local Data Center (7 Node Cluster) and 32 TB database size and 302 TB Data Warehouse DB on Oracle Exadata environment.
• Support Oracle technologies such as Oracle 11g RAC Clusterware, Oracle 12c, ASM, OEM 13c, and GoldenGate.
• Implemented Oracle Database 11g on HP Platform with xRAC (2 node Cluster)
• Implemented HP-UX Dual Inter-site extended distance 11g xRAC Cluster(s)
• Established Active-Active High Availability (HA) with no single point of failure (SPOF).
• Performed Oracle Systems Database Administration across multiple Oracle database environments and ensuring 24x7 operation and High Availability in support of mission critical production applications.
• Ensured the quality and consistency of data and database systems by following “best practice” procedures (change control, security procedures, user passwords, backups, etc.).
• Maintained sound RMAN backups and error recovery procedures by participating in periodic backup audits, ensuring all databases are being backed-up and validated
• Maintained the ability to provide support in database usage, and database performance.
• Pro-actively identifying and resolving database performance issues by understanding Oracle’s performance reports (AWR, ASH, ADDM) and Stats-Pack PL/SQL performance tuning.
• Assumed full ownership of database related problems; pursuing problem resolution and root cause analysis with My Oracle Support if necessary.
• Installing/configure Oracle 13c Cloud Control (OEM) monitoring and diagnostic tools to support the Oracle database ecosystem.
• Working with multiple Development teams to resolve technical performance issues/bottlenecks in a n-tier environment (e.g., network, SAN storage, Application, database)
• Ensuring the database environment SLA is highly reliable, providing the required functionality, is efficient, and cost effective; including installing, patching, upgrading and maintaining Oracle database Critical Patch Update (CPU) schedule.
• Providing DBA guidance on design and implementation, including SQL stored procedures, triggers, functions and schemas.
• Developing and maintaining the database configuration documentation and Entity Relationship Diagram (ERD) utilizing ERWIN data modeling toolset.
• Documenting problems and actions taken to resolve the problem, while keeping mgmt. fully updated on status eta.
• Participated in Tier 1 Data Center 24x7 on call rotation supporting 2 - 7 TB Oracle RAC databases including mgmt. of off-shore DBA resources.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA/RAC SME

Responsibilities:

• Provide technical database support to the business areas specifically in the database technology architecture and administration.
• Provide database support in all phases of SDLC
• Approve, schedule, plan and supervise the installation and testing of new products and improvements to enterprise data systems
• Installation Configurations of Oracle RAC, Grid and Databases 12c. With different methods of Database Deployments.
• Good in Sizing the Memory Structures for bigger databases.
• Patching of Databases PSU, CPU, one-off. In place patching, out of place patching.
• Upgrade of Database from 11g to 12c. and Migrations of 11g and 12c Databases.
• Creation, configuration and Management of Data guard and Data guard Broker
• Managing All protection modes of Data Guard Databases. Recovery of Primary from Standby Databases.
• RMAN backups, recovery and database clone/duplicate of production instance
• Golden Gate installation, Configuration and Management.
• Database Refreshes. Strong knowledge on basic concepts of RAC and ASM.Creation, configuration and Management of Oracle RAC, ASM.
• Strong knowledge on Database and PLSQL Performance tuning.
• Good in interpreting AWR and ADDR, TKPROF and Explain Plan reports.

Confidential

Sr. Oracle DBA/RAC SME

Responsibilities:

• Work closely with various teams and organizations within the company including DBDEV, and off-shore team members, NOC, project managers, and platform and application support teams.
• Install and document Oracle RAC database Migrations, clones and upgrades, etc.
• Respond to critical alerts and resolve production issues within a set SLA.
• Performing administrative DBA duties as assigned/required.
• Actively monitor the Oracle platforms to increase efficiency, improve reliability, and minimize operating expenses and ensure minimum downtime.
• Provide technical roadmaps and database solutions to better position the business to meet new technical and competition challenges.
• Support Application Release Mgmt upgrades and apply security database patches as required.
• Perform database administrative procedures using the latest tools and technologies.
• Oversees project reporting using: project management, budgeting and financial tracking controls.
• Monitors the performance of databases and makes tuning changes/recommendations.
• Oversees ongoing system capacity planning, forecasting and DB tuning.
• Provide 24 x 7 database support services. Including a fter hour and weekend support as required.

Confidential

Sr. Oracle DBA

Responsibilities:

• Database performance monitoring utilizing Oracle 12c Cloud control.
• Providing best practice procedures to IT staff members as the subject matter expert for everything Oracle.
• Discussing Oracle License and Support agreement for renewal and recommending database option such as Oracle’s Advance Security Option (ie. data encryption to address HIPPA security requirements )
• Responding to IT Help desk follow-up tickets when end users have system issues.
• Providing AWR, ASH and ADDM Reports for root-cause analysis of performance issues.
• Working with 3rd party Application Vendor during change control to maintain a stable system, by following best practices.
• Installation of Oracle unbreakable Linux, SAN storage allocation of LUNs for ASM and deployment of Oracle databases for new projects.
• Daily Database Backup to ASM & local disk and data guard active recovery of production archive logs to the DR-site standby database, to support the DGA Business Continuity plan.
• Performing test restore of RMAN backup to insure backups are validated.
• Apply Linux OS patches and Oracle database Critical Patch Updates to support Oracle security alert recommendations for bug fixes and enhancements.
• Maintain DEV/QA/Test instance environment with refreshed data from Production data
• Plan UNIX Server task for H/W outages with little to no down time.

Confidential

Oracle DBA Consultant

Responsibilities:

• On-site Oracle Subject Matter Expert (SME) to address client database system issues.
• Oracle 10g RAC installation, configuration and administration Oracle Database Administrator requiring complete understanding of Data center concepts - storage (Hitachi), server (Sun), and Networking concepts
• Oracle Enterprise Manager configuration and monitoring activities.
• Utilized UNIX shell scripting to automated DBA task.
• Complete understanding of HA/DR concepts - basic concepts and use of Symantec technology for backups" was necessary to communication to client business risk, moving forward with system changes.
• Reviewing alert log, trace files and EM alerts on a daily basis to follow-up on critical issues and opening TAR with My Oracle Support if necessary.
• Implemented & maintain multiple Oracle database environments, including logical/physical design and data modeling
• Participate in 24x7 on call rotation including mgmt. of off-shore DBAs
• Experience with SAN and NAS storage in conjunction with Oracle Database systems