SUMMARY

• Oracle Certified Professional with 26 years of experience in Oracle database. Being Oracle DBA for 22 years including 4 years with PeopleSoft, 4 year with SAP and 5 years with Oracle EBS; Proficient with SQL scripting and tuning
• Expert understanding of relational database design and data modeling; Enriched experience of VLDB and high availability environment; Solid understanding of Unix operating systems. Excellent abilities of database migration, administration, design, performance tuning.

PROFESSIONAL EXPERIENCE

Solution architect

Confidential, Atlanta, GA

Responsibilities:

• Ensure the availability, performance, integrity, and security of databases for Data Warehouse.
• Create physical standby databases and configured active data guard.
• Perform disaster recovery testing using data guard broker.
• Migrate databases to new data center using RMAN backup and Snapshot data guard.
• Apply quarterly Oracle database PSU. Perform database refresh using data pump.
• Troubleshoot and fix various ORA errors and corruptions.
• Deploy software releases using SQL*Developer. Troubleshot performance problems for ETL processes.
• Partition large table to improve the performance of front - end application and ETL processes.
• Install Oracle 12c/18c database software. Upgrade Oracle databases from 11.2.0.4 to 12c and 18c.

Sr. Oracle database administrator

Confidential, Suwanee, GA

Responsibilities:

• Create physical standby databases and configured active data guard for data warehouse and EBS database.
• Use data guard broker to switchover/switchback and snapshot data guard to flashback for DR testing.
• Implement tablespace encryption and range partitions.
• Restore and recover Oracle databases using RMAN.
• Install Oracle clusterware and RAC database on Red Hat Linux. Created Oracle RAC databases for EBS 11i/R12.
• Architect and perform Oracle EBS 11i/R12 database migration and upgrade
• Upgrade Oracle databases from 10.2.0.4 to 11.2.0.3 and migrated to new VMs.
• Perform SQL tuning and query optimization using explain plan, tkprof, SQL profile.
• Install and configured Oracle internet Directory to centralize SQL*Net configuration.
• Perform data analysis, data cleansing and develop data conversion processes using SQL and PL/SQL.
• Migrate database monitoring targets from OEM 10g and11g to OEM 12c.
• Use SQL*Developer Data Modeler to create logical and physical data model

Sr. Oracle database administrator

Confidential, Norcross, GA

Responsibilities:

• Lead efforts to implement database best practice, standards and procedures across the enterprise.
• Evaluate and deploy new technology to improve database efficiency and recoverability.
• Troubleshoot database issues and eliminates root causes through systematic approaches.
• Identify top CPU consumers or long running processes. Retrieve associated SQL statements for tuning.
• Optimize database performance by resizing SGA and tuning long running SQL.
• Design and implement partitioning to improve the performance in the data warehouse.
• Build physical standby database and configured data guard as disaster recovery solution.
• Drive changes to database architecture for performance improvement and efficient hardware resource allocation.
• Provide technical guidance on issues remediation and SQL optimization to the developers.
• Provide high level of technical expertise for the design, implementation, and management of Oracle databases.
• Ensure effective integration of new designs and optimal database performance.
• Perform RMAN backup and recovery. Refresh data using Oracle data dump export/import.
• Install and create Oracle 9i/10g RAC databases on Sun Solaris. Perform database upgrade and apply patches.
• Optimize performance of large batch processes. Perform tables and indexes reorganization to reclaim free space.

Oracle database consultant

Confidential

Responsibilities:

