SQL Developer

Job Title: SQL Developer

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.

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.

Contractor