Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities.
Support the development of long and short term requirements for database administration and design.
Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts.
Translate a set of requirements and data into a usable database schema.
Create and update data models using PowerDesigner
Assist in developing database structures that fit into the overall architecture of the system under development.
Lead development of database structures that fit into the overall architecture of the system under development.
Develop requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems).
Develop a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
Direct the overall database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
Direct fulfillment of requirements from a project’s inception to it conclusion.
Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, macros, updates to existing queries.
Direct the development of complex systems using queries, tables, Open -Database Connectivity and database storage and retrieval
Required Skills
Oracle
Linux
SQL
Scripting
1 week of on-call support every 3-5 weeks required after ramp-up
Desired Skills
Oracle Data Guard
Jira
Confluence
Relational database design tools such as PowerDesigner