Data 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.
2 - 5 years
Any graduation
Replication , MongoDB , PostgreSQL , Python , Big Data , Linux , Online Transaction Processing (OLTP) , OLAP , Data Warehouse