Sr. Oracle Certified DBA available
(San Jose)
Reply to:
rlohia@yahoo.com
Posting Date: 2006-02-2, 3:14 PM MST
Posting id:
1661
Raghu
Global Soft Solutions, Inc
Contact Raj: 408-569-5889
Professional Summary
Ø Five years of extensive experience as production, and development DBA of Oracle 10g/9i/8i.
Ø Extensive experience in administering, installing, managing, tuning and troubleshooting Oracle large database systems on Solaris, Linux, IBM/AIX and Windows
Ø Experienced in SQL*Loader, Export/Import, SQL*Net, SVRMGR, tuning using explain plan, SQL Trace, utlbstat, script, Stat pack, SGA tuning
Ø Good understanding of Oracle Data Dictionary and tunable parameter in init.ora
Ø Experience in backup and recovery, Replication, RAC
Ø Hands on experience in resource management like data files, online redo log file, control files.
Ø Experience with Hot/Cold database backup, recovery, disaster recovery procedures, and DadaGuard
Ø Experience using TOAD, and Enterprise Manager.
Ø Experience in UNIX shell scripts and performing pre and post installation task of Oracle database setup in the UNIX environment.
Ø Experience in working with RMAN backup and recovery.
Ø Experienced in working with very large databases from 200GB to 1 Terabytes on 24x7.
Ø Experienced in configuring Oracle databases on Multi Threaded Servers (Shared Servers)
Ø Enforcing data Integrity using integrity constraints and database triggers as per data model.
Ø Quick learner with an ability to rapidly achieve organizational integration assimilates job requirements and employ new methods and technologies
Ø At ease in high stress and fast-paced environments requiring the ability to effectively handle multiple responsibilities simultaneously
Qualifications:
· Bachelor of Engineering in Electronics and Communication from Karnatak University, Dharwad in year 2000
Certifications:
Oracle certified professional in oracle 9i.
Technical Skills:
Operating systems Sun Solaris 8.0, UNIX ,Windows NT
RDBMS Oracle-Server 9i/8i.
Languages PL/ SQL, C, C++, Java.
DBA Tools OEM, SQL TOAD, Net8, SQL LOADER, Export/import
Explain plan, TKPROF, RMAN, Oracle Designer9i,
Erwin, Data Guard, Standby database, RMAN
PROJECT DETAILS:
RR Donnelley, Lancaster, PA Feb 2005 – Till Date
Role: Oracle Database Administrator
Platform: HP/UX, Oracle 8i/9i
RR Donnelley is a full service print facility with typesetting, pre-press, print and bind capabilities. In addition RRD has a fulfillment and demand-printing centers in various in locations.
Responsibilities
· Plays critical role as core Production DBA team for providing DB support.
· Coordinating activities between the RRD Users and Client in understanding the requirements for fine-tuning the DB.
· Providing 24X7 supports for production databases.
· Design and implementation of backup and recovery processes
· Automation of backup and recovery, tasks in all environments – development, test and production
· Maintenance of advance queuing.
· Providing maintenance and support for advanced replication.
· Identifying poorly performing SQL and optimizing the same
· Coordinating activities between the project team and database administration
· Participate in establishing and evolving database standards within the company
Reliance Infocomm, Mumbai Nov 2003 – Dec 2004
Role: Oracle Database Administrator
Platform: Sun Fire F6800, V880, Sun OS 8, Oracle 8i/9i
Major job Responsibilities:
· Installation and Configuration of Oracle Databases on windows and UNIX platforms
· Design and implementation of backup and recovery processes.
· Automation of backup and recovery, tasks in all environments – development, test and production.
· Identifying resource bottlenecks in the production system and carrying out performance tuning exercises.
· Migrating data from different and disparate data sources using technologies like SQL * Loader
· Coordinating activities between the project team and database administration.
· Participate in establishing and evolving database standards within the company
· Providing 24X7 support for production databases and working experience on on-call
· Created Database objects like Tables, Partition tables, Views, Indexes, Clusters, Synonyms
· Established the connectivity between Servers and Clients Using Network utilities
· Involved in tablespace sizing and Rollback Segments
· Responsible for database user administration and setting up the security in database.
· Performed production system tuning to improve the response time for on-line transactions and through put for large queries
· SQL statement tuning using the optimization rules, suggesting the indexes using various OS tools and Oracle tools (TKPROF, EXPLAIN)
· Involved in the Migration & upgradation of Oracle versions and applying patches.
· Cloning of databases, configuring standby databases.
· Setting up and maintanance of Advance Queuing .
· Configuration and maintanance of Advance Replication.
· Data model designing and reengineering of existing databases using Designer
Stock Holding Corporation of India Limited Dec 2002-Oct2003
Role: Database Administrator
Platform: Oracle 8i, Solaris8
SHCIL is an premier custodian and the largest depository participant of the country. It provides the depository related services to its retail segments like corporates, firms, brokers etc. SHCIL offers the custodial and related services to financial institutions, mutual funds, investment institutions, insurance companies and banks. My role mainly involved in setting the oracle database environment like installation of oracle, database creation, taking backups and re-oraganizing of data using oracle tools like export and import utilities and providing the 24x7 availability and without compromising the performance.
Serevin Softwares pvt Ltd Feb 2002-Nov 2002
Role: Database Administrator
Platform: Oracle 8i, Solaris8
Employment Self Serivces
Employment Self Services (ESS) applications are implemented to automate the paper forms and are aligned with the processes and policies laid by Administration, finance and Human Resource. The different applications available to employees are advance, expenses, health insurance scheme, travel, provident fund, loans, leaves, HRA, reimbursement etc. My role mainly involved in maintaining the database of the employees, to serve the requests of the employees, minimized downtime by properly executed backup and recovery plans in case of any failures and availability and performance.
Thomson Travel Group Sep 2001-Jan 2002
Role: Database Administrator
Platform: Oracle 8i, Solaris8
Thomson Travel Group is one of Europe's leading online destination for holidays. It has also won a lot of media attention and awards. Customers can choose and buy from thousands of packaged holidays from top tour operators. With global coverage, powerful search functionality and a massive 3D-image catalog, it will provide a unique experience in selecting and buying a holiday. The site is supported by a large Oracle 8i database with tens of gigabytes of data and requirement to support hundreds of concurrent users.
nPower Apr 2001-Aug 2001
Role: Database Administrator
Platform: Oracle 8i, Solaris8
This is a home services portal aimed at providing the domestic consumer with an on-line resource to allow complete management of daily household requirements. The site is focused around providing a useful source of information to enable users to decide and manage the different household requirements they may have. Initially this has focused on electricity and gas supply but will grow to cover other utilities, local services and other areas such as local news/entertainment.
|