Description

You will optimize analytics performance and manage data integrity across multiple relational database environments.

Responsibilities

• Optimize analytics performance by writing and tuning SQL queries on Amazon Aurora, Redshift, Oracle, Microsoft SQL Server, and Snowflake.
• Resolve PostgreSQL issues and long-running queries as a subject matter expert.
• Design technical solutions by translating stakeholder and business analyst requirements into data models.
• Diagnose and resolve database incidents and performance bottlenecks using monitoring tools.
• Document system architecture, user designs, and deployed system configurations.

Required Skills

• 5+ years of experience in database analysis and optimization.
• Expertise in writing complex SQL queries for data manipulation and reporting.
• Proficiency with PostgreSQL, Snowflake, and Oracle.
• Experience with performance tuning, including query optimization and index tuning.
• Ability to monitor database metrics and resource utilization.
• Hands-on experience using SQL tools such as DBeaver or SQL Workbench.
• Experience performing data quality validations and ensuring target table validity.
• Any graduate degree.

Key Skills

Education

Any gradudate