Senior Database Engineer
Company: CoStar Group, Inc.
Location: Aurora
Posted on: October 11, 2024
Job Description:
Senior Database EngineerJob DescriptionCompany Overview: CoStar
Group (NASDAQ: CSGP) is a leading global provider of commercial and
residential real estate information, analytics, and online
marketplaces. Included in the S&P 500 Index and the NASDAQ 100,
CoStar Group is on a mission to digitize the world's real estate,
empowering all people to discover properties, insights, and
connections that improve their businesses and lives. We have been
living and breathing the world of real estate information and
online marketplaces for over 35 years, giving us the perspective to
create truly unique and valuable offerings to our
customers.Position Overview: CoStar Group serves up over 1.8PB of
data from more than 800 SQL Servers that span four On-Premise data
centers, two continents, and six different time zones. We are
expanding to AWS Cloud solutions rapidly and starting to support
Aurora MySQL, PostgreSQL, DynamoDB, Databricks, Snowflake, and
MongoDB Atlas among other DB engines on the cloud. Our highly
motivated, extremely talented DBA group is looking for
exceptionally bright Senior Database Administrators / Database
Engineers both On-prem and AWS Cloud that will help the company
continue to grow to the next level. If you are passionate about
automating and programming to support databases, this is your
job!Responsibilities:
- Demonstrate extensive knowledge of all aspects of Microsoft SQL
Server, including administration, replication, backup/restore
procedures, and related components such as Reporting Services,
Analysis Services, and Integration Services.
- Implement and maintain automated processes using
TSQL/PowerShell/Python scripts.
- Understand AWS-based architecture and closely work with DevOps,
SecOps and develop scripts to deploy and maintain the
environment.
- Install, configure, monitor, and maintain databases in the
production, development, and quality assurance environments.
- Recommend and implement solutions for SQL performance
monitoring, tuning, and automation.
- Understand SAN-based storage and related technologies,
specifically as applicable and useful to MS SQL Server
installations.
- Work with the Operations team planning server hardware,
storage, and OS configuration upgrades to help get the most out of
SQL Server for specific application requirements and performance
metrics.
- Process database change requests, including the creation and
modification of databases, tables, views, stored procedures,
triggers, jobs, etc. in accordance with change control
policies.
- Analyze problems, anticipate future problem areas, and
implement solutions.
- Work outside of normal business hours as required to complete
projects, work on deployments, and resolving system outages.
- To be placed on on-call rotation for a week every 3 months and
respond to system alerts.Basic Qualifications:
- Bachelor's degree required from an accredited, not-for-profit
university or college.
- 5+ years of experience with Microsoft SQL Server 2016 / 2017 /
2019 supporting high-traffic websites.
- Experience with the implementation and support of database
replication.
- Experience working with very large databases, upgrades,
troubleshooting performance, etc.
- Experience with SQL Server High Availability Architecture
(AlwaysOn) and troubleshooting.
- Understanding of Windows Server configuration and management,
specifically as it relates to MS SQL Server installations and
mission-critical systems.
- Excellent understanding of coding with Microsoft T-SQL and
stored procedures.
- Desire to learn and administrate new cloud technologies in
order to support a variety of database engines such as AWS Database
Engines (RDS, DynamoDB, Atlas MongoDB).
- Experience with adhering to and implementing best practices
within an enterprise environment that includes using source control
for all database-related artifacts (including jobs, SSIS packages,
and replication configuration) and following a change
request/notification policy.
- Experience with either Python scripting and/or PowerShell is
required.
- Experience with TFS/Visual Studio Database Projects, Azure
DevOps, Terraform, CloudFormation, or any other CI/CD with a Source
Control system is required.
- Experience with SANs (3PAR/EMC/Pure), specifically with aspects
related to MS SQL Server.
- Understands and is able to properly implement backup and
disaster recovery procedures.
- Excellent work ethic and willingness to put in significant
extra time with large team members are required.Preferred
Qualifications:
- Strong AWS experience.
- Deep Knowledge of Relational Database Management experience
such as MS SQL, Aurora / RDS PostgreSQL, MySQL, and Redshift is
preferred.
- Deep knowledge of Azure DevOps / Terraform / GitHub is a big
plus.
- NoSQL database experience
(MongoDB/Hadoop/Redis/DynamoDB/Elastic Search).
- Experienced with automation and deployment tools & Scripts: MS
Team Foundation Service, ELK, PRTG, Lambda, CloudFormation,
etc.
- AWS solution architect certification.
- Any other programming skills are valuable, such as C#.
- Having knowledge of all aspects of Azure Database Engines
(Managed Instances, Data Warehouse), including administration.
- Azure solutions architect associate certification.
- Excellent technical expertise in relevant state-of-the-art data
technologies, database warehouse data security, data systems, and
its design.
- Able to formulate and present various solutions for business
initiatives and discuss pros/cons for each option.
- Knowledge of monitoring tools such as Kibana, CloudWatch,
DataDog, or any other tools, etc.What's in it for You:When you join
CoStar Group, you'll experience a collaborative and innovative
culture working alongside the best and brightest to empower our
people and customers to succeed. We offer you generous compensation
and performance-based incentives. CoStar Group also invests in your
professional and academic growth with internal training, tuition
reimbursement, and an inter-office exchange program. Our benefits
package includes (but is not limited to): Comprehensive healthcare
coverage: Medical / Vision / Dental / Prescription Drug Life,
legal, and supplementary insurance Virtual and in-person mental
health counseling services for individuals and family Commuter and
parking benefits 401(K) retirement plan with matching contributions
Employee stock purchase plan Paid time off Tuition reimbursement
Access to CoStar Group's Diversity, Equity, & Inclusion Employee
Resource Groups Complimentary gourmet coffee, tea, hot chocolate,
fresh fruit, and other healthy snacks.We welcome all qualified
candidates who are currently eligible to work full-time in the
United States to apply. However, please note that CoStar is not
able to provide visa sponsorship for this position.#LI-CH1CoStar
Group is an Equal Employment Opportunity Employer; we maintain a
drug-free workplace and perform pre-employment substance abuse
testing. CoStar Group (NASDAQ: CSGP) is a leading global provider
of commercial and residential real estate information, analytics,
and online marketplaces. Included in the S&P 500 Index and the
NASDAQ 100, CoStar Group is on a mission to digitize the world's
real estate, empowering all people to discover properties, insights
and connections that improve their businesses and lives. We have
been living and breathing the world of real estate information and
online marketplaces for over 37 years, giving us the perspective to
create truly unique and valuable products and services.
#J-18808-Ljbffr
Keywords: CoStar Group, Inc., Lakewood , Senior Database Engineer, Engineering , Aurora, Colorado
Didn't find what you're looking for? Search again!
Loading more jobs...