Oracle Database Administrator Resume Samples

The Oracle Database Administrator manages the Oracle database of the company, the job description entails taking responsibility for system analysis, database development, and implementation based on the requirements of the business. Oracle Database Administrator Resume lists these job responsibilities  – assessing and designing reviews, evaluating the needs and requirements of the user, developing and integrating complex database systems for both internal and external clients/users; developing and overseeing test code implementation, preparing recommendations and presentations; installing, patching and maintaining Oracle Software, and implementing a strong backup and recovery system.

The skills required for this role include – maintenance of Oracle DBA experience, experience with all aspects of Oracle implementation, Oracle Middleware Administration proficiency, good skills with all Oracle tools, knowledge of data integrity and a sound understanding of the business. A degree in Computer related field is mandatory. Some Oracle DBA’s are self-learners, while many have a significant amount of education and experience.

Oracle Database Administrator Resume example

Oracle Database Administrator Resume

Headline : Over 6 years of experience as an Oracle Database Administrator - performing various tasks like database installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.

Skills : Performance Tuning, Data Guard,RMAN, Backup And Recovery, RAC, Migration, Upgrades, OEM, Reporting, Documentation. ETL

Description :

  • Implemented data guard with maximum availability, protection and performance configurations and worked with data guard fail over and switch over cases at the times of up gradation and migration.
  • Taking backups on scheduled time and monitoring scheduled backups performing backups and recoveries using rman hot backups.
  • Experienced in data center migration of databases to prepare the proof of concept, db migration procedures and scripts, developed templates that include check list for migrating the databases.
  • Configured repository and clients for grid control and also implemented db control for some databases.
  • Utilized oracle streams to capture, propagate and apply the transfer of data, transactions and events within managed databases.
  • Perform database upgrades, migrations; take logical exports from the qa, dev etc instances and importing the data on to the production systems etc.
  • Diagnosed oracle bugs and coordinating with oracle support to resolve them in timely manner.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Consultant
Education
Education
Bachelor in Economics


Senior Oracle Database Administrator Resume

Summary : Over 8 years of experience as an Oracle Database Administrator in various industries like Information Technology, Software's, Learning Centers and performed different tasks like database administration, installation, configuration, upgrades, performance tuning, backup and recovery, production support, cloning, refresh, space management, database security etc.

Skills : Linux, Unix, RMAN, Formal Oracle Training, Oracle Enterprise Manager

Description :

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


Oracle Database Administrator III Resume

Summary : Over 7+ years of experience in information technology which includes Oracle Database Administration, administration of UNIX and windows environments. Oracle Database Administration on 24x7 critical production and large databases using Oracle 10g RAC, 11g RAC, 9i, 8i. Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Standby Database Data Guard for large financial applications.

Skills : DBA, Peoplesoft, Performance Tuning, RMAN Backup And Recovery, Auditing, Scripting, Communications, Training, Team Building, OEM

Description :

  • Performed replication using materialized views with a complete refresh/fast refresh.
  • Development of policy and procedures as they relate to database maintenance, security and archiving.
  • Providing support to the development team and handling release schedules.
  • Maintaining sound backup and recovery policies and procedures using rman.
  • Monitoring the scheduled backup procedures for daily basis using crontab.
  • Creating, granting and monitoring user access rights and privileges through roles and profiles.
  • 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.
  • Applying upgrade patch, maintenance and interim patches on all the databases.
  • Refreshing dev and test instances with data from production on a regular basis.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Computer Engineer

Jr Oracle Database Administrator Resume

Headline : Excellent experience in managing large-scale OLTP databases 6+TB size in HA and DR setup. Managed 30+ TB Oracle 10g & 11g databases in Data warehousing environment. Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Skills : SQL, Database Administration, Documentation, Strategic Planning

Description :

  • Setup auditing/oracle transparent data encryption (tde) for security management.
  • Tuning and troubleshooting databases (improving existing sql and pl-sql code, creating triggers, procedures, and packages) - tuning instances for optimal performance.
  • Tuning database for better performance using awr/addm/oem report and manual scripts.
  • Use dbms_sqltune, dbms_sql_monitor packages for real-time sql monitoring.
  • 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.
  • Troubleshooting replication, etc, and other Oracle-related issues and implementing resolutions.
  • Performing day-to-day database administration tasks including installation, upgrades, backup/recovery, monitoring, disaster recovery procedures (switchover/failover) and database cloning across environments, patching.
  • Diagnosed sybase server problems like long running transactions, blocking processes then resolved and reported them as appropriate.
  • Performed troubleshooting, scheduling, monitoring and execution of sybase database activities in cron jobs.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Consultant
Education
Education
Diploma

Oracle Database Administrator (contract) Resume

