SEARCH

ORACLE Server Database Administrator Resume Example

Love this resume?Build Your Own Now
ORACLE SERVER DATABASE ADMINISTRATOR
Skills
  • TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.
  • Languages :
  • SQL, PL/SQL, UNIX Shell Scripting, PERL, T-SQL.
  • Tools and Utilities:
  • RMAN, OEM, SQL
  • Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer, SQL Server Integration Services SSIS, SQL Server Management Studio, Microsoft Team Foundation Server .
  • RDBMS :
  • Oracle 9i, 10g, 11g, 12c, 19c, MS SQL Server 2012
  • Operating Systems :
  • HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1, 7.0, RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000/2007, Windows Server 2008 R2 Enterprise.
  • SKILLS SUMMARY
  • Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Experienced in performance monitoring/tuning/troubleshooting.
  • Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
  • Implemented automated backup strategy with the UNIX shell script and CRON UTILITY for performing Cold Backup and RMAN incremental backups.
  • Experience in performance tuning using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Explain Plan, SQL TRACE, STATSPACK and different OEM utilities.
  • Strong working knowledge of development tools like TOAD, SQL Developer.
  • Proficiency with utilities such as Data Pump, SQL
  • Loader and TFS.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and Perl based utility “Opatch”.
  • Experience in doing upgrades including maintenance & monitoring implementation.
  • Experience in monitoring and performing routine database tasks.
  • Basic Experience in MS SQL Server 2012
  • Basic Experience in Windows Server 2008 R2 Enterprise.
  • Basic Experience in T-SQL and SQL 2012 SSIS packages
  • Experience in Microsoft Office 2013 (Word, Excel, Outlook)
  • Experience in Microsoft Team Foundation Server (TFS)
  • Ability to communicate effectively with a multiple audience
  • AIX/UNIX Systems Administration - Database and application integration efforts.
  • GO LIVE, Capacity planning, Disaster recovery, Excel, 98, Oracle 9, ORACLE/SQL, RDBMS, Sound, Troubleshooting, Utilities
  • AIX, Change management, HP-UX, Microsoft Office, NT, Oracle, Oracle SQL, Red Hat Linux, MS SQL Server, Type, VM
  • AIX 5.1, CPU, IDs, Outlook, Word, DBA, Peak, Servers, SQL, UNIX Systems Administration, VMS
  • Backup, Client, Linux, Windows, Migration, Db, PERL, Scripts, SQL Server, UNIX Shell Scripting
  • Basic, DATABASE, Managing, 2000, Enterprise, Oracle Database, Policies, Script, Strategy, UNIX shell
  • Bind, Databases, Meetings, 3.x, OS, Developer, Progress, Sun Solaris 2.5, TOAD, Upgrades
  • C, Designing, Access, Windows 95, Operating Systems, PL/SQL, Quality, Sun Solaris, T-SQL, Upgrade
Professional Summary

US CITIZEN An Accomplished Oracle Database Administrator with almost 7YEARS of experience in Oracle Database Administration in large-scale production environments across multiple platforms Ability to provide technical support in all aspects of database administration including upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Data Guard. Ability to work both as an individual and as a member of a team.

Work History
December 2020 to Current
ORACLE Server Database AdministratorCompany Name, City, State
  • ORACLE/SQL DATABASE ADMINISTRTOR, I Support more than 2500 databases including development/test/production sizes up to 4 TB for 24/7.
  • I carry on relinking after an OS upgrade to bring up services and link bind variables.
  • I Upgrade databases up to 19c.
  • I do Backup and recovery using RMAN utility and Data pump.
  • I 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.
  • I Setup and document Oracle Golden Gate replication on all versions for support team.
