Rajee Kallur

- all the DBA tasks from installation to recovery to performance tuning (Production and development databases);
- Managing multi-node Oracle 11g RAC database for core banking and ATM switch database
- Designed and implemented BCP for Oracle databases supporting on-line banking and ATM switches
- all the IT infrastructure (Unix/Linux Servers, Web hosting and online banking, Middleware, Operating systems, Data Bases and Applications) uptime as per SLA;
- implementing 24x7 support system for core banking system and ATM switch on Oracle RAC on 11G version;
- Planning and implementing technical upgrades of banking applications and interfaces
- providing and implementing performance related recommendations and tuning;
- closing all audit observations;
- developing a robust end to end architecture of the IT systems;
- user management;
- IT Risk Management as per ISO 27000 standards
- 24x7 monitoring of all production databases with Oracle Enterprise Manager
- team mentoring and coaching;
 Brings to the table over three (3) decades of system based performance management from North America;
-Parameterised, tested & implemented the banking system. Established roadmap for Data Base migration framework;
-Developed a robust Governance model and review system for high up keep of IT systems and infrastructure as per the established SLA with Lines of Business;
-Implemented security policies as per Base Security standards of the bank;
-Developed and implemented IT Back-up and Recovery Policy, Day to day Data base Administration, IT Operational Risk management, regulatory reporting and compliance, Fraud Control & Authorization framework;
-Developed Scorecards / Dashboards for efficiency management and monitoring;
-Delivered Oracle Data base and RAC upgrade project;
- Maintained work relationships with vendors;
- Developed successfully various IT management automation systems for online banking environment;
- Conducted the first audit for PCIDSS compliance of all payment systems transactions, facilitated the subsequent PCI DSS audits;
-Participated in internal and external audits;
- Developed in-house reports and procedures;
- Thorough knowledge of architecture and technology of banking systems;
-Knowledge of ATM Switch system (Powercard by Hitech Payment Systems);
-Extensive knowledge of brokerage system implemented for Muscat Capital, Riyadh by TCS;
-Plan, coordinate, implement and maintained IBM SIEM Q-Radar;
-Handled HP 3 PAR disk management tools and HP backup tool, data protector.

Worked as Sr. Oracle DBA for database supporting JDE / PeopleSoft for Lafarge, which is a French based largest North American Construction Company.
• Responsible for production / development support on Oracle 9i Database, RAC installed.
• Database technical owner of Oracle BI dataware database which was accessed through IBM DataStage.
• Worked through the implementation and migration of distributed database into single instance on 10G platform.
• Consolidated the back ups into HP OpenView Data protector.
• Interacting with Oracle Support.
• Performed duplicate, backup and recovery using RMAN with data protector and Legato systems.
• Reorganize and refresh the development instances using export / import utilities.
Used Oracle tracing at database and application level and explain plan to identify the problematic queries.
• Optimized current platform technologies and to investigate next Oracle database technology.
• Performed complex system analysis, research alternative approaches and predict scalability and response time.

Plan, co-ordinate and execute load and stress testing to ensure scalability and performance requirements / standards are met.
Identify problems, perform root cause analysis and recommend solution to resolve performance, scalability and availability issues in Oracle Apps Production environment and all interfaces.
Optimize current platform technologies and to investigate next Oracle database technology.
Perform complex system analysis, research alternative approaches, and predict scalability and response time on apps instances.

Developed detailed technical work plan to ensure successful development and implementation of the Fin ERP program on time.

Coordination and identification of technical architecture required to support the technical solution.
Work closely with Program Managers and technical staff
Coordinating necessary resources for the implementation
Install, upgrade, maintenance of Oracle Applications Rel 11i.
Patching of Oracle Applications
Training team members on concepts and technology of Oracle Applications Rel 11i
Coordinating with application team for any database related activities.
Interacting with Oracle Support Canada for any issues and fixes.
Creating routine jobs and scheduling through ESP
Refreshing development environments with production data.
Trouble shooting any issues
Oracle ERP modules such as GL, AP, Internet Expenses, Internet Procurement, Projects & Purchasing.
Oracle CRM modules such as sales compensation, Contracts.
Advanced Planning such as Inventory, OM, ASCP, iStore, iSupport
Oracle BIS modules such as EDW with Express, Financial Analyzer and Oracle Portals.
On - call and on - site support for all oracle related databases.
Design and Support of Production and Development Databases needed for RETEK - Retail merchandising System application Rel 7.0 of 3TB.
planning regular backups and disaster recoveries.
Exporting / Importing data between production and test environments
Monitoring using BMC tools

