SQL Developer

BGSF - Annapolis, MD

Full-time - Mid Level

Annapolis, MD

Administrative and Support Services

About the position

The SQL Developer position is a full-time contractor role based in Annapolis, MD, focusing on the development and management of SQL databases. The ideal candidate will have a strong background in SQL, particularly with MS SQL Server, and will be responsible for writing complex stored procedures from scratch based on provided ERP systems and wireframes. This role requires a deep understanding of relational database design and the ability to work independently with minimal supervision. The SQL Developer will also participate in design sessions with team members, ensuring that all database-related tasks align with project goals and standards. In this position, the SQL Developer will perform various essential duties, including performance management of databases, running diagnostics, optimizing queries, and ensuring proper backups. The candidate will modify existing databases and database management systems, test programs or databases, troubleshoot issues, and correct errors as necessary. Additionally, the SQL Developer will plan and implement security measures to safeguard data against unauthorized access or damage, and develop best practices for software acquisition and usage to protect sensitive information. The role demands excellent communication and client-facing skills, as the SQL Developer will need to collaborate effectively with other team members and stakeholders. The candidate should be able to complete assignments promptly under broad direction, demonstrating a proactive approach to problem-solving and database management.

Responsibilities

• Perform performance management, including running diagnostics, optimizing queries, and ensuring proper backups.
• Modify existing databases and database management systems or direct other programmers to make changes.
• Test programs or databases, troubleshoot issues, correct errors, and make necessary modifications.
• Plan, coordinate, and implement security measures to safeguard data against accidental or unauthorized damage, modification, or disclosure.
• Develop standards and best practices to guide the use and acquisition of software to protect vulnerable information.
• Complete assignments promptly under broad, general direction with minimal supervision.
• Demonstrate excellent communication and client-facing skills.

Requirements

• 5+ years of recent experience with MS SQL Developer (using daily).
• Strong MS SQL development experience (minimum 2008) with the ability to design complex stored procedures and functions.
• Expertise and knowledge of best practices with MS SQL Server and SQL development.
• Strong understanding of relational database design.
• Ability to solve complex problems by analyzing variables and applying appropriate solutions.
• Experience and understanding of the software development lifecycle preferred.
• Experience with SSRS necessary (SSIS is not as important).
• Ability to write complex stored procedures and back-end custom application work.
• Understanding of stored procedures, wireframes, and table structures.