Objective:

Looking forward to secure a responsible position in an organization which will be technically challenging, professionally rewarding and provide me the opportunity to understand the business applications/priorities of the customer and enable me to provide quality work, plan/implement industry standards that will help the client to achieve the cutting edge in their business.

Professional Profile:

Over 14 years of continuous Database Systems administration experience with strong concentration in Oracle RDBMS Technology. Extensive experience in the design, configuration, installation and upgrades of Oracle RDBMS software and databases version 7.x 11g.x , experience in implementation, pro-active monitoring and maintenance of production database systems in mission critical 24X7 environments, designing and setting up backup/recovery including Disaster Recovery solutions performed within the time limits permitted by aggressive Service Level Agreement SLA . Core understanding of design and maintenance of high-availability and scalable solutions using Oracle 10g 11gR2 RAC and ASM architectures. Experience with database and application tuning using a variety of Oracle database monitoring tools. Experience configuring Oracle Streams for bi-directional and uni-directional replication. I have experience in the installation, configuration and administration of Application Servers and Middle-tier applications such as Oracle 10gAS, Apache, BEA WebLogic, Oracle Forms/Reports Discoverer, Mentored new dba's, training/coordinating off-shore support teams and multi-tasking and working on multiple projects. Experience in implementing and enforcing database/data security using security products and procedures.

Techincal Skills:

• Oracle database Implementations, Implementation and enforcement of enterprise-wide standards
• Project estimation, Sizing and Capacity planning for databases/servers and dba resources
• Change Control and effective implementation of changes in lower regions and production environment
• SQL Reviews Proactive Reactive , Sql/Application tuning.
• Backup/Recovery using traditional hot/cold backups, export, data pump backups and RMAN backups, EMC BCV
• Oracle RDBMS Software Install/Upgrade/CPU-PSU Patching/Migrations, Database/Server Consolidations, Data center relocations
• Design DR solutions, Implement and periodic recovery exercise of DR strategies, Test/Validate DR procedures
• Effective Production Support and Off hour support, support handover, off-shore co-ordination
• Database Security Design, Implementation/Enforcement
• Implementing and Enforcing data security and procedures for Regulatory requirements of SOX, PCI, HIPAA and PII
• DBA - Utilities - Reorg, Index Builds, Export Jobs, Analyze/Stats, Resource manager, PL/SQL and Scripting to achieve this.
• Database Tools Install/upgrade and maintenance OEM grid control, BMC Patrol, Precise, Toad
• Proactive/Reactive Database Maintenance, Database/Instance tuning, SR Management/Tracking
• New Database Features Analysis /Testing/Feasibility study and implementation
• Managed databases in sizes varying > 2.5 Terabytes.

Employment History:

Confidential

Title: Oracle DBA Consultant

Responsibilities:

• Duties include application support, maintenance, installations, upgrades, migrations, SQL/performance tuning, backup and recovery, schema management, proactive monitoring and troubleshooting of Oracle 10g/11g databases in a 24x7 Data Warehouse OLTP environment. Core DBA activities include primary DBA support for the integrated Medical claims processing system and provider applications site supporting single sign on and profile information to over 1000 customers and backup for ODS/EDM databases.
• Provide hands on engineering, implementation, strategy and support plans to production and development teams for database related issues, including application tuning, troubleshooting and problem resolution, designing and building Oracle 11g2RAC nodes for High Availability and implementing Oracle 11gR2 Data guard Physical Standby for disaster recovery purpose for mission critical environments.
• Assists with impact analysis of any changes made to the database objects from Developers. Troubleshoot node evictions and issues related to Oracle 10g/11gRAC on Production environment and implement interconnect changes. Monitor ASM disk usage, utilization and plan for capacity planning.
• Duplicate Production database and schemas for Development and Test environment using RMAN. Planned and performed Online Backups RMAN using Tivoli Backup/ BMC SQL backtrack, DDBoost with Oracle RMAN. Designed tools to proactively report system and database availability. Created scripts to provide periodic reporting and database monitoring for internal and remote customers. Experience in Database and SQL tuning for optimized results using tools like Automatic Database Diagnostic Monitor ADDM to analyze data in the Automatic Workload Repository AWR in order to identify potential performance bottlenecks.

