Senior Database Architect: Cloud, Performance & Security

REGED INC; Heber (UT); Teletrabalho; USD 100 000 - 165 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, dental, vision

Life Insurance

Volunteer time off

Career growth opportunities

Performance bonuses

Resumo da oferta

RegEd, a leading RegTech provider, seeks a Senior Database Administrator to maintain and enhance on-premise and cloud databases. You will design, optimize, and secure SQL Server environments, address alerts within SLA, and partner with Architecture, QA, and IT teams to deliver scalable data solutions.

The role emphasizes performance tuning, complex SQL, and cloud-based databases (Azure). A remote-friendly, diverse work culture with opportunities for career growth and competitive benefits awaits.

Qualificações

• 7+ years database analysis, programming or similar experience
• ~ Minimum 4 years’ experience as a Senior Database Developer or equivalent
• ~ Extensive hands-on experience in SQL 2016 and higher
• ~ Hands on experience with cloud-based database systems in Azure using Managed Instance, Azure SQL Hyperscale, Azure SQL DB, and VMs
• Extensive experience dealing with multiple large (2+ TB) databases
• ~ Experience writing complex database procedures, functions and triggers
• ~ Understanding of execution plans, system views, and dynamic SQL
• ~ Strong understanding of database structures, theories, principles and practices
• ~ Proven strong innovate and analytical ability with extensive implementation skills
• ~ Proven success in performance optimization for OLTP and OLAP applications
• ~ Experience with SQL Server HADR technologies, including Always On Availability Groups, log shipping, and backup/recovery strategies.
• ~ Experience with database monitoring platforms and dashboard tools such as SSMS, Grafana, PowerBI, or other third-party tools.
• ~ Experience with SSIS or other ETL tooling.
• ~ Experience with SSRS or other managed reporting platforms
• ~ Familiarity with Oracle, PostgreSQL, or MySQL.
• ~ Familiarity with Azure Data Lake Storage, Synapse Analytics, or other cloud native platforms.

Responsabilidades

• The Senior Database Administrator is responsible for maintaining and improving existing databased systems and assisting in the design and development of new systems.
• - Primary responsibilities include database design, performance tuning, writing and understanding complex SQL, and updating existing database code.
• - Responding to database related alerts and escalations within an expected SLA time.
• - Define strategic solutions with the data team and address recurring problems.
• - Build and maintain database monitoring infrastructure for alerting and dashboards.
• - Advise on data retention, tiering, and archive strategies for high-volume production databases.
• - Work with Architecture, QA, App Development, and Infrastructure teams to implement and maintain database code.
• - Review and approve complex structural changes to the database, optimize queries, and develop efficient SQL.

Descrição da oferta de emprego

RegEd, a leading RegTech provider, seeks a Senior Database Administrator to maintain and enhance on-premise and cloud databases. You will design, optimize, and secure SQL Server environments, address alerts within SLA, and partner with Architecture, QA, and IT teams to deliver scalable data solutions.

The role emphasizes performance tuning, complex SQL, and cloud-based databases (Azure). A remote-friendly, diverse work culture with opportunities for career growth and competitive benefits awaits.