Prosoft
Overview
Clearance:
Active Secret or Top-Secret clearance required
As part of a larger team and also working in small project teams, 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.
Responsibilities
Design, create, maintain, and manage Command databases, ETL solutions, indexes, T-SQL scripts, stored procedures, tables and views, functions, reports, and forms.
Apply DoD data standards to all software applications and database data elements; ensure logical data models are attributed and data is normalized.
Provide technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.
Design and create SQL Server Integration Services (SSIS) packages and provide SQL Server Reporting Services (SSRS) for information delivery.
Monitor and maintain databases to ensure optimal performance; implement data management standards, requirements, and specifications.
Implement data mining and data warehousing applications.
Work within Agile methodology and Scrum framework for software development projects.
Qualifications
Knowledge of database management systems, query languages, table relationships, and views.
Knowledge in data analysis for normalization, ETL, and use in applications in relation to business rules.
Knowledge of data mining and data warehousing principles.
Knowledge of normalized database table design with referential integrity and indexing for performance; able to work with DDL directly when needed.
Knowledge of Database Programming (T-SQL) to write functions, views, and stored procedures for data retrieval and manipulation.
Skill in database creation and development in Microsoft SQL Server including SSIS, T-SQL, SQL Agent jobs, and SQL Reports.
Skill in ETL development and data clean-up processes.
Skill in conducting queries and developing algorithms to analyze data structures.
Skill in performance tuning and optimizing database performance.
Ability to structure and manage databases; advanced techniques to create stored procedures, automated applications, and advanced data modeling concepts.
Ability to function effectively in a dynamic, fast-paced environment.
Preferred C# and PowerShell scripting experience.
Education Education:
Bachelor’s degree in computer science or related field preferred, and six (6) years industry experience; OR, associate’s degree and eight (8) years of experience; OR Ten (10) years of experience may be substituted for formal degree.
Certifications CSWF Certifications:
IAT Level II CompTIA Security+ CE and Computing Environment certification or formal training required.
#J-18808-Ljbffr
Active Secret or Top-Secret clearance required
As part of a larger team and also working in small project teams, 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.
Responsibilities
Design, create, maintain, and manage Command databases, ETL solutions, indexes, T-SQL scripts, stored procedures, tables and views, functions, reports, and forms.
Apply DoD data standards to all software applications and database data elements; ensure logical data models are attributed and data is normalized.
Provide technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.
Design and create SQL Server Integration Services (SSIS) packages and provide SQL Server Reporting Services (SSRS) for information delivery.
Monitor and maintain databases to ensure optimal performance; implement data management standards, requirements, and specifications.
Implement data mining and data warehousing applications.
Work within Agile methodology and Scrum framework for software development projects.
Qualifications
Knowledge of database management systems, query languages, table relationships, and views.
Knowledge in data analysis for normalization, ETL, and use in applications in relation to business rules.
Knowledge of data mining and data warehousing principles.
Knowledge of normalized database table design with referential integrity and indexing for performance; able to work with DDL directly when needed.
Knowledge of Database Programming (T-SQL) to write functions, views, and stored procedures for data retrieval and manipulation.
Skill in database creation and development in Microsoft SQL Server including SSIS, T-SQL, SQL Agent jobs, and SQL Reports.
Skill in ETL development and data clean-up processes.
Skill in conducting queries and developing algorithms to analyze data structures.
Skill in performance tuning and optimizing database performance.
Ability to structure and manage databases; advanced techniques to create stored procedures, automated applications, and advanced data modeling concepts.
Ability to function effectively in a dynamic, fast-paced environment.
Preferred C# and PowerShell scripting experience.
Education Education:
Bachelor’s degree in computer science or related field preferred, and six (6) years industry experience; OR, associate’s degree and eight (8) years of experience; OR Ten (10) years of experience may be substituted for formal degree.
Certifications CSWF Certifications:
IAT Level II CompTIA Security+ CE and Computing Environment certification or formal training required.
#J-18808-Ljbffr