Data Systems Engineer

4 days ago

India ADVATIX - Advanced Supply Chain and Logistics Full time

As a Data Systems Engineer at ADVATIX - Advanced Supply Chain and Logistics, you will be responsible for managing and maintaining high-performance databases to ensure seamless data flow throughout our supply chain operations.

The estimated salary for this role is $120,000 - $180,000 per year, based on industry standards and the candidate's level of experience.

Job Description

We are seeking an experienced professional with expertise in MySQL and MariaDB database administration, particularly in high-availability environments using Galera Cluster and ProxySQL. The ideal candidate will have strong knowledge of SQL performance tuning, query optimization, and backup/recovery processes. Experience with Linux environments, shell scripting, and automation tools such as Ansible is also highly desirable.

Key Responsibilities:
  • Manage and administer MySQL and MariaDB databases, ensuring high performance, scalability, and reliability.
  • Implement and manage robust backup and recovery processes, ensuring minimal data loss in case of system failures.
  • Schedule and monitor regular backups, including full, incremental, and point-in-time recovery (PITR) strategies to meet RPO/RTO requirements.
Galera Cluster Management:
  • Configure, deploy, and maintain Galera Clusters for high availability and redundancy.
  • Troubleshoot and resolve issues specific to Galera replication, including split-brain and quorum loss.
  • Monitor cluster health, manage failover processes, and ensure data consistency across nodes.
ProxySQL Configuration and Management:
  • Set up and manage ProxySQL as a high-performance middle layer for routing SQL queries and load balancing.
  • Optimize ProxySQL configurations, including query caching, user management, and query rules.
  • Ensure seamless connectivity between applications and database clusters, leveraging ProxySQL features for high availability.
Performance Tuning and Query Optimization:
  • Analyze and optimize slow queries, indexing, and database schema design for better performance.
  • Utilize monitoring tools and techniques to proactively identify and address performance bottlenecks.
  • Work closely with development teams to optimize SQL queries and improve overall database performance.
Monitoring, Automation, and Scripting:
  • Set up and maintain database monitoring solutions for real-time insights and alerts on database health.
  • Automate routine DBA tasks such as backups, log rotation, and health checks using shell scripts.
  • Experience with shell scripting, Ansible, or other automation tools is a strong advantage to improve efficiency and reduce manual workload.