Confidential

Title: Snr. Oracle DBA

Responsibilities:

• Responsible for maintenance and 24x7 Support of multi-terabyte databases Oracle 10g/11g in production, testing and development environments hosted on Red Hat Linux 5.x servers. Setup and configured Oracle 11gR2 Grid Infrastructure and configured Oracle 11gr2 RAC Database instances. Engineer, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters RAC , Oracle Streams, specific network storage and clustering solutions. Supported Clearwire's Oracle 11gR2 8 node RAC Data Warehouse environment and various ERP / reporting / ETL applications.
• Responsible for performing Oracle database 10g 11gR2 tasks including installation, configuration, backup, recovery using RMAN and performance tuning. Implement and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC Real Application Clusters databases on HP-UX and Linux. Created and maintained Oracle Data-Guard configuration primary and standby databases using Data Guard broker interfaces, including a command-line interface DGMGRL and a graphical user interface that is integrated in Oracle Enterprise Manager.
• Designed implemented Disaster Recovery solutions for Clearwires' DR data center in Atlanta using RMAN clone and Oracle Data Guard for performing both planned and unplanned switchovers and failovers. Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts. Configured and setup RMAN scripts for daily backups to disk and nightly backupset copies to tape.
• Planned and implemented database schema and security changes. Monitored databases using Oracle OEM Grid control repository, configured for new database monitoring, set up thresholds and alert notifications for database issues. Responsible for engineering and implementing the migration of ClearWire's databases, enterprise applications and related infrastructure to Herndon data center with minimal downtime using Oracle physical standby databases.
• Troubleshoot and resolve database and/or application problems encountered by end users. Monitor database performance via STATSPACK, Automatic Workload Repository, Database Control, and Quest Tools. Participation in design reviews for upcoming application enhancements. Provide on-call support in adherence to specific business and customer Service Level Agreements.

Confidential

Title: Snr. Enterprise Database Consultant

• Fulfilled customer service requests for setting new Oracle databases and provided all database-related support for the production as well as test and lab databases for different markets. Installed and configured oracle 10g, 11g databases including RAC databases on Linux platforms and applied patch sets respectively on Test and Production environment. Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases, including RAC databases on Linux platforms.
• Provided Oracle DBA implementation and support for Knonos / Oracle migrations and upgrades, including environments using Oracle 10g/11g Data Guard. Configured and provided support for Oracle Enterprise Manager Grid Control and Agents. Provide 3rd level escalation support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN, trace analysis, service creation, cluster and system management.
• Planned and executed multiple server upgrades and migrations from Oracle 9i to 10gR2, 11gR1 and coordinated capacity planning through in-depth trend analysis. Monitored space utilization and application growth, and projected database sizing. Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control. Installed Management agent on hosts to be monitored using Grid control.

Confidential

Title: SNR. Oracle DBA / ORACLE STREAMS SPECIALIST

• Provide Oracle Database support for ExxonMobil Well Operations Data Management applications used for well drilling, planning and engineering projects. Installed, configured and implemented Oracle 10g R2 Streams Replication to support ExxonMobil EMDRILL, EMWELL and WELLVIEW 8/9 applications.
• Setup the Streams Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database. Used Scripts and Oracle OEM Grid Control to monitor and manage Streams Replication which includes the availability of queue for queuing messages, Number of messages received by destination queue, messages spilled by destination queue and time it took to dequeue the messages. Put the Apply queue in order if it was broken by instantiating the Objects and removing the errors from the queue.
• Used DATA PUMP/export import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process. Purge the data queue by using DBMS packages available before re-sync the streams. Assisted in the design of schemas for development and test databases using ErWin/Toad etc.
• Developed PL/SQL error and drilling Apply Handlers for the Apply Process for Wellview application Security. Configured complex capture and propagation processes and developed PL/SQL procedures to support BLOB, LONG RAW data types. Configured multiple apply processes for various critical risk and cost drilling assessment and performance analysis projects.
• Troubleshoot errors with data mismatch between a row LCR and the table for which the LCR is applying changes. Configured several internal streams capture, propagation, apply of schema in same databases and external streams capture, propagation and apply and different database for various projects. Developed Streams monitoring scripts to check status of apply, capture and propagation processes, checks for errors and display how LCR's are currently being applied.

