Greenplum Engineer

Position Description:

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.

Skills:

• English
• Database Administration
• Unix

What you can expect from us:

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.

Come join our teamone of the largest IT and business consulting services firms in the world.