Walkin @ CGI DBA, Oracle
Oracle Forms
Strong Working Knowledge on SQL and PL/SQL.
SQL: Medium and Complex Query writing.
PL/SQL: Packages, Procedures, Functions, Triggers and other PL/SQL constructs.
Working Knowledge on UNIX systems
Oracle Forms6i and Reports6i
Forms6i: Forms Design (Medium and Complex), Triggers (Form, Block, Item and Record Level), Procedures, Custom Object and PL/SQL libraries.
Reports6i: Reports Design Triggers, Efficient Query writing to build the report query.
Experience: 2-4 years
DBA Openings
DBC Activities
Install Oracle Release in specified user account;
Application of maintenance and security patches to Oracle;
Create Oracle Instances for the application;
Create database files i.e. table spaces and all Oracle application user ids;
Configure cold and hot backups using RMAN and TSM based on project requirements;
Monitor and support the space growth of the database
Retain DBA privilege at all times;
Perform start-up / shutdown of instances and listeners on scheduled or on adhoc basis;
Monitor the health of the database and its various components via Tivoli and other script
Perform routine audits on security.
DBA Activities
Installation of application schemas which include all the application database objects (eg. Store procedures; tables and index)
Import/Export of application database request;
Planning, sizing of application data growth and on-going needs;
Support hourly DB refreshing processes
Performance monitoring and reporting issues to various support teams;
Provide DBA support and consultation to CGI team.
Troubleshoot production database related incidents
Perform database reorganization as required to improve database performance
Co-ordinate application of Oracle alerts with IBM DBC;
Maintain application specific cleanups scripts and scheduling them for routine runs.
Support regular database maintenance activities
Participate in servicing database audit request
Knowledge in RAC, PL SQL & Performance tuning is mandatory.
Experience: 4 - 7 Years
Walk-In Date: 20 Dec 2008 | 10AM-3PM
Venue: CGI, Tower -2, No. 95/1,
Electronic City Phase I(West), Bangalore - 560100.
Contact Person: Pushpalatha K P
Phone : 080 6642 1274