Senior Software Engineer
cgi
Job Description
. 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