Sr. SQL Developer

Job Description

Job Description

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

• 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.