Oracle Database Administrator Resume Examples

oracle database administrator

  • As an Oracle database administrator providing operations-oriented support to help in managing underlying systems that drives core data for Woolworths Limited(Client), Australia
  • Managing and providing HA (High Availability) solutions like RAC, Data Guard etc.
  • Core Database upgrade and patching. 
  • Oracle RAC upgrade and patching. 
  • Optimizing Database/SQL performance.
  • Managing database that runs on EXADATA box and helping in levering Exadata key features. 
  • Helping in configuring disaster recovery. 

oracle database administrator

  • Communicate with customers and business leaders in requirements gathering and providing technical and functional solution definition for assigned Oracle projects. Ensured high availability and performance  in production and test environments. 
  • Implementing 3-node RAC concepts in different UNIX platforms and perform tuning operations on both Oracle 11g,12c technologies and monitored the production Oracle alert logs for database errors.
  • Detecting and diagnosing production system performance tuning of the database – SQL tuning, used tuning utilities like AWR,ASH report, ADDM, measuring system and database activity, querying Oracle dynamic performance views. 
  • Database replication using snapshots,import/export and traditional replication methods. 
  • Managed appropriate use of free space within Tablespaces , reclaimed space and reorganized tables and indexes within databases when needed. 
  • Resolved the issues in conflicts between the target and source database in Goldengate. Involved  in resolving bi-directional replication issues. 
  • Used Datapump tool  for exporting and importing the data between databases. 

junior oracle database administrator

  • Supporting 2000+ oracle databases as Oracle database administrator in GE Corporate Servers which includes development, stage, and production oracle databases.
  • Implemented Backup and recovery using RMAN incremental and cumulative backups. Scheduling the databases backup using Crontab. Monitored Day-to-Day backups, logs and recovering them as per the requirements. 
  • Supported Patch assistance for Unix team for Cluster Patching. 
  • Interacting with the Oracle support on Service Requests and implementing the solutions for successful completion of tasks.

oracle database administrator

  • Oracle 10g/11g/12C Installation on Rhel 7, Windows 2008/XP and client on terminals.
  • Managing 12c OEM.
  • Managing Tablespaces and data files, redo log groups and members.
  • Creating users and granting them roles and privileges.
  • Deploying SCR’s.
  •  Refresh of production data into UAT by restoring and recovering databases for user tests and requirements.
  • Look for harmful Growth Rates. Implementing daily, weekly, nightly, Monthly policies and procedures in crontab.

junior oracle database administrator

  • Working on DBA activities like Refreshes from DR database, Table Reorg, Data Refreshes.
  • Putting Standby DB to Flashback mode when required by Application teams.
  • Restoring RMAN backups, Working on RMAN Backup Failures
  • Working on all DB L1 issues, adding ASM disks to disk groups
  • Daily health checkups and Monitoring DR log sync
  • Implemented Dataguard with maximum availability, protection ,performance modes.
  • configurations and worked with dataguard switch over

oracle database administrator

  • Develop test scripts which can be used for automated as well as manual testing.
  • Have 2.5 years experience on “Informix” production servers and 1 year on “SQL” servers. Provided assistance for database monitoring and maintenance with regular statistics and backups. 
  • Providing support to development team, like Database changes, Trace and kill sessions.
  • Creating and Rebuilding indexes, Creating and Refreshing of Materialized views, Analyzing Schemas.

oracle database administrator

  •  Install, clone and create oracle database  
  •  Configure database initializations  
  •  Database storage management  
  •  Oracle user management  
  •  Oracle performance monitoring  
  •  Oracle data movement using export and import 
  •  Oracle backup and recovery using rman 

oracle database administrator

  •  Administering Database Creations and Database upgrades from 11G to 12C, other activities including Backup & Recovery using RMAN. 
  • Performing Database (DB) tuning & performance monitoring as well as capacity planning for growth and changes; undertaking Patch Management and Version Control. 
  •  Recommending production database best practices, analyzing the existing database structures and developing new code to provide solutions for new requirements. 
  • Supporting Application Development Teams throughout the project lifecycle. 
  • Assisting in code migration, database change management, and data management across various stages of the Software Development Life Cycle (SDLC). 
  • Responding to and resolving database access and performance issues. 
  • Ensuring the integrity and security of enterprise data on host computers, multiple databases, and during data transfer while adhering to privacy, security, and regulatory compliance. 

sr. oracle database administrator

  • Defined Data Models, Data Governance, Data Quality and Metadata strategy, Data Security Standards, Data Flows, Storage and Archiving mechanism 
  • Defined the Data Clustering and Replication policies and data flow pattern across the enterprise Application consumption
  • Developed HDL framework and Logical Solution design document for implementing project
  • Involved in all aspects of the application development lifecycle, which includes business
  • Requirements, functional specifications, architectural specifications, development, test plans, and documentation

senior oracle database administrator

  • Need to coordinate with the Application team to perform any changes in the Databases.
  • Perform scheduled COB(Standby) testing for production databases in conjunction with application team.
  •  Day to day monitoring like availability of system, listener, database, alert log file, trace file.
  •  Performance & Tuning of the Database
  • Attend daily/weekly conference call to discuss the build status with application team and Citi management
  • Open a Change review call with all the Oracle Specialists and Managers and discuss about the changes in the databases and explain the justification of the changes.