029875-Applications Consultant 2 - SQL Server DBA

• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

• Configure and maintain SQL database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

• Refine and automate regular processes, track issues, and document changes

• Provide 24x7 support for critical production systems.

• Perform scheduled maintenance and support release deployment activities after hours.

• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

• Candidate will work with Systems and Development teams on designs, SQL performance optimization, and perform on-call support by providing responses to high priority requests for assistance by Operations

• The candidate will work with application developers to evolve the database architecture and design and will participate in the creation and refinement of staging & production database instances.

• Candidate will be serving as a point of contact for advanced level troubleshooting issues, and perform hands-on Database/Systems administration as required.

• Candidate will automate regular Database/OS administrative work with other support teams and ensure they are functioning correctly.

• Candidate will plan and executes tests of fault tolerance capabilities, including backup/recovery, replication, failover, and disaster recovery.

• The candidate should have experience in tuning database server configurations, queries, and indexes. He/she will also be required to run such queries as requested by the development teams.

• Maintain documentation of backup and recovery procedures of the physical data storage and logical data design for assigned databases.

• 3+ years EDW/DWH DBA experience required

• 6+ months RedShift experience a plus

 • Local candidates required.

 With their expertise in a specific technology environment, Applications Consultants are responsible for software-specific design and realization, as well as testing, deployment and release management, or technical and functional application management of client-specific package based solutions (e.g. SAP, ORACLE).  These roles also require functional and methodological capabilities in testing and training.

 Required Skills and Experience:

 You focus on building solutions and on maintaining, optimizing and improving a client’s applications and systems. You contribute to a business and technical blueprint and customize the respective Software Package Core Module. You may also be responsible for unit testing, contribute to integration testing, and/or be responsible for the design and delivery of end-user training.

 • Qualification: Minimum 3 years experience, Bachelor’s Degree.

• Certification: Should have or seeking SE or ERP/SAP Level 1.

• Should be proficient in Package Configuration.

• Should have progressing skills in Business Analysis, Business Knowledge, Architecture Knowledge, Technical Solution Design and Vendor Management

About Capgemini

With more than 190,000 people, Capgemini is present in over 40 countries and celebrates its 50th Anniversary year in 2017.

A global leader in consulting, technology and outsourcing services, the Group reported 2016 global revenues of EUR 12.5 billion (about $13.8 billion USD at 2016 average rate).

Together with its clients, Capgemini creates and delivers business, technology and digital solutions that fit their needs, enabling them to achieve innovation and competitiveness.

A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model.

Learn more about us at www.capgemini.com.

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace.

All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position.

Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Responsibilities:

As part of the Capgemini Technology Services Group, this person will be responsible for the full systems lifecycle from requirements gathering through implementation of data analysis solutions.

This person will work closely with our clients and must demonstrate professional knowledge to ensure that the work products and deliverables are of the highest caliber to ensure client satisfaction.

This person will also apply subject matter expertise to identify, develop, and implement techniques to improve engagement productivity, increase efficiencies, mitigate risks, resolve issues, and optimize cost savings and efficiencies for each client.

Click the following link for more information on your rights as an Applicant: http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law