Capgemini
Oracle Database Developer
Capgemini, New York, New York, us, 10261
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 documents, and modify software specifications.Business requirements:
Analyze the company's data needs and assist in data migration and transformation projects to support business needs.Collaboration:
Work across IT teams and with business users to 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 databases 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: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.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.
#J-18808-Ljbffr
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 documents, and modify software specifications.Business requirements:
Analyze the company's data needs and assist in data migration and transformation projects to support business needs.Collaboration:
Work across IT teams and with business users to 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 databases 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: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.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.
#J-18808-Ljbffr