Database Architect - SQL Server

Aureum Technologies; United States; Remote; USD 140,000 - 210,000; Full time

Job summary

Aureum Technologies is seeking a senior database architect to design, optimize, and migrate cloud-based database solutions for modern applications. The role blends hands-on engineering with architectural leadership across SQL and NoSQL, supporting enterprise architecture and API-centric cloud transformations in a fully remote setting.

You will lead migrations, optimize performance, implement security measures, and mentor engineers, collaborating with stakeholders to align data strategies with

Qualifications

• 7+ years of database engineering experience.
• Proficient with SQL Server and PostgreSQL.
• Strong knowledge of normalization, indexing, stored procedures, and query optimization.
• Cloud experience on AWS/Azure/Google Cloud.
• Experience with Docker.
• Proven database migration leadership.
• Effective communicator with stakeholders.

Responsibilities

• Architect and design database solutions for modern applications.
• Lead database migration projects.
• Monitor and optimize performance across SQL/NoSQL environments.
• Implement database security and ensure regulatory compliance.
• Refactor stored procedures and data models for cross-compatibility and performance.
• Mentor team on SQL/NoSQL trade-offs.

Skills

SQL Server

PostgreSQL

Cloud platforms

Docker

Data modeling

Migration leadership

Stakeholder comms

Job description

Role overview

A senior database architect role focused on designing, optimizing, and migrating database solutions for modern cloud-based applications. The position combines hands-on database engineering with architectural leadership across both SQL and NoSQL environments. The work supports enterprise architecture, API-centric applications, and cloud transformation efforts in a fully remote setting.

Responsibilities

• Architect and design database solutions that meet the demands of modern applications and data processing
• Lead database migration projects, ensuring seamless transitions between database systems
• Continuously monitor and optimize performance across both SQL and NoSQL environments
• Implement database security measures and ensure compliance with data privacy regulations
• Refactor stored procedures, scripts, and data models for cross-compatibility and performance
• Mentor team members on best practices and provide expertise on SQL and NoSQL trade-offs

Requirements

• 7+ years of experience in database engineering
• Extensive proficiency with both SQL Server and PostgreSQL
• In-depth knowledge of normalization, indexing, stored procedures, and query optimization
• Experience with cloud platforms such as AWS, Azure, or Google Cloud
• Familiarity with containerization tools like Docker
• Proven experience leading large-scale database migrations, transitions, and refactoring projects
• Strong communication skills for working with both technical and non-technical stakeholders

Nice to have

• Hands-on experience with DynamoDB or MongoDB
• Full-stack development exposure with emphasis on backend database interactions
• Background working in an Agile environment

Benefits and work setup

Fully remote role with flexible working hours. The environment offers collaboration with experienced professionals, training and mentorship opportunities for professional growth, a competitive salary, and the chance to influence product design and user experience.