Database Architect

Description

Database Architect is expected to perform the following duties:

• Assist in the day-to-day collection, validation, and entry of data from various sources into centralized databases.
• Perform routine data cleaning and standardization tasks to ensure accuracy, completeness, and consistency.
• Help enforce data governance policies and naming conventions under the guidance of senior staff.
• Conduct basic data quality checks, identify anomalies or duplicates, and report issues to senior team members.
• Assist in documenting data sources, definitions, and lineage (data dictionaries, metadata).
• Execute complex queries (using SQL or similar) to extract data for reports or analysis as requested.
• Assist in the monitoring of data pipelines and ETL (Extract, Transform, Load) processes, flagging any failures.
• Perform regular database backups and support restoration tests.
• Help with user access management, granting basic permissions following approved requests.
• Support the migration and archiving of data according to retention policies.
• Generate and distribute standard reports and dashboards using tools.
• Support other teams (e.g., Analytics, Marketing, Operations) by providing clean, reliable datasets for their projects.
• Participate in meetings to understand data needs and communicate updates on data status.
• Assist in preparing data for internal and external audits.
• Maintain detailed logs of data management activities and issues.
• Stay updated on company data policies, compliance requirements, and best practices.
• Proactively learn new data management tools and technologies as required.
• Complete all assigned tasks with a high degree of accuracy and attention to detail.

Mandatory Qualification

• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• A Bachelor's Degree
• 84 months experience designing application architecture, developing & deploying n-tier asp.Net Web apps using vb.net web services and Windows Communication Foundation.
• 84 months experience analyzing business processes and workflows; and working with non-technical staff to develop system specifications and resolve issues.
• 60 months experience using Oracle and PL/SQL packages including SQL programming and JSON.
• 36 months experience as a Web GUI designer including accessibility compliance and using Angular Single Page Applications (SPA), Redux, Angular versions 9 thru 14.
• 24 months experience development applications relating to government human service eligibility systems.
• 24 months experience using object-oriented principles and concepts to design complex business objects
• 36 months experience using SQL Reporting Services (SSRS)
• 36 months experience development applications utilizing MVC .Net
• Project Management Professional Certification.