Database Architect

Universal E-business Solutions, LLC
Wyoming, MN, United States
6 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Cloud Database Cluster Analysis Databases Extract Transform Load (ETL) Data Migration Data Security Data Warehousing Dimensional Modeling PostgreSQL Microsoft SQL Server SQL Azure Oracle (Applications)
+10 more
Performance Tuning Query Optimization SQL Stored Procedures PL-SQL SQL Server Integration Services Transact-SQL Azure Data Factory Indexer Amazon Relational Database Service Physical Data Models

Job description

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., * 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

Requirements

  • 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…