Software Engineer-Mid DB Developer (PL/SQL, Mongo, Oracle)

. Company Profile: At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve. At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com. This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please. Job Title: Mid DB Developer Position: Software Engineer Experience:4-6 yrs Main location: Hyderabad 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