Confidential

Title: SNR. ORACLE DATABASE CONSULTANT

• Install and configure Oracle 11g database, perform upgrade of Oracle 10gR1 to Oracle 11g. Migrated Oracle 9iR2 to Oracle 11g. Used Oracle 11g new features such as Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor, and Automatic Database Diagnostic Monitor ADDM .
• Provided ongoing support to the National Oceanic and Atmospheric Administration NOAA , National Marine Fisheries. Installed, configured and deployed 2 sets of 2 Node Oracle 10gR2 10.2.0.1 RAC environment running on Windows 2003 servers. Installed and configured Oracle OCFS2, created partitions on Shared Disk Storage to accommodate CRS Voting disk, CRS Oracle Cluster Registry and OCFS for Oracle database files/redo logs, control files and spfilefile.ora. Configured Oracle Enterprise Manager to support and manage RAC database. Applied patches 10.2.0.3/10204, cpu-patches to RAC environment to resolve issues and stabilize environment.
• Configured Oracle 10g schema level Streams Replication to capture and replicate data between NOAA HQ offices in Silver Spring, Maryland and NOAA regional offices in Seattle, Washington. Setup STRMADMIN user, capture, apply queues, dblinks and propagation processes. Instantiated objects using SCN flashback/export/import process. Configured and performed RMAN backups and recovery, import exports, Standby database and Data Guard.
• Performed daily support and monitoring of streams replication to verify data loads are synchronized within all NOAA regional environments. Performed remote Administration for the SMARTTTRAC project. Install and configure Oracle 10gR2, provide remote support which includes trouble ticket resolution, backup and recovery using RMAN, installations and upgrades, user support, performance tuning and general DBA duties .

Confidential

Title: SNR. DATABASE ANALYST III / ORACLE 10GAS ADMIN

• Oracle Database Analyst III / Application Server Administrator providing day to day upkeep of Oracle 9i, 10g databases and 10g Application Servers versions 9.0.4.0, 9.0.4.2/3, 10gAS R1,R2 . Provided Oracle database administration support and resolve database and Application Server related issues in production environments.
• Experience installing and cloning Oracle database 9i 10g and 10gAS Oracle Forms/Reports, Portal Discoverer, SSO, OID/LDAP, Wallet Manager, J2EE and Web Cache . Installed, configured and maintained 4 Node 10G RAC on Red Hat 3.0 using HP shared storage environment, configured RAC CRS Clustering, ASM Disks, migration of tablespaces / datafiles to ASM storage. Configured VIPCA, setup TAF services to define load balancing and failover mechanisms.
• Experience administering Oracle 10gAS, upgrade to 10gAS, 10gAS performance tuning, high availability administration and experience in implementing OID, SSO and J2EE deployment. Troubleshot and resolved problems with Oracle databases, Oracle 10gAS infrastructure/middle tier applications. Performed database performance tuning, database and applications patches.
• Provided proactive performance analysis statistics using Oracle Statspack to improve memory optimization, CPU usage and I/O workload. Application side performance improvements included improvements to batching of updates and deletes, tuning SQL statements, creating/modifying indexes, object statistics collection, using hints and database design changes. Provided support to application developers to create and tune SQL for inclusion into the software.
• Updated and monitored backup and recovery systems using UNIX shell scripting. Provided long-range capacity and requirements planning and played key role in the design, development and implementation of high availability solutions for CREEMS Oracle 10g Application Server environment.

Confidential

Title: SNR. DATABASE ENGINEER

