SUKHI

acqmh0@r.postjobfree.com

Oracle DBA

• Over 7 years of IT experience, 6 years of extensive experience as an Oracle DBA on 9i, 10g, 11g.

• Worked on Oracle 9i, 10g and 11g Standalone and Cluster Environment.

• Build RAC from scratch on Red Hat Enterprise Linux/.

• Experience in Data Center Migration.

• Experience in setting up Oracle Data Guard.

• Experience in setting up Grid Control.

• Experience in setting up ASM disk groups.

• Experience in Setting up Materialize Views

• Upgraded from 10g to 11g R2.

• Worked with many new 11g new features.

• Worked with Oracle on open issues.

• Experience with Tablespace/Extent/Segment Management

• Worked on Backup and recoveries using User Managed and RMAN.

• Installed configured Setup Oracle Enterprise Manager (OEM)

• Worked on 11g Grid Control for database monitoring / performance / diagnostics.

• Worked on Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).

• Maintained Oracle fail over databases (Physical and Logical standby databases- Data Guard). Was primary on Standby databases.

• Worked in 24/7 environment.

• Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, and 11g.

• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.

• Experience monitoring Oracle RDBMS availability, database exports, datapump, tablespace, and extents fragmentation.

• Provided on-call support.

• Automated Storage Management (ASM) for 10g/11g databases.

• Installed and Administered Grid Control.

• Experienced in RAID, storage technologies and backup solutions

• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux

• Skilled in using tools such as SQL Developer and TOAD.

Authorized to work in the US for any employer

Work Experience

Oracle DBA

Bank of America

Chicago, IL

December 2013 to Present

Environment: Oracle 10g, 11g, 12c, RAC, Linux

• Installation, Configuration and administration of Oracle 11g RAC.

• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.

• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.

• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.

• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.

• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.

• Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,

• Worked on Automatic Storage Management (ASM) for managing data in SAN.

• Monitoring and resolving tickets in different environments.

• Export and Import of database objects to copy from one database to another database between different environments.

• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).

• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

• Created UNIX shell scripts to automate batch jobs through Cron.

• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.

• Analysis and management of Oracle problems/defects using SRs and/or Metalink with OracleCorporation and installation of patches.

• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

• Having experienced in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.

• Experience in using OEM 11G/12C and deployed agents on different targets.

• Skilled in managing OLTP and OLAP database systems with VLDB with multi terabytes in size.

• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Environment: HP-UX, Red Hat Linux, IBM-AIX, windows-NT, Oracle 12c, 11g, 10g, and 9i, OracleRAC (11g), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL.

Oracle DBA

ESPN

Bristol, CT

March 2011 to Nov2013

Environment: Oracle 12c, 11g, 10g, 9i, Toad, RMAN, Data Pump, SQL Developer

Responsibilities:

• Database refreshes.

• Planning new builds

• Implementing Changes.

• Validating standards

• Schedule backup

• Performed restore & recoveries using RMAN

• Provided 24/7 support

• Supported RAC databases.

• Build RAC Clusters

• Maintained Oracle 9i, 10g and 11g Databases.

• Worked with offshore team.

• Worked as part of a team and provided 24/7 support when required.

• Build databases using ASM as the file system.

• Implemented flashback.

• Worked on various performance issues.

• Very familiar with Dictionary tables and dynamic views.

• Installation of Oracle 11g, 10g, 9i installation and Configuration.

• Managed Linux, windows and Solaris Database servers.

• Planned and performed RMAN backups and recovery procedures.

• Planning and implementing hot, cold and export backups. Reviewing backup logs for irregular occurrences.

• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and some performance tuning.

• Primary DBA for Data Guard and Oracle RAC tasks.

• Tuning of memory and database SQL's to improve performance.

• Monitoring the database growth and conducting health checks on the databases. Reorganizing of databases.

• Review alert logs, trace and dump files for errors.

• Adding users, reviewing their profiles, roles, privileges and quotas. Setting up audit sessions and monitoring activities on Database objects.

• Documented server/database related information on Oracle SharePoint

• Meeting users' requests. Providing 24x7 supports for designated production databases.

• Designing, developing & implementing process improvements within the database environment.

• Attending / organizing meetings to sort out Capacity planning, Database performance and reliability and Change management issues.

• Installation, Configuration, Upgrading, Migration and Maintenance.

• Used external tables and SQL*Loader to import data from flat files.

• Monitored database space requirements and adjusted for future needs.

• Performed version upgrades and patch installs.

• Able to work effectively with multiple teams at once.

• Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes

• Solid discipline in providing end-users timely updates on their problems. Installing server software.

• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.

24*7 production support and on call rotation.

• Worked in environments of small 20 GBs size databases up to 4 TB Size Databases/DW.

• Worked on 12c, 11g Grid Control

• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.

• Worked with RAC implementation team. Added nodes.

• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space

• Used Grid Control and database control for monitoring, tuning and managing Oracle RAC and non-RAC Environments

• Export and Import of User, Tables and Database using exp/imp and Data Pump.

• Used RMAN for Backup, Restore and recovery of databases.

• Raised SR and TAR with Oracle Support.

• Used Oracle Enterprise Manager (OEM) for administering several databases

• Performed various different kind of database refresh request.

• Very familiar with Database cloning and recovery procedures.

• Used Duplicate database feature of RMAN to clone databases.

DBA

Southwest Airlines

Dallas, TX

January 2010 to March 2011

Environment: Oracle 11g/10g, 9i, Toad, RMAN, Import/Export, Oracle OEM, WinScp/FTP.

Responsibilities: -

• Build RAC on 2 nodes, 3 node clusters.

• Add/Remove node to/from existing RAC.

• Configure ASM and disk partitioning for disk groups.

• Worked with different teams like storage, network and security team during RAC builds and configurations.

• Apply CPU, PSU and one off patches.

• Capacity planning, capacity monitoring and management.

• Used 11g and 12c Grid Control.

• Migrated

• Performed database Cloning to setup test and development database

• Configure and manage tablespaces, tables, and users for custom applications.

• Maintaining schemas and user management

• Performed data pump, export/import refreshes for schemas.

• Worked very closely with development team on Database Change Requests (DCRs).

• Involved in 24x7 supports for production databases with on-call pager.

Jr. DBA

Kraft Inc

Northfield, IL

January 2007 to Dec2009

Environment: SQL Server, Oracle 9i, 10g

Responsibilities:-

• Creating users, roles and priviliges.

• Install and configure databases.

• Execute developer scripts in lower environments.

• Datapump exports of tables and schemas.

• Create and update tns entries.

• Generate AWR reports.

Education

BS in Computer Engineering

Gulbarga University -

Gulbarga, Karnataka

Additional Information

Technical Skills:

Operating Systems RHEL, Windows, CentOS, Fedora, SUN Solaris, HP-UX, AIX

RDBMS Oracle 9i, Oracle 10g R2, 11g R1/R2

High Availability Real Application Cluster RAC, Data Guard, Manual, Materialize View Servers

Languages SQL, PL/SQL, Shell scripting, T-SQL

Tools RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, DBMS_Stats

Tools Erwin, TOAD, putty, OEM, SQL Developer, Wise

Application Peoplesoft, JDEdwards, Oracle APEX, 10g / 11g / 12c Cloud control

Contact this candidate