SQL Database Developer

Project Title: DBA/SQL Developer (USSOCOM)
Location: Virginia Beach
Labor Category Title: Database Administrator and Developer, Senior

Description: PROSOFT is seeking a SQL Developer/DBA to work as part of a larger team and also working in small project teams to design, create, maintain, and manage Command databases, Extract Transform Load (ETL) solutions, indexes, T-SQL and data manipulation scripts, stored procedures, tables and views, functions, reports, and forms. Apply DoD data standards to all software applications and database data elements, ensuring logical data models are fully attributed and normalized data. Provide technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery. Design and create SQL Server Integration Services (SSIS) packages. Provide SQL Server reporting Services (SSRS) for the delivery of information. Monitor and maintain databases to ensure optimal performance. Implement data management standards, requirements, and specifications. Implement data mining and data warehousing applications. Software development projects employ an Agile methodology and Scrum framework.

Education: Bachelor’s degree in industry experience; OR associate’s degree and eight (8) years of experience; OR Ten (10) years of experience may be substituted for formal degree.

General Experience. At least ten (10) years documented experience in the following:

· Knowledge of database management systems, query languages, table relationships, and views;

· Knowledge in data analysis for the purpose of normalization, ETL, and use in applications and relation to business rules.

· Knowledge of data mining and data warehousing principles.

· Knowledge of Normalized Database table design with proper referential integrity and indexing for performance. Must be able to work with DDL directly when needed, not GUI tools alone.

· Knowledge of Database Programming (T-SQL) to write functions for reuse, views for reuse and obfuscation of complicated multi-table JOINS, and stored procedures for data retrieval and data manipulation done in applications.

· Skill in database creation and development in Microsoft SQL Server to include SSIS, T-SQL, SQL agent jobs, and SQL Reports.

Certifications: IAT Level II CompTIA Security CE and Computing Environment certification or formal training required.

Clearance: Active SECRET or TOP SECRET clearance required

Job Type: Full-time

Pay: $130,000.00 - $140,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Professional development assistance
• Referral program
• Relocation assistance
• Tuition reimbursement
• Vision insurance

Compensation Package:

• Performance bonus
• Profit sharing
• Yearly bonus
• Yearly pay

Schedule:

• 8 hour shift

Experience:

• SQL: 8 years (Required)

Security clearance:

• Secret (Required)

Ability to Commute:

• Virginia Beach, VA 23461 (Required)

Ability to Relocate:

• Virginia Beach, VA 23461: Relocate before starting work (Required)

Work Location: In person

Salary : $130,000 - $140,000