Senior SQL Database Developer
votre rôle
mission / role purpose
As a Senior SQL Database Developer, you will be expected to define the strategy for our Enterprise Data across the various business units, including:
Leading and enforcing the strategic design and maintenance of the data warehouse and business intelligence applications
Administer and/or refine the current database environments and data governance strategies to align with corporate strategic objectives
Mentoring and coaching team members on best practices
key responsibilities
Prioritize workload and produce highly confident estimates for all solution implementations
Capture, document and analyze business requirements: transitioning to technical solutions
Provide technical guidance, establishing oneself as an advisor to the cross-functional BI stakeholders
Maintain a high level of awareness of the current and future database technologies and best practices
Model database systems for performance and scalability
Partner with the Tools Lifecycle and Project Management team, BI users, other developers and Operations & Performance Management teams to define requirements, troubleshoot issues, fix bugs and build out new solutions
Administer SQL Server databases (2005 – 2016, on-prem and Azure)
Write SQL including stored procedures, macros and ETL packages
Design and develop logical and physical data models and databases
Monitor and proactively plan for database expansion and performance by understanding the business growth, plans and requirements
votre profil
knowledge and abilities
10+ years hands on database experience including database development and administration within Microsoft SQL Server environment which includes SQL Server, SSIS, SSAS and SSRS.
Strong project management disciplines and communication skills, including a demonstrated track record in managing and delivering multiple projects with aggressive timelines in a fast-paced environment
BS degree in computer science, MIS or other related technical discipline is required
Experience with Replication, Azure and/or Power BI is a strong plus
Excellent knowledge of SQL and relational database systems
Extensive technical knowledge and experience in database management techniques including logical data modeling, physical database optimization, data distribution, security, and database performance monitoring
Knowledge and awareness of networking and storage impacts pertaining to database design, optimization, and implementation within a VM environment
Proven experience in strategies/techniques for implementing data warehousing/BI support systems
Knowledge of high availability, fault tolerance, and disaster recovery strategies
A history of increasing responsibility in the database arena
Good Communication- Negotiations and facilitation and get everyone to consensus
Ability to communicate technical issues to non-technical users in multiple time zones
le plus de l'offre
education, qualifications, certifications, and experience
Bachelor’s or master’s degree in related technical field
8+ years of associated work experience
8+ years of SQL Server experience with at least 3+ years using SQL2012 and above. Expert in Microsoft SQL server and other back-end MS technologies, including SSIS, SSRS and SSAS
4+ years of good data analysis experience using Microsoft Excel, MS Access, VBA, and other similar tools, including excel based reporting, power pivots, power BI and others
Provides leadership and technical direction for the development, design, and systems integration for various business requirements from definition phase through implementation
Microsoft certified professional (BI, SQL, .NET) - Azure/Cloud implementation experience and knowledge. SQL Server certifications
Strong Database (SQL Server) and Programming experience background
Ability to understand the various data sets available in the Orange Business Services environment to architect, design and develop solutions to current business situations
entité
Orange Intl Ntwk Infr & Svcs
Orange Business manages and integrates the complexity of international communications, freeing our customers to focus on the strategic initiatives that drive their business. Our extensive experience and knowledge in global communication solutions, together with our understanding of multinational business and local support in 166 countries and territories, ensure that our customers receive a consistent, global solution wherever they do business.
contrat
CDI
Rabat,Morocco:Technopolis B6
mission / role purpose
As a Senior SQL Database Developer, you will be expected to define the strategy for our Enterprise Data across the various business units, including:
Leading and enforcing the strategic design and maintenance of the data warehouse and business intelligence applications
Administer and/or refine the current database environments and data governance strategies to align with corporate strategic objectives
Mentoring and coaching team members on best practices
key responsibilities
Prioritize workload and produce highly confident estimates for all solution implementations
Capture, document and analyze business requirements: transitioning to technical solutions
Provide technical guidance, establishing oneself as an advisor to the cross-functional BI stakeholders
Maintain a high level of awareness of the current and future database technologies and best practices
Model database systems for performance and scalability
Partner with the Tools Lifecycle and Project Management team, BI users, other developers and Operations & Performance Management teams to define requirements, troubleshoot issues, fix bugs and build out new solutions
Administer SQL Server databases (2005 – 2016, on-prem and Azure)
Write SQL including stored procedures, macros and ETL packages
Design and develop logical and physical data models and databases
Monitor and proactively plan for database expansion and performance by understanding the business growth, plans and requirements
votre profil
knowledge and abilities
10+ years hands on database experience including database development and administration within Microsoft SQL Server environment which includes SQL Server, SSIS, SSAS and SSRS.
Strong project management disciplines and communication skills, including a demonstrated track record in managing and delivering multiple projects with aggressive timelines in a fast-paced environment
BS degree in computer science, MIS or other related technical discipline is required
Experience with Replication, Azure and/or Power BI is a strong plus
Excellent knowledge of SQL and relational database systems
Extensive technical knowledge and experience in database management techniques including logical data modeling, physical database optimization, data distribution, security, and database performance monitoring
Knowledge and awareness of networking and storage impacts pertaining to database design, optimization, and implementation within a VM environment
Proven experience in strategies/techniques for implementing data warehousing/BI support systems
Knowledge of high availability, fault tolerance, and disaster recovery strategies
A history of increasing responsibility in the database arena
Good Communication- Negotiations and facilitation and get everyone to consensus
Ability to communicate technical issues to non-technical users in multiple time zones
le plus de l'offre
education, qualifications, certifications, and experience
Bachelor’s or master’s degree in related technical field
8+ years of associated work experience
8+ years of SQL Server experience with at least 3+ years using SQL2012 and above. Expert in Microsoft SQL server and other back-end MS technologies, including SSIS, SSRS and SSAS
4+ years of good data analysis experience using Microsoft Excel, MS Access, VBA, and other similar tools, including excel based reporting, power pivots, power BI and others
Provides leadership and technical direction for the development, design, and systems integration for various business requirements from definition phase through implementation
Microsoft certified professional (BI, SQL, .NET) - Azure/Cloud implementation experience and knowledge. SQL Server certifications
Strong Database (SQL Server) and Programming experience background
Ability to understand the various data sets available in the Orange Business Services environment to architect, design and develop solutions to current business situations
entité
Orange Intl Ntwk Infr & Svcs
Orange Business manages and integrates the complexity of international communications, freeing our customers to focus on the strategic initiatives that drive their business. Our extensive experience and knowledge in global communication solutions, together with our understanding of multinational business and local support in 166 countries and territories, ensure that our customers receive a consistent, global solution wherever they do business.
contrat
CDI
Rabat,Morocco:Technopolis B6