Database &

- Scripting Engineer (Mumbai) Company: Anlage Infotech (I Job Location: Mumbai, Maharashtra, India Employment Type: Full-time Experience Required: 5 - 7 years : Key Responsibilities :
- Query &
- Script Development : Develop, test, maintain, and optimize robust database queries, store procedures, triggers, views, and automation scripts to support data processing solutions. Data Operations (ETL/ELT) : Extract, transform, validate, and load high-volume data across multiple database environments, ensuring high performance, integrity, and operational consistency.

Performance Tuning : Troubleshoot database and scripting performance bottlenecks, optimize SQL execution plans, write efficient indexes, and re-engineer inefficient legacy scripts.

Process Automation : Leverage Python and shell/batch scripting to build end-to-end data pipelines, schedule batch processes, and automate repetitive data management tasks. Cross-Functional Collaboration : Partner closely with software engineering, data analytics, product management, and business teams to understand data requirements and translate them into efficient technical solutions. Data Quality &

- Governance : Establish validation rules, audit checks, and error-handling routines within scripts and database jobs to ensure high data accuracy and reliability.

System

Maintenance &

- Support : Perform root-cause analysis for production incidents related to databases or scripts,



applying timely resolution and preventative fixes. Technical &
- Professional Qualifications :
- Database Expertise : 5 - 7 years of hands-on experience with major relational database management systems (RDBMS) such as PostgreSQL, MySQL, MS SQL Server, or Oracle.

Advanced SQL : Expertise in writing complex SQL queries, analytical functions, CTEs, stored procedures, functions, and database views.

Scripting Languages : Solid proficiency in scripting languages (Shell/Bash, PowerShell) for task automation and basic-to-intermediate proficiency in Python for data processing and automation scripts. Data Modeling &

- Architecture : Valuable working knowledge of relational database schemas, normalization, indexing strategies, and database design principles. Problem-Solving &
- Logic : Excellent logical reasoning, debugging skills, and the ability to diagnose complex data anomalies and scripting issues. Preferred / Good-to-Have Skills : Modern Cloud Data Platforms : Awareness or hands-on experience with cloud data warehousing solutions like Snowflake, Databricks, or AWS Redshift.

Version Control : Familiarity with Git or similar version control systems for script and code repository management.

Scheduling Tools : Experience using job schedulers or orchestrators (e.g., Apache Airflow, Cron, Autosys). (ref:hirist.tech) .

Industry

IT Services &

- Consulting

📌 Database & Scripting Engineer (Mumbai)
🏢 Anlage Infotech (I
📍 Mumbai