Oracle database administration and Maintenance
Propose architecture changes, and perform feasibility study and prototyping on new technical solutions.
Optimize the oracle database design with the data modeler.
Sound knowledge in Data pump export/import
SQL query level tuning
Support to developers for SQL, PL/SQL query development
Create database objects (tables, indexes, etc.) in databases, corresponding to the design.
Build, optimize and automate the Informatica ETL process to load data into databases.
Manage user access control in databases.
Write database procedures, functions and triggers as needed.
Assist developers and data analysts with database activities, including but not limited to database query tuning, technical trouble-shooting and consultation. Based on current workload, the candidate might be requested to take over development tasks.
Set up and maintain database development standards, detailed specifications, data mapping & technical documentation.
Establish and maintain sound backup and recovery policies and procedures with the Infrastructure support team.
Support installation, configuration and upgrading of Oracle server software and related products with the Infrastructure support team.
Perform database / application tuning and performance monitoring with the Infrastructure support team.
Monitor database usage and plan capacity growth need.
Salary: INR 4,00,000 - 9,00,000 P.A.
Industry: IT-Software / Software Services
Functional Area: IT Software - Application Programming, Maintenance
Role Category: Admin/Maintenance/Security/Datawarehousing
Employment Type: Permanent Job, Full Time