Physical data design for Oracle Financials for group companies.

Installation of RDBMS and Oracle Financials.

Designing and implementing all tuning parameters.

designing of all database triggers.

Development of stored procedures as required for proper maintenance of the database and information flow among them.

Resume tracking system for Imtac Inc Canada Office, using Power Builder 6.0 & Oracle.8.0.

Imtac Inc. Web site designing, utilizing Microsoft FrontPage 98 and IIS.

Performed as an ORACLE database administrator for Bank Muscat, Oman’s largest bank, comprising 40 branches. Worked on Galaxy Cobol system on NCR 4100 AT&T UNIX Platform, utilizing a 20 GB database, developed the existing banking software.

Activities included:

Database administration including database & system parameters designing, user access and user security, performance tuning, automating back up and recovery procedures.
Re-designing the existing Cobol file structures in norms with RDBMS concepts and to oracle database.
Analysis, Planning, System designing for converting these Cobol files to Oracle database.
Phase-wise implementation of this conversion as well as front-end screen designs for users, such as customer inquiry, foreign exchange inquiry, account inquiry, GL inquiry screens.
Adhoc reporting based on the user requirements.
Implementation of Acu Cobol interfaces to Oracle Database.
Revamping of existing web pages and forms based on line inquiry for Internet banking.
Converted the existing Cobol programs to year 2000 compliant.
Worked, on part-time basis to assist in implementation of Oracle Financials. Modules include GL and Accounts payables, on HP UNIX 10.3 with Oracle Financials version 10.7

Provide database administration for ORACLE, as part of the Network Operations team. Responsible for managing 20+ in-house servers, utilizing multiple oracle applications. Specifics included:

Complete Responsibility Of Implementing ORACLE Applications Covering Oracle Financials, HRMS, Inventory, Library Management, Mail Management Systems within ORACLE India.
Total Database Administration and System Administration of MIS Servers in the data center.
Governing User community by imposing limits on what user can access system maintenance.
System performance - Balancing the systems processing workload between on-line data entry and background processing.
Customizing the overall system and application. Administering the Installed system.
Administering modification as the number of the application users, workload, quantity, type of peripheral equipment, S/W tools change.
Database Administration of Oracle APPS server.
Software installation (Client / Server) and maintenance.
Database tuning for optimal database use.
Database design, data accuracy, completeness, security, availability and recovery.

Machines worked on HP 9000, SUN ULTRA SPARC, NT, windows 95 Systems.
Designing of home pages on Oracle Web server using html.
In-house implementation of Oracle Applications - modules GL, Accounts payable.
Defining flex field structures for GL chart of accounts.
Adhoc reports and incorporating the same in the applications.

Setting up complete Computer Lab for Indian School in Al Wadi Al Kabir, Oman. Developed framing syllabus as per CBSE, as well as training students, and Faculty members on awareness and specifics developed " Student Database Management System" on Oracle Ver 6.0.

Also Worked for Al Sadd Al Ali Trading & Contracting Co., in Ruwi, Oman on part time basis. Conducted systems analysis and design for Commercial applications like financial accounting, Personnel & payroll.

Oracle database administration.

System Design, Development of Manufacturer's Resource Planning, consisting of Production, Planning, Purchase, Sales and Accountancy through which MIS was implemented.

Developed MRP reports required to brief Management with day to day operations from various divisions and disseminating the Management's decisions back to the various functional heads.

Training the Corporate Managers at Head Office and Regional Offices.

Setting up a corporate training center.

Environment: HP 9000 - 807 RISC based UNIX machine with TCP/IP, NFS client server architecture. Clients being 486 DX personal computers. Forms and Reports on Oracle 6.0