Senior Cloud Database Engineer job vacancy

Vacancy expired!

Senior Cloud Database Engineer

Job Description

CoStar delivers real-time, verified commercial real estate data that helps clients confidently spot great opportunities and make smart choices ahead of competitors. By combining the power of CoStar's independent research organization - the industry's largest - with global data delivery, software, and application solutions, clients can act on opportunities with confidence.

As CoStar's next Senior Cloud Database Engineer, you will work on the design, creation, configuration, and maintenance of MS SQL Server Databases. This includes overseeing database performance, job scheduling, replication, indexing and availability. You will partner up with developers and systems engineer to develop database strategies for new products and systems such as backup and recovery strategies and monitor servers to ensure capacity is not exceeded.

This position is based in our Washington, DC office and has the opportunity for hybrid work with up to two days remote per week.

Duties and Responsibilities:

Administrate and integrate with Microsoft SQL Server so decent MSFT SQL DBA skill is required
Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB)
Include DB technology evaluation, guidance and consultation, design support, task automation and scripting, best practice and standards development, capacity planning, optimization and tuning, system upgrades and migrations, performance management, monitoring, security, backup and recovery, issue troubleshooting, and documentation.
Implement and Maintain Automated Processes using TSQL/PowerShell/Python/Terraform scripts.
Deploy, configure, monitor, and maintain databases in the production, development, and quality assurance environments.
Understand AWS-based architecture and closely work with DevOps, SecOps develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform.
Work with Operations & Development team planning server/server-less resource requirements to decide the proper size 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 for completing projects, working on deployments, and resolving system outages.
Responsible for level 2 systems management and exercises project-level control over initiatives.
Recommend and implement solutions for performance monitoring and tuning.
Carries out assignments with minimal coaching and guidance from others.
Develops, enhances, and adheres to engineering and administration standards. Upholds and maintains strong documentation.
To be placed on on-call rotation for a week every 3 months and respond to system alerts

Requirements

Mid to high-Level Microsoft SQL Server DBA Skill is required
Experience with at least one of the Pubic Cloud providers like AWS, Google Cloud Services.
Knowledge of Relational Database Management experience such as MS SQL, PostgreSQL, MySQL, Redshift is preferred.
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.
Strong AWS experience
Knowledge of monitoring tools such as Kibana, CloudWatch, DataDog, or any other tools, etc
Knowledge of automation and deployment tools & Scripts: MS Team Foundation Service, ELK, PRTG, Jenkins, Chef, Lamda, Terraform, Cloudfomation, etc
Experience with the implementation and support of SQL database replication.
Experience working with very large databases, upgrades, and troubleshooting performance, etc.
Experience with SQL Server High Availability Architecture (AlwaysOn) and troubleshooting.

Qualifications

Degree in computer science/information systems, engineering, or related field preferred; or a corresponding number of years' experience in technical operations or software engineering
5+ years of advanced Microsoft SQL Server DBA experience in large, complex environment
1-3 years of supporting a large data platform and data pipe-lining.
2-3 or more years of experience with NoSQL data platforms like Spark, Solr, MongoDB Atlas, DynamoDB.
2-3 years experience with relevant scripting languages or programming frameworks desired (PowerShell, Python, NodeJS, JavaScript, bash)
Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etc is a big plus.
Expertise in database administration for large Data warehouse/datamart implementations including configuration, implementation, data modeling, maintenance, redundancy/HA/DR, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL

Nice to have (Big Plus)

Cloud migration experience
Strong experience with Linux Server platform
Experience solving data engineering problems using technologies such as Spark, Solr.
NoSQL database experience (MongoDB/Hadoop/Redis/DynamoDB/Elastic Search).
Strong Cloud Database management experience (Redshift/Snowflake) Data warehouse or Data analytics
Knowledge of all aspects of Azure Database Engines (Managed Instances, Data Warehouse) including administration
Programming skills are valuable such as C#/.NET
AWS solution architect certification preferred
Azure solutions architect associate certification is nice to have

OVERVIEW OF COMPANY:

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; LoopNet, the most heavily trafficked mobile and online real estate marketplace; Apartments.com, the premier rental home resource for renters, property managers and owners; STR, the leading provider of performance benchmarking and comparative analytics to the hotel industry; BizBuySell , the largest online marketplace for businesses-for-sales; and Lands of America, the leading operator of online marketplaces for rural real estate.

Headquartered in Washington, DC, CoStar Group maintains offices throughout the U.S. and in Europe, Canada, and Asia with a staff of over 4,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. In addition to generous compensation and performance-based incentives, you'll be supported in both 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
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, as well as Segways and bikes available for use during the day
Complimentary gourmet coffee, tea, hot chocolate, prepared foods, fresh fruit, and other healthy snacks

Be part of a team of professionals enjoying the opportunity to learn, do, and grow in a rewarding atmosphere. But don't just take our word for it see why our team chose to work at and stay at CoStar Group:

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.

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing

#LI-AW2 #LI-Hybrid

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing

ID: #48921701
State: District of Columbia Washington 20001 Washington USA
City: Washington
Salary: USD TBD TBD
Job type: Permanent
Showed: 2023-01-30
Deadline: 2023-03-30
Category: Et cetera