Database Architect
Universal E-business Solutions, LLC
Wyoming, MN, United States
6 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