Dev DBA

Simfluent; Dadri; Hybrid; INR 1,400,000 - 2,100,000; Full time

Job summary

ShyftLabs in India is seeking a Dev DBA to collaborate with engineers to build and maintain software solutions that require robust interaction with databases. The role requires strong knowledge of Oracle, MSSQL and PostgreSQL, with a focus on SQL tuning and performance troubleshooting.

The ideal candidate will work independently as well as part of a team in a fast-paced environment, adapting to new tasks quickly and ensuring governance and testing standards across prod and non-prod databases.

Qualifications

• 6+ years of experience in a similar role.
• +2 years of proven experience troubleshooting performance issues and doing sql tuning.
• Strong organizational and time-management skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Adaptability and flexibility to changing circumstances and priorities.

Responsibilities

• Requirements definition
• Data modeling
• Build and maintain database objects required by applications (tables, indexes, views, triggers, functions, procedures, etc.)
• Build and maintain test data
• Assist with SQL and performance tuning
• Quality assurance (Efficient SQL statements and index strategy, programming best practices)
• Design and implement a standard testing methodology that includes reporting, measuring and assessing performance results
• Constant looking for ways to improve system performance
• Respond to prod database-related app issues and incidents
• Troubleshooting and solving performance issues
• Logical database refreshes (schema-based)
• Support governance compliance in non-prod databases (Data redaction)
• Respond to database-related issues and incidents, and help with troubleshooting and solving
• Change management
• Incident management
• Problem management

Skills

Oracle

MSSQL

PostgreSQL

SQL tuning

Performance troubleshooting

Database object development

Data modeling

Change management

Incident management

Job description

Role Overview

As a Dev DBA you will collaborate with programmers, architects and infrastructure DBAs to build and to maintain software solutions that require interacting with databases. Good knowledge on database technologies like Oracle, MSSQL and Postgres are desirable skills. We are seeking a highly motivated and experienced professional to join our team. The ideal candidate will have the ability to work independently, as well as collaboratively in a fast-paced environment. This position requires someone who is flexible, adaptable, and able to take on new tasks and responsibilities quickly. ShyftLabs is a growing data product company founded in early 2020 and works primarily with Fortune 500 companies. We deliver digital solutions built to help accelerate the growth of businesses in various industries, by focusing on creating value through innovation

Responsibilities

• Requirements definition
• Data modeling
• Build and maintain database objects required by applications (tables, indexes, views, triggers, functions, procedures, etc.)
• Build and maintain test data
• Assist with SQL and performance tuning
• Quality assurance (Efficient SQL statements and index strategy, programming best practices)
• Design and implement a standard testing methodology that includes reporting, measuring and assessing performance results
• Constant looking for ways to improve system performance
• Respond to prod database-related app issues and incidents
• Troubleshooting and solving performance issues
• Logical database refreshes (schema-based)
• Support governance compliance in non-prod databases (Data redaction)
• Respond to database-related issues and incidents, and help with troubleshooting and solving
• Change management
• Incident management
• Problem management

Requirements

• Oracle
• MSSQL
• PostgreSQL
• SQL tuning
• Performance troubleshooting
• Database object development
• Data modeling
• Change management
• Incident management

Qualifications

• 6+ years of experience in a similar role
• +2 years of proven experience troubleshooting performance issues and doing sql tuning
• Strong organizational and time-management skills
• Excellent communication and interpersonal skills
• Ability to work independently and as part of a team
• Adaptability and flexibility to changing circumstances and priorities
• Proficiency in relevant systems and technologies