Roles & responsibilities:
SQL developers are responsible for ensuring delivery of SQL databases and SQL services. SQL databases are usually designed and then built by SQL developers on behalf of customers and clients. These databases can form very large complex data systems. A smaller database which is part of larger critical business information system or a standalone model. Business intelligence can be introduced to very good effect for data analysis. The SQL developers, engineers and database administrators are needed for the day-to-day management and maintenance, particularly for high availability information management systems to ensure a seamless system the business can rely on.
- Developing SQL Server Databases
- SQL Database design and development
- Clustering, fault tolerance, information throughput and capacity planning
- Planning backups and recovery
- Data analysis and data cleansing
- SQL server upgrades, patching and maintenance
- Compatibility, compliance, full and partial upgrades
- Data connectivity
- Administrative jobs such as backups
- Creating, editing and managing agents
- Testing the SQL system in specific environments, such as a sandpit development model, preproduction and test production models to live environment testing.
SQL Developers should have a good understanding of Databases and SQL systems, including specific SQL systesm i.e. Microsoft SQL Server, Oracle SQL or MySQL. It is common to hold formal and professional qualifications such as HNC, HND or BSc. and/or Microsoft Certified Solutions Expert (MCSE), Oracle Database Certifications, MySQL Database Administration Certificate.
DBA, DBE, Enterprise SQL Systems Administrator, Enterprise Systems Manager, Systems Analyst, Project Manager, Head of Department.
Average salary is £70,000 per annum as of June 2014 for SQL Developer based in London.