• Monitored databases using Netcool monitoring application. Applied patches to address Oracle security issues, address standby database space issues with the shipper and applier process. Monitored Quest shareplex post export and import queues, comparing and repairing out sync tables, clearing logs, etc.
• Performed installations, administration and maintenance of DOI multiple database applications. Support production/test/development instance of OLTP, DSS and data warehouse applications. Designed and implemented backup/recovery strategies for various database systems. Implement backup/recovery strategies for 24x7 critical systems using hot backups. Develop cold backup for data warehouse systems.
• Responsible for planning Oracle database, storage structures, creating databases and objects. Design and created database schema, functions, triggers and indexes. Monitored and optimized database performance by tuning application, network and database server. Installed Oracle Server and other Oracle tools.
• Participated in testing the compatibility and portability of application on Oracle 8.1.5/8.1.6/8.1.7. Migrated whole application and database from Oracle 7.3.4 to Oracle 8.0.5/8.1.5 and Oracle 9i. Created Database Objects tables, indexes, views, synonyms , instances, users, roles, database links, materialized views etc. Performed database security and user administration via roles, profile, privilege, synonyms, auditing and performing SQL tuning. Created several standardized reports for Department of Interior using Designer 2000 and Crystal reports tools. This project required significant scripting. Scripting was performed using Perl, shell and PL/SQL packages. A majority of these scripts have been incorporated into Unix cron jobs that formed the back end processing components for the system.

Confidential

Title: ORACLE DBA

• Administered Oracle 7/8i/9i and Oracle ERP Applications 11i HR, CRM, FIN, AP, E-Business Suite, Oracle Financials 10.7/11.5.4 . Installed and configured 2 node Oracle Applications 11i 11.5.4 Support and maintain 16 Oracle databases and 4 Oracle Applications 11.5.4 instances including production instances in development and production environments, develop and deploy performance tuning methods, develop and document database administration strategies and tools.
• Part of the technical implementation team for a 2 and 3 node ORACLE ERP Application 11i 11.5.4 . Performed installation, patching and Upgrade of 10.7.x to 11.5.3. Experience working with tools like MKS, GNUMAKE, Visual C , JDK, XSU, PL XML Parser, Rapid Install, Database Migration and upgrade, ADpatch, AutoUpgrade, AutoPatch, Concurrent Manager, AutoConfig, Rapid Clone.
• Involved in DR project which was accomplished using Quest Shareplex and Standby databases to maintain DW and DR in a high availability setting under Sun clusters systems. Managed every facet of clients' environment 24 by 7 including Patches, Metalink TARs, new product installs and upgrades, administration, trouble shooting, fault management, space management, resource management, capacity planning and performance tuning.
• Administered Concurrent Managers, user administration, printing queues etc. Participated in design and development of customizations and interfaces. Maintained data integrity, minimized fragmentation and disk contention, granted and revoked roles. Monitored rollback segment usage and temporary segments, generated alert reports and purged database

Confidential

Title: ORACLE DBA

• Created and maintained Oracle 8.x/8i instances, enrolled users and assigned resource profiles, quotas and roles.
• Worked with the customer base to compile user requirements and submitted case studies of the business model.
• Worked with a three-member technical team to implement a complicated set of business rules. Implemented several PL/SQL packages to perform data crunching. Created an Oracle 8i instance and populated it with the physical design and loaded the data. Installed Oracle Enterprise Manager on workstations to monitor and maintain multiple instances.
• Developed an automated process that retrieves data from a remote MS SQLSever 6.0 database on a NT server and updated remote Oracle database on a UNIX environment. The database structures were similar to each other requiring special handling of data. The program is written in Visual Basic 5.0 and is run on an NT workstation supporting NT Scheduling Services.
• Built shell scripts to generate monthly and quarterly transaction reports for the business development group using Pro C 2.0 on a SUN SPARC 5 workstation. Email notification packages were used in conjunction through the CRON utility on a Sun Ultra machine supporting an Oracle 8.1.7 database.