Summary:

Effective, driven, self-motivated, team player with 19 years of experience as Oracle DBA and Data Architect, Data Management professional in database administration, design, migration, replication, upgrade, development, maintenance, implementation, support. Extensive knowledge in design, architecture, performance tuning, high availability solution implementation using Oracle Real Application Clusters, Oracle Active Data Guard, Oracle Golden Gate, Oracle Grid Cluster-ware, Oracle Logical/Physical Stand-by and Oracle Business Intelligence solutions.

Technical Skills:

Databases: Oracle 12c, 11g,10g, 9i, 8i, 8.0.x, 7.x

OEM: Oracle 10g, 11g, 12c

Oracle Tools: RMAN, OEM, SQL Net, crsctl, srvctl, PL/SQL, SQL Loader, etc.

Backup : RMAN/Legato/NetBackup, Alexandria, DB-Breeze, SQL-Backtrack, EMC BCV

WebApps : Oracle Application Server, Apache Web Server

ETL Toos : Informatica, Ab Initio

Analytical Reporting Tools : Oracle Business Intelligence, Intelligent Warehouse 4.0, Crystal Reports, Business Objects, Micro Strategy, Siebel

Data Modeling Tools : ER-Win

Operating Systems: UNIX AIX, SunOS, Linux, HP-UX , Windows NT/2000/XP

Hardware: SunOS 6800, SunFire-15K, IBM RS/6000 clusters, IBM SMP/SP2 nodes, Sequent Symmetry systems SMP , Sequent NUMA-Q systems, SUN 6800 and SUN Fire-15K's, SUN Microsystems Sparc server and Sparc Station Series of Systems, HP Unix systems, HP Superdome server, ORG Supermax systems, DRS600,

Disk subsystems : EMC symmetric disks, EMC/BCV volumes, EMC timefinder, EMC Disk arrays, SRDF-A

Version controlling: Clear Case, CVS, SVN

Technical work summary:

• Designed, installed, configured, maintained numerous Oracle RAC for varied high availability business requirements and configured highly available services
• Designed, configured and maintained Oracle Golden Gate solution of complex data replication requirements.
• Expert in Oracle Streams implementation/mangement: multi-master, hub-and-spoke, downstream mining, investigative data mining, etc.
• Implemented highly secure encrypted financial messaging system using Advanced Queuing
• Migrated multi-master replication from Oracle Streams to Oracle Golden Gate
• Implemented Oracle Active Data Guard for active reporting needs for a high volume OLTP Implemented Physical Stand-by for contingency requirements
• Implemented Logical Stand-by for log mining purposes for auditing transactions
• Configured and managed Oracle Grid Cluster-ware solution for both database and non-database service high availability - using oracle services
• Implementing dash board reporting solution using Oracle Business Intelligence
• Installed and configured Oracle Automatic Storage Management ASM
• Installed, configured and managed Oracle Enterprise Manager using 12c, 11g, 10g management server for enterprise database monitoring
• Implemented Oracle Recovery Manager RMAN backup solution across enterprise
• Engineering and certification of Oracle 12c OEM 12c
• Architected, implemented and documented Disaster Recovery procedures
• Automated the Oracle Diagnostic Tools for the purpose of production diagnostics
• Designed and automated Oracle Minimum Security Baseline - Database security validation
• Architected and implemented Oracle Wallet solution enterprise wide
• Currently working on Oracle Identify Management solution
• Automated ID and password management activities using Enterprise Password Vault
• Implemented Flash Recovery Area as a solution for rollback of testing activity
• Worked with outsourcing partners in transitioning the knowledge using Knowledge Articles
• Standardized database management activities and conducted KA/KT sessions
• Designed and implemented partition management rolling-window system for VLDB
• Automated tablespace management for VLDB databases
• Participated in periodic architecture meetings and data knowledge management symposiums
• Initiated Database Systems Management Wiki creation for internal knowledge sharing
• Automated monitoring, alerting and reporting privileged database systems activities DSM
• Architected, engineered and automated vmware Virtualization of database hosts
• Performed Linux System Administration for engineering purposes
• Designed and implemented hands free automation of Oracle software database deployments
• Designed, implemented, Documented the Disaster recovery procedures
• Proficient with tracking, analyzing, and application of Oracle software patches
• Proficient with Release Management activities
• Proficient with Project Management and Program Management tasks
• Managed task tracking, resource management, as part of project management activities
• Managed Oracle Software Licenses and license allocation, etc

Database Administration Details:

• Administered oracle cluster using crsctl, srvctl, crs stat, oifcfg, etc.
• Diagnose the oracle cluster ware by enabling traces on cssd, crsd, etc.
• Configured Oracle ASM using oracleasm, asmcmd at unix level
• Configure ASM disks, manage disk groups, manage ASM instances
• Configured customized RMAN backups for VLDBs
• Managed backups using rman, cold, hot level-0, level-1 backups
• Used RDA Remote Diagnostic Agent to provide details to Oracle support.
• Design the logical and physical database structures based on business requirements
• Performed database recoveries using RMAN.
• Capacity planning data collection, analysis, reporting and automation
• Worked extensively on performance tuning
• Troubleshooting of database high availability issues
• Implemented golden gate extract, pump, replicat processes
• Use ADDM / AWR reports to fine tune SQL query and database performance issues
• AWR data extraction from production to development for offline performance analytics
• De-fragmentation of databases. Reorganizing the databases. Export/Import.
• SQL Net configurations.
• Used SQL Loader for data movement between databases
• Worked with ETL Tools such cas AbInitio and Informatica
• Managed perl scripts which automated much of database reporting
• Proficient in Unix shell scripting in ksh, sh, csh, awk etc.
• Wrote PLSQL code - procedures, functions, packages for database admin automated tasks
• Capacity planning
• Benchmarked high volume application operations to test scalability issues
• Worked with configuration management tools such as Clear Case, SVN, CVS, etc
• Familiar with SDLC, Agile and Water fall methods, Test procedures, etc
• Installed
• Configured OEM Agents, Databases with OEM, Monitoring and reporting on OEM
• Used ER-Studio for data modeling
• Standardized database creation procedures with customized enterprise wide deployments
• Automated oracle client software installations
• Created self service database schema deployments, database schema refreshes
• Configured services on oracle grid cluster-ware

Professional Exp rience:

Confidential

Technical Architect

Oracle 11g-12c, Oracle Streams, Oracle Active Data Guard, Advanced Queuing, RMAN, OEM, Specialized in highly secure database implementations

Confidential

Data Architect, Database Engineering, Technical Architect, DBA Manager

Oracle RAC, Oracle Active Data Guard, Oracle Golden Gate, Grid Clusterware

Logical/Physical Stand-by, Data Warehouse, OEM

Confidential

Data Architect and Database Administrator

Oracle RAC, HP Clusters, HP Superdome, Data Warehouse, OBIEE

Confidential

Database Warehouse DBA, Data Architect and Database Administrator

Oracle Parallel Server DBA, IBM AIX HACMP clusters, SUN Solaris

Confidential

Database Administrator