Senior Cloud Database Administrator with Security Clearance

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. 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. 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: We are committed to building a workplace where everyone feels seen, heard, and empowered to succeed. 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. Work with a leader in financial services industry

• Supportive & flexible remote or hybrid environment
• A company that cares with community service efforts

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. 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. 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 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. Our interviews are conducted either in person or via video calls. 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) Fantastic and comprehensive medical, dental and vision plans

• Life Insurance, Short-Term Disability and Long-Term Disability plans
• Volunteering Time Off and Flexible Schedules
• Incredible career growth opportunities
• Performance bonuses

The compensation range for this position is $100,000-$165,000. It is not typical for a candidate to be hired close to or at the maximum of the salary range. 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. 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. 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. Applicants must be authorized to work in the United States, and should not require, now or in the future, sponsorship for employment visa status.