Database Developer
Posted 1 day ago by The Emerald Group Ltd, Search and Selection
Negotiable
Undetermined
Hybrid
London Area, United Kingdom
Summary: The Database Developer role involves the administration, performance tuning, and security of enterprise production databases, primarily focusing on SQL and Snowflake. The position requires collaboration with Infrastructure & Operations teams to support application development and troubleshooting. The developer will also be responsible for database design and ensuring compliance with IT standards. This is a hybrid position based in London with an initial duration of six months.
Key Responsibilities:
- Performance tuning of production databases and development, implementation, deployments, migrations, and upgrades of databases.
- Database development using Microsoft SQL Server, Python, Databricks, and data visualization tools like Microsoft Power BI and Snowflake.
- Analyze and resolve end user software application incidents related to enterprise databases.
- Perform maintenance or project tasks to maintain databases as required.
- Deploy database scripts, jobs, schema changes, and compliance changes.
- Manage data load/refresh of UAT and Dev environments.
- Determine changes in physical database based on project requirements.
- Ensure successful completion of backups and technical patching, resolving issues as needed.
- Document tasks/activities within the ITSM system to ensure compliance with IT, SDLC, and security standards.
Key Skills:
- 3+ years of experience in data analysis/management and administration.
- Experience in insurance or Lloyd’s environment.
- Knowledge of Microsoft SQL Server, Python, Databricks, and data visualization tools like Microsoft Power BI and Snowflake.
- Strong hands-on experience with project implementations and understanding of project life-cycle.
- Project management, planning, problem-solving, and decision-making skills.
Salary (Rate): undetermined
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
JOB DESCRIPTION
POSITION: Database Developer
LOCATION: London/ hybrid
DURATION: 6-months initially
Job Description: The DB Developer will be responsible for the administration, documentation, performance, tuning, design, integrity and security of the enterprise’ production databases (mainly SQL, Snowflake), data transfers, and systems. In addition to traditional DBA maintenance, this role is expected to support DBA improvements and plan for the future, including incorporating best practices, emerging techniques and tools, etc. Additionally, the Database Developer will assist the Infrastructure & Operation teams with planning, developing and troubleshooting of applications. Developer will be designing the databases and application as per the requirement of the organization.
Responsibilities of the Database Developer:
- Performance tuning of production databases, as well as the development, implementation, deployments, migrations, and upgrades of databases.
- Database development (e.g. Microsoft SQL Server Database, Python), Data bricks, data analytics, and data visualization tools (e.g. Microsoft Power BI, Snowflake).
- Analyses and resolves end user software application incidents and/or problems as it relates to the enterprise databases, in a timely and accurate manner.
- Perform maintenance or project tasks as required and scheduled to maintain databases.
- Deployments of Database Scripts, Jobs, Schema Changes, compliance changes.
- Responsible for data load/refresh of UAT and Dev environments.
- Determine changes in physical database by studying project requirements, identifying database characteristics, such as location, amount of space, and access method.
- Ensure backups and technical patching are successfully completed and resolve issues if required.
- Document tasks/activities within the ITSM system to ensure conformance with IT, SDLC, and security standards and requirements.
Requirements of the Database Developer:
- Must have 3+ years of experience in data analysis/management and administration.
- Insurance or Lloyd’s experience.
- Knowledge of databases (e.g., Microsoft SQL Server, Python), Databricks, data analytics, and data visualization tools (e.g., Microsoft Power BI, Snowflake).
- The main focus will be on Snowflake, but they will also oversee Azure SQL databases.
- Demonstrated ability to deliver projects in a fast paced, multi stakeholder environment within scope, timeline, and budget.
- Strong hands-on experience and understanding of project implementations, project structure, project life-cycle, and best practice project standards.
- Project management, planning, problem-solving and decision-making skills.