Senior Software Engineer - DB Developer
Position Description
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 efficient 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.
Your future duties and responsibilities
Required qualifications to be successful in this role
Together, as owners, let’s turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll 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.
You’ll shape your career by joining a company built to grow and last. You’ll 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 team—one of the largest IT and business consulting services firms in the world.