Location: 80% Remote – Candidate must live within 2 hours of a government facility

Project Overview

• Must be a U.S. Citizen.
• Must be able to pass Minimum Background Investigation (MBI) / Medium-Risk federal agency security clearance.
• Data is collected daily from multiple data sources with a variety of data types. The warehouse contains approximately 15 terabytes of data and collects approximately 30 - 40 gigabytes of data each week.
• Hybrid work environment.
  
  

Responsibilities

• Develop and support the projects SQL development tasks per the client’s request.
• Comprehensive Software Development Life Cycle (SDLC) understanding.
• Demonstrated success in tailoring corporate-level SDLC to follow customer SDLC.
• Develop, debug, and maintain SQL Server stored procedures, views, functions, jobs, etc.
• Develop SQL databases, schemas, and tables, etc.
• Develop automated queries, etc. to support analyst requests.
• Troubleshoot and resolve issues with Extract, Transform and Load (ETL) processes, stored procedures, etc.
• Create, troubleshoot, and maintain SQL Server Integration Services (SSIS) packages.
• Develop processes to import data from various external sources.
• Develop and optimize complex SQL statements.
• Curate data for dashboard reports.
• Document current ETL procedures to prepare for SQL migration.
• Work with existing SQL Server tables, stored procedures, views, and functions.
• Support the design, development, and deployment for a new database environment.
• Actively participate in daily Kanban meetings.
• Support the project team by identifying and correcting data integrity issues.
• Create and maintain detailed standard operating procedures.
• Prepare configuration documents, test plans and additional documentation as needed.
  
  

Skills Requirement

• Bachelor's degree in a related field and 5+ years of SQL development experience.
• An additional 2 years of experience in large enterprise environments may be substituted in lieu of degree.
• 5+ years of experience with Microsoft SQL in enterprise environment.
• Ability to conform to current processes and procedures.
• Excellent troubleshooting skills with the ability to figure out unknown issues.
• Excellent time management and organizational skills.
• Ability to follow directions to ensure clients goals are met.
• Ability to adapt to new environments and assimilate information quickly.
• Work independently and with a team on multiple tasks with multiple deadlines.
• Knowledge of big data analytics a plus.
• Knowledge of VB.Net and/or .Net Core a plus.
• Knowledge of Business Intelligence Software a plus.
  
  

About Wisemen Multimedia, LLC

Founded in 2010, Wisemen Multimedia, LLC (EIN 27-2836493, DUNS 034-931-168, UEI QMEAXFXBFFT3) is a HUBZone certified hybrid digital business ecosystem creator for people, processes, and technologies. Our principal office is located at Peachtree Dekalb Airport in a designated Opportunity Zone. Let us know if you live in a Historically Underutilized Business Zone (HUBZone). Please copy and paste the link below and enter your home address to determine if you live in a HUBZone. https://maps.certify.sba.gov/hubzone/map#center=39.828200,-98.579500&zoom=5