Oracle DBA, Resume, Santa Clara, CA - Hire IT People

SUMMARY

Around 30 months of experience as Oracle Database Administration on various versions of 10g and 11g, such as Database Installation, Upgrade, Maintenance and support of Oracle Database Server on UNIX flavors (Linux, Solaris, and AIX).
Management of schemas, objects & Partitioning of tables & indexes.
Upgrade of database from 9i to 10g and 10g to 11g.
Managing ASM disks and disk groups.
Good experience on RAC 10g (Real Application Cluster) architecture.
Knowledge and understanding of AWR, ADDM, ASH.
Knowledge of TKPROF, EXPLAIN PLAN and resolve the issues on the basis.
Extensive experience in Installing, upgrading, patching and troubleshooting Oracle DB Server.
Knowledge to set up the primary and standby databases for 24x7 availability using Oracle Data Guard and switchover and failover, snapshot standby, active standby.
Created user assigned Profiles - Resource limits, maintained Security wif Roles/Privileges granting and revoking upon requirements.
Handling day-to-day DBA activities using Oracle utilities and tools, Checking Alert Logs, Archive logs, blocking sessions, table level locks, backup verifications, deploying application code, listener status, database status, load on database etc.
Weekly activities such as object dat break the rule, mount point free, ASM disk group management, Tablespace free space, tablespace growth, etc.
Refresh test and development databases wif production data on a regular basis OR as and when required by the development and testing teams and database cloning.
Good experience in SQL, PL/SQL, Partitioning, Data modeling, Logical and Physical Database Design, Backup and Recovery procedures.
Supported the system 24x7. Ability to work Confidential regular hours.
Proficient and prompt in learning and adapting to new technologies.
Excellent interpersonal communication clubbed wif good analytical, logical and problem solving techniques, Rapid-learning ability wif aptitude for challenging tasks, ability to work collaboratively and commitment to achieving Confidential goals.

TECHNICAL SKILLS

Operating Systems: Window Advance Server, HP-UX, AIX, Redhat Linux
Programming Languages: SQL, PL/SQL, SQL Tuning, Java
Databases System: Oracle 11g/10g/9i, 10g RAC.
Documentation Tools MS Word 2000, MS Excel 2000
Scripting Language Shell Scripting
Tools/Utilities RMAN, OEM, Oracle Management Server, SQL*Loader,
TOAD, Data pump Export/Import, Data Guard.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Santa Clara, CA

Responsibilities:

Daily check on issues like Tablespace alerts, server down, listener status, backup fails, blocking sessions, lock object, number of log switches per hour, etc.
Weekly monitors the invalid indexes, size of tables and creating partitions (hash, range, and list) if necessary, mount point full, etc.
Check the size of database and compare to previous available size to conclude the growth and capacity planning.
Managed ASM storage having multiple databases.
Prepare/Add/remove ASM disks. Monitor ASM Disk on regular basis.
Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
Upgrade of Database from 10.2.0.2 to 11.2.0.2 and apply patches whenever necessary.
Ensure backups are complete on regular basis and test these backups on testing environment.
Refresh test and development databases wif production data on a regular basis OR as and when required by the development and testing teams and database cloning.
Convert physical standby to snapshot standby and revert snapshot standby to physical standby for the purpose of Real Application testing.

Environment: Oracle 10g/11g RAC, SQL plus, RMAN, Import/Export Data pump and Linux, Oracle Streams, Dataguard, partitioning, upgrades, patching, AWR, ADDM, TKPROF, EXPLAIN PLAN, ASM, OEM.

Jr. DBA

Confidential

Responsibilities:

Upgrade of databases from Oracle 9.2.0.8 to Oracle 10.2.0.2 on Linux.
Developed strategies for database backup and recovery using RMAN utility.
Used exp/impdp utility and Sql loader for transformation of data.
Created Users, Roles and Profiles and Granting/revoking the privileges to the Users.
Created Procedures, Functions, Packages and database Triggers using PL/SQL and monitored the Tables and Indexes growth.
Responsible for creation of tablespaces, and management of storage space.
Write pl/sql quires as required
Prepare the documents of the process and knowledge transferring about the project to the new team members.
Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment: Oracle 10g R1/R2, Linux, RMAN, OEM, Data guard, exp/imp data pump.

We provide IT Staff Augmentation Services!

Oracle Dba, Resume

Santa Clara, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship