CoStar Realty Information, Inc.
Cloud Database Engineer (Snowflake/Databricks/AWS)
CoStar Realty Information, Inc., Arlington, Virginia, United States, 22201
Cloud Database Engineer (Snowflake/Databricks/AWS)
Job Description
CoStar Group serves up over 1.8PB of data from more than 800 SQL Servers that span four OnPremise data centers, two continents, and six different time zones and we are expanding to AWS Cloud solution rapidly and start to support Aurora MySQL, PostgreSQL, DynamoDB, Databricks, Snowflake and other DB engines on the cloud. Our highly motivated, extremely talented DBA group is looking for an exceptionally bright Cloud Database Engineer, both Onprem 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!. Our goal is to provide an exceptional experience for our customers through continued development, refinement, and improvement of our industry-leading applications.
We are a data-centric; Microsoft focused shop that uses the latest SQL Server, AWS RDS, DynamoDB and .NET technologies for major applications and also support Snowflake, Databricks, and more.
CoStar Group is the leading data provider of Multi-Family and Commercial Real Estate data in an industry valued at over 15 trillion dollars. If you are seeking a challenge that pushes your limits, have a strong desire to delight your customers, want to work with the latest technologies and are looking for responsibilities beyond that of a typical DBA, come to work for us today.
This position will have a work schedule of 4 days onsite, with 1 work from day located in Arlington, VA.
Duties and 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.
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
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
Requirements:
AWS Experience - Knowledge of various AWS services (EC2, RDS, S3, EBS, Lambda), CloudWatch, IAM.
3+ years of experience with Microsoft SQL Server 2017 / 2019/ 2022 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 the implementation and support of SQL database replication via script
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, Snowflake, Databricks)
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
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.
Bachelor's degree from an accredited, not-for-profit University or College.
A track record of commitment to prior employers
Nice to have (Big Plus):
Familiarity with Relational Database Management experience such as MS SQL, Aurora / RDS PostgreSQL, MySQL
Familiarity with Azure DevOps / Terraform / GitHub is a big plus
Experience with TFS/Visual Studio Database Projects, Azure DevOps, Terraform, CloudFormation, or any other CI/CD platforms
Any other programming skills are valuable, such as C#
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, and tuition reimbursement.
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
On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes
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 Group is not able to provide visa sponsorship for this position.
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
#LI-AV1
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
CoStar 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. We’ve continually refined, transformed and perfected our approach to our business, creating a language that has become standard in our industry and for our customers. This is how we deliver for our customers, our employees, and investors. By equipping the brightest minds with the best resources available, we provide an invaluable edge in real estate.
CoStar is committed to creating a diverse environment and is proud to be an equal opportunity workplace and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. CoStar is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access www.costargroup.com/careers as a result of your disability. You can request reasonable accommodations by calling 1-855-840-1715 or by sending an email to recruiting@costargroup.com .
Job Description
CoStar Group serves up over 1.8PB of data from more than 800 SQL Servers that span four OnPremise data centers, two continents, and six different time zones and we are expanding to AWS Cloud solution rapidly and start to support Aurora MySQL, PostgreSQL, DynamoDB, Databricks, Snowflake and other DB engines on the cloud. Our highly motivated, extremely talented DBA group is looking for an exceptionally bright Cloud Database Engineer, both Onprem 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!. Our goal is to provide an exceptional experience for our customers through continued development, refinement, and improvement of our industry-leading applications.
We are a data-centric; Microsoft focused shop that uses the latest SQL Server, AWS RDS, DynamoDB and .NET technologies for major applications and also support Snowflake, Databricks, and more.
CoStar Group is the leading data provider of Multi-Family and Commercial Real Estate data in an industry valued at over 15 trillion dollars. If you are seeking a challenge that pushes your limits, have a strong desire to delight your customers, want to work with the latest technologies and are looking for responsibilities beyond that of a typical DBA, come to work for us today.
This position will have a work schedule of 4 days onsite, with 1 work from day located in Arlington, VA.
Duties and 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.
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
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
Requirements:
AWS Experience - Knowledge of various AWS services (EC2, RDS, S3, EBS, Lambda), CloudWatch, IAM.
3+ years of experience with Microsoft SQL Server 2017 / 2019/ 2022 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 the implementation and support of SQL database replication via script
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, Snowflake, Databricks)
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
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.
Bachelor's degree from an accredited, not-for-profit University or College.
A track record of commitment to prior employers
Nice to have (Big Plus):
Familiarity with Relational Database Management experience such as MS SQL, Aurora / RDS PostgreSQL, MySQL
Familiarity with Azure DevOps / Terraform / GitHub is a big plus
Experience with TFS/Visual Studio Database Projects, Azure DevOps, Terraform, CloudFormation, or any other CI/CD platforms
Any other programming skills are valuable, such as C#
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, and tuition reimbursement.
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
On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes
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 Group is not able to provide visa sponsorship for this position.
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
#LI-AV1
CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
CoStar 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. We’ve continually refined, transformed and perfected our approach to our business, creating a language that has become standard in our industry and for our customers. This is how we deliver for our customers, our employees, and investors. By equipping the brightest minds with the best resources available, we provide an invaluable edge in real estate.
CoStar is committed to creating a diverse environment and is proud to be an equal opportunity workplace and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. CoStar is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access www.costargroup.com/careers as a result of your disability. You can request reasonable accommodations by calling 1-855-840-1715 or by sending an email to recruiting@costargroup.com .