We provide IT Staff Augmentation Services!

Sr Oracle Dba Resume

0/5 (Submit Your Rating)

Columbia, SC

SUMMARY

  • 12+ years of experience in Information Technology industry wif10+ years of experience as Oracle DBA, Oracle Form /Report, Oracle EBS, Software Development Life Cycle and extensive experience
  • Oracle Linux/Solaris/Windows OS OracleRDBMS & and SQL Server databases
  • Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration
  • Oracle Web Services for Fusion Middleware (Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11gR1
  • Installation, configuration, cloning, maintaining user management issues and space management, Patching database, backups (logical and physical)
  • Large Oracle Database Migration across different OS platforms.
  • Oracle RAC 11g/12C grid Infrastructure one node, multi node installation and configuration schema updates, data migrations, tech upgrades, user maintenance, troubleshooting, backup management, performance tuning, data recovery, and disaster recovery planning
  • Oracle GlodenGate 11g/12c installation, Configuration on Oracle Exadata.
  • Oracle GlodenGate replication to migrate data.
  • Assisted in management and database administration of Oracle database applications on Oracle Exadata platforms.
  • Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Oracle E - business suite extensions for Endeca and oracle Endeca information discovery wif FMW HOME and WebLogic server 10.3
  • Change Management in Production and non-Production instances through ITG Kintana applications
  • Documentation, software development methodology, version control, testing, and migration standards.
  • Performance Tuning of SQL statements and Database using tools like AWR, Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
  • Oracle Active Dataguard for high availability/disaster recovery setup (implement and test DR plan)
  • Replication, Performance Tuning, RMAN, ASM, RAC, OEM
  • Handled more TEMPthan 400 databases wif max size of 15TB.
  • Data Pump and Exp/Imp utilities, replication of tables to cross platform and Creating Materialized Views, PL/SQL and stored procedures and SQL scripting,
  • PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Created PL/SQL stored procedures, functions and packages, creating indexes on teh tables for faster retrieval of teh data to enhance database performance.
  • Oracle E-Business Suite 11.5.10 (11i), 12.2.5 (R12) installation, configuration, Patching, Cloning, Upgrade.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Diagnosis and troubleshooting typical SQL, PL/SQL Tuning issues
  • Data modeling, Table restructuring, data loading wif external tables in oracle database
  • Disaster Recovery Strategies, testing & implementation
  • Support and manage Onsite-Offshore model for Production in 24/7 systems, Development and Test instances and Oracle Applications environments of varied complexity.
  • Installation and Administration of Oracle products such as Oracle Application server and non-Oracle products such as Kintana (ITG), Noetix
  • Create Endeca Discoverer applications to do analysis of Data.
  • Installation and configuration of Sun Solaris 10
  • Installation and configuration of Sun Storage T3 and T4
  • Development of application using Oracle Form 6i, 11g Developer.
  • Financial Application development using Microsoft Visual Basic, MSSQL Server
  • Installation and administration of Microsoft SQL Server 2000
  • Installation and configuration ofHadoop HDFS Cluster, Pig, Hive, Spark, MATLAB

TECHNICAL SKILLS

Platforms: Linux, HP-UX, Oracle Exadata, Oracle Solaris SPARC 8/9/10, Windows (NT2008R2), RHEL 5/6

Database: Oracle 12C, 11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4 ), Oracle 10g, Oracle 9i/8i, MS-SQL Server (7,2000) 11gR2 active data guard

ERP Applications: Oracle E-Business Applications 11i (11.5.4, 11.5.9/ 11.5.10.2 ), R12 (12.1.3/ R12.2.5)

Languages: PLSQL, UNIX Shell Scripts, Java, Visual Basic,C,C++,Oracle Forms 6i/11g,Windows Power Shell.

Third Party applications: HP Kintana Applications (ITG for deploying scripts, forms, reports, objects), OBIEE, E-business Endeca applications, Share point, NOETIX,Excel4apps

Tools: & Utilities: Oracle Enterprise Manager (OEM),Oracle Gloden Gate, SQL Developer, Endeca, Oracle Hyperion, Toad, VNC, Hadoop Cluster, Secret Server (Enterprise Password Management), NetApp Backup, Cassandra NoSQL database,MATLAB, Delphix

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

Sr Oracle DBA

