Oracle Dba Resume
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.