Database Architect (Oracle / SQL / .NET)

Trigyn's direct government client has an immediate need for a Database Architect in Albany, NY.

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.

For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.