About EY
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
The opportunity
EY is looking for a Senior SQL Server Consultant to join our dynamic team, that focuses on implementing solutions and working in client engagement teams to deliver tech consulting services. In this role, you will leverage your extensive experience in SQL Server to design and implement robust database solutions that drive business success. You will play a crucial role in optimizing our data management processes and ensuring the integrity and security of our data assets.
Your key responsibilities
- Business Analysis: Collaborate with stakeholders to gather and analyze business requirements, translating them into technical specifications for database solutions.
• Database Development: Design, develop, test, implement, and maintain stored procedures, functions, and triggers in SQL Server to meet business needs and enhance operational efficiency.
• Performance Optimization: Conduct performance tuning and optimization of SQL queries and stored procedures to improve database performance and responsiveness.
• Cross-Functional Collaboration: Work closely with cross-functional teams, including application developers, data analysts, and project managers, to ensure seamless integration of database solutions.
• Monitoring and Troubleshooting: Monitor database performance and troubleshoot issues, implementing solutions to prevent future occurrences and ensure optimal performance.
• Data Security and Integrity: Implement best practices for data management to ensure the security, integrity, and availability of data within the SQL Server environment.
• Documentation: Maintain comprehensive documentation of database designs, processes, and procedures to facilitate knowledge sharing and compliance with organizational standards.
• Technical Support and Training: Provide technical support and training to end-users and development teams, fostering a culture of continuous improvement and knowledge sharing.
Skills and attributes for success
-
Communication is essential, must be able to listen and understand the question and develop and deliver clear insights, in both verbal and written, with the ability to convey complex technical concepts to non-technical stakeholders.
-
Independent and able to manage and prioritize workload.
-
Ability to adapt quickly and positively to change.
-
This position will require strong analytical and problem-solving skills, with a keen attention to detail.
-
You will also be a part of larger team (incl. client-side stakeholders), so communication and collaboration skills will also help you to succeed.
-
A proactive approach to identifying and resolving issues
To qualify for the role, you must have
-
Bachelor’s degree in information systems, Computer Science, Engineering, or other related;
-
Minimum of 6 years of experience in SQL Server database development and administration;
-
Strong proficiency in SQL programming, including the creation and maintenance of stored procedures, functions, and triggers;
-
Proven experience in database performance optimization and troubleshooting techniques;
-
Familiarity with ETL tools and data integration processes;
-
Excellent English communication skills (written & spoken). A good level of another foreign language would be an asset.
Ideally, you’ll also have
-
Relevant certifications in SQL Server (e.g., MCSA, MCSE) are a plus;
-
Experience with master / reference data are a plus;
-
Experience in SSIS, SSAS, Power BI
What we look for
An effective communicator and you’ll be a confident team player equipped with strong people management skills; Creative, proactive, a team player, and able to work under pressure. It’s important to have a strategically focused mindset and the ability to deliver multiple projects and present information in a clear and concise manner. Business mindset and some commercial acumen. We value a strong work ethic, forward-thinking, and being a self-starter; If you’re ready to take on a wide range of responsibilities and are committed to seeking out new ways to make a difference, this role is for you.
What we offer
We offer a competitive remuneration package where you’ll be rewarded for your individual and team performance. Plus, we offer support and coaching, opportunities to develop new skills and progress your career, and the freedom and flexibility to handle your role in a way that’s right for you.
-
Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
-
Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
-
Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
-
Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.
If you can demonstrate that you meet the criteria above, please contact us as soon as possible.
The exceptional EY experience, it’s yours to build.
**EY | Shape the future with confidence **
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.
At EY, we're committed to providing recruitment and career opportunities to all, regardless of gender, sexual orientation, social background or disability. We believe that equality and diversity are central to our recruitment process, as they enhance creativity and efficiency, leading to improved performance and productivity. In line with this commitment, EY Portugal recently became a member of the Inclusive Community Forum. This initiative, led by Nova SBE, focuses on the recruitment of individuals with disabilities, advocating for a more inclusive community. Moreover, EY Portugal has also endorsed the Diversity Charter of APPDI (the Portuguese Association for Diversity and Inclusion), pledging to establish and develop internal policies and practices which support diversity. Through these initiatives, EY seeks to actively contribute to the inclusion process, and promote a more inclusive community for people with disabilities, by actively participating in creating solutions.
**#LI-HYBRID **