PROFESSIONAL SUMMARY:

• Oracle Certified Professional wif about 8 years of experience as database administrator.
• Expertise in Installation, Configuration, Upgradation, Patching, Migration, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g databases on UNIX, LINUX and Windows environments.
• Experience in configuration and maintaining Oracle standby database and Data Guard.
• Expertise in using backup/recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Patches and Stored Procedures maintenance to create a bug free environment and automation.
• Configured data replication using Advanced Replication and Oracle Streams.
• Knowledge about Oracle Gloden gate.
• Experienced in writing UNIX Shell scripts to automate business process and daily backup.
• Configuration of Automatic Storage Management (ASM), Configuration of Oracle Cluster File System (OCFS2), Installation of Cluster ware in order to explore the RAC Database environment.
• Installation and Configuration of Oracle 10g Real Application Clusters (RAC) on 2 nodes cluster.
• Experience in on - call support and 24x7 DBA support for production environment.
• Cloning/Refreshing databases for development/testing/staging environments.
• Experience in database auditing including fine grain auditing.
• Proficient in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader, SQL Navigator, TOAD, Export, Import and SQL*PLUS.
• Good exposure to Oracle 10g/11g technologies like ASM, AWR, ADDM, Flashback technology, data pump import/export.
• Performance tuning of application using tkprof, explain plan, autotrace, Statspack and SQL tracing.
• Experience in configuring and maintaining Postgres databases.
• Experience in configuring and maintaining Sqlserver databases.
• Analytical, methodical, and resourceful approach to problem-solving, identifying root causes and corrective actions to meet short- and long-term business, financial, and system requirements.
• Strong analytical and trouble shooting skills coupled wif excellent Communication and
• Desire to learn new technologies and implement them.

TECHNICAL SKILLS:

Database: Oracle8i/9i/10g/11g Enterprise/StandardEdition, MSSQLServer 2000/2005/2008, Postgres

Platforms: Sun Solaris, Suse Linux, Red hat Linux,HP-UX 11i,Win2K

Languages: SQL, PL/SQL, UNIX shell scripting (Korn, Bash), Perl, Erwin, C, C++, JAVA, XML

Web Skills: HTML, DHTML, CSS, Java Script, MS FrontPage

Tools: SQL*PLUS, TOAD, OEM, RMAN, SQL*LOADER, SQLNAVIGATOR, OEM Grid Control,Imp/Exp and Data pump,STATSPACK, AWR

PROFESSIONAL EXPERIENCE:

Confidential, SEATTLE, WA

Sr. Oracle Database Administrator

Environment: Oracle8i/9i/10g/11g, Sqlserver 2000/2005/2008, Postgres, Sun Solaris 5.8 sparc/5.10 x86, Linux, SQL Plus, Oracle Enterprise Manager (OEM), Shell scripting.

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g/11g databases on different platforms as well as the clients.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Upgrading oracle databases from 10.2.0.3.0 to 10.2.0.4.0
• Upgrading oracle databases from 10.2.0.4.0 to 11.2.0.2
• Upgrading Sqlserver 2000 to Sqlserver 2008
• Installing, Configuring and Administering Sqlserver 2008 databases.
• Installing, Configuring and Administering Postgres databases.
• Installing CPU/PSU and other security, bug patches for Oracle databases on Solaris, Linux Platforms.
• Cloned/Refreshed databases for testing/QA environments using export/import, data pump and cold backup.
• Cloned/Refreshed staging environment wif production data using RMAN.
• Configuration of Automatic Storage Management (ASM) using raw devices.
• Tested implementing RAC on 2 node cluster.
• Implemented Hot and cold backups, Restore and recovery manually.
• Implemented RMAN backups and Restore and Recovery.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Implemented replication between databases using advanced replication.
• Installed and configured Oracle Streams between oracle databases in 11g.
• Participating in Auditing of databases like PCI Auditing.
• Helped in migrating terabytes of data between different versions of analytics databases.
• Configuring and maintaining OEM.
• Active participation in code deploy for engineering releases.
• Written PL/SQL, Stored Procedures and also UNIX Shell scripts for monitoring database activities,
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Worked closely wif application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Re-organization of database objects (Tables, and Indexes etc.)
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along wif AWR & ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Helped build extensive documentation for all Oracle related Administration

Confidential, WA

Sr. Oracle Database Administrator

