Expert Database Architect

Hybrid in Albany, NY, US • Posted 10 hours ago • Updated 10 hours ago
Full Time
No Travel Required
Hybrid
$75 - $80/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Warehouse
  • Database Administration
  • Bridging
  • ELT
  • Information Security Governance
  • SQL
  • Snow Flake Schema
  • Systems Architecture
  • RDBMS
  • Distributed File System

Summary

Expert Database Architect

Introduction:

As an Expert Database Architect, you will be responsible for designing data infrastructure to extract and organize enterprise data systems. You will bridge the gap between business needs and complex technology, ensuring that the data is secure, highly available, scalable, and compliant with New York State policies and regulations.

Responsibilities:

  • Monitor DFS Snowflake credit usage, adjust resource monitors, and tune virtual warehouses
  • Manage Snowflake users and roles, enforce security policies, and audit Snowflake access
  • Write and tune SQL queries, build Snowflake ELT pipelines, manage compute and cost, and configure security and governance
  • Build and update Informatica mappings and configure workflows
  • Perform unit testing and validate data integrity
  • Troubleshoot failures and tune performance
  • Document ETL process, security policies, system architecture, user guides, etc.

Requirements:

Primary 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 and SQL Query development
  • 48 Months Experience in solution architecture & modeling
  • 84 Months Experience in database and platform security & governance
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: 91174515
  • Position Id: 9063505
  • Posted 10 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Albany, New York

Today

Full-time

Albany, New York

Today

Contract, Third Party

DOE

Albany, New York

2d ago

Easy Apply

Third Party, Contract

Depends on Experience

Hybrid in Albany, New York

2d ago

Easy Apply

Contract, Third Party

66 - 68

Search all similar jobs