PROFILE:

• Oracle Production/Application DBA with 3 - 4 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: 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, Virtualization, 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:

Oracle Apps DBA

Confidential, Irving, Texas

Responsibilities:

• Provide support for 2 Oracle 12.1.0.2 and 12.2.0.1, RAC databases in DR env utilizing ASM, on R.H. Linux; dbs. size- 1.0TB to 10TB in Dev, Test, QA, Staging & Prod
• Monitor & support DG env using OEM 12c; develop & implement replication, archiving, backup and recovery strategies (DR Failover testing capabilities).
• Heavily involved in tuning tasks, proactively & reactively monitor, troubleshoot env using TOAD, OEM, Explain/Execution plan/AWR/ASH/ADDM to enhance performance
• Participate in backup, recovery, cloning utilizing import/export (Data Pump), Incremental backups, flashback, DBPITR, full recovery ( RMAN), RMAN DUPLICATE etc
• Use Partitioning at table/index level for more manageability, availability/ performance
• Supported/Performed Upgrades, DBUA/In-place Upgrades & Patches / O’Patch
• Involved in planning of hardware and storage requirements capacities for Dev, Test, QA, Staging, and Prod for scalable database growth and performance.
• Supported, implemented, researched, tested, installed vendor/internally developed apps
• Created & ran installation scripts; built tables, inserted data for new apps and upgrades
• Manage database security by performing user account management and server security management. Kept abreast of current database vulnerabilities & recommend/implement solutions to protect organization data per best practices.
• Wrote shell(korn/bash) scripts to automate routine work like backups and refreshes
• Participate in Change Management and Lifecycle Management processes
• Participate in primary and back up 24x7 DBA on-call rotation schedule

Oracle DBA

Confidential, Huntersville, NC

Responsibilities:

• Provide support for 3 Oracle 11.2.0.3/4 and 12.1.0.2, RAC/single instance DG databases utilizing ASM, on R.H. Linux; dbs. size- 1.0TB to 10TB in Dev, Test, QA, Staging & Prod
• Set up, configure, monitor & support DG env using OEM 12c; develop & implement replication, archiving, backup and recovery strategies (DR Failover testing capabilities).
• Participate in, monitor, support heavy data migration between data centers in DG env
• Proactively & reactively monitor, troubleshoot, tune, implement HA strategies in a 24x7 support/production env using TOAD, OEM, Explain/Execution plan/AWR/ASH/ADDM
• Participate in backup, recovery, cloning utilizing import/export (Data Pump), Incremental backups, flashback, DBPITR, full recovery ( RMAN), RMAN DUPLICATE etc
• Use Partitioning at table/index level for more manageability, availability/ performance
• Maintain database environments such as Upgrades, Patches, utilizing DBUA (In-place Upgrades) /Data Pump Migration, and OPatch to ensure protection against vulnerabilities.
• Utilize SQL*Loader to load data in flat files from DB2 into Oracle
• Manage database security by performing user account management and server security management. Kept abreast of current database vulnerabilities & recommend/implement solutions to protect organization data per best practices.
• Wrote shell(korn/bash) scripts to automate routine work like backups and refreshes
• Participate in Change Management and Lifecycle Management processes

Oracle DBA

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/ single instance DG databases on ASM, running on ABM AIX and Red Hat Linux platforms; database size-0.7 TB - 4.1 TB, configured, installed, supported Data Guard
• In SDLC, supported Apps in Dev, Test, QA & Prod and performed application upgradation;
• Used ERWIN Data Modeler for designing, building & implementation of conceptual, logical & physical data models, schemas in enterprise environment per RDBMS concepts
• Supported, implemented, researched, tested, installed vendor/internally developed apps
• Created & ran installation scripts; built tables, inserted data for new apps and upgrades
• Traced user sessions; leveraged AWR/ASH/ADDM, OEM/TOAD (SQL Monitoring and Tuning Advisor), Partitioning for query (SQL) optimization tasks
• Trouble shooting skills include problem triage, analysis, recommendation/root cause
• Applied scheduled PSU/CPU & one-off oracle patches; upgraded databases with DBUA
• Conducted security audit vulnerability assessments and remediate flagged flaws/ensuring database security through managing of profiles, roles, privileges etc
• Involved in high-level design (HLD/low-level design (LLD) of projects with db impacts
• Involved in planning of hardware and storage requirements capacities for Dev, Test, QA, Staging, and Prod for scalable database growth and performance
• Wrote shell(korn/bash) scripts to automate routine work like backups and refreshes
• Utilized GoldenGate to replicate - unidirectionally - forty-six (46+) tables from the IBM DB2 mainframe customer database to an Oracle 11.2.0.4 reporting database running on AIX.

Oracle Application DBA

Confidential

Responsibilities:

• In SDLC, installed, configured and supported the sandbox in Dev, Test, and QA, Oracle 10g & 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
• 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/DBArtisan for monitoring, tuning, scheduling, reporting and admin tasks
• Create and run installation scripts; build tables, insert data for new apps and upgrades
• Performed Upgrades/Patches, migrated objects/schemas between env and tuned bad queries
• Used WebEx/GoToMyPC to troubleshoot/resolve network related issues via phone/remotely

Business Analyst

Confidential

Responsibilities:

• Assisted in the planning and the target state design of the operating model:
• Worked closely with business teams to identify key functional processes across the firm.
• Gathered & translated business requirements to functional requirements & into system
• Assisted in consultant relationships, identified issues, structure problems & generated actionable recommendations using formal problem-solving frameworks & critical thinking
• Supported weekly status reports, Steering Committee(Steerco)reports, Group interactions
• Participated in creation of presentations to senior management, in clear, structured formats
• Assisted in broad project planning requirements; lay out a project plan with direction from appropriate business area stakeholders, as necessary
• Managed ambiguity, complex subject matters and concurrent deliverables
• Delivered data extracted from the work schedule to proactively manage issues/risks
• Participated in SharePoint migration project from legacy (Lotus) to SharePoint platform
• Utilized tools like Jira, Visio, TFS, Six-Sigma methodology, Microsoft Office

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.