DB Developer : We are looking for a highly skilled Mid Database Developer (5 ) with strong expertise in Oracle PL/SQL and MongoDB to design develop optimize and maintain robust data solutions.
Key Responsibilities
Database Development & Design
. Design and develop complex PL/SQL packages procedures functions and triggers
. Build and maintain efficient data models schemas and database structures
. Develop and manage MongoDB collections queries and aggregation pipelines
. Ensure data integrity consistency and security across systems
Performance Optimization
. Analyze and optimize slow running queries and database performance
. Implement indexing strategies and query tuning techniques
. Monitor database performance and recommend improvements
. Troubleshoot production issues and provide timely resolutions
Data Integration & Processing
. Develop and maintain ETL processes and data pipelines
. Integrate data between relational (Oracle) and NoSQL (MongoDB) systems
. Work with large datasets and ensure effective data processing
Collaboration & Support
. Collaborate with developers architects and QA teams for seamless delivery
. Participate in design discussions and provide database expertise
. Support release activities deployments and production support
. Document technical designs data flows and best practices
Required Skills & Qualifications
Technical Skills
. Strong experience in Oracle Database development (PL/SQL)
. Hands on experience with MongoDB (CRUD operations indexing aggregation)
. Expertise in SQL query optimization and performance tuning
. Experience in data modeling (ER diagrams normalization/denormalization)
. Knowledge of ETL tools or scripting (Shell Python etc.)
.
Familiarity with database migration and data transformation
Tools & Technologies
. Oracle SQL Developer / TOAD
. MongoDB Compass / Shell
. Version control tools (Git Bitbucket)
. CI/CD exposure is a plus
Preferred Qualifications
. Experience with Oracle performance tuning tools (AWR ASH reports)
. Exposure to cloud databases (AWS RDS Azure Cosmos DB etc.)
. Knowledge of data warehousing concepts
. Experience in domains like Banking.
Together as owners lets turn meaningful insights into action.
Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because
You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.
Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.
Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
That same commitment to fairness extends to how we use technology. To support our recruitment team AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
Come join our teamone of the largest IT and business consulting services firms in the world.