Oracle Database Developer 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. **Client Location: New York, NY** **Job Description** **Responsibilities:** **Database design:** Design and implement efficient database structures and schemas to support application functionality **Code writing:** Write and optimize complex SQL queries for data retrieval manipulation and reporting **Database queries:** Write SQL queries to extract and manipulate data **Testing and troubleshooting:** Test databases and identify and fix issues related to performance security or data integrity **Software specifications:** Research design document and modify software specifications **Business requirements:** Analyze the company's data need and assist in data migration and transformation projects to support business needs **Collaboration:** Work across IT teams and with business users understand the business needs and translate it to implementation. **Security processes:** Develop security processes **Best practices:** Develop and maintain documentation for database schemas procedures and best practices **Standards:** Verify that all database programs adhere to the organization s and performance standards. **Database performance:** Assess the effectiveness and performance of database systems and applications **Requirements and Skills:** + 5-7 years of experience working in Oracle and DB2 Databases. + Proven work experience as a Database developer. + In-depth understanding of data management (e.g. data discovery data analysis transformation data quality security and monitoring). + SQL Tuning techniques to prevent performance degradation and understanding on how to use + Explain Plan/Query Analyzer/Optimization Tool is required. + Knowledge of software development and Agile delivery methodology. + Proficiency in working with specific database like DB2 Oracle & SQL server. + Working knowledge of ETL processes and tools (i.e. Informatica for data extraction transformation and loading from various sources into existing databases) + Excellent analytical and organizational skills. + Understanding the needs of front-end users and having a problem-solving mindset. + Excellent verbal and written communication skills. **Life at Capgemini** Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: + Flexible work + Healthcare including dental, vision, mental health, and well-being programs. + Financial well-being programs such as 401(k) and Employee Share Ownership Plan + Paid time off and paid holidays + Paid parental leave. + Family building benefits like adoption assistance, surrogacy, and cryopreservation + Social well-being benefits like subsidized back-up child/elder care and tutoring + Mentoring, coaching, and learning programs. + Employee Resource Groups. + Disaster Relief. **Disclaimer** 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. Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact. Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law 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. **Salary Transparency:** Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to the highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $56186 - $87556 / yearly. This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees. **Note** : No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law. 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. Ref. code: 96973 Posted on: Oct 29, 2024 Experience Level: Experienced Professionals Contract Type: Permanent Location: New York, US Brand: Capgemini Professional Community: Software Engineering 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.