SUMMARY

• Over 12+ years of experience in Oracle physical administration including 24*7 support.
• Expertise in Hot and Cold Backup and Recovery and Cloning of Single Node and RAC databases.
• Installing and configuring of 9i /10g/11g RAC 3+ nodes in RHEL/HP/AIX/SOLARIS.
• Installing and configuring and performance tuning of Oracle RAC 3+ nodes.
• Cross platform database Migration.
• Physical data guard replication for high availability.
• Replication using Golden Gate
• Database performance tuning using Grid Control & Diagnostic pack (AWR,ASH ADDM etc)
• Design and implement backup and recovery including disaster recovery structures.
• Amazon Cloud EC2/RDS database server set up.
• Enable EC2 features such as S3,Glacier And Cloud Watch
• Database guard setup and maintenance in EC2
• RAC performance tuning using Archiving, Partitioning and Wait event Interface
• Database Security using Oracle Security Features (Roles, privileges), auditing & Network ACL config, Transparent Data encryption, DBMS CRYPTO, etc
• Instance Upgrades ranging from Oracle 8i till 11g and further PSU (Bundle patch) application
• ASM installation, Data transfer to from Non ASM to ASM.
• SQL server 2008 installation, maintenance and regular refresh.
• Database application support, Maintenance using Best practices.
• Configure oracle streams
• Excellent knowledge in Ora - 600, Ora-7445 issues and resolutions
• MySQL administration
• Oracle Gateway Configuration to MySQL
• Good working knowledge with XML files, Loading and unloading
• Patches, keeping applications software bug free and improving data integrity.
• Upgrades, Troubleshooting database issues, critical security updates and User Issues using Meta link.
• Design database schemas, data modeling and maintain database objects using ERWIN.
• Management of 20+ TB databases with 400+ RAC database instance Environment.
• Setup/configure RMAN using Enterprise Manager in 9i/10g/11gR2.
• Good UNIX system administration skill on RHEL 4/5, HP-UX 11i and Solaris 10, including storage administration.
• Data Warehousing through the creation of OLAP Hypercube with ODBC.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Languages: C, SQL, AWK, SED, PERL, PL-SQL, KSH, Java

Markup Languages: HTML, XML

Server Technologies: windows 2003 server, GCOS8 servers

Modeling tools: Erwin, Designer 2000, and Rational Rose

Web Services: ASP.NET, ADO.NET

Databases: Oracle 9i/10g/11g RAC, MySQL, Dynamo DB, SQL Server, HTML DB

Database Tools: DATA PUMP, AWR,ADDM, OEM, Golden Gate, Oracle ware house builder

GUI Applications: Forms 10g & Reports 10g

Operating systems: LINUX (SUSE, REDHAT), UNIX (AIX, Solaris 8,9,10, HP-UX 11i), Win

Protocols: HTTP, HTTPS, TCP/IP, FTP, UDP and Telnet

Scheduler (Batch Jobs): UNIX CRON jobs, UC4, Red wood windows scheduler.

Version Control Tools: Visual SourceSafe, Source Forge, Subversion.

Clients: TOAD, SQL PLUS, Toad Spot Light, DB - ARTISIAN

Installation Software: Exceed (Emulator) for Installations (Humming bird), INSTALLANYWHERE, XTERM.

Backup tools: SQL back track, COMMVAULT, TSM, VERITAS Backup.

Web server: Oracle HTTP server (Apache) provided in Oracle companion CD, HTML DB

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Lead Oracle DBA

Responsibilities:

