Senior Database Administrator

RegEd, Inc.; Northern (KY); Remote; USD 100,000 - 165,000; Full time

Benefits offered by this job

Fantastic medical, dental and vision计划

Life Insurance, Short-Term Disability

Volunteering Time Off and Flexible S

401(k) plan

Career growth opportunities

Performance bonuses

Job summary

RegEd is seeking a Senior Database Administrator to maintain and improve databases, both on-premise and in the cloud, focusing on performance and reliability.

You will design objects, tune queries, and lead incident resolution as part of a larger data team, in a remote/hybrid environment with flexible schedules.

The role offers a competitive salary, benefits, and opportunities for career growth across U.S. states including Kentucky.

Qualifications

• 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.
• Cloud-based database experience in Azure (Managed Instance, Hyperscale, Azure SQL DB, VM).
• Experience writing complex database procedures, functions and triggers.
• Understanding of execution plans, system views, and dynamic SQL.
• Strong knowledge of database structures, theories and practices.
• Experience with SQL Server HADR technologies (Always On, log shipping, backup/recovery).
• Experience with monitoring platforms like SSMS, Grafana, PowerBI, or similar.
• PowerShell scripting experience and Git/version-control familiarity.

Responsibilities

• Design, create, and maintain database objects on premise and in the cloud.
• Optimize queries and develop efficient SQL code.
• Lead investigation and resolution of database incidents.
• Build and maintain monitoring infrastructure for alerts and dashboards.
• Support database security and compliance using encryption tools.
• Advise on data retention, tiering and archive strategies for high-volume databases.
• Collaborate with Architecture, QA, Applications and Infrastructure teams.

Skills

SQL

Database design

Performance tuning

Cloud databases (Azure)

Query optimization

PowerShell

Git

Tools

SSMS

Grafana

PowerBI

Azure SQL Hyperscale

Backup/Recovery tooling

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior Database Administrator

Full Time Ind Contributor Remote

2 days ago Requisition ID: 1767

Salary Range: $100,000.00 To $165,000.00 Annually

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 Senior Database Administrator is responsible for maintaining and improving existing databased systems as well as assisting in the design and development of new systems utilizing the latest techniques and technologies. Primary responsibilities would include database design, performance tuning, writing and understanding complex SQL, optimizing and updating existing database code, fulfilling requests and resolving incidents. The role will also require responding to database related alerts and escalations within an expected SLA time. As part of the larger data team, working with management and other teams to define strategic solutions, and address recurring problems will be necessary.

This role requires a service-oriented mentality and high sense of ownership. The Senior Database Administrator would be 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 over multiple simultaneous projects are keys for success.

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

You’ve Got What It Takes If You Have:

• 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.

Nice To Have:

• 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.

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)

Welcome to RegEd!

The Perks:

• Fantasticand comprehensivemedical, dental and visionplans
• Life Insurance, Short-Term Disability and Long-Term Disability plans
• Volunteering Time Off andFlexible Schedules
• 401(k) plan
• Incredible career growthopportunities
• Performance bonuses

Pay Transparency:

The compensation range for this position is $100,000-$165,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.