Sr. Oracle DBA
Credit Suisse
Total years of experience :34 years, 6 Months
Install and support over 20 RAC 11g R2, 4 nodes Clusters including Physical Data Guard, ASM in MAA configuration
• Provide 2nd & 3rd Level production database administration support in Oracle 10g/11g Enterprise Edition on Sun Solaris and Redhat Linux
• Performance Tuning
• Database Backup/Recovery Management
• DB tasks automation
• Shell Scripting
• Troubleshooting and Tracing
• Ensure production DWH DBA Support of > 25 TB including 10g upgrading to Oracle 11g on Sun SPARC M5000
• Installation, configuration and support of very large OEM 10g/11g to monitor & manage production and non-production Oracle infrastructure
• Automation of OEM Agents mass deployments
• Involved in performance tuning & DB Monitoring including RAC and DB Backup using Oracle RMAN.
• Testing & validation of DB Cloning of production environment and troubleshooting of Oracle DB.
• Ensure production DWH DBA Support of > 25 TB including 10g upgrading to Oracle 11g.
• Oracle Data Guard Management / Deployment in MAA
• Disaster Recovery, BCP
- Involved in database administration of Oracle 9i & 10g Enterprise edition on HP-UX/ Sun Solaris Production environment and troubleshooting of Oracle DB.
- Accountable for performance tuning & DB monitoring.
- Developed concept for implementation of Oracle Grid Control in O2 Production data center to monitor and administer Oracle products
• Involved in database administration of Oracle 8i, 9i & 10g Enterprise edition on HP-UX/ Sun Solaris including Production/Development & Test environment and DB Backup, Oracle RMAN/Omniback/Data Protector Integration and Service Guard.
• Involved in Oracle 8i upgrades to Oracle9i, implementation of Oracle security patches.
• Focused on performance tuning & DB monitoring besides assisting developers to optimize SQL queries response time
• Conducted tests & validation through DB Cloning of production environment, designed & implemented Oracle DB Partitioning for a terabyte instance
• Managed Oracle Standby Database (Data Guard) and troubleshot Oracle DB related issues.
• Involved in systems management of HP-UX / Sun SPARC Solaris, Linux (Red Hat), AIX and administration of Weblogic Server.
• Administered Oracle 8i (8.1.7 Release 3) Enterprise Edition Database on Sun Solaris and Red Hat Linux platform apart from administration of Oracle Application Server Enterprise Edition
• Involved in system management of Sun SPARC Solaris 8, Linux (Red Hat) and ER-Data Modeling using Oracle Designer
• Accountable for SQL, PL/SQL programming and DB application development using Oracle JDeveloper (Java)
o Oracle 7 and Oracle 8 Enterprise Edition Database Administration
o ER-Data Modelling using Oracle Designer
o SQL, PL/SQL and Stored Procedures Programming
o 3GL Embedded SQL Programming using C, COBOL, PL/I, Visual C++ and MFC
o DB Software Development using Oracle Developer (Forms & Reports) and Designer Suite
o Programing C, C++, PL/I
o DB Administration Oracle 7 and 8i under OpenVMS and Windows
o OS Administration OpenVMS and Windows
- Maintenance and development of VAX/VMS Rdb / DECForms based applications
- Programming using SQL, COBOL, DECForms and VAX/VMS Datatrive
- VAX/VMS System / Cluster Management in Germany, Austria and Switzerland
- User Support
- Software-Developer / Programmer for NASA/ESA Project Galileo/Ulysses
- C/C++, FORTRAN and Ada Programming
- VAX/VMS System/Cluster Management
- Statistical data analysis of spacecraft / instrument’s telemetry data
- User Support