HBITS: HBITS-08-14596
Expert, Database Architect
30 month contract
Interview: Virtual Interview
Work model: 50% telecommuting, 50% Office per week
--- Project Description ---
Database Architect is expected to design data infrastructure to extract and
organize Department of Financial Services' enterprise data systems,
bridges the gap between business needs and complex technology, ensures
Department of Financial Services' data is secure, highly available, scalable,
and compliant with New York State policies and regulations.
--- Day-to-Day Tasks ---
1. Monitor DFS Snowflake credit usage, adjust resource monitors, and tune
virtual warehouses
2. Manage Snowflake users and roles, enforce security policies, audit
Snowflake access
3. Write and tune SQL queries, build Snowflake ELT pipelines, manage
compute and cost, and configure security and governance
4. Build and update Informatica mappings, and configure workflows.
5. Perform unit testing and validate data integrity
6. Troubleshoot failures, tune performance
7. Documentation ETL process, security policies, system architecture, user
guides and etc.
--- Required Qualifications ---
84 Months Experience in Snowflake data warehouse development and
administration.
84 Months Experience in Snowflake performance tuning and improvement.
84 Months Experience in Informatica pipeline development and data
transformation.
84 Months Experience in Informatica performance tuning and improvement.
84 Months Experience in RDBMS (Relational Database Management System)
and SQL Query development.
48 Months Experience in solution architecture & modeling.
84 Months Experience in database and platform security & governance.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10109907
- Position Id: 7421fe06f11f97faa18d1197a4363d6f
- Posted 6 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.
