PROFILE:

• Oracle Production/Application DBA with 5 - 7 years of extensive experience supporting next-generation oracle database solutions on a multi-platform, integrated IT environment
• Rich hybrid of process improvement and service delivery optimization experience
• Strong business acumen, communication skills and ability to effortlessly interface and build rapport with technical and non-technical users.
• Multi-lingual: Fluent in English, French & Dutch

KEY COMPETENCIES:

SQL Optimization

Oracle RAC (HA solution)

Capacity Planning & Monitoring

Oracle Data Guard (DR Solution)

RMAN Backup & Recovery

OEM Grid Control

Partitioning

Advanced Compression

Business Communication

Agile (SCRUM) Methodology

EXPERT IT SKILLS:

Databases: Oracle 12c/11g/10g, SQL Server 2008, MS Access

Methodologies: Structured Analysis/Design

RDBMS Tools/Technologies: OEM, Toad, DBArtisan, SQL*Plus, RMAN, DGMGRL, EMCTL, SRVCTL, ASMCMD, Golden Gate, Oracle streams, TCP/IP Protocol

Office Applications: MS Office 2013 - Access, Excel, Word, Power Point, Project

Hardware: IBM AIX pSeries with the 47 GHz PowerPC POWER7, Sun Fire V880, EMC Data Storage devices

Data Models: ERD, Logical/Physical

Operating Systems: UNIX (AIX, Sun), Red Hat Linux, Windows

Languages: SQL, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Responsibilities:

• Provided database support for three (3) production Oracle 11.2.0.3/4 and 12.1.0.2 three-node RAC and single instance DG databases running on AIX and Red Hat Linux platforms; the databases ranged in size from 0.7 TB - 4.1 TB.
• Supported Oracle multi-versions (10g,11g,12c) in Dev, Test, QA & Prod; performed database/grid infrastructure upgradation from 11.2.0.4 to 12.1.0.2.
• In SDLC, supported Applications in Dev, Test, QA & Prod and performed application upgradation; Upgraded MAXIMO, an IBM-owned application from v7.5 to 7.6.1
• Leveraged TOAD and OEM heavily for administrative, monitoring, scheduling, and query (SQL) optimization tasks
• Traced user sessions and utilized AWR/ADDM/ASH reports for tuning
• Trouble shooting skills include problem triage, analysis, recommendation and root cause
• Wrote shell (korn and bash) scripts to automate routine work like backups and refreshes
• Conducted security audit vulnerability assessments and remediate flagged flaws
• Utilized a variety of tools - OEM, EMC TimeFinder, RMAN, Data Guard, Data Pump, UNIX shell scripts - to backup, refresh/clone databases
• Leveraged AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports
• Routinely applied scheduled PSU/CPU and one-off oracle patches to and upgrade databases using DBUA
• Utilized SQL*Loader to load data in flat files from DB2 into Oracle
• Participated in primary and back up 24X7 DBA on-call rotation schedule
• Participated in the high-level design (HLD) and low-level design (LLD) of projects with database impacts
• SME on partitioning and advanced compression techniques

Oracle DBA

Confidential

Responsibilities:

• Installed, configured and administered Oracle 10g and 11g Development, Test, QA, and Pre-Prod single instance and RAC (two-node) databases on Red Hat Linux platform
• Supported Change Management processes by migrating changes between environments
• Wrote shell scripts, took backup and recoveries using RMAN and Data Pump utilities
• Analyzed the execution plans generated by optimizer and replaced bad plans with historical execution and improved performance of sql running on databases
• Worked with the Network team during OEM configuration to define ports in the firewall to enable traffic between the Oracle Management Server (OMS) and the Oracle Enterprise Manager (OEM) agent
• Heavily utilized OEM/TOAD for monitoring, tuning, reporting & other admin tasks
• Reviewed and optimized SQL and PL/SQL code for and from developers.
• Tested, assessed and recommended alternative processes, procedures and tools to streamline operations and provide a more efficient database environment

Jr. Oracle Application DBA

Confidential

Responsibilities:

• Installed, configured and supported the sandbox, development, test, and QA Oracle 10g and 11g R2 databases running on Sun Fire V880 servers for the Loan Solutions, group
• Planned backup/restoration strategy; scheduled physical backups using RMAN and logical backups using Data Pump in OEM and cron
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.
• Troubleshoot various Database instance tuning issues and maximized performance.
• UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc
• Utilized OEM and DBArtisan for monitoring, administrative, reporting and tuning tasks
• Migrated objects/schemas between environments and tuned bad queries

IT Support Specialist

Confidential

Responsibilities:

• Managed user accounts, network access and file permissions using DOS & UNIX utilities
• Created profiles, users, roles and assigned privileges as per the requirement.
• Installed newly built and re-imaged desktops/laptops in offices
• Built test cases and performed software testing prior to release.
• Troubleshoot and resolved network related issues over the phone and remotely via WebEx/GoToMyPC