L3 Database Administration
Posted Today by Infoplus Technologies UK Limited
Negotiable
Undetermined
Undetermined
Glasgow, Scotland, United Kingdom
Summary: The L3 Database Administration role based in Glasgow, UK, focuses on managing and optimizing PostgreSQL, Snowflake, and Greenplum databases. The position requires extensive experience in database administration, including provisioning, maintenance, and data migrations. Candidates should possess strong SQL skills and familiarity with various database utilities and scripting languages. This is a contract position with a focus on performance optimization and troubleshooting complex database issues.
Key Responsibilities:
- Database provisioning, maintenance, and upgrades for PostgreSQL.
- Data migrations using gpcopy and performance optimization for Greenplum.
- Managing database bloat and troubleshooting complex issues using GPTEXT.
- Utilizing Greenplum utilities like gpload, pxf, and GP spark for data loading and integration.
- Designing data lakes, structures, and models suited to Snowflake architecture.
- Implementing Snowflake modeling including roles, schemas, and databases.
- Writing complex SQL queries.
- Utilizing Shell/Python/Ansible scripting knowledge.
- Implementing Patroni for HADR and streaming replication.
Key Skills:
- Extensive knowledge of PostgreSQL, Snowflake, and Greenplum databases.
- Experience with database provisioning, maintenance, and upgrades.
- Proficiency in data migrations and performance optimization.
- Strong SQL and complex query writing skills.
- Expertise in Shell/Python/Ansible scripting.
- Familiarity with Greenplum utilities and Snowflake architecture.
- Experience with Patroni for HADR and streaming replication.
Salary (Rate): undetermined
City: Glasgow
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Role: L3 Database Administration
Location: Glasgow, UK
Duration: Contract
Job Description:
Your Profile;
Essential skills/knowledge/experience:
- Extensive working knowledge (DB Administration) on PostgreSQL, Snowflake and Greenplum databases.
- For Postgres - Database provisioning, maintenance, and upgrades
- For Greenplum – Data Migrations using gpcopy performance optimization leveraging Statistics
- Manage Db bloat, Understand and utilize GPTEXT for troubleshooting complex issues
- experience in Greenplum utilities like gpload, pxf, and GP spark for efficient data loading and integration.
- For Snowflake – Data lakes, data structures and data models suited to Snowflake architecture.
- Snowflake modeling – roles, schemas and databases
- SQL and complex query writing
- Expertise in Shell/Python/Ansible scripting knowledge
- Expertise in Patroni for HADR and streaming replication.