We provide IT Staff Augmentation Services!

Oracle Dba Resume

3.00/5 (Submit Your Rating)

Jersey City, NJ

SUMMARY

  • Over 6+ years of experience in Oracle Databases as Administrator in Enterprise level Database Administration, Management and Operations.
  • Experience in Installing, Designing and Managing11g RAC/10g Databases on UNIX (HP - UX, IBM AIX, Sun Solaris),
  • Installed/configuredOracle 11g/10g Real Application Clusters (RAC).
  • Upgraded databases from Oracle 10g and 11g,
  • Experience in a 24*7 Production Database support role.
  • Extensive experience in Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
  • Design and implementation of Backup and Recovery strategies (both cold and hotbackups) and performing periodical backup, restoration and recovery using RMAN(full and incremental) of
  • Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
  • Excellent experience in database cross-platform migration
  • Expert in Installation, Configuration and Maintenance of Oracle Standby (Active Data Guard).
  • Monitoring databases and setting alerts using Oracle Enterprise Manager/Grid Control
  • Experience in database cloning/refresh, tuning, patching
  • Good experience in Database Design (Conceptual Design, Logical Database Design, Physical Database Design), setting up the complete Database with Security Implementation, troubleshooting Oracle issues.
  • Experience in Writing Shellscripts.
  • Excellent SQL and PL/SQL programming and debugging skills - Cursors, Functions, Stored Procedures, Packages and Triggers etc.
  • Expertise in maintaining DatabaseSecurity using auditing.
  • Proven ability to adapt to demanding schedules and changing priorities.
  • Excellent analytical, interpersonal and communication skills.
  • Able to work independently and collaboratively in Team environment.

TECHNICAL SKILLS

Database: 11g RAC, Oracle 10g RAC

Operating System: Sun Solaris 8, 9, 10, HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3, 6.1 RedHat Linux 4.x, 5.x, 6.x

Networking: TCP/IP, UDP, DHCP, LAN, VLAN, Firewall Security, Routing Protocols

Languages/Tools: Unix Shell Script, PL/SQL, C, C++, OEM/Grid Control/Cloud, RMAN, AWR, ASM, ADDM, SQLTRACE, EXPLAIN PLAN, TKPROF,dbca, Logical/ Cold/ Hot backup, Data Pump, SQL*Net, Toad

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Oracle DBA

Responsibilities:

  • Ability to participate and provide 24/7 supports.
  • Created tables, views, materialized views.
  • Extensive knowledge of the Oracle Database gained over years of experience in installation, configuration, maintenance, security, backup and recovery, troubleshooting, performance tuning ofOracle RDBMS in Linux/Unix and Solaris environments.
  • Proficient inOracle10g, 11g databaseAdministration.
  • Proficient inOracle Enterprise managerDatabasecontrol.
  • Proficient in RMAN backup & recovery policy design and procedure.
  • Proficient in Real Application ClusterDatabaseand Data-guard Administration.
  • Proficient in setting up and installation of Oracle, ASM, Cluster in large multi nodes.
  • Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
  • Strong in solving problems of diverse scope where technical analysis and evaluation is required.
  • Perform index rebuilds in regular intervals and avoiding fragmentation
  • Creating & maintaining database objects ddl scripts and providing application support
  • Results-driven IT personnel with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments.
  • Proficient inDatabaseMigration, Upgrade and Patch Application.
  • Implemented Backup & Recovery procedures using level 0/level 1 using RMAN also implemented Hot/Cold Backups using conventional method
  • Developed automated maintenance scripts using PL/SQL procedures triggers, functions, packages.
  • Performing support to issues related to the application.

Environment: Oracle10g/ 11g, RMAN, Red Hat Linux, Data Guard,PL/SQL, SQL* Loader, Data GuardExport/Import

Confidential, KY

Oracle Database Adminstration

