Oracle Database Developer

$56,186 - $87,556/Yr

Capgemini - New York, NY

Full-time - Mid Level

New York, NY

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Database Developer position at Capgemini involves designing and implementing efficient database structures, writing and optimizing SQL queries, and collaborating with IT teams to meet business needs. The role focuses on ensuring database performance, security, and adherence to best practices while supporting data migration and transformation projects.

Responsibilities

• Design and implement efficient database structures and schemas to support application functionality
• Write and optimize complex SQL queries for data retrieval, manipulation, and reporting
• Write SQL queries to extract and manipulate data
• Test databases and identify and fix issues related to performance, security, or data integrity
• Research, design, document, and modify software specifications
• Analyze the company's data needs and assist in data migration and transformation projects
• Collaborate with IT teams and business users to understand business needs and translate them into implementation
• Develop security processes for database management
• Develop and maintain documentation for database schemas, procedures, and best practices
• Verify that all database programs adhere to organizational performance standards
• Assess the effectiveness and performance of database systems and applications

Requirements

• 5-7 years of experience working in Oracle and DB2 Databases
• Proven work experience as a Database developer
• In-depth understanding of data management including data discovery, analysis, transformation, quality, security, and monitoring
• Proficiency in SQL Tuning techniques to prevent performance degradation
• Knowledge of software development and Agile delivery methodology
• Proficiency in working with specific databases like DB2, Oracle, and SQL Server
• Working knowledge of ETL processes and tools (e.g., Informatica)
• Excellent analytical and organizational skills
• Understanding the needs of front-end users and having a problem-solving mindset
• Excellent verbal and written communication skills

Nice-to-haves

• Experience with cloud database solutions
• Familiarity with data visualization tools
• Knowledge of machine learning concepts

Benefits

• 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