• Oracle Database Lead overseeing Confidential databases and 7 member team
• Cost reduction in web methods /JBOSS licensing using oracle middle ware
• Support of Custom as well as BI data ware house servers.
• IFX4/GP4 database application development and production support.
• SAN migration including ASM and NON ASM file systems
• Oracle 10.2.0.3/11.1.0.7/11 gR2 RAC installation for production servers on RHEL 4/5.7
• Oracle Dataguard and Data Broker setup and maintenance.
• Setup of Oracle Disaster recovery area and maintenance.
• Oracle connection manager (OCM) configuration and maintenance.
• SQL server 2005 Maintenance, Installation and Refresh for EASY JET databases.
• MySQL database administration
• Various Oracle RAC Upgrades to 11gR1 to 11.2.0.3 grid Infrastructure
• Oracle Gateway configuration for MySQL tables.
• Performance tuning or oracle code, reduction of I/O, writing efficient queries for high performance and less CPU utilization
• Oracle database optimization with indexes, partitions and sub partitions Monitoring database for high RAC wait event’s
• Excellent Handling of ORA-600 and ORA-7445, related patching
• Worked with EC2 servers including the cloud storage (S3, Glacier), RDS (relational database services) in Different time zones.
• Setup of DR in EC2 Availability zones.
• Define Snapshot time periods of Various EBS database volumes in EC2 and Transfer to S3.
• Replication using Oracle Golden gate for forecasting jobs on Parallel production env.
• Scanning PL/SQL procedures, packages to extract code for complex and high time consuming SQL
• Identifying Bottle necks in the code
• Databases monitoring using Oracle 11g enterprise manager (OEM).
• Big Data Implementation for Forecasting In-flight Inventory needs and Pricing
• Redistribution of I/O among data files, rebuilding indexes in separate table spaces.
• Performance tuning using DBMS PROFILE, ADDM, AWR, ASH, TKPROF and stats pack reports.
• Index monitoring and tuning inserts, updates and deletes
• Oracle RAC node addition and Deletion.
• Monitoring connection from Web sphere, reducing Deadlocks.
• Writing high performance SQL constructs, utilizing Hints
• Storage parameter tuning for tables, indexes etc

Environment: Unix shell scripts, KSH, BSH, CSH, AWK, On SOLARIS 5,6,910, RHEL(LINUX) servers,Golden Gate PERL, Oracle 10g /11g RAC,SQL server 2005, Toad 9,Jboss, Oracle Streams, EC2 cloud,MySQL,Dynamo DB

Confidential, Columbus, GA

Oracle DBA

Responsibilities:

• 24x7 Production support and maintenance for more than 400 database instances.
• Oracle database performance tuning for OLTP and DSS, ODS environments which includes DML, Physical and logical Backups and Very Large Object (Tables, Procedures).
• DBMS PROFILER, DBMS TRACE for Tuning PL/SQL to record execution time at micro-second level for SQL.
• Tuning Databases using Partitions, Indexes, Local indexes, Global etc.
• RAC database interconnect tuning.
• Loaded java classes into databases with java specific commands related to oracle
• Oracle database migration from HP-UX itanium 11i server to solaris 10
• Oracle PL/SQL hints Tuning and Code revalidation and Documentation.
• RMAN Refresh & cloning, Archive log maintenance.
• Handled ORA-600 using merge patches provided by oracle.
• Handled ORA-600 due to memory mismatch with the physical data.
• SQL server 2003 installation and Tuning for T-SQL programming as needed by development team
• Developed Dynamic PL/SQL for Selects, Inserts and updates, Reducing bind variables.
• Fine grain auditing control on Objects and PL/SQL code.
• Uni directional oracle streams
• Database monitoring scripts involving various Data Dictionary scripts.
• People soft administration and fixing connectivity issues, Locks
• Mentoring Database and Build team on Oracle Software installations and different version.
• Documenting HP- UX operating Procedures for Oracle Databases for mentoring purposes
• Change management, Check in, Check out with Microsoft Visual Source safe
• Version control using clear case, VSS, Subversion, Source Forge
• Oracle Database and Operating System Monitoring steps for Knowledge transfer
• Helping out Junior DBAS to Follow Best practices in Oracle.
• Eliminating Cartesian products, Recursive SQL for better performance
• Supported people soft installation, database connectivity and migration.
• Maintaining database security using roles and privileges.
• PL/SQL programming and performance tuning using TOAD SPOT LIGHT/ DB-ARTISIAN/DB studio
• PMCMD command line scripting in informatica.
• Converted data from ASM to NON ASM and Vice versa
• Cloning RAC -> Standalone. Standalone -> RAC, RAC -> RAC, Standalone -> Standalone.
• Oracle RAC CRS configuration maintenance.
• COMMVAULT hot and cold backup configuration.
• Oracle enterprise manager (OEM) set up, maintenance and alerts.
• Installation of Oracle Standalone Grid control, OMS, Its agents across different servers
• Oracle database upgrade from 8.1.0.1 -> 8.7.0.1 -> 10.2.0.1.0

