We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Sterling, VA

SUMMARY:

  • Around 6 years IT working experience, and more than 5 years oracle database administration experience supporting a variety of mission critical applications in enterprise and production environment.
  • Experience in planning, design, install, configure, perform upgrade and maintain oracle 9i, 10g, 11g (release 1 and 2) and 12c across multiple platforms, like Sun Solaris, RHEL, AIX, and HP - UX.
  • Proficient in Install, upgrade, clone, administrate, patch and troubleshoot oracle databases.
  • Thorough knowledge of various Oracle tools like OEM with management pack, RMAN, SQL Loader, Statspack, AWR, SQL trace to perform day to day job.
  • Proficient in installation, configuration, administration, patching and maintenance of ORACLE 10g/11g/11gr2/12c RAC multi-node cluster and add/remove node as per need.
  • Configure, implement, maintain and troubleshoot errors of physical and logical standby databases DataGuard .
  • Replication, extract and apply on production using Golden Gate.
  • Installation and maintenance of OEM 11gr2/12c Database & Grid control for database monitoring, performance and diagnostics.
  • Oracle database implementation, configuration, administration.
  • Configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flashback Technology.
  • Logical and physical data modeling and database design using Oracle Designer.
  • Backup and Recovery strategy development (hot / cold) and implementation with through understanding of Database Recovery Scenarios.
  • Proficient in UNIX and Linux Shell Scripting, Oracle Net, TCP/IP, Stored Procedures, Functions, Cursors, Triggers and PL/SQL programming.
  • Security management using auditing, performance monitoring / tuning / troubleshooting on various levels, storage management, data migration from other databases to Oracle, Oracle/Crystal Reports and Cloning & Replication of Oracle Dat1abases.
  • Complete Oracle lifecycle experience from concept to design, architecture, hardware selection, installation & patches, configuration, database security & space management, performance monitoring & tuning, data integrity, backups & recovery planning and 24 x 7 supports.

TECHNICAL SKILLS:

Tools: DBCA, OEM Grid Control, RMAN, RAC, PL-SQL Developer, OWB 11gR2, DB Tools, OTM, TSM, GoldenGate.

DBMS: Oracle 10g, 11gR1/2, 12cR1, Oracle EBS, MSSQL, MS Access, MySQL.

Languages/Platforms: Forms/Reports,Designer, Import/Export/DataPump, SQL, SQL*Loader, SQL*Plus, C/C++, Perl/Shell programming, Python

Operating Systems: Sun Solaris, Linux, UNIX, DOS, Windows 2003/2000

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Sterling VA

Responsibilities:

  • Performed fresh Installation, Configure, Administrate and Maintained Oracle 11gr2/12cR1 databases.
  • Participated in oracle 12c upgrade, administration and golden gate training from oracle.
  • Performed Oracle Grid Infrastructure, database upgrade from 11gr2 to 12cR1 by command line and Golden Gate.
  • Created step by step instruction checklists/documents for database design, installation, patching, upgrade and administration.
  • Worked closely with project managers, middleware tools teams, testers and developers to provide best application performance.
  • Provided access of database and grant required permissions and audited actions of tools & testing team.
  • Involved in analysis and development of data warehousing applications.
  • Setup auto alerts and corrective action jobs from OEM and LDAP.
  • Implemented user and object level security, data encryption, data masking, fain grained auditing using DBMS packages.
  • Performed database and SQL tuning to lessen performance impact after oracle 12c upgrade.
  • Performed large batch jobs and tuning of SQL queries and database systems.
  • Provided assistance to client in database configuration and administration.
  • Configured and maintained Production database replication to client site using Golden Gate.
  • Used effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Performed adding/removing a node on test server cluster for production POC and added node on Production Environment for high availability.
  • Used data-guard to minimize downtime in Production server upgrade project.
  • Used active database, ASM Copy, RMAN and Data Pump to copy/create database for development/testing team.
  • Involved in designing, assembly and tuning of database for development teams.
  • Performed installation, upgrade, patching and configuration of OEM Cloud Control and Agents for database, RAC monitoring and data masking.
  • Scheduled auto maintenance and corrective actions jobs in OEM to reduce
  • Supported oracle installation, configuration, patching, database backups and assistance to developer with oracle and OWB issues, also add, remove, configure, support OWB workspace and troubleshoot OWB services when necessary.
  • Written K/Bash shell scripts for auto monitoring, backup validations and other corrective action tasks.

Environment: Oracle 11gR1/2, 12cR1, Grid Infrastructure 11gr2, 12cR1, MSSQL 2k3/8, Golden Gate,RAC, OMS 12c, OWB, SQL Developer, Windows.

Oracle DBA

Confidential, Atlanta GA

Responsibilities:

  • Performed fresh Installation, Configure and Administrate Oracle 11g.
  • Supported the application and GUI team to design and develop data models for the current and future CRM applications.
  • Develop documentation related to design, build, deploy and maintenance best practice for databases.
  • Design / Develop / Deploy logical and physical model into various environments to support application Dev-Prod-CRM launch related activities
  • Conducted data model reviews with project team members and client.
  • Worked closely with project managers, programmers and testers to database integrity and security and generated test data and tested new database consistency with existing database to meet the functionalities requirements.
  • Performed Change Control Process
  • Prepared documentation, following process and procedures
  • Created and modified triggers, cursors, functions and procedures.
  • Experienced with logical and physical data modeling and database design using Oracle Data Modeler.
  • Performed migration between MySQL-Oracle and loaded the data using SQL Loader
  • Performance Tuning at DB level, OS level and Object level.

Environment: Oracle 11g (11.2), Oracle Application Release 11i, MySQL DB, Oracle Data Modeler, Dataguard, SQL Developer, Oracle on Linux, MySQL.

Confidential

Oracle DBA

Responsibilities:

  • Installed, configured and maintained Oracle 10g on Linux also upgraded from Oracle 10g to 11g.
  • Implemented Oracle Database 10g two node Real Application Cluster (RAC) using Oracle Cluster-ware and was responsible for high availability and load balancing.
  • Configured Oracle Data guard for Oracle Disaster recovery.
  • Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
  • Created and modified procedures, triggers and functions.
  • Created all administration tasks of SQL Server and designed database.
  • Used system stored procedures and DBCC commands.
  • Planned Replication set up for banking software between SQL Server 2000 and local access database.
  • Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
  • Set up backup using Veritas, checking event viewer on Windows Server 2000/03 and developed recovery procedures.
  • Proficient in Windows Server 2003, Windows XP, Linux, OS2 operating systems
  • Knowledgeable in Microsoft Exchange, MS SQL, MySQL, IIS, VPN.
  • Active Directory administration, user logon scripts
  • Security administration over web servers, mail servers using SSL sockets, firewall
  • Created DTS packages for migration of data from SQL Server to MS Access or Oracle databases.
  • Created automatically running stored procedures for day-end operation using SQL Server agent.
  • Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
  • Created and supported complex database schemas
  • Designed data models
  • Implemented Microsoft SQL 2005 Server in a test environment.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: Windows 2003 server, oracle 10g, 11g, ASP 3.0, XML, MS SQL Server 2000 (Enterprise Manager, Query Analyzer), TSQL.

Hire Now