CONSULTANT NAME
(Oracle DBA)
SUMMARY
| Six plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.
|
| Performed Oracle 8i/9i/10g software and database installation and upgraded various versions.
|
| 5.0 + Years of professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of ERP (Oracle Applications 11.5.10.2/9/8) on 8.x/ 9.x production database |
| Experience in administering, tuning and monitoring database using Toad, OEM |
| Designed strategies for performing database backups and recovery
|
| Debugging with procedures, Function, Triggers, Packages and other PL/SQL objects
|
| Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask |
| 24x7 on-call Production support fordatabase activities. |
TECHNICAL SKILLS |
Databases: | Oracle 8i / 9i / 10g, SQL Server,MS Access |
Operating Systems: | UNIX, Windows NT/2000 |
Programming Languages: | PL/SQL, UNIX Shell Script |
Database Tools: | Toad, OEM, DBA Studio |
ETL Tools: | SQL Loader, Erwin |
Version Control Tools: | Visual Source Safe |
Telnet Tool: | Putty, Hummingbird Connectivity (9.0) |
PROFESSIONAL EXPERIENCE
Client Name |
From Date - To Date |
Oracle DBA |
Project : Maintenance and support for oracle 7/8i/9i/10g databases.
Responsibilities:
| Supporting more than 40 instances. |
| Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
|
| Automated hot backups using a combination of incremental, differential and full RMAN backups.
|
| Maintaining archive data on appropriate storage devices.
|
| Tracing, troubleshooting with database performance and tuning issues.
|
| Export/Import of oracle databases. |
| Tuning SQL queries. |
| Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
|
| Analyzing and validating database objects.
|
| Coordinating with team members. |
| On call support 24x7. |
Environment: Oracle Server 7.0.3/8i/9i/10g, SQL Server, HP –UNIX, AIX, Sun OS, Clarify, SPIN, Business objects.
Client Name |
From Date - To Date |
Oracle DBA |
Project: Maintenance and support for oracle 8i/9i databases.
Responsibilities:
| Supporting more than 30 instances. |
| Installing 9i database. |
| Upgraded oracle 9i /10g. |
| Extensively worked on Real Application Cluster (RAC).
|
| Creating stand by database. |
| Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
|
| Automated hot backups using a combination of incremental, differential and full RMAN backups.
|
| Maintaining archive data on appropriate storage devices.
|
| Tracing, troubleshooting with database performance and tuning issues.
|
| Export/Import of oracle databases.
|
| Tuning SQL queries.
|
| Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
|
| Analyzing and validating database objects.
|
| Coordinating with team members.
|
| On call support 24x7. |
Environment: Oracle Server 9i/10g, Sun OS, FLS
Client Name |
From Date - To Date |
Oracle DBA | |
Project: Brodvision Maintenance and support for oracle 8i/9i databases.
Responsibilities:
| Installing 9i database.
|
| Upgraded oracle 9i /10g.
|
| Creating stand by database.
|
| Extensively worked on Real Application Cluster (RAC).
|
| Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
|
| Automated hot backups using a combination of incremental, differential and full RMAN backups.
|
| Maintaining archive data on appropriate storage devices.
|
| Tracing, troubleshooting with database performance and tuning issues.
|
| Export/Import of oracle databases.
|
| Tuning SQL queries.
|
| Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
|
| Analyzing and validating database objects.
|
| Coordinating with team members.
|
| On call support 24x7. |
Environment: Oracle Server 8i / 9i / 10g, Sun OS, Broadvision 7.1
Client Name |
From Date - To Date |
Oracle DBA |
Project : Upgrade from oracle 8i to oracle 9i
Responsibilities:
| Installing 9i database.
|
| Upgraded oracle 8i to 9i.
|
| Provided and implement the DR solution.
|
| Used Oracle Dataguard tool for creating the standby database.
|
| Automated the process of oracle backup. |
| Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
|
| Tracing, troubleshooting with database performance and tuning issues.
|
| Export/Import of oracle databases.
|
| Tuning SQL queries.
|
| Maintaining archive data on appropriate storage devices.
|
| Analyzing and validating database objects.
|
| Coordinating with team members.
|
| On call support 24x7. |
Environment: Oracle 8i/ 9i, Windows 2000 Advanced server
Client Name |
From Date - To Date |
Oracle DBA |
Project: Maximo Management System
Responsibilities:
|
Installing ORACLE 8i Server and application tools.
|
| Allocating system storage and planning future storage requirements for the database.
|
| Involved in writing stored procedures/functions as per requirements.
|
| Maintaining archived data on appropriate storage devices.
|
| Controlling and monitoring user access to the database.
|
| Database performance and tuning issues.
|
| On call support 24x7. |
Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, Toad, Windows NT Maximo 4.1.
Client Name |
From Date - To Date |
Oracle DBA |
|
Project : Payroll Management System
The project involves maintaining the monthly payroll of employees of a company & handles the following functions. Maintaining the employee attendance, recording daily working hours, Calculation for standard deduction & net salary.
Responsibilities:
| Study and Analysis of Business requirements
|
| Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.
|
| Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client
|
| Was involved in database design and implementation.
|
| Participated constructively to help and enable team members with their challenges
|
| Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases.
|
| Involved in end-user training and creating user manual document |
Environment: Oracle 8i, Forms 4.5, Windows NT, HP - UNIX
EDUCATION
Degree from Ozmania University - 1996
CERTIFICATIONS
Oracle 9i DBA Track
PLEASE LEAVE YOUR COMMENTS BELOW
|