Database Analyst

REQUIRED SKILLS & EXPERIENCE:
Optimizing analytics performance by writing SQL queries on the data that resides in a relational database, including Amazon Aurora, Redshift, Oracle, Microsoft SQL Server, and Snowflake
Serve as a SME to resolve issues and long running queries on PostgreSQL
Work closely with stakeholders to understand the business requirements that drive the analysis and design of quality technical solutions
Create and update documentation to confirm architecture, user, design, and other documents describing the deployed system
Work closely with customers, business analysts and team members to understand the business requirements that drive the analysis and design of quality technical solutions
Create SQL queries for Data Quality validations
Writing complex SQL queries for reporting and ensuring data validity in target tables
Develop SQL queries to extract, manipulate, and/or calculate information
Data and reporting requirements including identifying the needed tables and columns
Capture details and required information to assign/resolve defects during Defect Management
Use SQL querying tools like DBeaver, SQL Workbench etc.

SKILL SET (Must Have):
Performance Tuning and Optimization: Identify and resolve database performance issues, including query optimization, index tuning, and resource utilization. Monitor database performance metrics and implement improvements to optimize performance
Database Monitoring and Troubleshooting: Monitor database activity and performance using database monitoring tools. Diagnose and resolve database-related issues and incidents, working closely with cross-functional teams to ensure timely resolution.