LiveCareer-Resume

lead oracle dba resume example with 20+ years of experience

JC J S S JS J S S JS J S S JS J S S JS J S S JS J S S JS
Jessica Claire
Montgomery Street, San Francisco, CA 9XXX5 (555) 432-1000, resumesample@example.com
Profile
Highly skilled and experienced senior Database Architect/Database Administrator with demonstrated success in information technology, database administration, and data warehousing. Proven expertise and strong ability to increase system reliability, ensure recoverability, and improve system performance. Proficient communicator effective at managing relationships between end users, strategic and senior leadership, and third-party vendors. Highly qualified with exceptional verbal/written communication skills to effectively resolve problems in a deadline-driven environment. Consistently promoted into various positions of increased responsibility. Areas of expertise include: Enterprise Architecture Database Design and Administration Data Warehousing Security Administration Diagnosis and Troubleshooting Systems Integration RAC Technology Program and Project Management Problem Resolution
Core Qualifications
  • Platforms: Red Hat Advanced & Oracle Enterprise Linux 4.0/5.0/6.0, Sun Solaris 2.x, HP UX 11.X on HP Superdome, Windows 2003/2008 Server
  • RDBMS :
  • Oracle Tools: Oracle EXADATA, Oracle RAC 12cR1, 11gR1+R2, 10gR1+R2. Oracle 7x,8x,9x
  • ASM, ASM LIB, Oracle Grid Control 10g/11g/12C, Oracle Clusterware 10g ,11g,12C OCFS2 , RMAN, Oracle Discoverer 10g, Oracle Golden Gate, Oracle Application Server 10g, Oracle Single Sign-On 11g, Oracle Diagnostic and Tuning Pack 10g/11g/12C- AWR and ADDM, TKPROF. Oracle Provisioning and automation Pack, Physical Standby 11g /Active Data Guard 11g. Oracle Database and Firewall 12.1.1
  • Tools: TOAD 12x, Quest Performance and Tuning Pack, Spotlight, Foglight, NetBackup , VMWARE, EMC DataDomain
  • Languages: PL/SQL, Java , Korn and Born Shell Script