November 2019 to December 2020
Oracle Database AdministratorCompany Name, City, State
  • I support about 2000 databases in dev, int and prod environment with the biggest ranging at 3TB.
  • I am responsible with given VM specs for the creation of new databases by the build team and after creation, I am responsible with the installation of oracle software and client installation on those VMS.
  • As a DBA, I create the new databases needed on the VMs and make sure that all necessary files and backup scripts are in place for daily incremental backups and properly saved for recovery purposes.
  • I make sure to patch the oracle homes as well as databases with the latest patch set before databases GO LIVE.
  • I upgrade databases from current version to newer versions such as 19c.
  • In my environment, I am in charge with migrating databases from CORE to AZURE since everything is being moved to Cloud.
  • On a weekly basis I migrate 3 to 4 databases for Dry Run and twice a month do all necessary preparations as well as implement the cutover by bringing the production database to Live.
  • Daily I work very close with customers with troubleshooting issues they encounter, such as creating new IDs, granting privileges, giving the right permissions to directory as well as authentication methods for users to access data.
  • I do both database refreshes as well as schema refreshes on a weekly basis and some weeks daily to keep data current for dry run testing before Prod cutover using Db_links.
  • I use Rman for backup and Restoring databases to other servers for replication.
  • On my daily activity I attend various meetings to bring in ideas on how to plan the migration of databases as well as bring the applications to live.
  • I am in a team of two oracle DBAs and I am still very able in making sure all task is completed in a timely manner for business continuity purposes.
March 2016 to November 2019
ORACLE DATABASE ADMINISTRTORCompany Name, City, State
  • I Support more than 2500 databases including development/test/production sizes up to 4 TB for 24/7.
  • I carry on relinking after an OS upgrade to bring up services and link bind variables.
  • I Upgrade databases from 10g to 11g (11.2.0.3 to 11.2.0.4) and newer versions.
  • I Install Oracle Homes 11.2.0.4 on development, test and production servers and apply Oracle Home patches.
  • Primary DBA for 1GB - 2.5TB database for 24/7 support.
  • I do Backup and recovery using RMAN utility and Data pump.
  • I 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.
  • I Setup and document Oracle Golden Gate replication on 11g for support team.
  • I also Develop, revise and implement policies, standards, procedures and guidelines necessary to effectively administer the database environments.
  • I work close with my team to ensure databases adhere to corporate standards and policies.
  • By this, I Work with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux.
  • 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 and Autosys.
  • I use ASH, ADDM and AWR reports to monitor database performance and also do Database refreshes using export /import and data pump.
  • I Perform Database Tuning & Performance issues, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
  • I Implement SQL outline to get the better execution plan for the offending queries.
  • On a Day to Day General Administration, I do Table space Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
  • I performed various tasks like Administering RAC using SRVCTL, adding nodes and instancing for High Availability purposes.
  • Refreshed multiple databases for Development and Testing upon short request.
  • Served as part of a 40-member DBA team which was involved in the maintenance of the Oracle 10g/11gdatabases for the Production as well as the development environments.
  • Actively involved in designing/Testing of Disaster Crash recovery.
  • Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
June 2014 to February 2016
KFORCECompany Name, City, State
  • Work closely with customers on a daily basis to understand their needs,.
  • Support business change and deliver a consistently high-quality customer experience.
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Applied patches 10.2.0.2 and 11.2.0.3, 11.2.0.4.
  • Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11G RAC.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Use to run the scripts Used to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Support client customizations, sharing implementation and best practices advice.
  • Provide hands-on assistance using proprietary tools in a test environment.
  • Or via remote client connectivity.
Education
September 2015ORACLE CERTIFIED ASSOCIATE 11GOracleBrontech , City
August 2008Some College CoursesLaw And Political ScienceUniversity Of Younde 2, City
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

82Good
Resume Strength
  • Word choice
  • Length
  • Measurable results
  • Typos

Resume Overview

School Attended

  • Brontech
  • University Of Younde 2

Job Titles Held:

  • ORACLE Server Database Administrator
  • Oracle Database Administrator
  • ORACLE DATABASE ADMINISTRTOR
  • KFORCE

Degrees

  • ORACLE CERTIFIED ASSOCIATE 11G Oracle
    Some College Courses Law And Political Science

Similar Resumes

View All
Oracle-database-administrator-resume-sample

Oracle database administrator

Jacksonville Beach, Florida