Exatech Inc is a staffing and recruiting company.
The Database Architect will be responsible for creating and tuning database architectures for a Data Warehousing application. This person must be willing to work in a fast paced environment. The successful candidate will analyze current and future system requirements and provide advanced database services to support multiple project implementations.
• Determines database structural requirements by analyzing operations, applications, and programming; review objectives with stakeholders; evaluating current systems;
• Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-ups, and recovery specifications.
• Identify study and understand requirements and translate them into Low level design in Design phase.
• Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
• Create, test and implement PL/SQL triggers, stored procedures, functions, and packages.
• Maintains database performance by identifying and resolving production and application development problems; evaluating, integrating, and installing new releases; completing maintenance.
• Analyze data requirements and create the designs needed to implement solutions; develop technical requirements definition, mapping and gap analysis following development standards
• Create High Level and detailed design documents in the Design phase.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Design and implement disaster recovery process to ensure production data is recoverable
• Lead capacity and performance review of the environment, identify optimization opportunities and recommend future growth needs
• Identify areas of process improvement and implement automation where applicable
• Updates job knowledge by participating in educational opportunities; reading professional publications;
• Identify architectural issues in design and propose alternative solutions