Professional Experience
2004 to Current Lead Oracle DBA Jpmorgan Chase & Co. | , PA,
  • Serve as Project Lead for Oracle 10g/11g/12C RAC implementation projects; manage business critical production databases including installation, configuration, patching, upgrade, and automation.
  • Improve efficiency via capacity planning, space management, problem resolution, database monitoring, and performance tuning of production databases on a daily basis using Quest and Oracle tools.
  • Design, implement, and participate in the disaster recovery process and database backups.
  • Administer user security on the database level by implementation roles, profiles, and auditing to adhere to the Sarbanes-Oxley (SOX) and HIPAA requirements.
  • Develop proactive scripts to monitor threshold for tablespaces in various production databases and alert or page as necessary.
  • Provide 24/7 support of 10g/11g/12C databases as part of on-call operations team.
  • Train and mentor junior DBAs on Oracle RAC database and Clusterware administration.
  • Managed several 11 plus Terabytes warehouse databases in production, test and stress environments.
  • Designed and setup several 11gR2, 10gR2, 12c R1 RAC clusters (CRS, ASM, ASM LIB) ranging from 2 to 6 nodes on Oracle Enterprise Linux 4/5/6 in production and development environments.
  • Upgraded Oracle 11gR2 Clusterware environments to 12C1 Grid Infrastructure with 11gR2 database.
  • Database upgrade to 12C testing is in process.
  • Upgraded Oracle 10gR2 Clusterware environments to 11gR2 Grid Infrastructure with 10gR2 database.
  • Upgraded Oracle databases on 10gR2 to 11gR2, this involved upgrading several Tera bytes databases Upgraded Operating system on Linux 4 to Linux5 using RAC Add/Remove node procedure.
  • Saved $100,000 in monitoring software by designing a custom repeat paging mechanism using Grid Control 10g which has been upgraded to Grid 11g to use out of the box repeat paging.
  • Jessica Claire Page 2 of 3 As a member of the Infrastructure Management and Automation team, responsible for managing Business critical Production Databases associated with installation, configuration, patching, upgrade, and automation.
  • Lead on Oracle Proof of Concept for in house setup, configuration and testing of EXADATA x2-2 Perform various infrastructure tasks on RAC servers which included changing subnet in OCR, moving Private Interconnect to isolated switches with Jumbo Frames and reconfiguring it to use bonding.
  • Developed and implemented disaster recovery plans/procedures and successfully recovered the Oracle 10g/11g RAC cluster due to corruption of ASM header and OCR files.
  • Setup and administer Grid Control 11g and 12C.
  • This included monitoring databases, logs for all resources and creating rules for notifications.
  • Migrated data from a four-terabyte 10.1.0.5 Warehouse Non-RAC database on HP-UX to RAC database on Linux using Data Pump technology.
  • Dramatically increased reliability and improved customer satisfaction through proactive database monitoring using customized PL/SQL scripts for tablespaces suspension and OEM monitoring Configure RAC services using Load Balancing techniques and work with users to connect applications using JDBC connections.
  • Tune Application queries to perform better in a data warehouse environment.
  • This involved using explain plain, tracing sessions, creating and refreshing Materialized views/Snapshots on regular basis Perform database tuning which included resizing SGA components, increasing size of undo segments, relocating data files, changing size and location of redo log Used 10g/11g RMAN to backup databases in archive log mode.
  • Utilize RMAN features such as compression.
  • Used NetBackup to backup databases to Tape from disk and directly to Tape.
  • Restore databases using RMAN point in time recovery techniques, restore/rename databases using RMAN Duplicate technique Setup and configured Oracle DBFW 12.1 to capture auditing for various databases in a centralized repository, additionally configured the Firewall in monitoring mode to capture the database traffic.
  • Manage/Maintain DWFW for alerts, configuration changes and issues.
  • Responsible for automating cloning and refreshing development, test databases with production data.
  • Consulted with application programmers and managers of other organizations to plan and schedule Oracle patches and upgrades.
  • Install, test, and deploy the RDBMS software with minimal interruption to services Resolve various ORA-600 and ORA-745 errors by finding solutions and work around with Oracle support.
  • Configured Oracle Physical Standby for several POC projects and RMAN backup testing.
  • Worked in VMware setup to test various Oracle upgrades.
  • Additional tasks performed creation of schema objects (tables, partitioning, views, indexes, packages, triggers, etc.), Code walk through and enhancement with the developers.
  • Installed, configured and monitor Oracle Database and Firewall 12.1.1.0 to centrally collect audit logs from several Oracle and SQL Server databases.
  • Setup and worked with Hadoop (Cloudera) on Oracle Virtual Box for the proof of concept Limited knowledge and experience with Oracle MySQL.
