We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

St Louis, MO

PROFESSIONAL SUMMARY:

  • Sr. Oracle DBA certified in Oracle database 11g Associate database administration with 7 plus years of experience in oracle database administration and maintenance tasks on all major flavors of UNIX including development experience in PL/SQL.
  • Hands on experience in Oracle10g/11g/12c RAC implementation and administration (OracleCluster - ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding anode to this cluster database for High Availability and Recovery.
  • Experience in Implementing, configuring, troubleshooting, switchover, failover of Physical Standby Data Guard on 10g/11g/12c.
  • Installation, Configuration and administration Oracle Golden Gate.
  • Experience in Database Upgrades in 10g and 11g and Data Migration using Data pump utility, Non RAC to RAC and Non-ASM to ASM.
  • Experience with (OEM) Oracle Enterprise Manager (Cloud Control) 12c / 11g for monitoring, alerting, and provisioning of databases.
  • Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
  • Experience in working with Oracle on Exadata related Issues/Investigations and Troubleshooting Exadata.
  • Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Views, materialized views, Bulk collect, Analytic functions e.g. ratio- to-report, rank etc. Roles and privileges and others in Oracle12c/11g/10g database.
  • Experience in implementing Flash Back Pointing Time Recovery.
  • Writing UNIX shell scripts to manage Oracle environment and application processes.
  • 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Tools: Oracle 12c/11g/10g, RAC, Data Guard, Golden Gate, Performance Tuning, Exadata, Import and Export, Data Pump, Automatic Storage Management, Recovery Manager, Red Hat Enterprise Linux, PL / SQL, Unix Tools and Scripting

Database: Oracle 12C, Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, Oracle X2/X3/X4 full rack Exadata machine.

Operating System: Oracle Linux, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Sr. ORACLE DBA

Responsibilities:

  • Installed Grid Infrastructure Software on new Linux Servers for 3node and 6nodeRAC and Failover environments.
  • Managed database security. Designed and implemented Permissions Security Project, which provides highest level of the application security.
  • Working with different teams (STORAGE, LINUX, CLOUD) in accordance to tasks such as adding ASM Disks to the Databases.
  • Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 11g and 12c.
  • Participated in analysis and designing of Oracle Exadata server for infrastructure and involved with subject matter experts for related projects.
  • Experience in developing Data Conversions/Data Migration ETL from Legacy System of various sources flat files, excel, Oracle, Non Oracle to Oracle system Using SQL Loader, UTL FILE.
  • Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools SQLTrace, AWRreports, ADDM, and Oracle Enterprise Manager.
  • Handy in utilizing data pump tool for exporting and importing the data between databases.
  • Implementation of Docker, and various Docker orchestration tools such as docker-compose, docker swarm, boot2docker and various other management tools.
  • Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Trace, Hints. SQL, PL/SQL and UNIX shell scripting.
  • Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.

Environment: RHEL, AIX, Windows 4.2, OEM12c / 11g, Oracle 10g/11g/12c, RAC, SQL* Loader, Perl scripting, Putty, RMAN, ASM, Data Guard, OracleX2, X3, X4 Exadata database machine.

Confidential, Princeton, NJ

Sr. ORACLE DBA

Responsibilities:

  • Installed Oracle 12c on Linux and Worked on RAC11g and ASM feature.
  • Extensively worked in setting up physical standby database using Data guard on Oracle 11gR2.
  • Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Data guard status via DGMGRL and GUI.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation of Duplicate Databases using RMAN Backups.
  • Upgrade of database (10g to 11g and 11g to 12c) and applying patches whenever required.
  • Migrated Non-ASM databases to ASM environment for high availability on 11g.
  • Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups.
  • First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machineX2, X3 and X4 including upgrades and patching.
  • Provide and implement performance-tuning recommendations of all components in Exadata database machine.
  • Identifying business requirements and mapping them to the Oracle Cloud functionality and configuring the Oracle Cloud Applications to meet requirements along with documenting application set-ups.
  • Worked closely with the developers & Application team for every monthly release structural / DDL changes activities to the production Databases.
  • Having good exposure in user management, table space management, session management, undo management issues.

Environment: RHEL 6, Windows, Sun Solaris, Oracle 11g/12c, Data guard, SQL*Plus, Oracle ERP, pentaho data integration, Atlassian, Toad, Jenkins, Shell Scripting.

Confidential, Dayton, OH

ORACLE DBA

Responsibilities:

  • Responsible for maintaining Oracle 11g/10g standby databases in Red Hat Linux.
  • Responsible for Installation of RAC and Managing RAC Environment efficiently.
  • Resolving the issues in conflicts between the target and source database in Golden gate.
  • Migrated Non-ASM databases to ASM environment for high availability on 11g.
  • Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
  • Applied CPU security patches in both RAC and standalone systems in ASM environment.
  • DBCA for database creation.
  • Also configured database cloning using RMAN.
  • Backing up system & user databases and restoring them as required and Create Database users and roles and implement appropriate user security.
  • Daily Health Check Up of the Database and SQL Queries using AWR and ADDM.
  • Worked on setting up auditing in databases.
  • Experience with DDL and DML operations and having sound knowledge.
  • Good experience with Oracle performance issues in both application tuning & memory tuning.
  • Writing UNIX shell scripts to manage Oracle environment and application processes.

Environment: RHEL 6, Windows, Sun Solaris, Oracle 11g/12c, 10g/11g RAC, 10g Grid, OEM, RMAN,ASM, Data guard, SQL*Plus, Shell Scripting.

Confidential, Oklahoma

ORACLE DEVELOPER / DBA

Responsibilities:

  • Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
  • Implemented Monitoring Templates and Incident Rule notifications using OEM 12C for database alerting.
  • Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
  • Worked with database export & import scripts to backup database structures and automation procedures.
  • DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
  • Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via shell scripting.
  • Space management on file system and ASM.
  • Having experience in using oracle in built packages DBMS JOB, DBMS SCHEDULER, DBMS ALERT, DBMS SQL, DBMS OUTPUT, DBMS AQ.
  • Created disk groups with required redundancy levels.
  • Provide development and production support related to database.

Environment: Oracle 10g/11g/12c, Toad, Putty, RHEL SOLARIS.

Confidential, Benicia, CA

JR. ORACLE DBA / DEVELOPER

Responsibilities:

  • 24/7 support for databases and critical production operations teams.
  • Perform daily maintenance tasks on ORACLE databases such as monitoring of Alert log files and resolve issues, daily check on the application of archive logs.
  • Monitoring and tuning the database queries of the application team, using SQL Trace.
  • Performance Tuning by creating indexes and analyze the database objects when needed.
  • Generating performance reports using utilities like stats pack, AWR, ASH report to gather statistics.
  • Performed database cloning to setup test and development database.
  • Perform other regular DBA activities including space management and performance monitoring.

Environment: s: SUN Solaris, Oracle 8i/9i/10g/11g, RHEL 2. . el5.

Confidential

ORACLE DEVELOPER

Responsibilities:

  • Nearly 2 years of experience in the Oracle PL/SQL Developer/Tester in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS)
  • Strong RDBMS concepts including expertise in Pl/SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.
  • Experience in Shell Scripting.
  • Experience in Oracle Forms and Reports Developer.
  • Collaborated with the application developers in data modeling and E-R design of the systems.
  • Maintained the documents and create reports for the business analysts and end-users.

Hire Now