JOB RESPONSIBILITIES
· 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.
· Good communication skills with management, development teams, and systems administrators.