Greenplum Engineer

The Technology Reliability Engineering and Operations (TREO) organization is a critical part of our IT division, supporting both internal and external customers. TREO reports to the Chief Technology Officer and delivers services such as hosting, security operations, application support, business intelligence infrastructure, collaboration tools, and end-user support. Our team spans 15+ states and three countries, blending full-time employees and contingent workers. We focus on operational excellence and continuous modernization.
Responsibilities: . Install, configure, and maintain database system software, ensuring robust security and performance. . Monitor and analyze database performance to ensure optimal utilization and availability. . Maintain database dictionaries, support tools, and accurate system documentation. . Contribute to the development and maintenance of strategic, architectural, and tactical plans for database and data warehouse environments. . Provide technical leadership and mentorship on database systems and tools. . Evaluate and implement new technologies and tools to improve database performance and reliability. . Implement business continuity and disaster recovery solutions, including replication and backup strategies. . Establish and enforce database standards and best practices. . Participate in a 24/7 on-call support rotation. Qualifications: . 4+ years of Greenplum administration experience, including performance tuning and optimization of complex SQL queries for large data sets. . Hands-on experience with Greenplum tools, including: MADlib, PXF, GPCC, gpfdist, gpload, gpbackup, gprestore, gpdr backup, and gpdr restore. . Strong SQL development skills and experience with data warehousing environments. . Proficiency in Bash scripting, Python, and working in UNIX/Linux (RHEL) environments. . Experience with Terraform and infrastructure-as-code practices. . Familiarity with ETL tools such as IBM DataStage or similar. . Automation-minded with a focus on streamlining database operations. . Experience with cloud platforms (GCP, AWS, or Azure). . Exposure to containerization (e.g., Docker, Kubernetes) and CI/CD pipelines. Experience with Databricks and Spark-based data processing.

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. Come join our team—one of the largest IT and business consulting services firms in the world.