Security and Compliance:
  • Ensure databases are secure and compliant with data protection regulations and company policies.
  • Implement and manage access controls, audit trails, and data encryption.
  • Work with security teams to conduct periodic audits and vulnerability assessments.

  • Data Warehouse Engineer | Data Warehouse Engineer | india

    2 weeks ago

    india Data Warehouse Engineer Full time

    Experience : 2- 5 YearsPrimary Skills : Strong SQL knowledge, Data warehouse concepts and ETL hands on experience, Azure services like Data Factory, Azure Data Lake, and Good analysis skills.Good to have skills: Power BI, Databricks, Python.

  • Data Warehouse Engineer

    2 weeks ago

    India Data Warehouse Engineer Full time

    Experience : 2- 5 Years Primary Skills : Strong SQL knowledge, Data warehouse concepts and ETL hands on experience, Azure services like Data Factory, Azure Data Lake, and Good analysis skills. Good to have skills: Power BI, Databricks, Python.

  • Data Warehouse Expert for Analytics Projects

    2 weeks ago

    India Data Warehouse Engineer Full time

    About the RoleWe are seeking an experienced Data Warehouse Engineer to join our team. In this role, you will design, develop, and maintain data warehouses that support business intelligence and analytics initiatives.

  • Senior Data Integration Engineer | Senior Data Integration Engineer | india

    2 weeks ago

    india Senior Data Integration Engineer Full time

    Must Have Skills/Skill Requirement:Design and architect integration solutions to connect various enterprise applications, systems, and databases.Develop and implement integration workflows, APIs, and data pipelines to enable smooth communication and data exchange between different applications.Utilize Azure Integration Services such as Azure Logic Apps,...

  • Senior Data Integration Engineer | Senior Data Integration Engineer | india

    2 weeks ago

    india Senior Data Integration Engineer Full time

    Must Have Skills/Skill Requirement: Design and architect integration solutions to connect various enterprise applications, systems, and databases. Develop and implement integration workflows, APIs, and data pipelines to enable smooth communication and data exchange between different applications. Utilize Azure Integration Services such as Azure Logic Apps,...

  • Senior Data Integration Engineer

    2 weeks ago

    India Senior Data Integration Engineer Full time

    Must Have Skills/Skill Requirement: Design and architect integration solutions to connect various enterprise applications, systems, and databases. Develop and implement integration workflows, APIs, and data pipelines to enable smooth communication and data exchange between different applications. Utilize Azure Integration Services such as Azure Logic...

  • Ubique Systems | Cloud Data Engineer

    4 days ago

    india Ubique Systems Full time

    Role: Cloud Data Engineer Location: Gurugram/ Noida/Pune/Bengaluru (hybrid) Shift: Rotational shift 24*7 Experience: 4+ YearsJob Description:🔹 Design and Build Data Pipelines using Azure Data Factory (ADF), SQL Queries, and Synapse Analytics 🔹 Develop Power BI reports to provide actionable insights for our clients 🔹 Enhance Data Ingestion Pipelines...

  • ITI Data | PySpark Data Engineer

    2 days ago

    india ITI Data Full time

    Location : IndiaType : Full-timeExperience : 10 – 13 years Functions : Consulting, Finance, Information Technology, Big Data Engineering Industries : Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, HealthcareJob DescriptionWe are looking for a PySpark solutions...

  • ITI Data | PySpark Data Engineer

    1 day ago

    india ITI Data Full time

    Location : India Type : Full-time Experience : 10 – 13 years Functions : Consulting, Finance, Information Technology, Big Data Engineering Industries : Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, Healthcare Job Description We are looking for a PySpark...

  • Data Engineering Specialist

    4 days ago

    India Ubique Systems Full time

    Job OverviewUbique Systems is seeking a skilled Cloud Data Engineer to join our team. As a key member of our data engineering team, you will design and build scalable data pipelines using Azure Data Factory (ADF), SQL Queries, and Synapse Analytics.ResponsibilitiesWe are looking for a talented individual with experience in designing business intelligence...

  • PySpark Data Engineer

    1 day ago

    India ITI Data Full time

    Location : India Type : Full-time Experience : 10 – 13 years Functions : Consulting, Finance, Information Technology, Big Data Engineering Industries : Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, Healthcare Job Description We are looking for a PySpark...

  • PySpark Data Engineer

    5 hours ago

    India ITI Data Full time

    Location : IndiaType : Full-timeExperience : 10 – 13 years Functions : Consulting, Finance, Information Technology, Big Data Engineering Industries : Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, HealthcareJob DescriptionWe are looking for a PySpark solutions...

  • Ubique Systems | Cloud Data Engineer | india

    4 days ago

    india Ubique Systems Full time

    Role: Cloud Data Engineer Location : Gurugram/ Noida/Pune/Bengaluru (hybrid) Shift: Rotational shift 24*7 Experience : 4+ Years Job Description:

  • Ubique Systems | Cloud Data Engineer | india

    4 days ago

    india Ubique Systems Full time

    Role: Cloud Data Engineer Location : Gurugram/ Noida/Pune/Bengaluru (hybrid) Shift: Rotational shift 24*7 Experience : 4+ Years Job Description: Design and Build Data Pipelines using Azure Data Factory (ADF), SQL Queries, and Synapse Analytics Develop Power BI reports to provide actionable insights for our clients Enhance Data Ingestion...

  • Aws data engineer

    2 weeks ago

    India ITI Data Full time

    Job Description We are looking for an AWS Data with primary skills on Py Spark development who will be able to design and build solutions for one of our Fortune 500 Client programs, which aims towards building an Enterprise Data Lake on AWS Cloud platform, build Data pipelines by developing several AWS Data Integration, Engineering & Analytics resources....

  • Ubique Systems | Data Architect

    4 days ago

    india Ubique Systems Full time

    We are looking for a Data Architect with:Location: Delhi NCR, Hyderabad, Bangalore, Pune, Chennai12+ Years of experience for the below:• Experience in cloud platform expertise (Azure, AWS, Google Cloud).• Strong knowledge of managing security infrastructure and applications.• Direct, hands-on experience or strong working knowledge of vulnerability...

  • Yield Engineering Systems | Systems Modeling Engineer

    4 days ago

    india Yield Engineering Systems Full time

    YES (Yield Engineering Systems, Inc.) is a leading manufacturer of reliable, high-tech, cost-effective capital equipment that transforms materials and surfaces at the nanoscale. From startups to the Fortune 50, our customers rely on YES to help them unleash products that change lives – from cell phones and IoT devices to AI and virtual reality, to...

  • AWS Data Engineer

    4 months ago

    India ITI Data Full time

    Job Description We are looking for an AWS Data with primary skills on PySpark development who will be able to design and build solutions for one of our Fortune 500 Client programs, which aims towards building an Enterprise Data Lake on AWS Cloud platform, build Data pipelines by developing several AWS Data Integration, Engineering & Analytics resources....

  • AWS Data Engineer

    4 months ago

    India ITI Data Full time

    Job DescriptionWe are looking for an AWS Data with primary skills on PySpark development who will be able to design and build solutions for one of our Fortune 500 Client programs, which aims towards building an Enterprise Data Lake on AWS Cloud platform, build Data pipelines by developing several AWS Data Integration, Engineering & Analytics resources. There...

  • AWS Data Engineer

    1 month ago

    india ITI Data Full time

    Job Description We are looking for an AWS Data with primary skills on PySpark development who will be able to design and build solutions for one of our Fortune 500 Client programs, which aims towards building an Enterprise Data Lake on AWS Cloud platform, build Data pipelines by developing several AWS Data Integration, Engineering & Analytics resources....