OracleGuru
Home > Computers & Programming > Databases > Oracle > OracleGuru

OracleGuru

This expert is currently unavailable for sessions. We apologize for any inconvenience caused.
Expert in: Oracle    
Rating:
Languages: English
Oracle Guru (15 years) Technical architecture definition, Capacity planning, Oracle Database and Data Warehouse Design and Administration on (24x7) VLDB production databases.
All chat sessions start FREE!
Chat / Phone: $0.75 per minute (Convert currency)
Email: $45/hr (Convert currency)
 

Degrees

Maters in Computer Applications, Bachelors in Mathematics

My Expert Service

1. ---> Over 14 years of experience in Technical architecture definition, Capacity planning, Oracle Database and Data Warehouse Design and Administration on (24x7) VLDB production databases. 2. ----> Expert skills in Oracle RDBMS (10g/9i/8i) Installation, Capacity planning, Database Creation, Performance Monitoring & tuning and Backup & Disaster Recovery. 3. ---> Strong Data modeling, Data Conversion, Data & Volumetric Analysis, Application infrastructure & enterprise model management experience. 4. ---> Worked in Oracle 10g Rls 2/9i Real Application Cluster environment with Oracle 10gAS/9iAS interface. Extensive knowledge of Oracle functionality & internals. 5. ---> Worked with variety of clients in financial/public sector, federal/State government and E-commerce based organizations. 6. ---> Good consulting and communication skills, with knowledge of client-relationship building techniques and project methodologies with good team building skills.

Experience & Qualifications

• ---> Certification Course Oracle 10g Rls2 RAC for Database Administration from Oracle University in 2008. • ---> Certified OCP in Database administration. • ---> EMC Certified in Enterprise Storage Foundations. • ---> CMMI Overview Certification. <---------------------------> PROFESSIONAL EXPERIENCE <---------------------------> <------SEC (federal)--------------> <----Principal DBA/Team Lead for Database Administration ----------> •-->> Production Database Support for Oracle 10g Release 2 and 9.2.0.7 databases on Linux with 10g RAC environment and Windows 2003 Advanced Server (64-bit) with Financial ERP front-end. •-->> Technical Architect for Oracle 9i to 10g Rls 2 (64-bit) upgrade, configuring Grid Control and Advanced Security (ASO) configuration for TDE and Network encryption for financial data. •-->> Oracle 10g RAC installation l in 2 Node Red Hat Linux environment for Oracle BPEL implementation. •-->> Installed Oracle 10g/9i, Capacity planning, Disk/Volume layout, RAID definition for 4 tera bytes database. •-->> Installing Oracle FailSafe 3.4 (64-bit) and testing failover in 4 node cluster using EMC SRDF for Disaster recovery. •-->> Advanced Performance Monitoring and Tuning using 10g OEM tools AWR, Metric baselines and ADDM. Query tuning using SQL Tuning and Access Advisors. •-->> Configured RMAN backups using 10g OEM/scripts and configure with Veritas Netbackup. <------> GSA(federal) <-----------> <---> Principal DBA/Lead for Oracle Technical Architecture <---> •-->> Development and Production Database Support for Oracle 10.2.0.4 with Siebel 7.8.2 Call Center application on AIX server (64-bit). •-->> Upgrade Oracle databases fro 9.2.0.8 to 10.2.0.4. •-->> System technical architecture definition, Capacity planning, SAN Disk Storage, defining RAID levels for Production databases and data warehouse. •-->> BCV backups/restores for the databases on EMC SANs. RMAN configuration using Vertias for Backups and Data Guard for physical standby. •-->> Configuring Oracle Fail Safe 3.4 with MS Clusters for Active-Active db nodes in Windows 2003 environment. •-->> Logical/physical data model definition using Erwin and Capacity planning for monthly/yearly data loads. •-->> Performance monitoring and tuning using STATSPACK, OEM and custom scripts. •-->> Supporting Rational tools administration and Siebel, Business Objects and Informatica administration. <----> Pennsylvania State Police (Lockheed Martin)<----------------> <-----> Sr. Oracle Solutions Architect <-----------------------> •-->> Production DBA for Oracle 10.2.0.3 databases (24x7support) 1.1 TB, on HP 9000 and Windows 2000 advanced servers. •-->> Performance monitoring and tuning using Statspack reports and implementing DB security procedures using User Roles classification and data encryption. •-->> Backup and Disaster Recovery procedures implementation using BCV backups and RMAN. •-->> Oracle 10g (Enterprise Edition) installation and research available methodologies for replicating data between MCD’s (Mobile Computing Device) and Master DB server on Windows 2000 Advanced Server. •-->> Maintaining the existing data model in ERwin to conform to the Standard naming conventions and Abbreviations document. Mentoring other DBA's on Data modeling techniques & principles. •-->> Communication of issues/scope and requirements to Data warehousing/Reporting, infrastructure teams and end-user groups. •-->> Implementing the Application drop procedures and the changes required for the database and recompilation of the forms, reports and PL/SQL libraries. •-->> Oracle 10g Lite install and prototyope application for development and synch operation on the MCD.

Available Modes Of Communication

email/chat

Contact OracleGuru