Environment: Oracle 9i/10g/11g, RED Hat Linux, Sun Solaris, Windows 2003, SQL Server 2005, SQL*Loader, RMAN, RAC, Toad, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Shell scripting.

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g using ASM on Linux machines.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Installed CPU patches on Solaris, UNIX and Linux platforms in RAC and Non-Rac Environment.
• Monitored RAC Instances Using Scripts For Backups, Performance Tuning, to find out Free space at Table Space, table Levels etc …
• Configuration of Automatic Storage Management (ASM), Configuration of Oracle Cluster File System (OCFS2), Installation of Clusterware in order to explore the RAC Database environment
• Created Recovery Catalog database for RMAN backups.
• Created tables, views, stored procedures and monitored insertions and upload of data as part of the Custom Logger built.
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Extensively used Datapump for the export and import of schemas and tables.
• Extensively used SQL*Loader to load the data into the schema.
• Implemented Hot and cold backups, Restore and recovery through RMAN as well as manually.
• Security and Bug Patch implementation for Oracle 10g binaries.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow.
• Written UNIX shell scripts to monitor ASM, listeners, monitor the alerts, RMAN backups, PL/SQL Stored Procedures and Triggers.
• Wrote PL/SQL procedures, functions, and packages for Extract Transform and Load (ETL) of data from OLTP system to Oracle Data warehouse
• Experienced at, expdp, impdp, exp, imp and other Oracle utilities.
• Created users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users.
• Re-organization of database objects (Tablespaces, Tables, and Indexes etc.)
• Tuning the application using Oracle utilities like OEM, SQL Trace, TKProf and Explain Plan.
• Worked closely wif application team members in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along wif AWR & ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Confidential, SEATTLE, WA

Sr. Oracle Database Administrator

Environment: Oracle 9i/10g,Sun Solaris 5.8 sparc/5.10 x86,HP-UX11i AIX 5.1, 5.2, Linux, Windows 2003, SQL Server 2000, 2005, SQL*Loader, RMAN, RAC, Toad, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Shell scripting.

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g databases on different platforms as well as the clients.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
• Installed and configured Oracle 10g RAC using ASM on 2 node Sun Solaris server.
• Applied CPU patches on Solaris, UNIX and Linux platforms in RAC and Non-Rac Environment.
• Installed and configured 10g Grid Control.
• Created Recovery Catalog database for RMAN backups.
• Cloned/Refreshed databases for testing/QA environments.
• Implemented Hot and cold backups, Restore and recovery through RMAN as well as manually.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager) and AWR.
• Replicated few tables of a Schema using Oracle Streams wif two oracle databases in 10g.
• Involved in Data warehousing/ Business intelligence solutions designing, developing and deploying ETL jobs complimented wif report designing skills
• Written UNIX Shell scripts to monitor tablespaces, listeners, disk space and database availability, compress/delete old archive logs.
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Worked closely wif application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Responsible for applying Oracle Patches and CPU patches.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along wif AWR & ADDM reports
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Confidential, COLUMBUS, OH

Sr. Oracle Database Administrator

Environment: Oracle 9i/10g, Toad, SQL Plus, SQL*Loader, MS SQL Server 2000, RMAN, RAC, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN,LINUX,HP-UX11i, AIX 5.1, 5.2.

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Migrated oracle databases from 9i to 10g version.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes wif Automatic Storage Management (ASM).
• Created a number of database instances for development, testing and production.
• Maintained Development databases, Test databases and applied Patches
• Managed Oracle environment easily and consistently using Oracle Grid Control. Used Grid Control to manage Real Application Cluster.
• Running imports/export utilities, off-line backup, on-line backup various PL/SQL server Applications utilities, used File Transfer Protocol.
• Cloning of databases from production to Dev & QA Databases.
• Database migration from SQL server 2000 to Oracle Database.
• Provided partitioning of the large tables to reduce the access time.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk me/O.
• Created users, allocation to appropriate table space quotas wif necessary privileges and roles for all databases.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• 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.
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views wif fast refreshes for transfers of information.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze
• Configured disaster recovery site wif physical standby database for high availability.
• 24*7 production support and on call rotation.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Involved in testing stage of two-node RAC implementation on SUSE Linux.
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.

Confidential

Oracle DBA

Environment: Oracle 8i/9i, PL/SQL, Developer 2000, Windows NT 5.0/ UNIX

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Wrote various scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning, trouble shooting Oracle Databases, Database Objects Designs, Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.
• Performed capacity planning required to create and maintain the database environments.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
• Replication of materialized views (snapshots) wif fast refreshes for transfers of information.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• Tuned Oracle Initialization Parameters.
• Gatheird Database Instance Statistics & generated reports using STATSPACK.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary Tablespace, UNDO Tablespace and RMAN.
• Created Partitions at O/S level, according to DB requirements.
• Installing Oracle 8i on Win'NT 4.0 Server and Setting up Oracle Clients.
• User Creations wif allocation to appropriate tablespaces and quotas wif necessary privileges and roles.

Confidential

Jr. Oracle DBA

Environment: Oracle 8i/9i, UNIX, Linux, JAVA, JSP

Responsibilities:

• Installation, Configuration and Administration of Oracle 8i/9i databases.
• Created roles, profiles, users and assigned privileges to them.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Created different types of Indexes (B tree, reverse key, IOT and function based etc).
• Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.
• Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
• Provided partitioning of the large tables to reduce the access time.
• Applying patches both Server side and Client side.
• Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Supported developers during batch jobs to increase rollback segments and archive log space for additional month end updates to the system.
• Database analysis and design activities as a team wif the Data Analysts.
• Modified and defined database objects as per requirements.
• Performed application SQL tuning using SQL Trace/Explain plan and TKPROF and database tuning for optimum performance.
• Wrote procedures, triggers and shell scripts.
• Cloning databases for development/testing environments.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.