Design, develop, and maintain scalable and robust database solutions and data transformation systems using advanced SQL techniques.
Transform and process large datasets from diverse sources, ensuring data integrity, quality, and consistency.
Optimize and build efficient SQL queries for data retrieval and manipulation; manage and interact with relational databases (MSSQL, PostgreSQL, Oracle, etc.).
Collaborate with cross-functional teams to understand data requirements and deliver innovative database solutions.
Implement data models and structures to support business intelligence, analytics, and reporting initiatives.
Leverage advanced SQL programming techniques and tools (e.g., stored procedures, triggers, indexing, partitioning) to solve complex data challenges.
Architect and implement automated solutions to enhance database intelligence and support next-generation analytics.
Work with AWS cloud services related to database management (AWS RDS, Athena, S3, Lambda, etc.).
Stay abreast of emerging trends in database technologies and proactively recommend improvements.
Integrate real-time data streaming solutions (e.g., Kafka, Kinesis) into database workflows.
(Good to have) Utilize Python scripting for automation, data transformation, or integration with