Livecareer-Resume

Senior Cloud Database Administrator Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Summary
A talent and resourceful Oracle DBA professional with over 6+ years of diligent experience. I have supported the complete life cycle of the SDLC. I have worked on Oracle 9i, 10g, 11g and 12c versions. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate and security management. I have supported customized Applications like HR, FIN and PEOPLESOFT
Skills
  • Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
  • Experienced in Performance Monitoring tools like OEM, AWR report, DBMS_PROFILER to troubleshoot some PL/SQL codes.
  • Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM Grid, monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.
  • Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental and cumulative.
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.
  • Experience in applying patches/ patch sets to the databases.
  • Extensively worked on Import/Export and Data Pump Import/Export tools.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.
  • High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.
  • Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.
  • Performed database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.
  • Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
  • Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • Expertise in maintaining Database Security using auditing and High level Security using Transparent Data Encryption(TDE),
  • 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 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.
  • RDBMS
  • Oracle 10g, 11g, 12c
  • Languages
  • SQL, PL/SQL, UNIX Shell Scripting, PERL.
  • Tools
  • TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.
  • Database Utilities
  • SQL
  • Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
  • Loader, RMAN, DataPump, Export, Import
  • TWS Scheduler
  • ADF
  • APPLICATIONS
  • HR, FIN, PEOPLESOFT
  • Jessica Claire
  • Page 7
  • Administrative, Auditing, C, Consultation, Clients, DBA, Data Warehousing, DML, Features, HP-UX, Managing, 3.x, Migration, Operating Systems, Oracle database, PEOPLESOFT, Python, Red Hat Linux, Shell scripting, Sql, Loader, TOAD, UNIX, Upgrades, Veritas cluster server
  • IBM-AIX, Backup, C 2, CPU, Data modeling, Databases, Decision Support, Estimating, Firewalls, Hub, Access, Windows 95, Enterprise, Optimization, PL/SQL, PERL, QA, Scaling, Sun Solaris, Microsoft SQL Server, Statistics, Trend, UNIX/SHELL scripts, Upgrading, View
  • AIX 5.1, Bash, Capacity planning, Encryption, Data warehouse, Database, Diagnosis, ETL, Flash, HR, Windows, 98, Network, Oracle Enterprise Manager, Page 7, Policies, RDBMS, Scheduling, Sun Solaris 2.5, SQL Server, Tables, Troubleshoot, UNIX shell scripts, Upgrade, VMS
  • ASM, BI, Compliance reports, Client, Database administration, DBMS, Disaster recovery, Event management, Government, Linux, 2000, NT, OLAP, Oracle, Peak, Coding, Real Time, Scripts, Solaris, SQL, Teradata, Troubleshooting, UNIX Shell Scripting, Utilities, Windows Server
Education and Training
, Expected in
  • Government High School (Advanced Level Certificate in Business studies)
  • OCI Certified
  • : - GPA :
    Siantou University Complex Yaounde , Expected in BS : Business Management and Administration - GPA :
    Experience
    Brink's Incorporated - Senior Cloud Database Administrator
    Clearwater, FL, 10/2018 - Current
    Apex Systems - Oracle Database Administrator
    Woburn, MA, 02/2016 - 05/2018
    • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
    • 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 datacenters.
    • Installed Oracle 11g on Linux platform using ASM.
    • Creating Materialized views and Materialized View Logs for Data Replication.
    • Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
    • Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.
    • Implemented oracle 12c active standby database for test database environment.
    • Handled my group of 4 people in all and lead them for getting best results.
    • Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports.
    • Provided recommendations using ADDM reports.
    • Analyzed the trace files Using TKPROF utility.
    • Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.
    • Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas cluster server.
    • Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
    • Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
    • Developed compliance reports and performed auditing at higher levels.
    • Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.
    • Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
    • Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
    • Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
    • Capacity planning: Allocate system storage and plan future storage requirements.
    • Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
    • Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).
    • Performing monthly and annual performance reports for trend analysis and capacity planning.
    • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
    • Worked on both VMS and UNIX environments.
    • Troubleshooting of various database performances by proper diagnosis at all levels like SQL.
    • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
    • Used GOLDEN GATE for Zero Downtown Upgrade and Migration.
    • Experience in writing UNIX/SHELL scripts for providing the reports.
    • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
    • Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
    J.B. Hunt Transport, Inc - Oracle DBA
    City, STATE, 01/2015 - 04/2016
    • Troubleshot and resolved web application issues resulting from customers and other departments with a high success rate.
    • Worked with clients to analyze computing and network needs and implemented appropriate solutions with every department.
    • Experience in performance monitoring/tuning/troubleshooting - Oracle database services with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ASH and SQL TRACE.
    • Experience in Installation, configuration and maintenance of Physical, Logical, Active standby databases supported by Data guard on Oracle 10g, and 11g RAC for disaster recovery purposes.
    • Generated ASH, ADDM and AWR Reports using OEM from Oracle 10g, 11g and 12c database and analyzed the reports for better performance, time consuming SQL queries, tablespace growth, and database availability.
    • Implemented database re-organizations as required to improved performance and ensure maximum up-time of the database.
    • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and ACFS file systems.
    • Migrated multiple stand-alone databases to RAC databases using Rconfig, RMAN and OEM.
    • Migrated single instance databases from NON-ASM to ASM file system to improve performance.
    • Expert in Installation of Oracle 10g, 11g and 12c software and created multiple databases including Plug-able and container databases in oracle 12c.
    • Implemented TDE, Data Redaction and database Auditing to improved data integrity and security.
    • Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using OPatch Auto.
    • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and OEM.
    • Implemented and managed logical backup/recovery with Data pump and Export/Import utilities.
    • Cloned databases using RMAN and Manually using scripts.
    • Implemented Point In Time Recovery on one or more tablespaces to recover lost of a table(s) while eliminating down time for the database.
    • Installed SQL Server EE 2012 on windows and created databases, triggers, tables, procedures, functions and database diagrams.
    • Extensive experience in Upgrading databases from 10g to 11g and 12c using DBUA, Data pump, Manually, Transportable Table space and Oracle Data guard.
    Activities and Honors

    By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

    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.

    Resume Overview

    School Attended
    • Siantou University Complex Yaounde
    Job Titles Held:
    • Senior Cloud Database Administrator
    • Oracle Database Administrator
    • Oracle DBA
    Degrees
    • <li>Government High School (Advanced Level Certificate in Business studies)</li><li>OCI Certified</li>
    • BS