Creation of functional and technical specifications for database development analyze requirements and help project team in solution technical design implementation and support.
Work with the project team in completing all relevant and required documentation in alignment with OPS standards.
Experience and Skill Set Requirements
Deliverables:
Creation of technical specifications for Azure SQL and Oracle database systems development
Design implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
Undertake special assignments/subprojects as assigned
Conduct assess evaluate and document stakeholder interests and business needs
Create and validate business scenarios and use cases
Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture as well as traceability to solution logical and physical architectures
Create review provide input and support of Enterprise Architecture artifacts for all checkpoints as required
Create system and user interface design and modifications (data & screen) as required
Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
Ensure alignment and adherence to Ministry of Government Services processes and standards
Support the testing team during system and UAT testing
Participate in Knowledge transfer
Requirements
Skills and Knowledge:
Experience administering database management systems (i.e. ORACLE Exadata Microsoft SQL Server Azure etc.) for business intelligence and analytics applications
Create test and implement safeguards to maintain data integrity and protect against unauthorized access
Assist with SQL optimization and code reviews to ensure queries are efficient
Mandatory Requirements:
At least 10 years of experience
Experience in database replication / RealTime data delivery with either MSSQL or Oracle products (5 years)
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.