SUMMARY:

• Oracle Certified Professional (OCP) 8i/9i/11g in database administration, design and development.
• More than thirteen years of experience in database administration, design (Physical & logical), development of Oracle 12c/ 11g/10g/9i/8i/8.0 with focus on Migration, RAC, DATAGUARD, RMAN with EMC Avamar 6.1, VERITAS, TSM under Linux, AIX, HP - UX 11.0, Solaris 2.7 environment handling both production and development databases.
• Expert in handling both production and development database environment of various databases on multiple platforms
• Experience in UNIX (AIX, Solaris, Linux and Tru64) Windows NT/2000 & 95. Oracle 9i/8i/8.x - Installation and configuration of Oracle and large databases on UNIX (AIX/ SUN/HP) and Admin. Functions, security Planning, Creation of Database, Physical Database Configuration and Disk Space Layout Planning using NAS (Netapp F820, EMC Symmetrix 8000 series) & SAN ( Confidential & SUN Blades) storage.

PROFESSIONAL EXPERIENCE:

Confidential, Washington D.C

Oracle database engineer

• Part of a new team to scope and architect a new development and test lab including developing proposal, inventory, tech specs, budgeting and business analysis.
• Installed and configured 12c for testing migration from 11g.
• Performed STIG to oracle databases 11g. Implemented security measure like oracle wallet, Tablespaces encryption, oracle auditing and listener security.
• Install and configure 11G databases and integrate with applications.
• Upgrade 10g to 11g databases.
• Developed shell scripts to automate management tasks.
• Documentation
• Coached and sponsored junior to mid-level DBAs for the HR DoS team. This includes developing step by step work documents, training, day to day guidance.in troubleshooting.
• Assisted in architecting and developing high level HR projects including upgrade of all the backend systems from 9i to 11g, setup central monitoring 11g Grid Control for mid-tier and backend systems, Business continuity and disastrous recovery using EMC VPLEX and SRDF, develop a program to refresh DEV, TST databases from production databases on daily basis.
• Develop and architected backup programs for all productions databases using OSS in ASM
• 11g RAC installation on ASM
• Implemented Oracle Wallet for TDE (Transparent Data encryption).
• Provided proposals and developed new methods and work processes to streamline periodical release and scheduled maintenance resulting in cut of costs. This includes automation of routine work, study and analyzes of legacy systems and provided alternative solutions that cut costs in terms of time and efforts.
• Design VI solutions for DoS data center
• Install/configure/ tune VMware products.
• Install, configure and tune ESX hosts
• Upgrade ESX software
• Apply patches and firmware
• Assemble, rack and install HP c7000 BladeSystems enclosures, blades and hardware.
• Configure HP blades Onboard Administrator, Virtual Connect, FlexNet NICs and FC modules.
• Troubleshoot HP blades, remove and replace parts
• Perform on-call duties
• Update passwords
• Create, customize, deploy and manage VMs
• Install, configure and test 11g Oracle RAC in virtual environment for bench mark.
• Work with developers to tune virtual Oracle environments
• Work with Architects to plan and develop transition plans to migrate Oracle databases to virtual environments.
• Respond to customer real world issues and provide suggestions to technical concepts
• Monitor HP blades, VMs and respond to alerts.
• Assist with storage team(Netapp SAN) with applying PKI certificates to Netapp Filers, audit DFS (file shares), monitor scheduled snapmirrors and rack filers
• Watch and Complete tasks submitted in Remedy system, Internal Service Request and requests thru emails.

Confidential, North America

Sr. Oracle DBA

• Provide database/middle tier systems and application support for Oracle based technologies.
• Researched new 11g Snapshot standby database features.
• Tested migration of 10g to 11g.
• Worked with 10g Grid Control configurations and agent install and deployment.
• Install and configure Oracle 10g databases, Oracle application server 10g.
• Responsible of automating daily DBA tasks using UNIX BASH scripting.
• Maintained and resolved 10g Dataguard issues.
• Assisted with installing and configuring Cognos 8
• Apply database patches.
• Worked and modified PL/SQL code.
• Assisted in maintaining Oracle Forms code in CVS

