SENIOR SQL SERVER DATA BASE ADMINISTRATOR

Home. It’s a word that holds a special place at Bright MLS. At its core, it’s shelter. But it’s also so much more. Family. Community. Safety. A place where you can be your fullest, truest self. That’s the word that inspires all of us at Bright to do the work that we do - Ensuring an open, clear, and competitive housing market for ALL.
Our company –and our brand –are reflective of the diverse communities that make up our market. Our employees represent a diverse mix of backgrounds, cultures and experiences, so much so that Bright’s been named as one of the most diverse employers in the area by the Washington Business Journal –2 years in a row.
Bright MLS is the engine that powers the real estate market in the Mid-Atlantic U.S. - supporting over $100B in transactions yearly. It is the single source for all data on Mid-Atlantic residential real estate - anywhere. As a Multiple Listing Service (MLS), our technology solutions connect real estate professionals with other real estate professionals and their clients, providing an open and accessible marketplace for buying and selling real estate.
We’re redefining what it means to be an MLS, and we’d love to have YOU here with us helping tell a Brighter story to the world. To learn more, please visit www.brightmls.com.

OVERVIEW:

We are seeking a skilled SQL Database Administrator with experience in installation, configuration, maintenance of SQL database servers (RDS and on-prem/Cloud SQL server) and processes, including monitoring of system health and performance. The ideal candidate will possess a deep understanding of SQL services, AWS RDS, and Redshift. This role requires strong Agile Scrum proficiency, a collaborative team player mindset, and the ability to work independently. With at least 5 years of Database experience, the candidate should excel in delivering innovative solutions within a cloud-native environment.

REQUIRED SKILLS:

• 5 to 8 years of experience in SQL server database administration, AWS RDS, and Redshift.
• Strong command of SQL, SQL server tools and NoSQL databases like MongoDB.
• Experience with High Availability (HA), database security, backup and Disaster Recovery (DR).
• Experience in design, planning and migration of databases to AWS.
• Experience in PowerShell/Unix Shell scripting & operational automation.
• Experience with Performance Tuning and Optimization, using native monitoring and troubleshooting tools as well as 3rd party tools.
• Understanding of relational and dimensional data modeling.
• Familiarity with SSAS, SSIS, SSRS.
• Experience working with Windows server, including Active Directory.
• Self-motivated, directed and with keen attention to detail.
• Excellent interpersonal, verbal and written communication skills as well as strong logical, analytical and problem solving skills.
• Experience working in team-oriented, collaborative environment and with teams spread across multiple locations across multiple time zones.
• Experience with Linux and Windows Server environments.
• Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB).
• Experience with AWS cloud services (RDS, Redshift, S3, Glue) required.

REQUIRED EDUCATION/PREFERRED SKILLS:

• Bachelor’s degree in computer science or a related field.
• MCSE/MCSA certifications preferred.
• Experience with MongoDB is preferred.
  The salary range for this position is approximately $100,000 to $125,000, based on experience, skills, and qualifications. This position is also eligible for annual performance-based bonuses. Our comprehensive benefits package includes individual and family health, vision, and dental coverage, 401(k) plan with employer-matching, and Paid Time Off (PTO) and holidays.
  It is the company’s policy to recruit, hire, train and promote individuals, as well as to administer any and all personnel actions, without regard to race, religion, age, sex, marital status, sexual orientation, disability, national origin, ancestry, military status or any other unlawfully prohibited characteristic in accordance with applicable laws

• Install, configure, and maintain SQL database servers (RDS and on-prem/Cloud SQL server installations).
• Monitor and tune database performance to ensure high levels of performance, availability, and security.
• Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
• Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
• Develop processes for optimizing database security, protect sensitive data, and manage database access efficiently.
• Complete necessary patching and updates on servers and instances.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards.
• Refine and automate regular/repeating processes, track issues, and document changes.
• Be available for on-call support as needed.
• Work with developers, DevOps and engineering team to support application development and implement solutions/enhancements for recurring problems.
• Design and complete migration of databases to AWS.
• Troubleshoot and resolve database-related problems/escalations in a timely manner.