Responsibilities:

  • Install, configure, manage and administerOracle10g/11g infrastructure databases in test, development and production environments running on Solaris Unix,Oracle Linux and Red Hat Enterprise Linux systems.
  • Perform installation ofOracle Database10g/11g software andOracleEnterprise Grid Control.
  • Administer and monitor databases using OEM Grid Control.
  • Install and configureOracle10g RAC databases with ASM, Clusterware on new servers.
  • Configure standbydatabase usingOracleData Guard for Data Replication.
  • Manage backup/recovery using RMAN backups performing hot and daily incremental backups.
  • Troubleshoot issues relating to performance or storage using SQL and PL/SQL.
  • Create and maintain users, roles, privileges and assign roles to users.
  • UpgradeOracledatabases to latest version and patch levels and work with developers to fix or improve databaserelated issues.
  • Designing the Oracle backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups,cold backupsanddata pump utilities.
  • Migrated databases to different environment using Data pump.
  • Support clients to resolve data related issues providing 24x7 rotational effort.
  • Created new hash, range and list partitioned and sub partitioned tables.
  • PerformeddatabaseupgradefromOracle10.2.0.4 to 11.2.0.2.
  • Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
  • Strong leadership qualities and result oriented.
  • Allocating system storage and planning future storage requirements for the database
  • Developed best practices for support with DBA teams.

Environment: Oracle 10g/11g, RMAN, RAC databases,Solaris Unix, OEM Grid Control, SQLPL/SQL

Confidential

Oracle DBA

Responsibilities:

  • Responsible to provide 24 x 7 database administrative activities over different database servers.
  • Involved in Installation, Upgrade from Oracle 10g to Oracle 11g and Configuration of Oracle NETservices.
  • Extensive experience in Performance Tuning, Memory Tuning etc.
  • Applied patches including both one-off patches using OPatch as well as patch sets.
  • Refresh/Cloning of database using data pump and RMAN utility.
  • Standby Database setup and configuration.
  • Worked alongside programmers and database developers for contributing to the development processes.
  • Monitoring growth of tables and undertaking necessary re-organization of database as and when required
  • Involved in decision making for the naming convention of datafiles, redolog files, tablespaces and segments.
  • Partitioning Tables and indexes by determining the suitable methodology to improve performance and manageability.
  • Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
  • Written shell scripts and automated nightly jobs using crontab to schedule the backups, exports and refreshing databases from production.
  • OS level Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.

Environment: Oracle 10g, HP-UX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, SQL*LOADER, Tkprof

Confidential

Jr Oracle DBA

Responsibilities:

  • Responsible for maintenance of production.
  • Created tables, views, materializedviews
  • Managing Database Structure, Storage Allocation, Table/Index segments
  • Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
  • Configured and managed OEM to stabilized oracle database into healthy environment.
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
  • Trouble shooting performance issues using Explain Plan and TKPROF.
  • Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
  • Maintenance & modification of ShellScripts.
  • Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes.
  • Develop, document and enforce database standards and procedures.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
  • Troubleshooting and fixing database listenerissues.

Environment: Oracle 10g, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader

Confidential

System admin

Responsibilities:

  • Maintain system efficiency.
  • Ensure design of system allows all components to work properly together.
  • Troubleshoot problems reported by users.
  • Make recommendations for future upgrades.
  • Maintain network and system security.
  • Monitor networks to ensure security and availability to specific users.
  • Evaluate and modify system's performance.
  • Identify user needs.
  • Maintain integrity of the network, server deployment, and security.
  • Ensure network connectivity throughout a company's LAN/WAN infrastructure is on par with technical considerations and perform network address assignment..
  • Assign routing protocols and routing table configuration.
  • Assign configuration of authentication and authorization of directory services.
  • Maintain network facilities in individual machines, such as drivers and settings of personal computers as well as printers.
  • Maintain network servers such as file servers, VPNgateways, intrusion detection systems.
  • Administer servers, desktop computers, printers, routers, switches, firewalls, phones, personal digital assistants, smartphones, software deployment, security updates and patches.

Environment: LAN/WAN infrastructure, VPNgateways, Network issues, deployment, security checksrouting table configuration.

We'd love your feedback!