MS SQL Database Developer

ManTech - Norfolk, VA

Full-time - Mid Level

Norfolk, VA

Professional, Scientific, and Technical Services

About the position

The MS SQL Database Developer at ManTech is responsible for designing, developing, and optimizing database schemas and SQL scripts to meet application functionality and performance requirements for government customers. This role involves collaborating with stakeholders on data-related technical issues, performing database development, and maintaining formal SQL coding processes and documentation.

Responsibilities

• Design, develop and optimize database schemas, SQL scripts, and objects to meet application functionality and performance requirements.
• Work with stakeholders on data-related technical issues.
• Perform database development including schema, stored procedures, and views.
• Gather requirement specifications from users.
• Implement and maintain formal SQL coding processes, documentation, and standards.
• Create data architecture for efficient data storage, retrieval, and manipulation.
• Update databases based on requests, troubleshoot issues, and optimize legacy systems.
• Collaborate with developers to improve applications and establish best practices.
• Create and maintain database objects including logical and physical data model packages, procedures, and advanced SQL queries.
• Support the production environment by identifying root causes for critical system issues to ensure timely resolution and minimize impact to business partners.
• Develop and integrate data models and database objects per written specifications.
• Document deployment and operational database standards.
• Tune PL/SQL code.

Requirements

• 5 years of experience with SQL programming, database design, and query tuning.
• Expertise in programming languages such as SQL, PL/SQL, and Oracle.
• Knowledge and understanding of the ETL (Extract, Transform, Load) process.
• Ability to create database objects such as tables, views, and stored procedures.

Nice-to-haves

• Experience with PostgreSQL, MySQL, and SQL CRL.
• Bachelor's degree.