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 requirements while reducing operating expenses.- 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. -Continuously optimize query performance, indexing strategies, and workload distribution. -Implement high-availability (HA/DR) solutions, including clustering, replication, and failover strategies.- -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. - Sets and monitors standards. - Advises management on database concepts and functional capabilities. - Performs backup and recovery on Database Management Systems, configures database parameters, and prototypes designs against logical data models. - Defines data repository requirements, data dictionaries, and warehousing requirements. - Develops and designs database strategies and system monitoring. - Improves database performance and capacity, and plans for future expansion requirements. - Installs and upgrades the database server and application tools. - Modifies the database structure, as necessary, from information given by application developers. - Controls and monitors user access to the database. - May also plan, coordinate and implement security measures to safeguard the database.
Minimum Requirements
- Bachelor's degree in relevant field of study and 7+ years of relevant professional experience required, or equivalent combination of education and experience.

5+ years' experience as a Database Administration, with expert-level knowledge of MS SQL Server in a medium to large scale solutions to include experience with tasks such as data migration, data modeling, automation, modernization, data replication, backup and recovery, and general DBA tasks

3+ years of experience in database administration with knowledge of AWS infrastructures

3+ years of hands-on experience with AWS services and both relational and non-relational databases.

Bachelor's degree required.

Proven experience in auto-scaling, clustering (Always On Availability Groups), and high-performance transactional databases.

Familiarity with cloud-managed database services (Azure SQL, Amazon RDS, Snowflake).

Strong understanding of database design, implementation, and maintenance principles, with a focus on automation and optimization.

#techjobs

Proficiency in scripting languages such as TSQL, PowerShell or Bash for automation tasks.  

Competencies:

Strong oral and written communication skills

Advanced computer skills

Excellent problem-solving and analytical thinking abilities

High attention to detail

#Techjobs

EEO Statement Active military service members, their spouses, and veteran candidates often embody the core competencies Maximus deems essential, and bring a resiliency and dependability that greatly enhances our workforce. We recognize your unique skills and experiences, and want to provide you with a career path that allows you to continue making a difference for our country. We’re proud of our connections to organizations dedicated to serving veterans and their families. If you are transitioning from military to civilian life, have prior service, are a retired veteran or a member of the National Guard or Reserves, or a spouse of an active military service member, we have challenging and rewarding career opportunities available for you. A committed and diverse workforce is our most important resource. Maximus is an Affirmative Action/Equal Opportunity Employer. Maximus provides equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or disabled status. Pay Transparency Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.