We are seeking a highly skilled and experienced senior principle database architect. The ideal candidate should have a proven track record in MS SQL databases. The senior principle database architect will be responsible for visualizing and designing a entertainment platform enterprise data management framework. This framework should describe the processes required to create, acquire, use, plan, specify, enable, maintain, retrieve, control, purge, and archive data. Data architects are supposed to create a strategy that lines up with the businesss processes and includes - Database development statuses, Data model designs, Data warehouse implementation and management, Data analytics systems implementation and management. Responsibilities Design, construct and further develop the data architecture of an enterprise platform Design concepts to make the flow of data supporting multiple clients as efficient as possible Classify and organize data and provide specifications for data quality Monitor and analyse data sources using databases and data warehousing tools Design schemes intended to accelerate the workflow of a company Translate idealistic concepts into practical forms Prepare a design for all metadata relating to various Extract/Transform/Load (ETL) processes Prepare the designs for needed database systems and recommend measures to improve performance Design different ETL processes and conduct tests on the data Define all metadata standards for the data warehouse Conduct troubleshooting on all ETL processes and effectively resolve any issues Analyse every data warehouse architecture goal and identify what skill requirements they require Develop and maintain database scripts and tools to make the automation process run smoother Analyse all the needed data warehouse activities and identify what essential resources they require Monitor processes and develop plans to expedite gathering and accessing all relevant metadata Develop and implement any needed project work plans Qualifications Strong and demonstrable experience as DBA in large-scale MS SQL environments. Experience with MS Azure and MS Azure managed instance databases. Documented hands-on expertise managing high-volume instances of MS SQL setups featuring high availability. Strong problem-solving skills, with the ability to get to the route of an issue quickly. Architects should be familiar with DevOps best practices and automation of processes like building, configuration, deployment, documentation, testing, and monitoring. Must have a broad understanding of Data Modelling, SQL, OLAP, and ETL, including practical experience with at least one ETL tool, such as SSIS. Understanding of a couple of BI and reporting platforms, an awareness of industry trends and direction in BI/reporting, Good communication and coordination skills and able to work efficiently under pressure. Diversity, Equity And Inclusion Program/Affirmative Action Plan We have transformed our company into an inclusive environment where individuals are valued for their talents and empowered to reach their fullest potential. At PrismHR, we strive to continually lead with our values and beliefs that enable our employees to develop their potential, bring their full self to work, and engage in a world of inclusion. Ensuring an inclusive environment for our employees is an integral part of the PrismHR culture. We aren't just checking a box, we are truly committed to creating a workplace that celebrates the diversity of our employees and fosters a sense of belonging for everyone. This is essential to our success. We are dedicated to building a diverse, inclusive, and authentic workplace, so if youre excited about our roles but your past experience doesnt align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for these open roles or other open roles. We particularly encourage applicants from traditionally under-represented groups as we seek to increase the diversity of our workforce and provide fair opportunities for all. The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company and prohibits unlawful discrimination by any employee of the Company, including supervisors and co-workers. Privacy Policy: For information about how we collect and use your personal information, please see our privacy statement available at https://www.prismhr.com/about/privacy-policy. PrismHR provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. If you have any difficulty using our online system and you need a reasonable accommodation due to a disability, you may use the following alternative email address to contact us about your interest in employment at PrismHR: hidden_email candidates being considered for a position who require an accommodation will receive a follow-up response.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & ConsultingRole Category: Not SpecifiedFunctional Area: Not SpecifiedRole/Responsibilies: Senior Principle Database Architect Job in