SUMMARY:

• 14 yrs of experience as an Oracle Database Architect/DBA in Oracle (8, 8i, 9i, 10G and 11G).
• Data management skills on HP Unix, Sun Solaris, Red Hat enterprise Linux and Windows environment: .
• Specialization in Datawarehouse Architecture design and administration
• Expertise in Oracle Database Infrastructure Sizing, Optimization, and documentation - Technical Support.
• Experience in Information Systems, Oracle Database Administration, and Data warehouse design and complete software development life cycle.
• Proficient in Installation, Configuration, Maintenance and Tuning of Oracle 11g (11.2.0.3, 11.2.0.2 and 11.1.0.7)/ 10g (10.2.0.5, 10.2.0.4 and 10.2.0.2)/ 9i / 8i and 8 on AIX, HP UNIX (HP UX IA64 11.31, HP UX 11.23, HP UX 11.11, Sun Solaris (5.9, 5.10 and 5.11), Linux and Windows platforms. Migration and maintenance of Oracle Databases (11g, 10g, 9i, 8i).
• Experience in Oracle 10g, 11g RAC installations, ASM, and OEM grid control.
• Experience with very large database environments (VLDB) of size in Tera Bytes (TB).
• Experience in instance configurations, tuning, and capacity planning, physical, logical database designs, Server software upgrade, patches, monitoring database and OS (UNIX / Windows) performance.
• Proficient in developing efficient logical database designs, implementation of supporting packages, stored procedures, triggers, functional data models, periodic data load cycles, data integrity testing procedures.
• Supported and maintained business data models from development through production implementation phases.
• Supported and maintained data consistency in Production, Development, and Backup and Test databases.
• Experience with Database reorganization, collecting statistics and monitoring database performance using STATSPACK, OEM, and TOAD.
• Adept in Application and Database tuning, use of SQL diagnostic and tuning tools like Automatic Workload Repository AWR, Automatic Database Diagnostic Monitor ADDM, TKPROFEXPLAIN PLAN, AUTOTRACE, and trend analysis.
• Developed programs to load data using PL/SQL and SQL*Loader to transaction processing databases.
• Knowledge of Data modeling and Software design methodology, UML, TOAD and software like Rational Rose, Erwin 4.x, Data-warehousing methodologies.
• Excellent communication, presentation, technical writing & team work skills with ability to adapt to the nature of the job.

TECHNICAL SUMMARY:

Hardware: HP-UX Servers, AIX servers, SUN servers, Linux servers, Windows 2000 Servers, Windows 2003 Servers, Windows NT Servers, NAS Filer.

Operating Systems: HP UNIX (HP UX IA64 11.31, HP UX 11.23, HP UX 11 11.11, Sun Solaris (5.9, 5.10 and 5.11), AIX 5.3, Linux x86, Linux x86 64, Windows 2000 Server, Windows 2003 Server, Windows XP, SuSE Linux, RHEL Linux and Windows NT.

Databases: Oracle 7.3/ 8/ 8i/ 9i, Oracle 10g (10.2.0.5, 10.2.0.4 and 10.2.0.2) and Oracle 11g (11.2.0.3, 11.2.0.2 and 11.1.0.7).

Languages: SQL, Advanced PL/SQL.

Tools: Oracle DBA tools OEM, OMS, DBArtisan, Oracle Failsafe, Hp-ux service guard, Cluster failover software, VERITAS net backup, PRTG monitoring tool, RICMS REMEDY ticket. Standby, RAC, AQUAS. OEM GRID monitoring tool.

DBMS Utilities: SQL*Loader, Import/Export utility, Data pump, RMAN

Database and SQL tuning/diagnostic utilities: TKPROF, SQL Trace, STATSPACK, OEM Diagnostic Pack, UNIX performance utilities- sar, vmstat, UNIX Shell scripts, Cron, topas, top. Prtdiag. nmon, iostat.

Other Tools: UML, Rational Rose Data Modeler 5.0, Windows At scheduler, MS Project 2000, Erwin Data Modeler 4.1.4, TOAD, Spotlight, SQL Navigator, Quest Central, Oracle Developer 2K Forms and Reports, Jdeveloper, Visio, SQL Developer, isql*plus, Wincvs, Test Director, Exceed Hummingbird, Service center Client, Unix cron scheduler., EVO access, VPN connection.

PROFESSIONAL EXPERIENCE:

Confidential, Emeryville, CA

Oracle Database Administrator

Responsibilities:

• Installed 11g R2 RAC build setup along with the 11g R2 cluster ware.
• Migration and maintenance of Oracle Databases (11g, 10g, 9i, 8i).
• Database upgrades from 10.2.0.1 to 10.2.0.5, 10.2.0.5 to 11.2.0.2.
• Performed regular Database Administration activities which involved - Database Upgrades from 10g to 11g. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.
• Data Reorg using Exp/Imp, Expdp/Impdp and Alter table move to reclaim space.
• Applied quarterly CPU patches, supported other patching activities.
• Monitored Production, test, sandbox, QA, development databases. Maintained rman database backups, full export logs, archive log backups. Maintained tape backups, disk backups for all the environments. Reports created for schema duplications, missing schemas, duplication of instances for different, same life cycles on other servers.
• Maintained database consolidation report. Provided Streams configuration support. Resolved oracle errors. Supported over 100+ databases of different versions from 7.3, 8.0.4, 8.1.7, 9i, 10g and 11g in all the environments.
• Created retention policy reports for tape backups, disk backups for all the environments, retention policies for 7.3, 8.0.4, 8.1.7, 9.2.0.8, 10.2.0.3, 11g, 11gr2 databases, rman configurations of retention, tape or disk backup policies, Backup schedules for tapes, disk, backup script locations, cleanup script locations, cleanup script policies for all the databases.
• Worked on the installation, configuration, and upgrade of oracle server software. Worked on database design and implementation.
• Supported database issues from backups. Maintained filer space of 8TB for disk backups. Created db monitoring users and granted privileges. Maintained more than 3 recovery catalog databases for all the databases categorized on versions 7,8i, 9i, 10g, 11g, 11gr2. Supported high transaction processing systems .
• Supported development of software from pl/sql batch processing. Multi-tasked and provided support for multiple development teams across concurrent application development tasks. Refreshed development, sandbox schemas from production database schemas.
• Created test plans, test scripts. Developed recommendations. Multi tasked on various projects. Established and maintained backup and recovery procedures for 10g, 11g. Implemented and maintained database security. Tuned oracle databases and monitored performance. Supported application servers. Worked on capacity planning, and determined the upgrade path. Setup and maintained documentation standards. Worked on tablespaces, and other storage methods for data storage. Implemented database objects. Worked on performance analysis and testing, performance tuning.
• Worked in pl/sql and sql. Implemented, maintained, 10g,10gr2, 11g RAC databases. Provided support as ON-CALL DBA on rotation. Restored standby databases. Worked on 10g, 11g ASM.
• Executed routine database tasks from Remedy.
• Maintained and troubleshooted databases in a physical, virtual and clustered environment. Worked on 10g, 10gr2, 11g, 11gr2 oracle RAC cluster setups, grid control, ASM, oem and oracle client installations.
• Worked in dataguard, replication, disaster recovery. Created databases. Worked with SharePoint.. Performed migrations from oracle 10g, 10gr2 to 11g, 11gr2 . Administered databases through full application lifecycle, development, testing, and production. Prepared for and executed backup and recovery. Maintained secure and audited systems . Participated in on-call rotation. supported ASM disk space setups. Also maintained ASM disk space. Optimized service delivery . performed under established operating procedures. Supported 24x7 environments. Co-ordinated issues with the application/help desk staff.
• Multi-tasked and provided support for multiple development teams across concurrent application development tasks. Refreshed development, sandbox schemas from production database schemas .

Environment: Sun Solaris 5.10, Sun Solaris 5.9, Linux x86, Linux x 86 64, Windows NT, Windows 2000, Windows 2003, Oracle Database Enterprise Edition ( 7.3, 8.1.7.4, 8.0.6, 9.2.0.8,10.2.0.1, 10.2.0.2,10.1.0.5, 10.2.0.3,10.2.0.4, 10.2.0.5, 11g,11gr2), Oracle client 8i,9i,(10g),11g,11gr2 Sun sparc servers, AIX servers . Linux servers, windows servers.

Confidential, SF, CA

Oracle Database Administrator

Responsibilities:

• Supported production databases in Confidential group .
• Migrated, and copied pre-production performance testing databases for data center move to Tempe, Arizona .
• The pre-production database sizes migrated ranged from 50 GB to 600 GB .
• Supported releases to pre-production database. Setup oracle streams for databases migrated .
• Applied db updates to create the objects on pre-production databases to bring it to the current production release levels with tar files .
• Maintained availability of all the pre-production databases running. Applied releases scripts from the staging location to the pre-production databases.
• Supported 24x7 for 3 tier applications.
• Worked with defect tracking systems.
• Worked in Unix/Linux shell scripting .
• Developed sql queries, pl/sql procedures.
• Supported application development with weblogic ., application server.
• Developed database standards.
• Performed backup and recovery of large databases.
• Worked in 10g,11g RAC, pl/sql, rman, dataguard, and OEM. Also created shell scripts.

Environment: Sun Solaris 5.8, 5.10, Windows NT, Oracle Database Enterprise Edition ( 9.2.0.8, 10.2.0.2, 10.2.0.3 ), Oracle client (10g), Exceed Hummingbird connectivity, Sun sparc servers, Sun netra t-12 servers, Secure-FX, Secure CRT .

Confidential, NY

Database Administrator

Responsibilities:

• Restructured production databases and Improved performance by 10%, considered the requirements of Business, databases and applications, and resource utilization. created change requests and gsrs for non-prod and executed release scripts.
• Created release plans for DR TESTS. Performed DR test.
• Setup data masking for database schema tables.
• Provided support as ON-CALL DBA on rotation. Restored standby databases.
• Supported oracle 10g rac databases.
• Created RMAN backup and recovery procedures.
• Worked on disk storage.Worked in unix, windows nt operating systems .
• Managed projects.
• Tuned sql queries.
• Created shell scripts.
• Created stored procedures, triggers, packages, and functions.
• Performed database imports/exports.
• Worked on Database loading/unloading utilities .

Environment: Sun Solaris 5.8, 5.10, Windows NT, Oracle Database Enterprise Edition( 9.2.0.4, 9.2.0.6, 9.2.0.8,10.2.0.1, 10.2.0.3, 10.2.0.4 ), Oracle client (10g), OEM r2, Foglight v4.1, DBArtisan, Gas Job Client, Gas Job Manager, Service center client, NAS filer, AIX 5.3.0.0, Sun sparc servers, cron scheduler, perl .

Confidential, Virginia

Database Administrator

Responsibilities:

• Created documentation for the databases supported, administered oracle databases,
• Monitored and maintained the oracle databases.
• Performed migrations from oracle 10g to 11g .
• Administered databases through full application lifecycle, development, testing, and production.
• Prepared for and executed backup and recovery.
• Maintained secure and audited systems .
• Participated in on-call rotation.
• Supported database availability and performance.
• Optimized database performance, server capacity.
• Worked with internal, external support groups to provide maintenance of databases for operational availability.

Environment: Sun Solaris 5.8, 5.10, Windows NT, Oracle Database Enterprise Edition( 9.2.0.4, 9.2.0.6, 9.2.0.8,10.2.0.1, 10.2.0.3, 10.2.0.4 ), Oracle client (10g), OEM r2, Gas Job Client, Gas Job Manager, Service center client, NAS filer, AIX 5.3.0.0, Sun sparc servers, cron scheduler, perl .

Confidential, San Francisco, CA

Database Administrator

Responsibilities:

• Provide Operational support for oracle databases.
• Monitor production support requests during business hours and after -hours as (primary- secondary) on-call DBA.
• Maintained Development, Integration, Quality Assurance, Production environments for applications supported.
• Create 10gr1, 10gr2, 9204, 9208 databases, Move databases from one server to another (10gr1-10.1.0.4, v8.1.7 to 10.2.0.4, 10gr1-10gr1 2 v, 8.0.6.3.0), create database certification reports for support applications, Upgrade from 9i to 10g, 10g to 10.2.0.3, 8.1.7 to 10g. Move Bcp database to new server.
• Support BCP failover test(10gR2/8174/9204), switchover.
• Implemented database security procedures. Maintained, managed schema implementation changes.
• Created, maintained, sql, pl/sql scripts for stored procedures. Manages disk space usage for tablespaces.
• Worked with SQL Developer, TOAD.
• Created schemas, tables, constraints, indexes, materialized views.
• Managed the database access for developers and end users.
• Worked with unix..
• Worked with optimization of complex SQL queries.

Environment: Sun Solaris 5.8, Windows 2000, Windows NT, Oracle Database (8.1.7/8.2.0.4/ 9.2.0.4/10.2.0.2 ), Oracle client (10g), OEM r2.

Confidential, Chandler, AZ

Database Administrator

Responsibilities:

• Provided database support role for product development and validation.
• Extend database operational support to environment setups - Integration, Development, Patch Qualifications, Quality Assurance, and Replication.
• Maintain an operating environment with databases running on a two node cluster setups in windows and UNIX.
• Perform client customized oracle database installs, Install Oracle client software 92066,92075 with patches on windows 2003, windows 2000 virtual servers. Windows 2003 node clusters.
• Run backups of databases.
• Schedule cron jobs for running database monitors, backups, statistics data collection, purging statistics. Modify job timings. Reschedule backup jobs.
• Supported sql server databases.

Environment: HP-UX 11.0, Windows 2003, Windows 2000, Oracle Database (8.1.7.6/ 9.2.0.6 ), Oracle client (9.2.0.7.5, 9.2.0.6.6), Oramts 9.2.0.4.1, Odbc driver 9.2.0.6.5, Oracle Failsafe Manager, sql server .

Confidential, Charlotte, NC

Sr. Database Consultant

Responsibilities:

• Responsible for designing, modeling, developing and supporting ORACLE Database Management Systems (DBMS).
• Analyze, design, develop, implement, and administers back-end databases in a distributed environment.
• Provides database support to application developers on the project team.
• Monitors database error logs, snapshots, indexes, tablespaces, fragmentation, transaction logs, etc, routinely to ensure proper performance, capacity, availability, and recoverability.
• Documented and developed PL/SQL Stored procedures for extracting data from XML format to be stored in Oracle tables for business reporting requirements.

Environment: Solaris 8.0/10, Oracle (8.1.7.4/ 9.2.0.5/9.2.0.6 ),OEM, DBArtisan, TOAD, PL/SQL, SQL* Plus, Test Director, Wincvs.