About the job
Orion Innovation stands as a distinguished, award-winning global business and technology services firm. We specialize in transformative business solutions and product development driven by digital strategy, innovative design, and engineering excellence. Our unique blend of agility, scalability, and maturity enables us to partner with a diverse set of clients across various sectors, including financial services, telecommunications, media, consumer products, automotive, industrial automation, professional sports, life sciences, e-commerce, and education.
Job Responsibilities:
• Design and implement robust data models that meet both application and business requirements, ensuring they are scalable and efficient.
• Define and maintain database schemas, ensuring proper structure and compliance with best practices.
• Develop and optimize indexing strategies to boost query performance and overall database efficiency.
• Manage data ingestion processes for seamless integration of data from various sources.
• Oversee data export processes to support reporting, analytics, and external system integration.
• Serve as the primary owner of all database systems, ensuring reliability, security, and performance.
• Review and validate database-related contributions from team members to ensure quality and consistency.
• Mentor and guide team members on best practices in database design, development, and optimization.
• Establish and enforce database governance policies, including naming conventions and access controls.
• Monitor and analyze database performance, proactively identifying and resolving bottlenecks.
• Design, develop, and maintain complex SQL stored procedures to support application development and data processing.
• Perform performance tuning and optimization of SQL queries and databases for efficient data retrieval.
• Integrate with Azure Data Lake Storage (ADLS) for seamless data access.
• Manage and maintain Azure SQL databases to ensure high availability and security.
• Implement data lake integration strategies to facilitate analytics and reporting.
• Develop and manage Azure Data Factory (ADF) pipelines for data movement and transformation.
• Oversee database management and sharding concepts to ensure scalability and performance.