Environment: Red Hat AS 4.0, Confidential blades, SUN Blades, ColdFusion, J2EE, Oracle 11g, Oracle 10g, Oracle Forms 9i, Oracle iAS 10g, Cognos 8

Confidential, Rosslyn, VA

Sr. Database Engineer

• Supported and managed the US-VISIT ( Department of Homeland Security ) Enterprise Reporting System Oracle 10g database schema release using CVS and Version Manager.
• Worked and troubleshot issues with Advanced Queue (AQ) and automated a Metalink internal note to resolve known AQ orphan objects using PL/SQL.
• Developed scripts in PL/SQL, UNIX shell scripts to facilitate database management.
• Analyzed data, performed code reviews and identified architectural issues by enforcing integrity relationships in the source tables instead of Materialized Views.
• Performed SQL tuning using Explain Plan and suggested query rewrite, using hints and create of indexes to eliminate Full Table Scans.
• Worked with Oracle schedulers
• Worked with release documentation.
• Responded to ad-hoc database requests and resolved various database issues.

Confidential, Foster City, CA

Sr. DBA

• Performed senior database administrator duties.
• Planned and developed database management projects
• Setup Dataguard for disastrous recovery plans
• Installed and setup Grid Control monitoring.
• Installed and configured ASM for storage management in LINUX platform for analysis and testing purposes.
• Troubleshot performance issues and developed solutions
• Worked with application and QA team to resolve design problems.
• Analyzed and presented PPT featuring 11g new features.

Confidential, Sunnyvale, CA

Sr. Oracle DBA

• Worked as the primary Database engineer for Oracle 10g environment for the Confidential mobile systems (Y Go) application for mobile devices.
• Setup, installed and configured 10g in RAC environment using NetApp.
• Developed cold/hot backup & recovery scripts using NetApp snapshots.
• Worked closely with system engineer to configure Netapp storage using Netapp System Manager tool
• Developed monitoring scripts to alert, capture debugging oracle data and to automate some of the DBA daily routine tasks.
• Setup and worked with AWR reports
• Performed duties of database upgrade from 10.1 to 10.2.
• Managed and worked with 10g Enterprise Manager (Grid Control)
• Performs on-call duty.
• Worked close to developers to tune SQL statements and Applications support

Environment: Red Hat AS 4.0, NetApp, JBOSS, JMS, JDBC, EJB, PL/SQL, Oracle 10g, RAC, 10g EM

Confidential, Mountain View, CA

Database / Application Admin

• Worked as the primary DBA for Oracle 10g environment.
• Setup, installed and configured 10g Data Guard.
• Plan, develop and implement disastrous recovery strategy using 10g RMAN scripts for different backup & recovery plans.
• Setup & installed Oracle 10gR2 RAC using Clusterware on Netapp
• Installed, configured and tested ASM for storage management in LINUX platform using raw devices.
• Developed Oracle monitoring scripts for Big Brother Alerts using BASH & Korn shell.
• Setup and worked with AWR reports for tuning
• Performed duties of database upgrade from 10.1 to 10.2.
• Installed and configured 10g Warehouse using (OWB)warehouse builder
• Managed and worked with 10g Enterprise Manager.
• Performs on-call duty
• 24/7 support
• Worked with SonicMQ 6.0 (Java Based messaging system)
• Applications support
• Assisted in Setup Kerberos servers.

Environment: Red Hat Linux AS 3.0, Red Hat AS 4.0, NetApp, JSP, JDBC, PL/SQL, Oracle 9i/10g, Windows 2000 Server, SonicMQ 6.0, RMAN, RAC, Oracle 10g Data Warehouse, Unix, Oracle Warehouse Builder (OWB), SUN Storage 1000A.

Confidential, South San Francisco, CA

Database/ Applications Admin

