Bright MLS · 7 hours ago
Senior SQL Server Database Administrator
Bright MLS is a company dedicated to ensuring an open, clear, and competitive housing market for all. They are seeking a skilled SQL Database Administrator to manage the installation, configuration, and maintenance of SQL database servers, while also ensuring high performance and security of the databases.
Real Estate
Responsibilities
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
Qualification
Required
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
Bachelor's degree in computer science or a related field
Preferred
MCSE/MCSA certifications preferred
Experience with MongoDB is preferred
Benefits
Individual and family health, vision, and dental coverage
401(k) plan with employer-matching
Paid Time Off (PTO) and holidays
Company
Bright MLS
Bright MLS was founded in 2016 as a collaboration between 43 visionary associations and two of the nation’s most prominent MLSs to transform what an MLS is and what it does, so real estate pros and the people they serve can thrive today and into our data-driven future through an open, clear and competitive housing market for all.