Livecareer-Resume
JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Summary
  • Oracle DBA with 11+ experience in implementation, tuning, development, and support of critical systems. Expert at utilizing my Business Information Systems proficiency to manage all phases of project life cycle from business requirements and technical definitions for testing, documentation, production support, training and completion; a strong decision maker that can complete multiple tasks to enhance office productivity and requirements of the business executives.

TECHNICAL SKILLS

  • Oracle DBA (10 years), Patching (8 years), Data Guard (8 years), RAC (8 years), VPD (2 years), Migration (8 years), ASM (8 years) AWR (8 years) RMAN (8 years) Shell scripting (6 years) Exadata (2 years) AIX (4 years) Data Warehouse (2 years) Solaris (5 years) Linux (8 years) Windows (8 years) Storage (8 years) Golden Gate (5 years) Team Lead (4 years) Provided 24x7 production support for Oracle 19c/12c/11g/10g/9i databases on Windows / UNIX platforms. Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting and Documentation. Implement Oracle Enterprise Manager Grid Control (OEM 19c/12c/11g/10g) for centralized monitoring and administration. Planned and implemented high availability solutions using Oracle 19c/12c/11g/10g; Standby Database using Oracle Active Data Guard (Physical and Snapshot) Operating Systems: Installation and Configuration of UNIX/Red Hat Linux, Windows 2003/08 for Oracle database and ASM installation. Tools: SQL
  • Plus, Enterprise Manager (OEM), Grid Control, SQL Loader, Oracle Recovery Manager (RMAN), Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, Data Pump, Real Application Clusters (RAC), Active Data Guard, Unix Shell Scripting, Automatic Storage Management (ASM), Data Archiving, TOAD, MobaxTerm, SecureCRT, Enterprise Reporting.
Skills
  • Administrative, Optimization
  • ASM, Oracle 9
  • Backup, Oracle
  • C, Oracle applications
  • C 2, Oracle Database
  • Cable, Oracle PL/SQL
  • Hardware upgrades, Oracle & SQL
  • Hardware, Peripherals
  • CPU, Policies
  • Encryption, Presenting
  • Clients, Processes
  • Client, Progress
  • Database, Red Hat Linux
  • Databases, Reporting
  • Database design, Requirement
  • Database development, Scheduling
  • Disaster recovery, SDLC
  • Engineer, Servers
  • Fast, Shell scripting
  • Features, Service Level Agreement
  • Flash, Sun Solaris
  • Focus, SQL
  • Functional, Strategy
  • GC, System Administration
  • Grants, System analysis
  • HP servers, Tables
  • Information Security, Troubleshoot
  • Innovation, Troubleshooting
  • LINUX, UNIX
  • Managing, Upgrades
  • Memory, Upgrade
  • Access, Upgrading
  • Windows, Utilities
  • Window, Video
  • Works
  • Migration
  • Enterprise
  • Network
  • OS
  • Operating system
  • Data testing
  • Writing queries
  • Database analysis
  • Apache Tomcat
  • Microsoft SQL
  • Data conversion and migration
Experience
04/2014 to Current Senior Team-Lead Database Administrator Barclays Bank | Wilmington, DE, America
  • Configured and maintained replication using Oracle Golden Gate.
  • Migration of large data from Exadata to RAC clustered environment.
  • Installed, configured Oracle 10G, 11gr2, 12c and 19C on Linux, Sun Solaris and HP servers.
  • Migration of standalone databases to RAC and ASM.
  • Hands on experience in creating application contest packages for VPD configuration.
  • Created login triggers to monitor user’s access to the database using VPD technology.
  • Created synonyms, objects and grants on security packages to users.
  • Created and applied security policies to VPD tables.
  • Creating duplicates databases for RAT testing and moving databases from EXADATA in RAC environment.
  • Installation of TLS for database encryption and, for PII Security data.
  • Installed, configured and maintained Oracle 9i/10g/11g/12c/19c Databases on Linux, UNIX and Windows Platforms.
  • Involved in the complete SDLC, Database design, System analysis, design and development.
  • Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
  • Installation and Configuration of 11g, 12c and 19c Grid Control.
  • Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.
  • Implemented Oracle Database 11g/12c/19c 2 to 4 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.
  • Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.
  • Worked on Oracle 9i to 10g/11g/12c/19c migration projects with low maintenance window and applied patches to various databases.
  • Worked on OEM Grid Control 11g and OEM Cloud Control 12c scheduling and troubleshooting OEM jobs and deploying OEM agents.
  • Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.
  • Disaster recovery implementation using physical standby databases for high availability.
  • Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).
  • Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.
  • Work with software vendors and Oracle support to ensure all database and application related issues are resolved timely and efficiently.
  • Performance tuning and optimization of Oracle applications and databases (Database Buffer cache, Library catch, Dictionary catch) AWR reports, SQL Trace, explain Plan.
  • Identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
  • Engineer, System Administration-related solutions for various projects and operational needs.
  • Install new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc.
  • In accordance with standards and project/operational requirements.
  • Develop and maintain installation and configuration procedures.
  • Apply OS patches and upgrades on a regular basis and upgrade administrative tools and utilities.
  • Configure / add new services as necessary.
  • Perform ongoing performance tuning, hardware upgrades and resource optimization as required and configure CPU, memory, and disk partitions as required.
  • Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
  • Perform daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent off site as necessary.
  • Provide Tier III/other support per request from various constituencies.
  • Investigate and troubleshoot issues.
