Description

Act as the primary subject matter expert for database technologies, architectures, and infrastructure operability.

Responsibilities

• Design and implement physical and logical database schemas, including dimensional data models and star schemas for data marts.
• Manage end-to-end performance, uptime, and scalability of service processes to meet SLAs through on-call monitoring.
• Develop and optimize ETL solutions, packages, and queries to improve processing speed and data warehouse efficiency.
• Troubleshoot complex database issues and implement solutions to enhance system security and capacity.
• Build and maintain reporting infrastructure using SSRS and Power BI to monitor business metrics and processes.

Required Skills

• 5+ years of experience in database administration and engineering.
• Expertise in Microsoft SQL Server administration and development.
• Strong proficiency in Oracle PL/SQL for developing complex packages and programs.
• Hands-on experience with ETL design and implementation.
• Advanced knowledge of SSRS for report optimization and dashboard creation.
• Experience with Power BI using custom SQL query data sources.
• Deep understanding of Data Architecture, including normalization and dimensional modeling.
• Ability to perform query optimization and tuning for stored procedures and database objects.
• Experience working within agile methodologies to deliver data models and requirements.

Preferred Skills

• Experience with listener configuration support and operational data warehouse architecture.

Key Skills

Education

Any Graduate