Sr. SQL Developer

Wisemen Multimedia; Chamblee (GA); Hybrid; USD 75,000 - 95,000; Full time

Job summary

A technology solutions provider is seeking a SQL Developer with over 5 years of experience in SQL development and data management within enterprise environments. This role involves developing, debugging, and maintaining SQL Server databases and automating queries to support analysis. Candidates must have a Bachelor's degree in a related field or equivalent experience. The position offers a hybrid work environment, requiring candidates to be U.S. citizens able to pass a federal security clearance.

Qualifications

• 5+ years of SQL development experience.
• Ability to conform to current processes and procedures.
• Excellent troubleshooting skills with the ability to figure out unknown issues.

Responsibilities

• Develop and support the projects SQL development tasks per the client’s request.
• Troubleshoot and resolve issues with Extract, Transform and Load (ETL) processes.
• Create, troubleshoot, and maintain SQL Server Integration Services (SSIS) packages.

Skills

SQL development experience

Troubleshooting skills

Time management

Understanding of big data analytics

VB.Net and/or .Net Core knowledge

Education

Bachelor's degree in a related field

Job description

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.