Summary : Team player very dedicated in work environment worked for over 8 years as an Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management.

Skills : Oracle, Linux, AIX, Solaris, Windows

Description :

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

Oracle Database Administrator / Middleware Administrator Resume

Summary : Over 9 years of hands-on experience as an Oracle Database Administrator. Possess complete life cycle knowledge including Installation. Worked on Oracle 10g, 11g and 12c versions involving database administration support, installation and configuration, database migration, backup and recovery, performance tuning, database upgrades, applying patches, database cloning, space management and security administration..

Skills : Oracle 10G,, 11G,, 12c, Database Administration

Description :

  • Cluster-wide resource management such as create resource plan, service configuration, parallel instance group, application isolation.
  • 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.
  • Data refresh of large production data warehouse environment to setup test, development environments using san level storage mirroring: gold image copy and cloning.
  • Work with Oracle data pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
  • 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.
  • Monitoring growth of tables and undertaking necessary re-organization of a database, capacity planning.
  • Designed the logical and physical database structure and involved in logical, physical data modeling.
  • 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.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Computer Engineer

Senior Oracle Database Administrator Resume

Summary : Highly talented, results oriented Oracle professional with 9+ years' experience as an Oracle Database administrator. Database Installations, configuring, Tuning, Administration, performed Backup, Recovery, Data-Loads, perform database upgrades, Managing database's storage structures.

Skills : oracle 10g, 11g, 12c on various platforms like IBM-AIX, SUN SOLARIS, HP-UX, Red Hat Linux and Windows

Description :

  • Monitored different databases and application servers using oracle enterprise manager 10g grid control.
  • Design, document, implement and maintain all disaster recovery procedures which result in no data loss.
  • Provided assistance to memory corruption and dictionary corruption errors.
  • Database tuning by generating explain plans for long-running queries, creating indexes on columns to improve performance.
  • Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
  • 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.
  • Perform daily monitor of real-time replication as well as detailed reports database links, creating, managing table-spaces and data files.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Master of Science

Jr Oracle Database Administrator Resume

Headline : To work as a Senior Oracle Apps DBA that allows for the immediate use of my diverse technical skill set, motivational management style, best practices focus and attention to details and results.

Skills : DATABASE, ORACLE, DATABASES, AIX, HACMP, OPERATIONS, SUN

Description :

  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Data refresh of large production data warehouse environment to setup test, development environments using san level storage mirroring: gold image copy and cloning.
  • 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.
  • 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.
  • 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.
  • Experience working with sql, pl/sql coding, stored procedures, functions, packages, triggers.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Consultant
Education
Education
BA

Oracle Database Administrator II Resume

Summary : Over 8 years of IT experience in development, staging and production environments. Solid background in completing project life cycle from planning, analysis, design, development, implementation, testing and documentation of client/server systems. Experience using Oracle [] R1/R2, Oracle RAC, ASM, RMAN, EM Cloud and Grid Control in highly critical environments. Transitional experience of SQL Server [] Administration. Planning & handling of database backup and recovery strategies using RMAN.

Skills : MS Windows 2000/NT/XP/Vista/2007/2008, Red Hat Enterprise Linux, UNIX, Sun Solaris,, SQL, PL/SQL, UNIX Shell Scripting, HTML, Oracle 8i/9i/10g,11g,, Installation, Backup Planning And Implementation.

Description :

  • Supporting multiple databases for production, development, test and staging purposes on sun Solaris and Windows environments.
  • Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
  • Involved in the installation, configuration and extended support to oracle 11g, 10g two node rac with asm file system on sun solaris platform.
  • Implementing data pump, conventional export/import utility of oracle 11g, 10g for re-organizing databases/schemas/tables to improve the performance.
  • Database monitoring/maintenance, replication process and performance tuning using oem automated the processes like moving files, managing alert log, efficient backup by developing unix scripts.
  • Installed oem grid control that includes oracle agent, management repository and management service on vmware red hat linux virtual machine.
  • Applied patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Computer Engineer

Oracle Database Administrator Resume

Summary : Oracle memory tuning Experience performing backup and recovery using the Oracle RMAN, and Datapump Export utilities Experience migrating databases from environment to environment as well as within same environment using datapump Export, Import, RMAN and SQL Loader utilities.

Skills : involving database administration, production support, installation, configuration, upgrades, patches, migration

Description :

  • Supporting multiple databases for production, development, test and staging purposes on sun solaris and windows environments.
  • Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron.
  • 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.
  • Developed pl/SQL packages, dml, ddl, Oracle tables, stored procedures, functions, cursors, triggers, and UNIX shell scripts.
  • Thorough knowledge in setting up infrastructure for databases in huge data centers.
  • Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and of, for performance testing and future 10g production implementation.
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
MBA