Job Description

OVERVIEW - DATABASE ADMINISTRATOR, LONDON

CoStar is the largest provider of CRE research and real-time data; In the US we own brands such as LoopNet, the most heavily trafficked mobile and online real estate marketplace; Apartments.com, the premier rental home resource for renters, property managers and owners. Our CoStar family of brands also includes STR, the leading provider of performance benchmarking and comparative analytics to the hotel industry. In the UK and Europe Realla, Thomas Daily, Belbex are among the industry leading businesses under the CoStar brand. Headquartered in Washington, DC, CoStar Group maintains offices throughout the U.S, Europe, Canada, and Asia, with a staff of over 5,300 worldwide.

Our highly motivated and talented DBA group is looking for a Database Engineer that will help the company continue to grow. CoStar Group serves up close to 1.4PB of data from more than 700 SQL Servers that span four On-Premise data centers, two continents and six time zones, and we are expanding to AWS Cloud solution rapidly and start to support Aurora MySQL, MongoDB, ELK, DynamoDB and other DB engines on cloud. We are also looking to support MSFT Azure. We are a data-centric Microsoft focused shop that uses the latest SQL Server and .NET technologies for major applications. As a member of the team you will be relied on for your problem solving, communication, collaboration, project management, process adherence, and financial analysis skills.

RESPONSIBILITIES

• Database technology evaluation, guidance and consultation. You will offer design support and conduct task automation and scripting whilst adhering to, and implementing, best practice and standards development.
• Capacity planning, optimization and tuning covering system upgrades and migrations You will undertake performance management, monitoring, security, backup, and recovery, issue troubleshooting, and documentation.
• Deploy, configure, monitor, and maintain databases in the production, development, and quality assurance environments.
• Working closely with our Operations & Development team planning server/server-less resource requirements.
• Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc.
• You will be responsible for level 2 systems management, you will hold project-level control over some DB initiatives.
• You will help to administrate and support integrating with Microsoft SQL Server so some MSFT SQL DBA skill is required.

BASIC QUALIFICATIONS

• Microsoft SQL Server Management experience.
• Experience of other Relational Database Management systems; MySQL or PostgreSQL.
• Demonstrable experience of solving data engineering problems with any NoSQL data platforms like Spark, Solr, MongoDB, DocumentDB, DynamoDB, Cosmos DB
• Expertise in database administration for configuration, implementation, maintenance, redundancy/HA/DR, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, Microsoft SQL
• Knowledge of any monitoring tools such as Kibana, AWS CloudWatch, DataDog, etc

PREFERRED QUALIFICATIONS

• The ideal candidate will have experience with at least one of the Public Cloud providers like AWS, Google Cloud Services, and Azure experience.
• Experience with Linux Server platform
• Cloud migration experience
• Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse or Data Analytics
• Experience with relevant scripting languages or programming frameworks desired (PowerShell, Python, NodeJS, JavaScript, bash)
• Knowledge of automation tools & Scripts: ELK, PRTG, Jenkins, Chef, Lamda, Terraform, AWS CloudFomation, Azure Automation, etc.

COMPANY OVERVIEW

Founded in 1987, CoStar Group is the leading provider of commercial real estate information, analytics, and online marketplaces. Our suite of online services enables clients to analyze, interpret and gain unmatched insight on commercial property values, market conditions and current availability. Behind some of the most well-known brands in the industry, CoStar Group includes CoStar, the largest provider of CRE research and real-time data; Realla, the UK’s newest online commercial real estate marketplace; STR, the leading provider of performance benchmarking and comparative analytics to the hotel industry.

Headquartered in Washington, DC, CoStar Group maintains offices throughout the U.S. and in Europe, Canada, and Asia with a staff of over 5,300 worldwide.

WHAT’S IN IT FOR YOU?

Working at CoStar Group means you'll enjoy a culture of collaboration and innovation that attracts the best and brightest across a broad range of disciplines. As well as having an outstanding working environment based in the Shard, other perks include full private medical cover and member rewards, 28 days annual leave, a competitive pension, season ticket loans, birthday lunches and much more! Take a look at our employee’s stories to find out more - Careers | CoStar Group

• At CoStar, we recognise the positive value of diversity and promote equality. We aim at all times to recruit the person who is most suited to the job and welcome applications from people of all backgrounds – men and women, people of all ages, sexual orientations, nationalities, religions and beliefs.

However, we particularly encourage applications from women, disabled and Black, Asian and Minority Ethnic (BAME) candidates, as these groups are underrepresented throughout the commercial real estate industry.