Database Architect (.Net, Microsoft, Oracle)

MVP Consulting

Albany, NY

Apply

JOB DETAILS

SKILLS

Business Operations, Business Support, Consulting, Corporate Policies, Data Management, Data Quality, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Database Triggers, Homeless Services, Information Technology & Information Systems, Microsoft .NET, Needs Assessment, Operational Audit, Operational Support, Oracle, Oracle Database, People Management, Regulatory Compliance, Requirements Management, Resolve Customer Issues, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Software Engineering, Strategic Planning, Technical Support

LOCATION

Albany, NY

POSTED

3 days ago

HBITS: HBITS-07-14842

NYS OTDA - 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 combining of various aging systems
into one comprehensive Homeless Information Management System
(HMIS). In this role, they will be responsible for designing, implementing,
maintaining, and securing our organization's databases to ensure optimal
performance, reliability, and data integrity. They will collaborate closely with
developers, analysts, and IT teams to support business operations and
strategic initiatives. Generate and distribute standard & complex reports and
dashboards. Maintain detailed logs of data management activities and
issues.

--- Day-to-Day Tasks ---
1. Participate in meetings to understand data needs and communicate
updates on data status.
2. Maintain detailed logs of data management activities and issues.
3. Stay updated on company data policies, compliance requirements, and
best practices.
4. Learn new data management tools and technologies as required.
5. Complete all assigned tasks.
6. Assist in documenting data sources, definitions, and lineage (data
dictionaries, metadata).
7. Execute complex queries (using SQL or similar) to extract data for reports
or analysis as requested.
8. Ensures that project goals/objectives are met.

Database Architect
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.
Expert 84+ months: 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.

--- Required Qualifications ---
• 36 months experience with participating in meetings to understand data needs
and communicate updates on data status. Maintaining detailed logs of data
management activities and issues.
• 60 months experience with SSIS design and development
• 84 months experience in performing Extract, Transform, and Load (ETL)
techniques and flagging any failures.
• 60 months experience in in SQL programming including writing complex
queries utilizing JSON in Oracle.
• 60 months experience using SQL Reporting Services (SSRS)
• 84 months experience in designing logical and physical database models.
• 84 months experience designing oracle databases including triggers and
packages

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

Database Architect (.Net, Microsoft, Oracle)

MVP Consulting

Albany, NY

About the Company

MVP Consulting

Similar Job Searches