Oracle Database Administrator Resume Samples

Description :

Experience

5-7 Years

Level

Consultant

Education

Bachelor in Economics

Description :

1. Installation and configuration of 12c container databases on standalone servers and cluster on windows and unix platforms.
2. Upgraded multiple single instance databases and grid infrastructure from 11gr2 to 12cr1.
3. Worked on new features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c databases.
4. Experience in troubleshooting RAC databases and engaging with the application team for gaining performance enhancements for application in a clustered environment.
5. Applied psu on standalone test environment using opatch and same psu(grid and rdbms patching) on production cluster using opatch auto.
6. Supported in performing goldengate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
7. Implemented physical standby databases on 2-node 11gr2 real application cluster and automized scripts to delete archive logs that already applied to standby.
8. Duplicating tablespaces and databases from a production server to test server as per customer requirement.
9. Involved in datacentre migrating large size database in multiple platform.

Experience

7-10 Years

Level

Management

Education

Bachelor of Science

Description :

1. Performed replication using materialized views with a complete refresh/fast refresh.
2. Development of policy and procedures as they relate to database maintenance, security and archiving.
3. Providing support to the development team and handling release schedules.
4. Maintaining sound backup and recovery policies and procedures using rman.
5. Monitoring the scheduled backup procedures for daily basis using crontab.
6. Creating, granting and monitoring user access rights and privileges through roles and profiles.
7. Providing instance level performance monitoring and tuning for event waits, sessions, physical and logical io and memory usage with the help of awr and addm reports.
8. Applying upgrade patch, maintenance and interim patches on all the databases.
9. Refreshing dev and test instances with data from production on a regular basis.

Experience

7-10 Years

Level

Management

Education

Computer Engineer

Description :

1. Setup auditing/oracle transparent data encryption (tde) for security management.
2. Tuning and troubleshooting databases (improving existing sql and pl-sql code, creating triggers, procedures, and packages) - tuning instances for optimal performance.
3. Tuning database for better performance using awr/addm/oem report and manual scripts.
4. Use dbms_sqltune, dbms_sql_monitor packages for real-time sql monitoring.
5. Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability involved in installation/configuration/maintenance of oracle rac/asm databases and troubleshooting rac performance issues.
6. Troubleshooting replication, etc, and other Oracle-related issues and implementing resolutions.
7. Performing day-to-day database administration tasks including installation, upgrades, backup/recovery, monitoring, disaster recovery procedures (switchover/failover) and database cloning across environments, patching.
8. Diagnosed sybase server problems like long running transactions, blocking processes then resolved and reported them as appropriate.
9. Performed troubleshooting, scheduling, monitoring and execution of sybase database activities in cron jobs.

Experience

5-7 Years

Level

Consultant

Education

Diploma

Description :

1. Supporting multiple databases for production, development, test and staging purposes on sun Solaris and Windows environments.
2. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
3. Implemented dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for a production database.
4. Installing Oracle golden gate on rhel and setup table level replication as well as ddl replication too.
5. Migrate database across different servers and platforms using transportable tablespaces and data pump export/import and perform database refresh and RMAN cloning.
6. Planned and implemented disaster recovery solutions using Oracle standby database/data guard and performed data replication using golden gate technology.
7. Rebuild indexes, table partitioning, tuning memory usage and SQL tuning using explain plan, SQL trace, tkprof and statspack for best performance.
8. Automated the data replication process using materialized views for reporting databases.

Experience

7-10 Years

Level

Management

Education

Bachelor in Physics

Description :

1. Cluster-wide resource management such as create resource plan, service configuration, parallel instance group, application isolation.
2. Installation and creation of 11g databases for testing & development on both IBM-Aix and the linux environment in OLTP, decision support system data warehousing environment.
3. Data refresh of large production data warehouse environment to setup test, development environments using san level storage mirroring: gold image copy and cloning.
4. Work with Oracle data pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
5. Management of schema objects, partitioning of tables & indexes and performing sqlloader jobs for loading data from flat files (ETL) and Oracle database monitoring, troubleshoot and resolve the issues.
6. Monitoring growth of tables and undertaking necessary re-organization of a database, capacity planning.
7. Designed the logical and physical database structure and involved in logical, physical data modeling.
8. Provide support to developers to enhance their SQL, Pl/SQL code and responsible for setting up new user accounts, schema deployments, and related user administrative tasks.

Experience

7-10 Years

Level

Management

Education

Computer Engineer

Description :

1. Monitored different databases and application servers using oracle enterprise manager 10g grid control.
2. Design, document, implement and maintain all disaster recovery procedures which result in no data loss.
3. Provided assistance to memory corruption and dictionary corruption errors.
4. Database tuning by generating explain plans for long-running queries, creating indexes on columns to improve performance.
5. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
6. Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.
7. Perform daily monitor of real-time replication as well as detailed reports database links, creating, managing table-spaces and data files.

Experience

7-10 Years

Level

Management

Education

Master of Science

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. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
3. Data refresh of large production data warehouse environment to setup test, development environments using san level storage mirroring: gold image copy and cloning.
4. Handled high volume production databases around 25 tb size along with physical standby databases proficient in oracle high availability features like rac, data guard, grid control and oracle performance tuning utilities like addm, awr, ash, sql-tuning advisor, explain plan, tk prof, dbv.
5. Performed data file recovery from logical and physical block corruptions good understanding and implementation expertise in rac, asm, data guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
6. Continuous monitoring of performance during peak and non-peak loads using awr reports, ash, addm and optimization SQL code using SQL trace, tkrpof, explain plan.
7. Experience working with sql, pl/sql coding, stored procedures, functions, packages, triggers.

Experience

5-7 Years

Level

Consultant

Education

BA

Description :

1. Supporting multiple databases for production, development, test and staging purposes on sun Solaris and Windows environments.
2. Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Experience

7-10 Years

Level

Management

Education

Computer Engineer

Description :

1. Supporting multiple databases for production, development, test and staging purposes on sun solaris and windows environments.
2. Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron.
3. Applying upgrade patch, maintenance and interim (opatch) patches on all the databases. Refreshing dev and test instances with data from production on a regular basis.
4. Developed pl/SQL packages, dml, ddl, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.
5. Thorough knowledge in setting up infrastructure for databases in huge data centers.
6. Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
7. Installed and configured Oracle 11g database on a test server using Oracle standard procedures and of, for performance testing and future 10g production implementation.

Experience

7-10 Years

Level

Management

Education

MBA