06/2007 to 04/2014 Oracle Database Administrator Comcast | City, STATE,
  • Comcast Cable applies the latest innovation and technology to entertain, inform and connect people in new ways.
  • Providing households and businesses with the ultimate in video, Internet, voice, home management and business services.
  • Comcast's advanced fiber network powers small and mid-sized companies with the solutions they need to make their businesses more productive by deploying real life operational, functional and technical experience to offer innovative solution for business challenges and deliver business driven solutions.
  • Installed and configured databases and provided all databases related support for the production environment as well as provided consultancy services as needed to other organizations.
  • Performed application installation, space estimation, performance and memory tuning.
  • Experience in 24/7 server/database monitoring, configuration and troubleshooting.
  • Worked with system administrators, application developers, and design team on oracle database practices.
  • Installing and configuring Oracle Enterprise Red Hat Linux operating system versions and Windows 2008 servers for Oracle Relational (RDB) installation and creation, installing Oracle grid infrastructure & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
  • Creating, migrating and backing up database for various clients.
  • Maintained, supported and managed multiple 2 nodes Oracle 10g Real Application Clusters (RAC) environment.
  • Lead a project with a team of 5 and successfully analyzed, recommended and implemented an active Oracle Data Guard to facilitate data protection, site redundancy and disaster recovery.
  • Lead a team of 3 to successfully upgrade multiple databases and carried out short term performance tuning, maintenance and training for continuous operation Presenting and analyzing database performance reports and improvement recommendations to client company’s senior executives.
  • Ensuring fast and secure access to business applications round the clock.
  • Installing Oracle software, planning the database & security strategy, enrolling system users and planning for their Oracle Network access.
  • Ensuring proper configuration and security on all database servers.
  • Work with Developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, stored procedures and functions.
01/2005 to 10/2007 Jnr. Database Administrator ATT | City, STATE,
  • Maintained and managed the Oracle 10g RAC environment and troubleshoot performance problems.
  • Upgrading Oracle Databases from 9i to 10g, 11g,12c and 19c.
  • Building test strategies, backup & recovery models for Oracle.
  • Refreshing test databases.
  • Developing and maintaining new and existing database systems.
  • Proactively pursuing development opportunities, learns existing environment and processes and exhibits progress on learning plan.
  • Building strong internal and external partnerships.
  • Assisting in the development of technical database design documents.
  • Providing initial unit testing of all database development and enhancements with the goal of providing a stable production environment while optimized for end-user performance.
  • Builds and maintains database systems in such a way that exceeds regulatory requirements.
  • Security is a critical design requirement and data, systems, and applications must be protected at all points of the development lifecycle.
  • Identifies development opportunities and works with manager to establish learning focus and learning plan.
  • Managing backup & Recovery for Oracle on Linux using RMAN •Going through the day-to-day user requests and troubleshooting the database related problems.
  • Linux shell scripting for monitoring oracle Database status, security & backups.
  • Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
  • Created user, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracle & SQL Server databases.
  • Created backup plan design and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.
  • Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
  • Responsible for reporting risks that are identified to the appropriate team and/or management.
  • Additionally, responsible for managing, monitoring and reporting risks within the scope of your work area, to include, but not limited to Information Security risks.
Education and Training
Expected in B.S | Computer Engineering , , GPA:
Expected in Oracle Database 11g Administrator Certified Associate (OCA) | Southern Polytechnic And State University, Structured Query Language (SQL), Marietta, GA GPA:
Expected in Associate | Physics and Engineering Clayton State University, Morrow, GA GPA:
Activities and Honors
  • Member, Alumni Association
Certifications

Oracle Cloud Infrastructure Developer Certified Associate

Oracle Java SE 8 Programmer I (OCA)

MySQL 5.7 Database Administrator (OCP)

By clicking Customize This Resume, 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.

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:

70Average

resume Strength

    Resume Overview

    School Attended

    • Southern Polytechnic And State University, Structured Query Language (SQL)
    • Clayton State University

    Job Titles Held:

    • Senior Team-Lead Database Administrator
    • Oracle Database Administrator
    • Jnr. Database Administrator

    Degrees

    • B.S
    • Oracle Database 11g Administrator Certified Associate (OCA)
    • Associate

    By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

    *As seen in: