Vacancy expired!
Senior Cloud Database Engineer Job Description
CoStar Group serves up over 1PB of data from more than 700 SQL Servers that span four On-Premise 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, MongoDB Atlas, ELK, DynamoDB and other DB engines on the cloud. Our highly motivated, extremely talented DBA group is looking for an exceptionally bright Senior Cloud Database Engineer 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 and .NET technologies for major applications and our responsibility has expanded to also support MongoDB, Aurora MySQL, DynamoDB, ELK and many more. As a member of the team, you will be relied on for your problem solving, communication, collaboration, project management, and process adherence skills.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
- Mid to high-Level Microsoft SQL Server DBA Skill is required
- The ideal candidate will have experience with at least one of the Pubic Cloud providers like AWS, Google Cloud Services.
- Deep 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
- Deep Knowledge of monitoring tools such as Kibana, CloudWatch, DataDog, or any other tools, etc
- Deep 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.
- Degree in computer science/information systems, engineering, or related field preferred; or a corresponding number of years' experience in technical operations or software engineering
- 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
- Cloud migration experience also a plus.
- 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
- Having knowledge of all aspects of Azure Database Engines (Managed Instances, Data Warehouse) including administration
- Any other programming skills are valuable such .Net.
- AWS solution architect certification preferred
- Azure solutions architect associate certification is nice to have
- 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
Vacancy expired!