Environment: Unix shell scripts, KSH, BSH, CSH, AWK, On SOLARIS 5,6,910, RHEL(LINUX) servers, PERL, Oracle 10g /11g RAC,SQL server 2003, Erwin Designer 200, Toad 8.1, DBARTISIAN, COMMVAULT, HTTP server, HTML DB, Informatica, Magna 8, FilSys, Fast I/O, people soft

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Implemented Complex Database security Models for hierarchy of developers & testers.
• 24x7 Support for the Developers Across the globe.
• Installed and Maintained Oracle 11i Application Server.
• Extensive database migration from windows server 2003 to HP-UX and solaris.
• Implemented Materialized Views and Complex External tables for Data filtering.
• Installed RAC databases with High availability data guard architecture.
• Weekly schedule of Application server patching and cloning the application server databases.
• Developed PL/SQL stored procedures, functions, packages and triggers and UNIX shell.
• Worked with Oracle packages like UTL FILE to open, read and write files to OS directories.
• Regular database Refresh from multi node RAC to single node and vice versa.
• Replicated data using oracle streams
• Developed java related pages to access the database (execute queries).
• Data Modeling through ERWIN, Designer 2000.
• Backup and Recovery of database Through RMAN.
• RMAN block change tracking, Compressed incremental backups.
• People soft administration and resolving issues related to ot
• Trouble shooting java web pages for inconsistencies in oracle procedures.
• Data transfer from NON ASM to ASM and vice versa
• Built modules to process data change capture and to transform to LCR in stream.
• Supported people soft integration with oracle.
• Documenting Best practices in Oracle and Mentoring Staff about these procedures
• Mentoring Staff in Coding in Oracle PL/SQL, Installation of Soft ware, Build Mechanism and Version control in For oracle scripts
• Training Staff to develop and maintain oracle monitoring software.
• Oracle one way streaming configuration and maintenance.
• Oracle workflow administration.
• Supporting Customer environments.
• Implemented SOX compliant Threshold for User Profile management.
• Worked on TAR s for various patches to ensure security updates are applied regularly.
• Created and maintained all databases required for development, testing, education.
• Assisted with impact analysis of any changes made to the database objects.
• Oracle RAC software Upgrades to 10g and RAC migration from one server to other.
• Implemented Logical volumes on Volume groups using on HP-UX for Raw devices.
• Worked on middle tier apps, people soft, Apache & IIS web servers, Form & Reports server etc.
• INFORMATICA ( ETL) Administration and maintenance of PMSERVER and PMREPSERVER
• Worked extensively with INFORMATICA power center.

