SQL Developer

Location

Norcross, GA | United States

Job description

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.

Founded in 2010, we are a minority owned, HUBZone certified, small business concern and GSA Schedule holder, based in Atlanta, GA. As an enterprise solutions provider, we offer a wide range of consulting and solutions development services designed to help you deploy the right resources at the right time the first time. With decades of experience, our leadership team leverages modern technology and future concepts to deliver our flagship services with excellence. We specialize in helping commercial clients enhance their capabilities while improving operational efficiency, and we champion efforts to help modernize agencies and reduce government burden.We value all employees and job candidates as unique individuals, and we welcome the variety of experiences they bring to our company. As such, we have a strict non-discrimination policy. We believe everyone should be treated equally regardless of race, sex, gender identification, sexual orientation, national origin, native language, religion, age, disability, marital status, citizenship, genetic information, pregnancy, or any other characteristic protected by law.Wisemen Multimedia LLC (“Wisemen”) is seeking qualified candidates to fill several full-time, part-time, and intern positions. Wisemen embraces diversity and strongly encourages all qualified individuals, including people of varied ethnicity, gender identity, sexual orientation, and physical abilities, to apply, especially 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.

Job tags

Salary

$110k - $150k