oracle dba
Resume:
Raghawendra Balgi 203-***-****
*******@*****.***
SUMMARY:
• Certified and accomplished administrator and architect managing oracle products for more than 5 years.
• Extensive knowledge on database administration for Oracle 8i, 9i and 10g, with experience within very large scale database environment.
• Experienced and effective in visualizing and implementing creative solutions to the most complex requirements.
• Experienced dealing with outsourced technical resources and coordinating global development efforts.
• Excellent communication skills, able to explain complex technical structures in an understandable user friendly format.
• Database Architect and Administrator with expertise in Design, RAC/Grid, Performance tuning, Capacity planning, IT Infrastructure, System Deployment, Security Implementation, Troubleshooting and System Administration on various platforms.
• Successful execution of 5 life-cycle implementation of Oracle10g Real Application Clusters using Oracle10g Clusterware and Oracle10g ASM.
• Expertise in Oracle Data Integrator (ODI) for developing data warehouse ETL and experience in Oracle Data Quality (ODQ).
• Highly proficient in working with Oracle Physical Standby (Dataguard) and Oracle RMAN and Oracle report server.
• Expertise in setting up Oracle Enterprise Manager (OEM) and DATA GUARD.
Technology:
Operating Systems : Windows NT/2000, Mysql, HP –UX 10.x, Unix
Languages : C, Sql, Pl/Sql, UNIX shell Programming
Databases : Oracle 10g RAC,, 8i,
Case Tools : Sql * Loader, OEM, Tkprof, Toad,
ETL : Oracle Data Integrator (ODI) & Operational Data Store.
Tools & Utilities : Export/Import, Sql * loader, Toad, OEM, RMAN
Data Modeling : Erwin, Visio
Professional Work Experience
Chiquita Brands International Inc, Cincinnati, OH
Oracle Database Administrator Oct 07 – Nov 09
The project involved maintaining customer information and ensuring efficient data retrieval as required for core decision making. There were many development projects which were going on, as a result of ever growing demand of new databases in the organization, the development projects were more client based, which included all the client related information as well as investment data, other tasks also included supporting production databases.
Environment: Oracle 10g/11g, SQL*Plus, Export/Import, ASM, RAC, Datawarehouse.
Responsibilities:
• Developed architecture to consolidate multiple agencies' standalone db's into two.
• Created and Defined responsibilities for Oracle roll out to U.S., Canada Australia encompassing 15 Oracle Modules.
• Oracle RAC Planning & implementation including Servers, Storage, Network and Management tiers
• Performed maintenance and Support for RAC Infrastructure components and Database
• Set up regular backup (Hot, Cold), recovery and regular testing of recovery in test environment,
• Improved database performance using ASH and AWR reports
• Setup replacement replication using streams and DataPump.
• Optimizing queries for the developer teams for better application performance.
• Tuning OS, storage and resolving I/O and contention issues.
• Managed database growth and space, performed capacity planning, table partitioning, distribution of tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Administered security and managed profiles, roles, users and their privileges
• Performed Semi-Annual Oracle Financials Access Review
• Migrated data from test instances to production
• Database administration of very large (>8 TB) databases: OLTP, ODS and Data Warehouse.
• Provided rapid turn around on requests and managed change control procedures.
• Closed over 250 Tickets in iSupport for Oracle/Canada/U.S implementation.
American Dynamics ltd, Shelton CT
Oracle Database Administrator Sep 05 – Sep 07
As part of Oracle DBA team I was responsible for the technical delivery and managing Oracle databases and administer the mission critical Oracle production databases for Enterprise
Resource Planning applications on IBM P570 servers in a high availability cluster, which supports 600 users.
Environment: Oracle 9i/10g, SQL, PL/SQL, Oracle Grid Control, Oracle 10g RAC TOAD, Statspack.
Responsibilities:
• Responsible for Oracle10g logical and physical databases design, implementation and maintenance on UNIX and NT.
• Tested and upgraded production databases from oracle 8i to 10g.
• Created and managed physical/logical standby databases using oracle data guard
• Installed oracle Clusterware and oracle Database 10g with oracle Real Application clusters, set up third party cluster file system and created Oracle Real application clusters databases.
• Configured the Distributed Lock Manager (DLM)
• Performed performance tuning for oracle Real Application Clusters (RAC)
• Configured Recovery Manager and archiving.
• Used Real Application Clusters administration Procedures for Enterprise Manager.
• Added and deleted nodes and instances on Unix-Based systems, Linux-Based and Windows-Based systems.
• Set up CRM Application and Oracle HRMS in Production.
• Administered Oracle workflow and changed system profiles on Oracle recommendations.
• Installed new releases of Oracle software, created and configured new instances of database, refreshed or cloned development database with production database
• Installed/configured 10g Grid Control and Agents on the primary node and the secondary nodes in AIX HACMP cluster, used 10g grid control to monitor all nodes in the cluster
• Implemented 10g new features like data pump and transportable tablespace to refresh test and development databases
Paisley Consulting, Minneapolis MN
Oracle DBA Consultant Jul 04 – Sep 05
My responsibility involved design and maintenance of Database environment. This includes development, test and production database support 24x7. I was part on integration and consolidation team. Performed upgrades, patch maintenance and integration with vendor software.
Responsibilities
• Installed and set up environment on Linux and Windows Operating Systems.
• Implemented and troubleshoot advanced replication setup at customer sites.
• Created Database build scripts.
• Tuned I/O, Memory and CPU along with Oracle’s regular performance tuning for optimized results using tools like Explain Plan, Autotrace, Top SQL and TKPROF
• Created applications using HTML DB for enterprise reporting.
• Built database and Data loading using export/import.
• Planned Backup, Recovery Strategy and Disaster Recovery on Production, Development and Test databases.
• Tested backups performing complete recovery on a separate server.
• Created database tables with proper storage managements.
• Transferred data between different locations and different servers.
• Managed storage, sized database objects, monitored file Systems.
• Schema Design and Security Administration for the database.
• Performed resizing of SGA and tablespaces, added data files as when necessary.
• Developed, tested, continuously monitored and updated backup.
• Performed logical and physical backups periodically.
• Designed & implemented indexes.
• Created environments for production, development and testing.
• Troubleshoot database and application errors, logged bugs with vendor support services, and worked with vendor support services as well as IT team member to quickly resolve problems.
Environment: Windows 95, Oracle 10g, exp/imp, RMAN SQL, PL/SQL, SQL*Plus, Svrmgr, Lsnrctl, Developer/2000.
ICICI Bank LTD Jan 04 - Jun 04
Jr. Oracle DBA
Project was to monitor all the backup processes, assist the senior members of the team with checking the specifications and recommending the enhancement changes with writing the triggers and stored procedures.
Responsibility
• Designed and implemented of backup strategy for the production databases using RMAN and Split mirror.
• Maintained database objects including tables, index
• Monitored block corruption in database.
• Monitored and tuned oracle memory structure.
• Tuned production database performance which was instrumental in SQL tuning that improved application response.
Environment: Oracle 10g, SQL*LOADER, RMAN PL/SQL.
Contact this candidate