Maintain and support Non-Prod databases (Non-Prod) for the OFSAA , Informatica development and ETL processes.
Propose architecture changes, and perform feasibility study and prototyping on new technical solutions.
Optimize the database design with the data modeler. Create database objects (tables, indexes, etc.) at Non-Prod databases, corresponding to the design.
Build, optimize and automate the OFSAA and Informatica ETL process to load data into Non-Prod databases.
Manage user access control at Non-Prod 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.
Design test strategy, create test cases and perform testing.
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.
Prepare the migration document for promoting database components to the production databases.
Monitor database usage and plan capacity growth need.
Identify potential problems and proactively suggest changes and solutions.