• Setup Oracle 8i/9i/10G databases environments.
• Participated in database and application schema architect for the Research environment.
• Worked with Materialized Views and implemented snapshot replications.
• Developed processes to facilitate data loading using transportable tablespace.
• Installed, configured and tested Oracle 9i on RAC (Real Application Cluster).
• Performed database tuning for distributed applications via dblinks using Statspack and SQLTrace.
• Developed and automated applications management using UNIX shell scripts (korn89/Bash)
• Performed DBA support for Oracle Datawarehouse 9i.
• Troubleshot and worked with Oracle Java classes.

Confidential, San Jose, CA

Database/ Applications Admin

• Setup, implement, and deploy Oracle Advanced Queuing (AQ).
• Developed and automated processes using PL/SQL for recovering Oracle databases from Advanced Queuing object corruption.
• Troubleshot and debug AQ propagation problems.
• Worked with Oracle support to debug and implement solutions for Oracle bugs and Oracle internal problems
• Setup Oracle 8i/9i/10G databases environments.
• Installed, configured and tested Oracle 9i/10G on RAC (Real Application Cluster).
• Performed database tuning using Statspack and SQLTrace.
• Setup testing environment simulating Production environment to troubleshoot complex enterprise Load performance. This involves installation of Perl modules, JDBC connection pooling and setting up and installation of Bea Weblogic 6.2

Confidential, Burlingame, CA

Database/Unix Admin

• Design, setup, networked and configured UNIX servers for a newly built data center for WebSphere Integration Team (WBI) (AIX 5.2, Solaris 8, Linux RH 2.4, Linux Suse 9.1)
• Installed and configured HMC for managing AIX servers
• Design, Install & Configure Oracle (9i, 10g) & DB2 8.1 test databases

Confidential, Fremont, California

Database Administrator / Application Engineer

• Responsible for monitoring and achieving maximum database performance.
• Plan and perform all database configuration, management, monitoring, tuning, capacity planning, data extraction, backup and recovery using RMAN.
• Performed migrations to all PeopleSoft8 backend repositories from Oracle 8.1.7.4 to Oracle 9.2.0.0
• Configured, administered Oracle databases for PeopleSoft8
• Worked with EMC Symmetrix 8000 Series (Control Center v5.1.18.3)
• Migrate Oracle parallel Server (OPS) (Oracle 8.1.7.4/HP-UX) to Real Application Cluster (RAC) (9.2.0.4/HP-UX)
• Apply Oracle patches to upgrade to 9.2.0.4

Confidential, San Francisco, California

Oracle DBA

• Installed, configured and administered oracle (8i, 9i, 10g) and UDB v7.1 and v8.1 databases. Worked with Oracle 9i Data warehouse & (Power Center) Informatica 6.2
• Installed and configured Weblogic and Websphere Application Server
• Installed Veritas Volume manager and Set it up for taking regular backups and recovery.
• Responsible for all aspects of Oracle 9i & 10g Database Administration in a production phase to facilitate 24/7 operations.
• These responsibilities include database configuration, backup and recovery, capacity planning, improving database performance, data extraction, troubleshooting, security, schema maintenance, applying patches and performance tuning.
• Used Encryption wizard to configure & enable data encryption
• Used Parallel query server processing, Tuning tools like EXPLAIN PLAN, SQL Trace, TKPROF, scripts like STATSPACK, monitoring SQL tuning through use of optimizer hints within SQL statements. Reorganized the database to reduce fragmentation, which includes table, index, Synonym etc
• Architected and planned a 3-tier module for the rollout of BMC monitoring and administering tools to more than 240 production and development UDB and Oracle databases.
• Developed Java program and stored procedures to automate the installation and configuration of BMC software. Administered BMC middle tier application server. Used the BMC tools to perform DB troubleshooting, SQL trace and databases tuning.
• Worked with oracle failover and RAC. Used shell scripting to create tarballs as part of the rollout plan for BMC software.

