Profile

• 4+ years of experience in SQL Server (and PostgreSQL) development.
• Expert proficiency in writing complex and highly optimized SQL queries, stored procedures, functions, and triggers.
• Thorough understanding of T-SQL, indexes, query plans, blocking, transactions, etc, to perform optimizations.
• Understanding of database design principles and best practices.
• Experience in built-in and external DB tools, including SQL profiler, DM, V, etc.
• Experience working with large databases will be a plus.
• Priority will be given to candidates who can join immediately.

Responsibilities

• Manage and enhance existing SQL Server and PostgreSQL tables, views, and stored procedures.
• Work with the business team to understand requirements and implement necessary database changes.
• Design and develop new tables, views, and stored procedures to support business needs.
• Optimize database (SQL Server and Postgres) performance through indexing, query tuning, and other best practices.
• Work with the architecture team to provide insights and suggestions for database design and improvements.
• (Bonus) Experience with ETL processes, Python, and Apache Airflow is a plus.