Job Description
- 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.