04/1999 to 11/2003 Oracle DBA/Software Engineer Suny Plattsburgh | Plattsburgh, NY,
  • E-Business Developed SQL Loader scripts for 20 batch jobs to quickly load 22 million rows of data into tables from various data files and sources daily to refresh wireless customers for enrollment process.
  • Maintained six oracle environments and provided monthly database maintenance support on ONE-BILL application.
  • Installed and configured Oracle 9.0.2.3.0 to migrate ONE-BILL database; converted schema, views, packages, stored procedures, and triggers Jessica Claire Page 3 of 3 Designed and developed Web based ONE-BILL application to combine bills for Verizon Wireless and Verizon Communication landline customers in Oracle 8.1.7.2 on SUN Solaris 2.8 through the Web GUI.
  • Reduced churn by 49% for both the landline and wireless customers, which directly translated into increased revenues and lowered costs; saved Verizon over $1 million since launch in July 2002.
  • Supported 3,000 enrollments per day with 2,000 representatives logging in the application to enroll customers.
  • Developed numerous PL/SQL packages, Stored-Procedures and Triggers, Views to support the application flow and business logic.
  • Developed and tuned SQL scripts for reporting purpose Maintained 6 oracle environments for ONE-BILL project.
  • Provide monthly database maintenance support on ONE-BILL application, which included new Tables, Views, Stored-Procedures and Triggers to enforce and maintain business rules.
  • Oracle DBA, Verizon.com Team Member Performed daily technical support, operations, and maintenance of Oracle databases (7x, 8x, 9x) in the E-Business.
  • Installed relational database systems software on database servers and administered Oracle databases for numerous applications on UNIX systems.
  • Created database instances, imported, and exported data.
  • Assisted with schema design and implementation to the development team.
  • Analyzed and optimized query performance, managed data space and administered users, monitored database instance, and set up data protection.
  • Configured new Oracle implementations for testing, development, and production environments; Designed and developed Oracle databases that support the registration, billing for Verizon.com Web site.
  • Set up scripts in PL/SQL and UNIX via SQL Loader and export/import utilities to load 140 million rows of data.
  • Wrote stored procedures and triggers to enforce business rules.
  • Setup snapshots and views for distributed database synchronization.
  • Increased performance by tuning SQL code, database parameters, and balanced I/O.
  • Developed and improve scripts in PL/SQL and UNIX shell scripts that modify database schemas import and export data.
  • Create scripts to extract, manipulate and modify data in tables across various schemas.
  • Developed scripts in PL/SQL and UNIX that backup, restore and recover database servers.
  • Tune application SQL, indexes, views etc, to meet performance objectives.
  • Determine storage and sizing parameters for tables and indexes for various projects.
04/1998 to 04/1999 Programmer/Analyst Scientific Systems & Software International Corporation (SSSI) | City, STATE,
  • Developed and maintained a Small Business Disadvantage tracking system (SDB) for Small Business Administration (SBA) in Oracle 7.3.4.
  • Incorporated responses from the application in the Access database to Oracle database using UNIX scripts and SQL.
  • Developed and updated data models in Erwin; used SQL queries to update and modify data in Oracle databases.
Education
Expected in 1999 to to Master of Science | Information Systems (MIS) University of Baltimore, Baltimore, MD GPA:

Information Systems (MIS)

Expected in 1998 to to MBA | Kansas State University (KSU), Manhattan, KS GPA:
Expected in to to | University of Baltimore, , GPA:
Expected in 1994 to to BS | , , GPA:
Expected in to to Bachelor of Science | Electrical Engineering , , GPA:
Electrical Engineering
Expected in to to Master of Business Administration | Information Systems , , GPA:
Information Systems
Certifications
Oracle 9i Certified Administrator (OCA) *Oracle Database 12c: Backup and Recovery Workshop Ed 1
Skills
ASM, auditing, Automation, Backup, billing, Born Shell, Business Administration, C, capacity planning, com, Concept, customer satisfaction, data warehouse, Databases, Database, designing, disaster recovery, E-Business, Erwin, features, Firewall, GUI, HP, HP-UX, HP UX, Java, JDBC, Linux 4.0, Linux, Linux 4, Linux5, logging, logic, managing, mentor, Access database, Windows, 9x, MySQL, Enterprise, OCR, Operating system, Oracle 9.0.2, Oracle 9, Oracle Discoverer, Oracle Application Server, Oracle 7.3, Oracle, Oracle database, Oracle DBA, PL/SQL, Oracle and SQL, Oracle 7, Oracle 8, page, problem resolution, Project Lead, Quest, RDBMS, Red Hat, relational database, reporting, Sarbanes-Oxley, servers, scripts, Script, SUN Solaris 2.8, Sun Solaris 2.x, SQL, SQL Loader, switches, Symposium, Tables, technical support, TOAD, UNIX, UNIX shell scripts, UNIX scripts, upgrades, upgrading, upgrade, utilities, NetBackup, Web site

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

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Baltimore
  • Kansas State University (KSU)
  • University of Baltimore

Job Titles Held:

  • Lead Oracle DBA
  • Oracle DBA/Software Engineer
  • Programmer/Analyst

Degrees

  • Master of Science
  • MBA
  • BS
  • Bachelor of Science
  • Master of Business Administration

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

*As seen in:As seen in: