Zions Bancorporation is seeking a Greenplum Database Administrator (DBA) to support and optimize their data warehouse environments, ensuring robust security and performance, and contributing to the development of strategic plans for database and data warehouse environments.
Requirements
- 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.
- Experience with cloud platforms (GCP, AWS, or Azure)
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.
Other
- Participate in a 24/7 on-call support rotation.
- 4+ years of experience
- Paid Training, Paid Time Off (PTO) and 11 Paid Federal Holidays
- 401(k) plan with company match, Profit Sharing, competitive compensation in line with work experience
- Medical, Dental and Vision Insurance - START DAY ONE!
