Database Developer
Role details
Job location
Tech stack
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
- 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.