Responsibilities:

  • End to end Support and implementation for more TEMPthan 100s 11g and 12C Production, UAT and Development database.
  • Oracle Database db fresh, schemarefresh, creation of new database for DEV, TEST, UAT environment.
  • Installation, Configuration, deployment of Oracle Grid Infrastructure Cluster, RAC 3 node, 2 node environment for Production databases.
  • Installation, configuration, deployment of Oracle Enterprise Manager (OEM 11g,12c) and OEM agent deployment for Production, UAT and DEV environment.
  • Daily database monitoring activity which includes oncall DBA, responding to Production database alerts, warnings and try to meet SLA for Severity 1 issues.
  • Installation, configuration of Oracle Data guard (Disaster -Recovery).
  • Oracle High Availability (HA) RAC environment Disaster Recovery testing to make sure RAC environment is working well if in case of node failure, ASM instance failure, network failure wifout interrupting end user connections.
  • Deployment and testing ofRMAN database backup and recovery strategies.
  • Performs tuning of teh databases and halping developer team to tune SQL and PL-SQL.
  • Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
  • Enable audit for schema/tables and password management, SOX audit, extensively used profile based users.
  • Installation, configuration and deployment of unidirectional Oracle Gloden Gate setup.
  • Migration of large data from external Client database like Text/CSV files, MSAccess, MS SQL Server to Oracle Database.
  • Manage sharing of resources among applications and Multiple Standby Database setup for Critical databases.
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and creating new instances when require.
  • Attending daily scrum, Kanban meeting wif different stake holder including Business Analyst, Developer, Testing Team and other DBA Teams.
  • Create, update and maintaining of User Stories (US) as per user requirements in JIRA, Rally agile Softwares.
  • Design and deployment for MATLAB software for Machine Learning Technic to analyze System, Database and application log files to make prediction and analysis of system overall performance.

Environment: Oracle RDBMS 12C/11gR1/11gR2/, RMAN, Oracle Linux 6, OEM11g/12c, Oracle Gloden Gate Share point, MS SQL Server 2015, Rally, JIRA, KANBAN, MATLAB

Confidential, St. Louis, MO

Senior Oracle DBA

Responsibilities:

  • End to end Support and implementation for Oracle 11g/ Dev/Test/Production instances for multiple applications.
  • Daily backups and db refresh from production database to Dev/Test
  • Migration of teh databases and applications between different file systems on different filers.
  • Install new versions of teh Oracle RDBMS and its tools and any other tools that access teh Oracle database
  • 11gR2 active dataguard and DR drill (once in 6 months)
  • Plans and implements backup and recovery of teh Oracle database.
  • Installation and configuration of Oracle Developer Suite 11g (Forms, Reports)
  • Installation and configuration of Oracle WebLogic Server 10.1.3
  • Create users and provide access to developer team wif required privileges
  • Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
  • Installation and configuration of Oracle Form 11g, Reports, Toad, WebLogic 10.3
  • Help BA and Development team to Tune teh Business Rules, Tune teh Data Design, Tune teh Application Design
  • Frequently checking if require changes to teh data design and additional creation of indexes to increase performance of application
  • Help to Development team to understand Oracle's query processing mechanism to write effective SQL statements.
  • Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

Environment: Oracle RDBMS 12C/11gR1/11gR2/ RMAN, Oracle Linux 6, OEM11g/12c, Oracle Form 11g, Report, Web logic Server 10.1.3, Share point

Confidential, O’Fallon, IL

Principle Oracle DBA

