Description

Maintain and develop OLTP and OLAP data warehouse databases, including performance optimization, migration support, and reporting.

Responsibilities

• Develop and write SQL scripts, stored procedures, functions, and triggers for OLTP and OLAP systems.
• Implement indexes and manage database backup and recovery processes.
• Support database migration efforts, including SSIS migrations across various server versions.
• Perform database performance optimization, including implementing partitioning and supporting distributed databases.
• Develop drill-through and drill-down reports using SQL Server Reporting Services (SSRS).

Required Skills

• 5+ years of experience with OLTP and OLAP Data Warehouse Databases.
• Proficiency in SQL Scripting, Data Modeling, and database design.
• Experience writing and debugging Stored Procedures, Views, and Triggers.
• Familiarity with RedGate, Teradata, and Jira.
• Ability to automate tasks using PowerShell.
• Familiarity with SOP and SLA documentation.

Preferred Skills

• Master's degree in a relevant technical field.
• Experience maintaining database systems for 3 years or more.

Key Skills

Education

Master's degree