The Database Architect will be responsible for creating and tuning database architectures for a Data Warehousing application.
This person must be willing to work in a fast paced environment.
The successful candidate will analyze current and future system requirements and provide advanced database services to support multiple project implementations.
Determines database structural requirements by analyzing operations, applications, and programming; review objectives with stakeholders; evaluating current systems;
Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-ups, and recovery specifications.
Identify study and understand requirements and translate them into Low level design in Design phase.
Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
Create, test and implement PL/SQL triggers, stored procedures, functions, and packages.
Maintains database performance by identifying and resolving production and application development problems; evaluating, integrating, and installing new releases; completing maintenance.
Analyze data requirements and create the designs needed to implement solutions; develop technical requirements definition, mapping and gap analysis following development standards.
Create High Level and detailed design documents in the Design phase.
Provides database support by coding utilities, responding to user questions, and resolving problems.
Design and implement disaster recovery process to ensure production data is recoverable.
Lead capacity and performance review of the environment, identify optimization opportunities and recommend future growth needs.
Identify areas of process improvement and implement automation where applicable.
Updates job knowledge by participating in educational opportunities; reading professional publications;
Identify architectural issues in design and propose alternative solutions.
40% SME (QG3, review and creation of A&DD).
50% QA (design guidance & review, code review, TC review, process improvements, compliance) .
10% Technical Deployment review.
o ITIL certified (Preferred).
o Oracle PL/SQL Expert (Oracle v18.104.22.168).
o Must Have Strong Data Modelling experience (Awareness of Normalization concepts).
o Oracle PL/SQL programming.
o Expert in PL/SQL tuning and identifying performance bottlenecks
o Expert in Materialized views, partitioning, Oracle db-jobs, triggers, BULK COLLECT, OO concepts, Dynamic SQL, Collections, Exception Handling.
o Migration experience(Good to Have).
o Expertise in Unix (AIX) and Shell scripting preferable.
o Expertise in using Toad and SQL Developer.
o Self Starter – Should be motivated and be able to work with minimal supervision.
o Ability to effectively prioritize and execute tasks in a high-pressure environment is crucial.
o IBM Remedy iDesk
o Clear Case
o Clear Quest
o Oracle 22.214.171.124 experience (Preferred – planned to upgrade current version to 126.96.36.199 soon)
o .Net Development Experience (Preferred)
o Retail Domain (Preferred)
o Team Management.
o Client and vendor relationship management.
o Good communication skill (English).
o Most of the client communication and reporting.
o Moderating Weekly/Monthly status call with client.
o Effective communication within team.
o In time reporting to Capgemini Management or supervisor.
o Analytical skill.
Architect’s role will mainly focus on:
– SME (QG3, review and creation of A&DD).
– QA (design guidance and review, code review, TC review, process improvements, compliance).
– Technical Deployment review.
– Release Stream Strategy in cooperation with the client.
– Any other topic as required by the demand.
– Supports SLF towards improvement in quality of service by providing Technical coaching to complex architectural issues/problems.
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. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed.
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.
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-lawApply now