Confidential, Brisbane - California

Sr. Oracle Database/ Unix Administrator

• Performed the roles of UNIX administrator and Oracle DBA.
• Installed, configured and tested Oracle 9i on RAC (Real Application Cluster).
• Assisted with the daily maintenance and administration of Oracle 9i on different platforms like Linux, AIX, HP-UX and Solaris.
• Performed Unix Administration activities like creating and managing users accounts, Disk Management, Disaster recovery, handling UNIX kernel parameters, file system permissions, startup and shutdown daemons, Automation of data loading process using UNIX crons and extensive usage of UNIX awk, sed scripts and Perl.
• Involved with adding, modifying and promoting database objects through the development environments.
• Performed Oracle 9i/10g and SQL tuning with the development teams.
• Responsible for all aspects of Oracle 9i Database Administration in a production phase to facilitate 24/7 operations.
• These responsibilities include database configuration, backup and recovery, capacity planning, improving database performance, troubleshooting, security, schema maintenance,
• Assisted in installing and configuring PERFORCE and perform control management tasks.
• Installed and configured Weblogic and Websphere Application Server
• Installed Veritas Volume manager and Set it up for taking regular backups and recovery.
• Installed and maintain Oracle security server and setup server side security.
• Worked with ANT and generated configured builds.
• Configured the Standby Database for high availability of the database and Cloning.
• Responsible for building, configuring HP OpenView/Performance Insight
• Extensively used Unix Shell Scripting (Korn shell/Bourne shell/C Shell), CGI-Perl and JSP scripts to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring crons, usage of ufsdump, ufsrestore, cpio, and tar. Alerts
• Performed Space management, Defragmentation of the database.
• Implement RMAN backup script for taking Full, Incremental backups.
• Racked, setup and configured Netapp F820 for Oracle storage

Confidential, Pleasanton, Ca

Oracle Database Engineer and Administrator

• Installed, managed and configured Oracle databases and responsible for 24x7 production support
• Configured and managed Oracle Advanced Security features
• Handled online application downtime problems and worked with IIS 5.0, DNS and Load balancer (BGP).
• Configured RMAN, with TSM for backup, recovery
• Installed, configured and worked with OEM.
• Involved with upgrades, migrations, cloning and performance tuning
• Worked with documentation and change control management.
• Applied online application upgrades.
• Worked with SQL Server management in clustered environment. Platforms used were Solaris, windows 2000 and Windows NT.
• Worked with ETL & Data Mart for Finance Dept.
• The logical data modeling was done after going through the existing system and plans were suggested.
• Created and modified Oracle Schema objects like Tables, Indexes.
• Created Programs in PL/SQL to implement business Logic.
• Installed HP OpenView Performance Insight Manager.
• Extensively used the Entity relationship, Data Flow diagrammer, Repository, Repository reports, Database Transformer etc.

Confidential, Spokane - Washington

Engineer

• Performed duties of quality assurance and software testing for power & energy applications.
• Worked with SILK TEST software to develop scripts and harnesses to debug .NET enterprise applications
• Installed, managed SQL Server 2000 for the QA environment
• Experience with identifying and submitting software defects/bugs and categorizing priorities using RATIONAL TEST SUITES.

Confidential, Modesto - California

Java Client/Server Developer

• Modeled, planned, developed and implemented a Java client / server solution to maintain medical records.
• Application developed using Enterprise JBuilder 6.0 tools to develop Java SWING GUI components.
• Developed JDBC to interact with PL/SQL code using SQL*PLUS and TOAD.
• Developed web reports using JSP, JServlet and HTML on BEA Weblogic servers for the company Intranet.

Confidential - Fairchild Washington

Communication/Navigation Technician

• Military Basic Training.
• OSHA responsibilities for the flight, training, documentation and follow up.
• Performed duties of an avionics technician in KC-135 refueling aircrafts and H1 helicopters.
• Expert in full aircraft maintenance in hangers.
• Honorably discharged