Note: The job is a remote job and is open to candidates in USA. RegEd is hiring a Database Administrator to provide operational and application database services. The role maintains database health, security, performance, backups, and recovery, and supports incident resolution, deployments, and collaboration with development and infrastructure teams.
Responsibilities
- Design, create, and maintain database objects including indexes, views, stored procedures, tables, and other schema elements in on-premise and cloud environments
- Monitor and maintain database health by reviewing and responding to backup status, maintenance jobs, index health, and daily operational alerts
- Perform database user and security management: create logins and users, manage roles and access privileges, and support compliance requirements
- Plan, implement, and maintain backup, restore, and recovery procedures; verify backup success and support restore testing
- Participate in investigation and resolution of database incidents including blocking, deadlocks, and performance degradation
- Optimize existing queries and procedures; develop efficient T-SQL using execution plans, system views, and indexing best practices
- Refresh development and test environment databases on a regular basis to support QA and development teams
- Assist in building and maintaining database monitoring infrastructure for alerting, performance data collection, and operational visibility
- Support implementation of database changes and code deployments; work with the Architecture team on coding standards for stored procedures, triggers, and schema design
- Perform feasibility studies and effort estimates for new or revised database systems to address business needs
- Install, upgrade, and maintain database instances required for development, testing, and production usage
- General technical troubleshooting and consultation with Quality Assurance, Application Development, and Infrastructure teams
- Work with multiple departments including Architecture, Quality Assurance, Application Development, and Infrastructure to implement and maintain database code and configurations
Skills
- 3+ years of database administration, development, or equivalent experience
- Hands-on experience with Microsoft SQL Server 2016 or higher
- Strong T-SQL skills including complex queries, stored procedures, transaction management, error handling, and dynamic SQL
- Understanding of execution plans and query optimization techniques
- Working knowledge of database backup, recovery, and HADR concepts
- Familiarity with cloud database services in Azure such as Azure SQL MI, Azure SQL DB, or Azure SQL on VMs
- Experience with database security administration such as user management, role assignment, and access controls
- Ability to build and maintain SQL scripts, indexes, and complex queries for data analysis and operational use
- Strong understanding of database structures, theories, principles, and practices for OLTP environments
- Proven analytical ability and attention to detail in a production environment
- Strong interpersonal, written, and oral communication skills
- Ability to work collaboratively with development teams in a dynamic environment
- Commitment to quality and accuracy
- 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 PowerShell for scripting and operational automation
- Familiarity with database monitoring and dashboard tools such as SSMS, Grafana, or similar platforms
- Experience with SSIS or other ETL tooling
- Experience with SSRS or other managed reporting platforms
- Familiarity with Git or other version control processes
- Familiarity with other database platforms such as Oracle, PostgreSQL, or MySQL
- Familiarity with SOC 2, FINRA, or other regulated industry compliance requirement
- B.E. or B.S. Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field; related work experience can be substituted for education requirement
Benefits
- 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
- Supportive & flexible remote or hybrid environment
- Vacation
- Sick leave
- Volunteer time off
- Paid parental leave
Company Overview