Database Administrator - India

POSITION SUMMARY

We are seeking a highly skilled Database Administrator (DBA) to join our team in India and manage critical components of our SaaS platform, leveraging the power of AWS and other Cloud Data Warehouse providers. The ideal candidate will have a deep understanding of Data Warehouses, data modeling, and performance optimization techniques, coupled with a strong grasp of cloud technologies.

This role requires a strong blend of technical expertise, problem-solving skills, and a passion for data. You'll be working in a fast-paced environment, collaborating with cross-functional teams to deliver innovative data solutions.

KEY RESPONSIBILITIES

Data Modeling and Engineering:

• Design and implement efficient data models to support business requirements.
• Create and maintain data pipelines to ensure data integrity and consistency.
• Optimize data storage and indexing strategies to improve query performance.
• Collaborate with data engineers and analysts to design and implement data solutions.

Cloud Integration:

• Integrate Cloud Data Warehouses (CDWs) with AWS and Azure services to leverage their capabilities.
• Configure and manage cloud resources (VMs, storage, networks) to support CDWs.
• Implement automated deployment and provisioning processes using infrastructure as code (IaC) tools.
• Monitor cloud costs and optimize resource utilization.

Performance Optimization:

• Analyze query performance and identify bottlenecks.
• Tune queries and optimize database configurations to improve performance.
• Implement caching strategies to reduce query execution time.
• Monitor resource utilization and adjust resource allocations as needed.

Security and Compliance:

• Implement robust security measures to protect sensitive data.
• Monitor and enforce security policies and procedures.
• Conduct regular security audits and vulnerability assessments.
• Ensure compliance with industry standards and regulations, including GDPR, HIPAA, and SOC 2.

Backup and Recovery:

• Implement and maintain backup and recovery strategies.
• Test recovery procedures to ensure data integrity.
• Implement disaster recovery plans to minimize downtime in case of failures.

Troubleshooting and Support:

• Diagnose and resolve database issues.
• Provide technical support to users.
• Collaborate with other teams to ensure smooth operations.

JOB REQUIREMENTS

• Bachelor's degree in computer science, information systems or comparable experience.
• 5+ years of experience as a Database Administrator;
• Strong understanding of cloud data warehouses, features, and best practices;
• Proficiency in SQL and Python;
• Experience with data modeling and ETL processes;
• Knowledge of cloud platforms (AWS and Azure) and their services;
• Strong analytical and problem-solving skills;
• Excellent communication and interpersonal skills;
• Ability to work independently and as part of a team;
• Experience with infrastructure as code (IaC) tools like Terraform or CloudFormation;
• Understanding of security best practices and compliance standards;
• Availability to provide on-call support and handle out-of-band requests;

Familiarity with a wide range of database admin.

INDIA BENEFITS & PERKS

• Medical insurance provided
• Maternity and paternity leave policies
• Baby bucks: a cash allowance to spend on anything for every newborn or child adopted
• “Haute Mama”: cash allowance for maternity wardrobe benefit (only for women employees)
• Annual leave of 18 days + 10 holidays + 12 sick leaves
• Sodexo Meal Pass
• Health and Wellness Benefit
• One-time Technology Benefit: cash allowance towards the purchase of a tablet or smartwatch
• Corporate National Pension Scheme
• Employee Assistance Programme (EAP)
• Marriage leaves up to 3 days
• Bereavement leaves up to 5 days