POSITION SUMMARY:

The Data Architect is responsible for management oversight, provisioning, installation/configuration, operation, and maintenance of cloud services, on premises database environments, budgeting and planning of IT Operations. This individual will lead technical research and development to enable continuing innovation within the technology services organization. This individual ensures that cloud tenants, system hardware, operating systems, software systems, and related procedures adhere to organizational values, policies, and procedures.

This individual is accountable for the following systems: Azure/365 Tenant Management, Server Environments for On-Premises Hosted Data Centers, Virtualization Systems, Storage systems, Software Development Schematics, Business Intelligence and Analytics, Maintenance and Capital Budget planning and projects as assigned by the Technology Services Director.

THE DETAILS:

This contract Database Administrator (DBA) position is expected to span an initial six-month term, with the potential for extension based on ongoing project demand. The DBA will provide critical support for several strategic, high-priority initiatives planned for 2026, with primary emphasis on ACO Analytics and Data & Analytics (D&A) initiatives, including the Snowflake migration. Applicants must be authorized to work in the United States without the need for current or future employer-sponsored work authorization.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Database Administration

• Design, implement, and maintain database systems to ensure high performance, security, and availability.
• Monitor database performance, implement changes, and apply new patches and versions when required.
• Perform regular database backups and recovery procedures.
• Optimize and tune database queries for efficiency after being released to production
• Collaborate with developers to design and optimize database schemas.
• Ensure data integrity and security by implementing appropriate measures.
• Create and maintain documentation related to database configurations, procedures, and policies.
• Troubleshoot and resolve database-related issues and provide support to end-users.
• Conduct regular audits to ensure compliance with data protection regulations, such as GDPR, HIPAA
• Proficiency in database management systems including related tools (e.g., SQL Server ,data lakes, document stores, event hubs).
• Strong knowledge of database security, backup and recovery, and performance tuning.
• Familiarity with database design, documentation, and coding.
• Application ecosystem troubleshooting.

On-Premises SQL Server Installations:

• Install, configure, and maintain SQL Server instances and related software.
• Monitor and optimize database performance, including indexing and query tuning.
• Implement and manage database security measures, including user roles and permissions.
• Perform regular backups and ensure reliable recovery processes.
• Apply patches and updates to SQL Server to maintain security and performance.
• Troubleshoot and resolve database issues, ensuring minimal downtime.
• Conduct regular audits to ensure compliance with organizational policies and regulations.
• Develop and maintain documentation for database configurations, procedures, and policies.

Azure SQL Databases:

• Provision and configure Azure SQL databases to meet application requirements.
• Monitor and optimize database performance, including indexing and query tuning.
• Implement security measures, including firewall rules, encryption, and access controls.
• Manage automated backups and configure point-in-time restore options.
• Scale databases up or down based on performance and storage needs.
• Ensure high availability and disaster recovery using geo-replication and failover groups.
• Optimize cost by managing resource utilization and selecting appropriate pricing tiers.
• Integrate with other Azure services for enhanced functionality and analytics.

Must have peripheral and adjacent knowledge of:

• Power BI
• Data lakes
• ADF
• Databricks
• Snowflake
• Event processing technologies
• Azure Dev Ops
• Github
• Agile/Scrum methodologies

SPECIAL KNOWLEDGE, SKILLS, ABILITIES, TRAINING OR SPECIAL LICENSES/CERTIFICATIONS NEEDED TO PERFORM THIS JOB:

(Looking for individuals with SME experience with at least 2 or more technologies listed below)

• Azure including Azure SQL Platform as a Service, Azure Virtual Networking, Identity and Access Management, API, containerization and web application services
• Functional knowledge of DNS and Networking
• Functional knowledge of on-premises hosting of three tier architecture and virtualization
• Experience supporting a 1000+ user environment across multiple locations

Complexity/Problem Solving

Position owns a variety of production services and provides direction to others. The question/issues are typically clear and requires determination of which answer (from a few choices) is the best.

Communications/Interpersonal Contacts

• Must maintain positive attitude when working with IT team, other colleagues, and customers.
• Interpret and/or discuss information with others, which involves terminology or concepts not familiar to many people; regularly provide advice and recommend actions involving rather complex issues.

EDUCATION / EXPERIENCE:

Education

Minimum: Bachelor’s Degree

Experience

Minimum: 7 years - combination of system administration and data architecture experience

COMPENSATION: $70 - $80 per hour. Exact pay will be determined based on candidate experience and geographic location