Start searching
Back to Jobs
Recently postedOther

Database Architect

Universal Consulting Partners Inc.Wyoming, MN🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationWyoming, MN, United States
OraclePL/SQLSQLT-SQLAWSETLEncryptionComplianceRoot Cause AnalysisAzurePostgreSQLSQL Server

Job description

Database Architect

Job Overview:

Design, build, and optimize enterprise database systems for a State Agency. Lead database architecture, data modeling, performance tuning, and migration strategies while ensuring data security, integrity, and compliance with State standards.

Key Responsibilities:

  • Design and architect enterprise database solutions - SQL Server, Oracle, PostgreSQL
  • Develop logical & physical data models, ER diagrams, database schemas
  • Lead performance tuning, query optimization, indexing, partitioning
  • Define database standards, backup/recovery, high-availability strategies
  • Plan and execute data migration, integration, and ETL processes
  • Ensure data security, access control, encryption, and compliance
  • Support production DB issues, troubleshooting, root cause analysis

Required Skills (Must Have):

  • 8+ Years as Database Architect / Senior DBA
  • Expert in SQL Server, Oracle, PostgreSQL (at least 2)
  • Expert in Data Modeling, Normalization, Dimensional Modeling
  • Strong in T-SQL, PL/SQL, Stored Procedures, Functions, Triggers
  • Experience with HA, Replication, Clustering, Always On, RAC
  • Experience with ETL, SSIS, Data Migration, Data Warehousing
  • Knowledge of Cloud Databases - AWS RDS, Azure SQL

Preferred:

  • State / Government project experience
  • Certifications: MCDBA, Oracle OCP, Azure Data Engineer

Similar jobs

Apply