[Remote] Senior Database Administrator

Note: The job is a remote job and is open to candidates in USA. RegEd is hiring a Senior Database Administrator to maintain and improve existing database systems and assist in designing and developing new systems. The role focuses on database design, SQL development and performance optimization, incident response, monitoring, security, and collaboration on strategic data solutions.

Responsibilities

• Design, create, and maintain database objects. This includes all database physical and logical primary objects such as indexes, views, procedures, etc. in on premise and cloud databases
• Recommend database approaches and design to architecture and application staff
• Drive innovation and improvement through implementation of newer data technologies
• Work with the Architecture team to establish coding standards for stored procedures, triggers, and logical and physical schema design
• Review and approve complex structural changes to the database
• Optimization of existing queries and procedures as well as development of efficient, optimal SQL code
• Lead investigation and resolution of database incidents including blocking and deadlocks
• Assist in building and maintaining database monitoring infrastructure for alerting, performance collection, and operational dashboards
• Support database security and compliance requirements using TDE, data masking, and other encryption tools
• Advise on and implement data retention, tiering, and archive strategies for high-volume production databases
• General technical troubleshooting and consultation with quality assurance, application development, and infrastructure teams
• Work with several departments including Architecture, Quality Assurance, Application Development, and Infrastructure to implement and maintain database and database code

Skills

• 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
• Proficiency in PowerShell for script automation, tooling, and operational workflows
• Experience with Git or other version-control change management processes
• Applicants must be authorized to work in the United States, and should not require, now or in the future, sponsorship for employment visa status
• Experience with SSIS or other ETL tooling
• Experience with SSRS or other managed reporting platforms
• Familiarity with Oracle, PostgreSQL, or MySQL
• Experience with schema migration tools like Liquibase or Flyway
• Familiarity with Azure Data Lake Storage, Synapse Analytics, or other cloud native platforms
• Experience with SOC 2, FINRA, or other regulated industry compliance requirements

Benefits

• Supportive & flexible remote or hybrid environment
• Fantastic and comprehensive medical, dental and vision plans
• Life Insurance, Short-Term Disability and Long-Term Disability plans
• Volunteering Time Off
• Flexible Schedules
• 401(k) plan
• Incredible career growth opportunities
• Performance bonuses
• Bonus/commission program participation
• Vacation
• Sick time
• Volunteer time off
• Paid parental leave

Company Overview