Responsibilities:

  • End to end Support and implementation for 11g and 12C Production instances.
  • Daily backups and daily refresh instances.
  • Oracle patching on DEV, UAT and Productions.
  • Supported Kintana database upgrades from 10g to 11g and agile upgrade
  • Migration of teh databases and applications between different file systems on different filers.
  • 11gR2 active dataguard and DR drill (once in 6 months)
  • Oracle Database Cloning on Linux.
  • Installation, configuration and maintenance of Hyperion EPM 11.1.2.3
  • Assists wif impact analysis of any changes made to teh database objects.
  • Closely works wif system administration, Network and Linux teams
  • Performs tuning of teh databases and Performs teh capacity planning to create & maintain teh databases
  • Install new versions of teh Oracle RDBMS and its tools and any other tools that access teh Oracle database
  • Plans and implements backup and recovery of teh Oracle database.
  • Apply Oracle database patches (opatch) Critical Patch Update (CPU), Patch Set Updates (PSU), Security Patch Update (SPU)
  • Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views
  • Enable audit for schema/tables and password management, SOX audit, extensively used profile based users.
  • Installed and configured glodengate on Exadata. Implemented broadcasting and bi-directional replication.
  • Resolved replication issues in Glodengate. Automating tasks using cron for GG restart
  • Configured GlodenGate to achieve unidirectional and bidirectional replication.
  • Prepare GlodenGate parameter files for Extraction and Replication
  • Performs database re-orgs as required to assist performance and ensure maximum uptime of teh database.
  • Provides technical support to application development teams
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and creating new instances when required
  • Manage sharing of resources amongst applications and Multiple Standby Database setup for Critical databases.
  • Closely work wif Onsite-Offshore DBA and Development Team.
  • Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.

Environment: Oracle RDBMS 12C/11gR1/11gR2/10g/9i, RMAN, Oracle Linux 6, OBIEE, OEM11g/12c, Hyperion EPM 11.1.2.3,Share point, Secret Server (Enterprise Password Management), Oracle EBS 11i

Confidential, O’Fallon, IL

Senior Oracle DBA

Responsibilities:

  • Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle Development and Test Instance.
  • End to end Support and implementation for Oracle 11g all Pre- Production instances.
  • Co-ordination between Development and DBA team
  • Discussion wif Customer for future project implementations.
  • Installation, Monitoring and Administration of SUN SOLARIS Server.
  • Installation and configuration of different third party tools.
  • Closely works wif Network teams
  • Performs tuning of teh databases and Performs teh capacity planning to create & maintain teh databases
  • Install new versions of teh Oracle RDBMS and its tools and any other tools that access teh Oracle database
  • Installation, configuration and maintenance of Hyperion EPM Release 9.3.3

Environment: Oracle RDBMS 11gR1/11gR2/10g, RMAN, Oracle Solaris, Share point, Hyperion EPM Release 9.3.3, Oracle EBS 11i

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

  • Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Oracle EBS 11i Development, Test, UAT and PROD Instance
  • End to end Support and implementation for EBS 11i Production instances.
  • 11gR2 active dataguard and DR drill (once in 3 months)
  • Cloning of Dev,Test and UAT instances from Production
  • Patch analysis, Patch application on DEV UAT PROD using Kintana Package
  • Discussion wif Customer for future project implementations.
  • Installation and configuration of different third party tools.
  • Closely work wif Onsite-Offshore DBA and Development Team.
  • Plans and implements backup and recovery of teh Oracle database using NetApp Backup.
  • Installation and configuration of Neotix, kintana tools

Environment: Oracle RDBMS 11gR1/10g, RMAN, Oracle Solaris, Share pointKintana, Neotix

Confidential

Oracle DBA and MSSQL Server DBA

Responsibilities:

  • Installation, configuration, Cloning, Patching, Upgrade, Monitoring and supporting Finance ApplicationDevelopment, Test, UAT and PROD Instance
  • Patch analysis, Patch application, Cloning.
  • Regularly Checking Alert log, Implementing Backup strategy. Monitoring Users, Concurrent Managers using Sysadmin, Pro-Active Checks up on teh Database
  • Installation, configuration and Implementing Backup strategy of MS SQL Server 2000.

Environment: Oracle RDBMS 10g/9i, RMAN, HP -UX, MSSQL 2000

Confidential

Software Developer and MSSQL Server DBA

Responsibilities:

  • Successfully analyzed all business rules for Voucher Transaction module.
  • Explored some features to implement these business rules available in Oracle 8i. Declared prototypes of functions used in this module, defined Oracle Form Screen interface, formatted different financial report required in system in Reports
  • Implemented user interface screen for above-mentioned modules. Implemented functionality of validating data, wrote Oracle Form and SQL & PLSQL source code for Voucher Transaction, deposit, Simple/Cumulative interest calculations, interest posting Designed reports for teh modules. Successfully installed application at client side and gave client side support for teh product.

Environment: Visual Basic 6.0,MSSQL Server 7/2000, Crystal Report 7, Oracle form 6i, Oracle RDBMS 8i, Visual Source Safe, MS office 2000

We'd love your feedback!