AWS Data Engineer (Standard)

As a SQL Developer, you will be responsible for designing, developing, and managing SQL-based databases to ensure the efficient storage, retrieval, and processing of data. You will write complex queries, optimize performance, and support data-driven decision-making by ensuring the integrity, security, and accessibility of data across the organization. The ideal candidate will have a strong background in SQL programming, relational databases, and a keen eye for detail when working with data.

Key Responsibilities:-

Design and implement relational databases, tables, views, indexes, and stored procedures to support application features and data processes.

Write and optimize complex SQL queries to retrieve, manipulate, and analyze large datasets efficiently.

Create and maintain database schemas, including data models and relationships between tables.

Develop and maintain stored procedures, triggers, and functions to automate repetitive tasks and improve system performance.

Perform regular database optimization and tuning, including query optimization and indexing strategies.

Troubleshoot and resolve database-related performance issues and ensure consistent data quality.

Conduct data analysis and reporting using SQL to support business intelligence and decision-making processes.

Collaborate with cross-functional teams (developers, data analysts, business stakeholders) to gather data requirements and implement solutions.

Ensure data security, privacy, and compliance with internal and external regulations.

Monitor and maintain the health of the database environment, including backups, disaster recovery, and security patches.

Document database processes, queries, and procedures for reference and knowledge sharing.

Participate in code reviews and contribute to database best practices within the team.

Required Skills & Qualifications:-

Proven experience as an SQL Developer or in a similar database development role.

Strong proficiency in SQL, including the ability to write complex queries, joins, and subqueries.

Experience with relational databases (e.g., MySQL, PostgreSQL, MS SQL Server, Oracle, etc.) and related database tools.

Experience with database design, normalization, and optimization techniques.

Knowledge of data modeling and schema design.

Familiarity with database administration tasks, including backups, replication, and performance tuning.

Strong problem-solving skills and ability to troubleshoot database performance and data quality issues.

Excellent attention to detail and ability to work with large datasets.

Knowledge of version control systems (e.g., Git) and working in collaborative environments.

Strong communication skills, both written and verbal, and the ability to work effectively with non-technical teams.