Database Architect - SQL Server / AWS

Description & Requirements

As a Database Administrator, you will work on the scalability, performance, and security of our mission-critical database infrastructure.

You will be responsible for designing, optimizing, and automating database solutions that power multiple platform, ensuring high availability, zero-downtime migrations, and enterprise-grade reliability.

The Database Administrator will manage all activities related to data planning, development, and policy implementation.

This includes establishing and enforcing policies and procedures for data management, security, maintenance, and utilization.

This role is ideal for an expert in MS SQL Server who has experience with auto-scaling clusters, transaction logging, disaster recovery, and performance tuning.

Knowledge of Snowflake and AWS RDS is beneficial.

You will collaborate with DevOps, SRE, and Development teams to implement best practices and drive innovation in database architecture and operations.

Per VES contract requirements, staff working on the VES project must be a US Citizen or US Legal Resident (green card holders

Essential Duties and Responsibilities:
- Establish and maintain enterprise data warehouse (EDW) architecture environments and data ingestion/integration development frameworks, including architecting elegant technical solutions that meet the business requirements while reducing operating expenses.
- Oversee architecture changes for all data ingestion solutions and provide technical advice on complex data mappings and transformations, including production support guidance, researching, and responding to security vulnerability findings, and working with multiple vendors and teams to leverage existing architecture components.
- Facilitate the creation of architectures that consider how the current system interacts with other internal and external systems and environments and ensure that the new system behaves and performs correctly, including: prioritizing backlog projects and coordinating with system and network administration personnel on maintenance, upgrades, changes, and performance needs.
- Mentor and transition architectural knowledge to team members and provide leadership and work guidance to less experienced personnel, including conducting quality assurance activities such as peer reviews.

Provide adequate and timely acceptance criteria for new or enhanced data ingestion solutions and explain costs and efficiencies of backlog items to management and other stakeholders.
- Develop architectures that support the business requirements and provide assistance to the team in troubleshooting performance and system errors, including providing data analysis support, discovering and fixing data issues, and communicating with various stakeholders.

- Establish and maintain enterprise data warehouse (EDW) architecture environments and data ingestion/integration development frameworks, including architecting elegant technical solutions that meet the business requireme...