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.
US
