Oracle Administration:
- To handle successful and streamlined administration IN ORDER TO avoid dead locks, keep servers up and monitor application for smooth running.
Oracle Scripting:
- To plan and process scripts, PL/SQL procedures, functions, triggers and jobs etc. in order to generate automated inputs and databases
Oracle Maintenance:
- To ensure local environment integrity in order to enable smooth operations for development, QC, staging, production and showcasing
Data Migration:
- To align and format the data in accordance with the ETL protocol (Extract Transfer Load) and verify in accordance with the system in order to integrate data into application
Documentation & Reports:
- To prepare the release notes documents for product and project, In order to provide information to QC Team or Client.
- Use BIRT Application, in order to manage and update reports.
Database Conversion:
- To convert database from one brand to another like Oracle to Postgres IN ORDER TO achieve application shifting to another database from existing.
Database Issue Resolution:
- To Fix database issues / bugs identified by QC or the client pre or post production IN ORDER TO incorporate changes or start a separate DB script
Database Release Management:
- Perform Database Sync activities IN ORDER TO incorporate new features / changes, maintain scripts, reflect changes in development and forward to QC for staging and production in parallel.
Intradepartmental Coordination:
- To coordinate with other technical departments within P&SD in order to produce the best products as per client requirements