Description

You will develop and maintain the core database infrastructure.

Responsibilities

• Build and optimize database schemas based on business requirements, including designing Entity-Relationship diagrams and normalization strategies.
• Write and tune complex SQL queries against the designed database schema.
• Implement indexing strategies and troubleshoot performance bottlenecks to maintain system efficiency.
• Design and implement database objects such as views, stored procedures, and triggers.

Required Skills

• 8+ years of experience with SQL Server or similar relational databases.
• Proven experience in data modeling, including ER diagrams, relationships, and normalization.
• Expertise in SQL query development, covering complex joins, subqueries, and aggregations.
• Strong ability to design database schemas from detailed business requirements.
• Good understanding of indexing, performance tuning, and optimization strategies.
• Experience with SQL.
• Familiarity with ETL processes.

Preferred Skills

• Experience with Data Warehousing.
• Familiarity with data modeling tools like ER/Studio or PowerDesigner.

Key Skills

Education

Bachelor's degree