Oracle DBA Resume Samples

Description :

1. Installation of Oracle 11g databases in production, development and test environments depending on project requirements.
2. Maintain and support Oracle 11gr1, 11gr2, 12c rac, physical and logical standby database for test, development, and production for various home-developed applications involve in 24x7 on-call support for 12 databases of 2. 0 TB 4 node production 10g and 11g RAC databases using Oracle 12c cloud control for alert monitoring and notification upgrade dbs from 11. 2. 0. 4 to 12. 1.
3. Setting and managing user management, space management granting required privileges to users.
4. Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
5. Refreshing dev and test instances with data from production on a regular basis.
6. Creating and assigning appropriate roles and privileges to users depending on the user activity.
7. Defragmentation of tables and indexes for improved performance and effective space management.

Experience

7-10 Years

Level

Management

Education

Business Management

Description :

1. Managed container and pluggable databases cloned 12c database performed incremental backups using recovery manager.
2. Created a recovery catalog, performed the complete and incomplete recovery using RMAN.
3. Installation of 3 nodes 10g racon Linux & Solaris with Veritas cluster.
4. Audit database performance using add reports, awr snapshot, and diagnostic SQL scripts.
5. Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
6. Controlled migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
7. Database and ERP system maintenance including service request, patches, clone, migration, and upgrade, etc.

Experience

7-10 Years

Level

Management

Education

B.Sc in Electronics

Description :

1. Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
2. Install setup and configured oracle enterprise manager cloud control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM grid control 11g/12c.
3. Troubleshooting errors using Clusterware logs and patching 11g and 12c RAC environments involved in upgradation of databases from 11. 2. 0. 4 to 12c in QA and dev environments.
4. Implemented asm on rac and standalone databases and managing disks and disk groups.
5. Monitored and performed database sizing, transaction management and security administration data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
6. Experience in handling multi-terabyte database migrations/consolidations with minimum/no downtime.
7. Experienced with all facets of oracle dba day-to-day activities like production, database monitoring, backup & recovery using RMAN, cloning, troubleshooting production issues, and physical database design.

Experience

5-7 Years

Level

Consultant

Education

Oracle DBMS

Description :

1. Created a recovery catalog, performed the complete and incomplete recovery using RMAN.
2. Wrote scripts for backup of databases, maintenance of archive logs for databases.
3. Streamlined backup procedures and implemented rman for backup and disaster recovery.
4. Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current Oracle configuration, capacity, and oracle outstanding tasks.
5. Developed, revised and implemented policies, standards, procedures, and guidelines necessary to effectively administer the database environments.
6. Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the optimal flex architecture.
7. Provided instance-level performance monitoring and tuning for event waits, sessions, physical and logical io, and memory usage.
8. Monitoring the scheduled backup procedures for daily basis using crontab.
9. Used power designer, e/r studio for data modeling and to estimate the database size, database design reviews.

Experience

7-10 Years

Level

Management

Education

Bachelor of Science

Description :

Experience

0-2 Years

Level

Junior

Education

Bachelor in Computer Science

Description :

1. Monitoring health checks of OCR, voting disks and interconnect for better performance and troubleshooting issues in RAC environment (11gr2).
2. Worked on active data guard and performed troubleshooting data guard environment.
3. Applied patch set and interim patches whenever required to make the database software up to date.
4. Migration of databases from 10g to 11g using export/import and data pump export/import utilities.
5. Monitoring day-to-day backups, log's & recovering them as per the requirement.
6. Weekly data refresh from production to development and test environments using data pump export/import.
7. Providing application support for performance and database related issues.

Experience

7-10 Years

Level

Management

Education

Bachelor of Technology

Description :

1. Performed upgrades, bug fixes, enhancements, and regular maintenance to the system by researching, planning, as well as applying patches to databases and e-business suite to keep them up-to-date.
2. Effectively decrease ogg lag by using various technical methods such as database tuning, ogg parameter tuning, application large table re-design, linux/unix kernel performance tuning.
3. Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data installation, configuration, and maintenance of Oracle 10g and 11g database on oel.
4. Supported more than 130 production and development databases upgraded the oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
5. Monitoring day-to-day backups, log's & recovering them as per the requirement.
6. Successfully implemented backup & recovery using rman, hot and cold backups.
7. Implemented data guard with maximum availability, protection and performance configurations and worked with data guard failover and switch over cases at the times of up gradation and migration.
8. Managed and monitored the Oracle real application cluster (2 node RAC) running on Veritas storage.
9. Performed zero downtime database data center migration using golden gate and data guard.

Experience

2-5 Years

Level

Executive

Education

BS in Computer Engineering

Description :

1. Design data security and/or backup/recovery programming specifications that meet security requirements.
2. Create and maintain appropriate documentation as it relates to database creation/implementation.
3. Work simultaneously with other departments and/or outside contractors to resolve system production problems.
4. Participate in, and may facilitate technical review meetings with the team and/or customer as required.
5. Maintain industry knowledge and participates in technical training as recommended or required by the manager.
6. Installation and configuration of the golden gate for replication and resolve issues to sync databases performed disaster recovery exercises for databases/application servers/f5 big IP devices/network switches/tsm database recovery at a SunGard facility.
7. Setup golden gate replication during database migration from Unix to Linux server. Analyze database requirements for developers and business systems analysts

Experience

2-5 Years

Level

Executive

Education

Human Resource Management

Description :

1. Provided mentoring, guidance and general oversight to less experienced staff in a variety of database design and administration concepts and issues.
2. Developed shell scripts for Oracle DB, session, process, deadlock, file system monitoring, free space in the tablespaces, free space in ASM disk groups and free disk space in archive log destination for production databases.
3. Expertise in the identification and resolution of database availability and performance issues in a timely manner.
4. Performed real-time application testing by capturing database workload on production servers and replayed on development/test servers.
5. Devised and implemented strategies for database backups and recovery using RMAN.
6. Performed troubleshooting for configuration related problems in the Oracle RAC environment for Oracle Clusterware, ASM, and rac.

Experience

5-7 Years

Level

Consultant

Education

M.Sc. in Environmental Management

Description :

1. Perform databases related tasks such as running scripts, checking daily backup status, etc.
2. Designed and developed a backup/recovery strategy and procedures for several Oracle 10g/11g and SQL server databases.
3. Involved in the database audit process, working with an audit team, running different scripts and explaining them the roles of users.
4. Configured and maintained rac clusters on both asm and non-asm file management involved in upgrading data warehouse database version from 10g to 11g.
5. Implemented Oracle failsafe to setup RAC environment on windows platform.
6. Involved in user management, creating new user ids, assigning them roles and privileges, monitoring their activity.

Experience

7-10 Years

Level

Management

Education

BS in Information Systems