Environment: Oracle 10g RAC, Solaris 10, Data guard, Red Hat, ASM, KSH, BSH, PERL and RMAN, Siebel analytics server admin tool, DBARTISIAN, Toad, OWB, Informatica, Java, Magna, Fast I/O, DBEF, GCOS8 servers, People soft, Veritas Net backup

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Primary Resource for 24x7 Production Support of 400+ databases on AIX and Solaris.
• Tuning for performance at Operating system level and Database Level.
• Regular database backup and recovery of 10+ terabyte oracle data warehouses.
• Applied security patch upgrades referring meta-link details.
• Managed Oracle APPS issues and users.
• RMAN backup and recovery.
• Virtual machine setup and installing cluster ware software.
• Database migration using import and export as well as using RMAN.
• Load balancing in Oracle applications (JSERV layer and hardware load balancing).
• Trouble shooting java pages for Data base inconsistencies in procedures
• Scheduling and maintenance of jobs through redwood instance scheduler.
• CPU average, Load average, IDLE time average monitoring by TOP, NMON.
• Developed tables for catching java procedure call exceptions.
• Database schema Design and Code Generation through ERWIN.
• RMAN catalog database creation, Backup and restore configuration.
• Designed IDSII schema’s and setting up there security using privileges.
• Supported people soft environment and related database sessions.
• Oracle streams set up and maintenance.
• Monitoring DB through wait event interface, trace files (TKPROF), Locks, Memory, I/O, Alert log.
• Cloning RAC -> Standalone. Standalone -> RAC, RAC -> RAC, Standalone -> Standalone.
• Configure, Schedule, Enable and Disable hot and cold RMAN backups.
• Administrating Partitions on RAW Disk Devices to Support Oracle data files using SAM in HP-UX.
• Prioritizing Incidents, Service Requests based on Severity, Scope and Business Impact.
• New machine setup and DB installation.
• Informatica PMSERVER and PMREPSERVER management
• PMCMD command scripting for informatica
• Informatica code promotion from Dev to QA, QA to Prod etc.
• Informatica user administration and security with Informatica work flow manager.
• Created scripts with COMMVAULT for Database backups and backup monitoring.
• Worked with Big brother monitoring Tool for monitoring various databases.
• Providing consultation for Oracle to developer team.
• Oracle 10g Physical and logical Data guard installation and maintenance for Reporting purpose
• Monitoring Fragmentation at Table level for optimal utilization.
• Used DB Verify to deal with block corruptions and RMAN block recovery.
• Documented installations, setup, upgrades, patch apply procedures.

Environment: Oracle RAC 8i/9i/10g, AIX 5.3, Solaris 9/10, GCOS8, Red hat Linux, COMMVAULT, VERITAS, NETAPP backup’s, 10g grid control, 10g ASM, Oracle 10g Standby, Windows2003, KSH, PERL, RMAN, Java, Magna, FastI/O,DBEF, People soft, Veritas Netback up.

Confidential, Tucson, AZ

Oracle DBA

Responsibilities:

• Performed database re-organizations as required to assist performance and ensure maximum uptime.
• Designed and created the Oracle RAC database.
• Performed 2nd tier Application support and administration.
• ERWIN reverse engineering, Database schema modeling.
• Troubleshooting and providing support 24X7 for the Oracle 9i RAC production environment.
• Database 24x7 monitoring to ensure a proactive problem recognition and resolution to database issues.
• IDSII schema setup and roles assignment. database migration and validating the objects, recompiling, taking out errors
• Trouble shooting database issues, critical security updates using Tar’s & Meta-link.
• Responsible for creating database Schema Scripts as part of the installation.
• Normal & RMAN backup and Recovery.
• Installation and maintaining of Oracle application server.
• IDSII schema set up and assigning privileeges
• Created & upgraded code to automate repetitive tasks, monitor database performance.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Reorganization of Data Base Objects for better performance.
• CPU average, Load average, IDLE time average monitoring by TOP, NMON.
• Created regular backing up and restoration of databases.
• Data migration (total Oracle 9i RAC DB restores to different machine).
• Database, OS and application tuning.
• Created & upgraded code to automate repetitive tasks, monitor database performance.
• Cloned production database to development and QA environment.
• Database monitoring (waits, locks, contention, sessions, IO, memory, alert log, trace files).
• Performance tuning using optimizing and minimizing the programming constructs.

Environment: Oracle 8i/9i/10g RAC, PL/SQL, SQL*Loader, SUSE, Red hat Linux, Win NT 4.0, Toad, Java, Magna, Fast I/O, Filsys, HP-UX 11i itanium, GCOS7, solaris 10, people soft