Database Architect(Expert) .Net, Microsoft technologies and Sql/Oracle Database

MVP Consulting

Albany, NY

Apply

JOB DETAILS

SKILLS

Architectural Design, Business Analysis, Business Processes, Corporate Policies, Data Cleaning, Data Entry, Data Management, Data Quality, Data Recovery, Data Sets, Database Architecture, Database Backup, Database Extract Transform and Load (ETL), External Audit, Internal Audit, JSON, Marketing, Microsoft .NET, Model View Controller, Needs Assessment, Object Oriented (OO), Oracle, Oracle Database, Oracle PL-SQL, Process Analysis, Project Management Certification, Project Management Professional (PMP), Regulatory Compliance, Reporting Dashboards, SQL (Structured Query Language), SQL Databases, SQL Server Reporting Services (SSRS), Software Design

LOCATION

Albany, NY

POSTED

16 days ago

HBITS: HBITS-07-14787

Expert, Database Architect

30 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week

--- Project Description ---
This project involves the upgrading and redesigning of the current HMIS
application for OTDA.

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

--- Required Qualifications ---
" 36 months exerience development applications utilizing MVC.Net
" 60 months experience using Oracle and PL/SQL packages including SQL
programming and JSON.
" 36 months experience as a Web GUI designer including accessibility
complaince and using Angular Single Page Applications (SPA), Redux,
Angular versions 9 thru 14.
" 24 months experience development applications relating to government
human service eligility systems.
" 24 months experience using object-oriented principles and concepts to design
complex business objects
" 36 months experience using SQL Reporting Services (SSRS)
" 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.
" Project Management Professional Certification

About the Company

MVP Consulting

Resume Resources

Free Resume Templates Free Resume Builder