Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Location: Oaks | Pennsylvania

Required Skills:

• Must have Skills SQL Server Experience:
• Minimum of 10 years of hands-on experience.
• T-SQL Expertise: Extensive experience in writing complex T-SQL queries.

Soft Skills:

• Strong problem-solving skills collaborative team player excellent communication skills
• Ability to mentor junior developers.

Responsibilities:

• Stored Procedures:
• Proficient in developing and optimizing large and chained stored procedures.
• SQL Views: Proficient in creating both standard and indexed SQL views.
• Performance Tuning: Skilled in performance tuning without relying on SQL Profiler.
• Database Design: Expertise in creating ER diagrams and designing data warehouses.
• Data Management: Experience with archival and purging strategies in large SQL data warehouses involving numerous entity relationships.
• Execution Plans: Deep understanding of SQL execution plans and optimization techniques.
• Advanced Indexing: Knowledgeable in advanced SQL indexing techniques including columnstore indexes.
  

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.