We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

PROFESSIONAL PROFILE:

Technology Specialist Senior Oracle Database Administrator with over 10 years’ experience on multiple platforms and environments including production, development and testing. Strong experience leading migration, high availability and disaster recovery initiatives and PL/SQL development. Recognized for superior troubleshooting and problem solving skills and a commitment to customer and end user support

SKILL SUMMARY:

Platform: Languages Database Tools ERP Software Soft Skill BM AIX 6.1 UNIX, Red Hat / Oracle Enterprise Linux 5/6, Windows 7/8/10, Windows 2008 /2012 Server, VMWARE, Sun Solaris, Oracle Web Logic 11g/12c, EM Cloud Control 12c/13c SQL, T - SQL, PL/SQL, UNIX Shell Script, VBSCRIPT, HTML, XML, COBOL, Perl, Java, Python Oracle Database 9i, 10g, 11g and 12c, SQL Server 2005/2008/2012 , PostgreSQL, MySQL SQL1Plus, SQL*Loader, TOAD, Recover Manager (RMAN), Oracle Enterprise Manager (OEM), Grid/Cloud Control, Data Pump, Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, Oracle Reports and Forms Developer 6i/10g, PL/SQL Developer, SQL Navigator, SQL Developer, FNDLOAD, OS Watcher, Statspack, TKPROF, SQL Server Management Studio, SFTP, SSH, Oracle Alerts, Form Personalization, TCP/IP, Oracle Concurrent Manager, Oracle Maintenance Wizard, Financial Statement Generator (FSG) Oracle E-Business Suites 11i (11.5.10.2) / R12.1.3 - General Ledger (GL), Accounts Payable (AP), Account Receivables (AR), Cash Management (CM), Projects (PA), Grants (GmS), iProcurement and Customer Relationship Management (CRM) Modules; PeopleSoft and Banner Applications SQL Server Reporting Services (SSRS), Visual Studio, Panaya, Mantis Hub, Subversion (SVN), Veritas, Microsoft Office (Word, Excel, Power Point, Outlook, Access, Visio, Projects), SecureCRT, Uni-Center, Remedy, Putty, MobaXterm, QuickBooks, XML Publisher Energetic self-starter with excellent analytical and organizational skills. Strong customer service, leadership and team building skills; excellent verbal and written communications skills

EMPLOYMENT SUMMARY:

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

  • Perform database backup and recovery duties, establish standards and schedules for database backups, develop and test recovery procedures, and ensure backup schedules meet the recovery requirements
  • Regularly present professional development workshops to clients of varying sizes on a variety of advanced Oracle Database and PL/SQL topics including Real Application Cluster(RAC), Oracle Active Data Guard, Oracle eBusiness Suite Development, industry best practice, collaboration, professionalism, creative problem solving, coaching and mentoring, adapting to change, and customer service

Oracle Database Administrator

Confidential, Decatur, GA