• Manage SAP R/3 4.6, BW 3.5, SAP ECC 5.0 and other Oracle databases for 6000+ worldwide users.
• Maintain high availability of databases using Oracle RAC and Data Guard/Standby databases.
• Install Oracle database 9i/10g software and apply the required patches.
• Troubleshoot Oracle errors, fine-tune database parameters, and analyze STATPACK reports.
• Utilize sapdba to manage Oracle database tablespaces
• Implement Oracle range/hash partitions to improve query performance.
• Configure SAP brbackup and brarchive with Legato NetWorker.
• Provide technical direction and leadership to a team of Oracle DBAs and Unix Administrators.
• Oversee and define technical strategy in the area of system architecture, capacity planning, and database upgrade.
• Establish enterprise database standard and best practices for backup/recovery, monitoring, space management.
• Lead IT engineering projects to re-design architecture, re-engineer infrastructure, and consolidate database servers.
• Design and implement 3-tier system architecture to reduce hardware costs and Oracle licensing fees
• Effectively manage Oracle database space allocation resulting in savings of hardware and maintenance costs.
• Monitor CPU usage, I/O contention, memory paging on Unix server. Identify resource and performance bottleneck.
• Evaluate and adjust Oracle database initialized parameters. Monitor and optimize database performance. Resolve all performance issues caused by historical Oracle architecture and application design.
• Install Oracle database and application server software. Perform upgrade and migrate of Oracle databases.
• Perform complete and incomplete database recovery. Plan and perform Disaster/Recovery testing.

Sr. Oracle database administrator

Confidential

Responsibilities:

• Maintain and support SAP R/3 and BW Oracle databases on Tru64 Unix.
• Maintain and monitor the physical layout of disk storage, tablespaces, datafiles, and object extents.
• Monitor cache hit ratio, I/O, lock, and latch contention. Diagnose and troubleshoot Oracle database issues.
• Evaluates init.ora parameters and makes necessary adjustments to optimize database performance.
• Monitors and analyzes Oracle trace files and alert log.
• Installs and upgrades Oracle database software. Applies patches to fix the Oracle bugs.
• Evaluates and designs SAP server architecture, system infrastructure and Oracle database architecture.
• Performs database recovery and troubleshoot failures of backup process.
• Creates and maintains Oracle standby database.

Oracle data architect/DBA

Confidential

Responsibilities:

• Created and configured Oracle database instances. Planned database capacity and designed database architecture.
• Created database objects, such as table, view, database link, synonym and trigger for application development.
• Performs Oracle database export/import, backup/recovery. Refreshed database with up to date information.
• Develops data conversion scripts and performs data analysis by using SQL and PL/SQL for PeopleSoft application.
• Leverages and consolidates existing technical architectures and infrastructure for PeopleSoft hosting.
• Created, configured and administrated PeopleSoft Process Scheduler and Application server.

Data Modeler

Confidential

Responsibilities:

• Install and manage Oracle Designer/2000 repository for designing and developing a customer information database.
• Perform logical data modeling and physical design by using Designer/2000 and complying with IBM IAA.
• Develop database triggers and stored procedures to implement business logic and ensure system integrity.
• Develop business process model, function hierarchy model, and Entity Relationship Diagram by using Designer/2000.
• Design and generate Oracle database and objects by using Designer/2000.
• Develop application by using Oracle Forms 4.5 and developing PL/SQL procedures and functions.
• Use Designer/2000 Module Data Diagram and Forms generator to generate entire application.

TECHNICAL SKILLS

Operating System: Red Hat, Windows, Sun Solaris, IBM AIX, Compaq Tru64 Unix, SuSE Linux, HP - UX 11

Programming Language: SQL, PL/SQL, SQR, Unix shell

Software and Applications: Oracle Developer, Peoplesoft 6.0, 7.5, SAP R/3, Oracle EBS 11i/R12

Database: Oracle DBMS v7, 8i, 9i,10g, 11g, 12c,18c

Database Utility and Tools: Oracle Enterprise Manager, SAPDBA, SQL*Developer, Data Modeler, ERWin

Data Modeling: Oracle Designer, IBM IAA, Oracle Data modeler, IBM Infosphere Data Architect, ERWin

Database Backup Utility: Oracle RMAN, SAP brbackup, brarchive, Legato Networker, NetApp snapshot