Database Architect (In-Person Interview)

About the role

This Database Architect position supports multiple software applications for the DOH Office of Professional Medical Conduct, functioning as a database developer and architect.

Responsibilities

• Analysis and design of database objects and data collection systems, including transforming legislative requirements into system functionality.
• Data modelling.
• Software development tasks including Oracle PL/SQL and MS SQL Server coding, testing, and implementation.
• Troubleshooting application issues to find solutions.
• Preparation of technical and user documentation.

Requirements

• 15+ years of experience determining database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems; and providing database support by coding utilities, responding to user questions, and resolving problems.
• 84 months of experience interpreting physical database models and working with relational database concepts such as indexes, primary and foreign keys, and constraints using both Oracle and Microsoft SQL Server.
• 84 months of experience developing using Oracle PL/SQL, including database packages, procedures, functions, and triggers.
• 84 months of experience working with Oracle version 11g or later.
• 84 months of experience using Oracle programming tools (SQL*Plus, SQL*Loader, or other Oracle database programming tools).
• 60 months of experience developing using Microsoft Transact-SQL (T-SQL).
• 60 months of experience designing relational databases.
• 24 months of experience integrating multiple database schemas.
• 18 months of experience using Git.

This is a 100% onsite role.