- Moonli
- Full-time · Mid
- 5+ years
Design, develop, test, and optimize database systems, complex queries, stored procedures, and data pipelines.
Responsibilities
- Write, maintain, and optimize complex SQL queries, views, indexes, stored procedures, triggers, and user-defined functions (UDFs)
- Perform query performance tuning using execution plans, indexing strategies, partitioning, and caching techniques
- Analyze and resolve database performance bottlenecks, locking/deadlock issues, and resource contention
- Assist in designing conceptual, logical, and physical data models (relational schemas, star/snowflake dimensional models)
- Enforce relational integrity, constraints, data normalization, and denormalization standards based on operational (OLTP) and analytical (OLAP) requirements
Requirements
- Nice to have: Java
- Nice to have: Visual Studio
- Nice to have: Ab Initio