Responsibilities:

  • Provided administration, monitoring and support for Oracle 10g/11gR2 including installation, database creation, database optimization, alert configuration and performance tuning using snap shots taken by Automated Workload Repository (AWR) / Automatic Database Diagnostic Monitor (ADDM); and plan and implement backup, recovery and cloning of Oracle databases with RMAN and Data Pump
  • Created, tested and implemented the county’s first production failover site using Data Guard (Physical & Snapshot standby databases), Automatic storage management (ASM) and Real Application cluster (RAC), ACFS on Linux platform.
  • Implemented Oracle Enterprise Manager Grid/cloud Control (OEM 12c) for centralized monitoring and administration.
  • Clone Databases using RMAN scripts to support development, training and testing environments
  • Created and maintained UNIX shell scripts and VBSCRIPTS to simplify database support tasks including RMAN database backup/recovery, database refresh and CRONTAB jobs.
  • Upgraded production database from 10g to 11gR2
  • Created, modified and maintained Oracle database objects and storage structures including tablespaces, tables, users, roles, profiles, directories and indexes.
  • Worked with developer group to review, test and install Oracle recommended patches to fix Oracle Applications issues/bugs
  • Worked as one of the Techno-functional Leads in the upgrade project of Oracle eBusiness Suite Application from 11i to R12 and database from 10g to 11gr2 on IBM AIX platform
  • Served as a technical and training resource for other members of the Database Administration/Development team. Mentor other DBAs/Developers in adhering to coding standards, Change management methodology and SOX Controls
  • Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, explain plan and TKPROF as well as create/follow-up of service requests (SRs) via Oracle Support/Metalink
  • Analyzed and applied PSU and other patches to Grid Infrastructure and Database Instances
  • Interact with end users via telephone, email, ticketing system or in person to provide daily technical and functional production support for Oracle e-Business Suite 11i/R12 - GL/AP/AR/CM/P&G/iProcurement and CRM modules
  • Work with users to gather and review project requirements and develop detailed designs to implement those requirements.
  • Design, develop/modify, test and deploy custom reports and forms using PL/SQL, Oracle Reports and Forms Developer within Oracle e-Business Suite
  • Design, develop, test and implement interfaces between Oracle e-Business Suite (GL/AR/AP/CRM) using custom / Standard API and Open interfaces
  • Design, develop, test and implement PL/SQL stored procedures, functions, triggers, types, packages as well as customize Oracle Alerts to monitor and notify users on the status of interfaces between Oracle Applications and other applications.
  • Write technical design documents for conversions, extensions, interfaces, and reports using AIM methodology (MD.050, TE.040, TE.050, MD.120, BR100, and MD.070).

Environment: Oracle E-Business Suite 11i/R12.1.3, PL/SQL, FNDLOAD, SQL*Loader, Oracle 9i/10g/11g, Oracle Report/Forms Developer 6i/10g, TOAD, SQL*Plus, SecureCRT, Red Hat Linux 6, IBM AIX ver. 7.1 UNIX, CA-Unicenter, VBSCRIPT, UNIX Shell Script, Windows 2003/2008/2012 Server, SQL Server 2005/2008, SSIS,SSRS,SSAS,OBIEE, PeopleSoft, Banner Application

Application Support Specialist

Confidential, Atlanta, GA

Responsibilities:

  • Act as a liaison and leader to resolve application or system issues working with cross-departmental teams: application developers, quality assurance testers, other application support individuals & server, network and database administrators.
  • Enhanced end users’ understanding of Applications and database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
  • Analyze, develop, implement, and support technology solutions for users to include; process improvements, troubleshooting, production support, and new product implementation
  • Work closely with: Architects, Development and Integration Leads, Database Administrators, Hardware Engineers, External Integrators (consultants), and a mix of On-Off Shore Developers to deliver new functionality to Custom application.
  • Documenting, tracking and monitoring issues to ensure a resolution within Service Level Agreements (SLAs)
  • Compiling and maintaining metrics reports
  • Training users on existing and future functionality of the application systems
  • Facilitating user acceptance, testing and future functionality
  • Researching issues by using SQL query on Oracle 9i/10g and SQL Server 2005 Database
  • Develop, test, and modify custom PL/SQL stored procedure, function, trigger, and package to meet user requirements

Environment: Oracle 9i/10g, Sun Solaris UNIX, Oracle Report/Forms Developer 6i, SQL Server 2005, PL/SQL Developer, SQL Server 2005 Management Studio, Mercury QTP, FogBugz, Epicor-Clientele, Microsoft Access, Word, Excel, PowerPoint, Outlook, Windows 2003 Server, Windows XP/Vista, Active Directory, Citrix

Oracle Developer

Confidential, Atlanta, GA

Responsibilities:

  • Perform systems analysis work and functions as a business liaison to gather business requirements from end users and translate them into technical specifications
  • Develop and maintained PL/SQL stored packages, functions, procedures, triggers and SQL scripts in Oracle 9i,10g and Solaris environment
  • Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution
  • Develop project plans and schedules for the System Development. Collaborate in the creation of overall project plans, resource allocations, and schedules to implement the specified system changes. Provide accurate and timely project status reporting that will inform Project Manager of the status of projects.
Environment: Oracle 9i, PL/SQL Developer, Mercury QTP, Microsoft Access, Word, Excel, PowerPoint, Outlook, Windows 2003 Server, Windows XP/Vista, Active Directory, Sun Solaris

We'd love your feedback!