Required Skills

SQL POSTGRESQL DBA

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 20th Jul 2022

JOB DETAIL

. SQL Server

a. They need to be able to troubleshoot SQL DB – be expert on database internals like recovery models, transactions, checkpoints, backups etc.

2. Terraform – Infra as a Code in their cloud env.

3. Postgres SQL – migrating from MSSQL to Postgres

4. Working with Datasets in cloud env. GCP, AWS, Azure

5. Scaling databases

6. Scripting – with powershell

7. Configuration Management – puppet, ansible, Chef

Please brush up/ be prepared to speak on the following topics:

• SQL Server à migrations, upgrades, patching

• Working with cloud database technologies: SPECIFICALLY POSTGRES SQL

• Spinning up Postgres SQL from scratch

• Migrating databases from on prem to public cloud

• Experience/ knowledge of decoupling/refactoring databases

Description:

The Data Platforms Engineering team is responsible for the core technologies that underlie a cutting-edge ecommerce business and exceptional customer experience, from order processing and logistics optimization to machine learning and AI. Our team is looking for smart, passionate, and curious people who are excited to help us scale our distributed storage, data processing, and analytics platforms.

With the broad set of technologies we are using and the scale at which our systems operate, you will have the opportunity to grow your skills and be exposed to new people and ideas who work on a diverse set of cutting-edge technologies. If you are the type of person who is fascinated by engineering extremely large deployments of high-volume systems, skilled in designing scalable automation for maintaining them, and are passionate about troubleshooting challenging technical problems involving

distributed systems, we should talk.

What You’ll Do

- Implement solutions and automation for managing terabyte-scale database environments

- Improve observability by addressing gaps in our monitoring, tracing and logging.

- Contribute to triaging production incidents by helping to drive resolution, identify root cause, and pinpoint changes required to prevent future occurrences

- Participate in on-call rotation supporting and troubleshooting database issues off-hours and during promotional events

- Provide a high level of customer-service by fulfilling customer requests in a timely manner that meets established Service Levels, and offer solutions that utilize established industry best practices.

- Mentor junior engineers to develop the next generation of engineering

Skills:

Database administrator, Sql, Postgresql, terraform

Top Skills Details:

Database administrator, Sql, Postgresql, terraform

Additional Skills & Qualifications:

Experience with Database decoupling

Experience working with public cloud providers such as GCP, AWS, or Azure, and running database systems at large scales/volumes

- Experience with infrastructure as code and configuration management tools such as Terraform and Puppet

- Experience in driving complex technical projects and collaborating with other teams across organization boundaries

- Strong written and oral communication skills with a high degree of comfort speaking with developers, vendors and leadership

Company Information