Onshore Lead Oracle DBA Resume Saint Louis, MO - Hire IT People

SUMMARY

Has over 8.6 years of experience in Planning, Installation, Implementation, Managing and Tuning the Oracle Databases as a Lead Oracle Database Administrator.
Experienced in Installation of Oracle 9i/10g and Oracle11g databases.
Migration of Databases from any Lower Versions to Higher Versions.
Patch Application to Installed Oracle Releases which include Rolling Patch In case of RAC.
Experienced in Planning and Implementing the Backup strategy using Hot backup, Cold backup and RMAN.
Knowledge in data replication techniques such as Data Guard, Golden Gate.

TECHNICAL SKILLS

Languages: SQL, Shell Scripting, C, C++, Java

RDBMS: Oracle 9i/10g/11g/12c

IDE Tools: Toad, SQL Developer, Edit Plus, Notepad++

Operating Systems: Windows, UNIX, Linux, Hp - Ux, IBM-AIX.

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Onshore Lead Oracle DBA

Responsibilities:

Administered Sun Solaris/Linux systems.
Developed UNIX shell and SQL scripts for database monitoring.
Performed database tuning.
Defragmentation of tables and indexes for improved performance and effective space management.
Database backups and recovery.
Creating and assigning appropriate roles and privileges to users depending on the user activity.
Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
Participated in go live and provide technical support.
Performed analytics against Oracle RDBMS Workload Repository Data to proactively diagnose database performance problems.
Managing & Maintaining RAC Database.
Monitoring above 25 databases and Troubleshooting the errors, archive and space management for all the databases.
Managing profiles, user accounts, password policies.
Involved in Issue resolution, User communication and interactions and regular support activities.

Environment: Oracle 11gR2, 12c,OEM 12c Cloud Control,, TOAD, RMAN, Data guard, AIX 6.1, RHEL, RAC, ASM, SQL Developer, PL/SQL, Golden Gate.

Confidential

Oracle DBA

Responsibilities:

Participated in go live and provide technical support
Configure RMAN parameter value as needed.
Register Target database in Recovery Catalog database.
Create appropriate users, assigning roles and profile.
Modify physical structure of Oracle Database.
Checking network issue and troubleshooting.
Export and Import of Oracle Database.
Taking Daily, Monthly & Weekly Oracle Database backup on Tape using Symantec Backup Tool.

Environment: Oracle11G,OEM 11g grid control, LINUX, IBM AIX, TOAD,SQL Developer, TKPROF, SQL Tuning.

Confidential

Oracle DBA

Responsibilities:

Analysis of the specifications provided by the clients
Created and migrated database from the current PROD RMAN backup
Install Oracle Base software (10.2.0.1) using silent install
Apply/Install Upgrade patch for Oracle Database (10.2.0.4 ) using silent install
Listener Installation and thorough testing of environment setup, etc.
Participated in go live and provide technical support.

Confidential

Oracle DBA

Responsibilities:

Performed SQL tuning by using Explain Plan and Tkprof.
Making structural changes to the databases when database design changes are to be implemented.
Implementation and maintenance of read only snapshots and snapshot logs.
Refreshing development/test database from production using Export/Import.
Developing UNIX shell scripts and SQL scripts to carry out routine checks on databases.
Experience in using repositories including AWR, ADDM.
Upgraded the data’s from Existing Oracle 9i to Oracle 10g.

Environment: Oracle database 10g (10.2.0.4), Redhat4, HP-UNIX 10.0, RAC,TOAD,ASM,OracleEnterprise Manager,Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential

Oracle DBA

Responsibilities:

Load data into Oracle Database using Sql Loader.
Implement Index Strategy to improve performance of SQL queries.
Write complex Queries (based on Join, Inline view & order by).
Handle Predefine & user define exceptions.
Developed Management Report in SQL & scheduled using crontab.
Use shell scripts in project.
Understand & implement Execution Plan & Performance Tuning concept to
Perform daily business related data correction, and help business user with day to day tickets/items.
Worked with users during UAT to ensure smooth functioning of the project..
Worked proactively to provide appropriate root cause analysis for recurring problems to avoid issues in the applications.

Environment: Oracle10g, RAC,TOAD,ASM,OracleEnterprise Manager,Network ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential

Database Support Engineer

Responsibilities:

Maintain and Support MySQL Database
As a member MySQL database operation Team of production support, responsible for all system level DBA tasks which include general administration and backup recoveries.
Performed the DB cloning from PROD to DEV.
Participated in go live and provide technical support
DBA maintenance tasks in the form of adding datafiles to tablespaces, resizing the datafiles.
Maintained Development databases, Test databases and applied Patches

We provide IT Staff Augmentation Services!

Onshore Lead Oracle Dba Resume

Saint Louis, MO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship