Database Administrator at RegEd

Job description

Who We Are: RegEd is the market-leading provider of RegTech enterprise solutions with relationships with hundreds of enterprise clients, including 80% of the top 25 financial services firms. Established in 2000 by former regulators, the company is recognized for continuous regulatory technology innovation with solutions hallmarked by workflow-directed processes, data integration, regulatory intelligence, automated validations, business process automation and compliance dashboards. The aggregate drives the highest levels of operational efficiency and enables our clients to cost-effectively comply with regulations and continuously mitigate risk. Trusted by the nation’s top financial services firms, RegEd’s proven, holistic approach to RegTech meets firms where they are on the compliance and risk management continuum, scaling as their needs evolve and amplifying the value proposition delivered to clients. Life at RegEd: We are an innovative, fast-paced company that embraces diversity. Our remote or hybrid environment blends an entrepreneurial culture with the right balance of structure and process. We empower and trust our employees. Most RegEder’s work remotely, and some roles work a hybrid schedule from our Headquarters in Morrisville, North Carolina. Learn more about #LifeAtRegEd on our LinkedIn page ! Diversity Drives Innovation: RegEd believes that diverse perspectives make us stronger, smarter, and more innovative. We are committed to building a workplace where everyone feels seen, heard, and empowered to succeed. We actively seek individuals from all backgrounds and are committed to cultivating an environment of inclusivity and belonging. RegEd also recognizes the exceptional skills, discipline and dedication of those who serve - and those who stand beside them. Whether you’re a veteran, active-duty service member transitioning to civilian life, or a military spouse, your unique experience brings incredible value to our team. Military members, veterans, and military spouses are strongly encouraged to apply. Don’t meet every requirement? If you are excited about this role but your experience does not align perfectly with all the qualifications, we encourage you to apply anyway . Experience comes in many forms, and you may be the perfect candidate for this or other roles . Five Reasons to Work with Us:   • Work with a leader in financial services industry  • Supportive & flexible remote or hybrid environment  • Diverse & friendly culture  • Fast paced growing company  • A company that cares with community service efforts What You Will Be Doing:   The Database Administrator (DBA) is responsible for providing operational and application database services to the organization. Primary responsibilities include owning, tracking, and resolving database-related incidents and requests; monitoring and maintaining database health through backups, maintenance jobs, and index management; and supporting performance and security requirements. This role involves daily monitoring to identify and address service-related issues, responding to database alerts and escalations, and collaborating with management and other teams on solutions to recurring problems. The DBA role requires a service-oriented mentality and a high sense of ownership. The DBA is expected to continually look for areas of improvement in projects, products, and processes to ensure efficiency, consistency, and accuracy. Self-direction and the ability to manage and allocate your time across multiple simultaneous projects are keys for success. 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. You’ve Got What It Takes If You Have: • 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 Nice To Have:   • 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 The Process: We can hire in the following states: Alabama, Arizona, California, Colorado, Connecticut, Florida, Georgia, Illinois, Iowa, Kentucky, Maryland, Massachusetts, Michigan, Minnesota, Missouri, New Jersey, New York, North Carolina, Ohio, Pennsylvania, South Carolina, Tennessee, Texas and Utah. Any communications related to open RegEd positions will come from a RegEd.com email address. We do not hire through text message , social media, or email alone. Our interviews are conducted either in person or via video calls. We will not ask you for sensitive information nor will we ask you to pay anything during the hiring process. • Apply! (3-25 minutes) • Resume review (up to 2 weeks) • Brief video interview with RegEd Recruiting Team Member (30 minutes) • Video interview with Team Members (60 minutes) • Video interview with Hiring Manager (30-60 minutes) • Video interview with Team Leader (30-60 minutes) • Offer • Background check and drug test (2-5 days) • Onboarding, yay! Welcome to RegEd! The Perks:   • Fantastic and comprehensive medical, dental and vision plans • Life Insurance, Short-Term Disability and Long-Term Disability plans • Volunteering Time Off and Flexible Schedules • 401(k) plan • Incredible career growth opportunities • Performance bonuses If you are interested in joining a market leader and innovator poised for exponential new business growth in the coming years, please apply. It’s a great time to join the RegEd Team!  Pay Transparency:   The compensation range for this position is $85,000-$120,000.   RegEd takes a market-based approach to pay. It is not typical for a candidate to be hired close to or at the maximum of the salary range. Your actual pay at RegEd is based on your unique background, pertinent experience, work location and qualifications. Base pay also depends on the relative experience, knowledge and skills to our internal peers in the role. In addition to competitive base pay and bonus/commission program participation, RegEd’s total compensation package also includes our comprehensive benefits package in addition to vacation, sick, volunteer time off and paid parental leave. Accommodation: We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the interview process, perform essential job functions and to receive other benefits and privileges of employment. If you need an accommodation in order to interview, please let us know during any of your interactions with the RegEd Recruiting Team. This information will be treated as confidential and only used to determine appropriate accommodation for the interview process. Equal Opportunity Policy (EEO): At RegEd, we do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, veteran status, and basis of disability or any other federal, state, or local protected class. RegEd is proud to be an Equal Opportunity Workplace. Applicants must be authorized to work in the United States, and should not require, now or in the future, sponsorship for employment visa status.     RegEd does not seek or accept unsolicited resumes from recruitment agencies. We are not responsible for any fees related to unsolicited resumes.

Requirements

Must-haves

Work with a leader in financial services industry
Supportive & flexible remote or hybrid environment
Diverse & friendly culture
Fast paced growing company
A company that cares with community service efforts
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.

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazure

Platform: adp-workforce-now
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Parental Leave