System Engineer

• Noida, Uttar Pradesh, India
• Permanent
• Database
• 2 - 5 years

System Engineer

Key Responsibilities:

• 
  Design and manage database architecture for OLTP and OLAP systems.

• 
  Implement and oversee replication, sharding, and backup drills.

• 
  Optimize performance through indexing, query tuning, and resource allocation.

• 
  Implement validation, cleaning, and monitoring to ensure data accuracy.

• 
  Improve data system performance, storage, and efficiency

• 
  Create, review, and optimize complex SQL queries.

• 
  Manage integration with Big Data systems, Data Lakes, Data Marts, and Data Warehouses, Snowflake.

• 
  Use Python scripting for automation and custom DBA tools.

• 
  Collaborate with DevOps, engineering, and analytics teams.

Qualifications:

• 
  Strong experience with replication, sharding, backup & disaster recovery.

• 
  Expertise in database performance tuning, architecture, and query optimization.

• 
  Proficiency in MongoDB, PostgreSQL, ClickHouse, AWS Redshift, or similar databases & data warehouses.

• 
  Hands-on with Python scripting for automation.

• 
  Experience in Linux-based systems and AWS services.

• 
  Solid understanding of OLTP, OLAP, Data Lakes, Data Marts, and Data Warehouses.

• 
  Strong analytical, debugging, and leadership skills.

Preferred:

• Experience with NoSQL, Big Data tools (PySpark, Python, Docker, Kafka).

• 
  Certifications in AWS, Linux, or leading database technologies.