What are the responsibilities and job description for the Database Architect position at i-Link Solutions?
Job Title: Database Architect - Expert
Task ID: HBITS-07-14787
Position Duration: 30 Months
Client: State of NY
Agency: OTDA
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at nysreqs@ilinksolutions.com
Description
Database Architect is expected to perform the following duties:
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
Task ID: HBITS-07-14787
Position Duration: 30 Months
Client: State of NY
Agency: OTDA
Please call (703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at nysreqs@ilinksolutions.com
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.
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability