SUMMARY:

• 14+ years of experience in Oracle and SQL 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 6 nodes in RHEL/HP/AIX/SOLARIS.
• Installing and configuring and performance tuning of Oracle RAC 3+ nodes.
• Cross platform database Migration.
• Support of Oracle Databases on EXADATA Engineered system
• Physical data guard replication for high availability.
• Data Replication using Golden Gate/streams in RAC with DBFS
• Database performance tuning using Grid Control & Diagnostic pack (AWR,ASH ADDM etc)
• BI and ETL Reporting support.
• Design and implement backup and recovery including disaster recovery structures.
• Amazon Cloud EC2/RDS database server set up.
• 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
• ASM installation, Data transfer to from Non ASM to ASM.
• SQL server installation, maintenance and regular refresh.
• Database application support, Maintenance using Best practices.
• Excellent knowledge in Ora - 600, Ora-7445 issues and resolutions
• Designed and implemented various Gateway between SQL server and Oracle databases
• Hands-On expertise on managing large scale SQL server databases up to 1.3 TB
• Good working knowledge with XML files, Loading and unloading
• Patches, keeping applications software bug free and improving data integrity.
• 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 with SQL server 2005.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

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

Markup Languages: HTML, XML

Server Technologies: windows 2003 server

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 2005, 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/Architect

Responsibilities:

• Oracle Database Lead overseeing Confidential databases and 7 member team
• Support of Custom as well as BI data ware house servers.
• IFX4/GP4/SPMT database application development and production support.
• EXADATA with DBFS Production support
• Performance tuning of EXADATA IO wait events like “ Cell Single Block Physical Read”
• Worked with Hybrid columnar compression with EXADATA and 11gr2
• Oracle 11gr2 RAC setup and support on Datacenters of SAAVIS-CIBER,SUNGARD &AWS
• Supported Application Development in Agile environment utilizing a test driven development approach
• Support of BI environment for Critical reports with 4 TB Database size
• Tuning ETL process and analyzing SQL involved for better performance
• Query offloading and forecast job set up using GoldenGate.
• GoldenGate Trouble shooting and performance Tuning.
• Database logical and physical design.
• Configuring system DSN on windows server for ETL connectivity.
• Client and service side load balancing, application failover using TAF, listener config
• Configuring RMAN backup process, Regular RMAN restore/cloning to test and qa databases.
• 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 5.7, AIX 7.1
• Oracle Data guard and Data Broker setup and maintenance.
• VERITAS Cluster Failover using two Solaris Nodes for High Availability.
• Clearing Error’s causing Failover in VERITAS cluster.
• Setup of Oracle Disaster recovery area and maintenance.
• Migration of Oracle Databases to Cloud/RDS 11.2.0.2 in AWS
• Working with different storage options in EC2 like EB2 and S3
• Working with amazon support to resolve issues with RDS databases.
• Migration and simultaneous upgrade of Oracle database 10.2.0.3 to 11gR2
• Various Oracle RAC Upgrades to 10.2.0.3/11 gR1 to 11.2.0.3 grid Infrastructure
• Performance tuning or oracle code, reduction of I/O, writing efficient queries for high performance and less CPU utilization
• Oracle database optimizations with indexes, partitions, sub partitions.
• Monitoring database for high RAC GC 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.
• Configured Bi Directional database using Golden Gate for EC2 distributed database
• Upgrade using 10.2.0.3 to 11.2.0.3 using golden gate reducing down time.
• Identifying Bottle necks in the code
• Databases monitoring using Oracle 11g enterprise manager (OEM).
• Redistribution of I/O among data files, rebuilding indexes in separate table spaces.
• Performance tuning using DBMS PROFILE, ADDM, AWR, ASH 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,Veritas, On SOLARIS 5,6,910, RHEL, AIX servers,Golden Gate, Agile, PERL, Oracle 10g /11g RAC,SQL server 2005, Toad 9,Jboss, Oracle Streams, EC2 cloud,MySQL,Dynamo DB

Confidential, Columbus, GA

Oracle DBA/Architect

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
• Implemented 10.2.0.3 to 11.1.0.7 using Transportable tablespaces.
• 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
• 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.
• 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 2 nd 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 privileges
• 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

Confidential, Minneapolis, Minnesota

Oracle DBA

Responsibilities:

• Developing and administering FedEx Smart post Import & Extract files.
• Installation and maintained Oracle application server with shared TOPS.
• Performance Tuning Oracle Application server for Optimization.
• Designed, installed, and maintained 24x7 up time required back-end databases.
• Troubleshooting and providing support 24x7 for the production environment.
• Cloned and refreshed non-production environments from production for developers to work with.
• Monitoring the database growth, fragmentation, rollback segments maintenance.
• Switching the clients from the primary to the stand by server on primary failure.
• Unix system monitoring by TOP, IOSTAT, NETSTAT, VMSTAT, NMON, GLANCE.
• IDSII schema design and implementation
• Database 24x7 monitoring to ensure a proactive problem recognition and resolution to database issues.
• Optimized database performance by analyzing tables and indexes.
• Created regular backing up and restoring of databases.
• Worked on setting up user profiles and roles as per the access level of user and application security.
• Coded the stored procedures, Packages ad function. And well tuned the SQL in the application.
• Coding and unit testing of the server side components.
• Assisted with impact analysis of any changes made to the database objects.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Trouble shooting database issues, critical security updates using Tar’s & Meta-link.

Environment: Oracle 8i/ 9.0.1/ 9.2.0.5/10 g, PL/SQL, SQL*Loader, Import-Export, UNIX, Win NT 4.0, Toad, JavaHP-UX 11i, Solaris 10