What are the responsibilities and job description for the Sr. SQL Developer position at Wisemen Multimedia, LLC?
Location: 80% Remote – Candidate must live within 2 hours of a government facility
Project Overview
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
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.
- 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.
- 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, 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
Salary : $110,000 - $150,000