SQL Developer - 2188

Job Overview :

• Requires full proficiency in T-SQL as identified by the development manager.
• Create Stored Procedures
• SSIS ETL Packages
• Unit tests
• Documentation of developed code
• Status updates as requested by the Project Manager and Development Manager.
• Ability to write advanced SQL commands.
• Ability to test and troubleshoot database procedures and ETL Packages.
• Excellent written and verbal communication skills
• Elicit data requirements by assisting with interviews, document analysis, data requirements workshops, Data process descriptions, use cases, Data analysis, task and workflow analysis.
• SQL Servers version 2012 and later
• Develop new SSIS / SSRS packages to meet business needs.
• Experience in writing complex SQL queries, stored procedures, functions, and triggers.
• Has the ability to receive a request from the business and translate that into a query / ad hoc report independently.
• Has the ability to review table structures and understand the database
• Has the ability to review existing stored procedures and SSIS packages to understand processes

Required Qualifications :

• 5 years’ experience with extensive knowledge of Agile process development in .Net, MVS and SQL
• Working hands-on with all aspects of the System Development Life Cycle
• Ability to document code developed by analyst
• Experience with project development methodology and able to apply methodology in a practical manner
• Proficiency using SQL database including SSIS.
• Create Stored Procedure, Views, Triggers, Functions, T-SQL, Indexes, Cursors, Performance Tuning, and SQL Profiler.
• Including writing of complex queries using SQL
• Participate in the on-going development and support of existing production system, both technically and functionally.
• Work closely with other developers or and analysts to ensure development meets requirements and delivers optimal performance to our end users.
• Collaborate with Product Owner and SMEs to scope the opportunities, identify constraints, and help mitigate risks.
• Research and adapt technical solutions based on changing business needs.
• Provide technical mentoring for team members as needed.
• Actively look for opportunities to enhance standards and improve process efficiency.
• Researches, evaluates, and recommends new Internet tools and applications for use in assigned responsibilities.
• Ability to work independently. Develop automated tests to use for regression and unit testing.
• Proficiency using SQL database including SSIS.
• Solid written and verbal communication skills.
• Advanced knowledge in SSRS to develop reports

Preferred Qualifications :

• 7 years of experience in SQL development experience
• 5 years of experience in Stored Procedures
• SSIS ETL Packages
• 5 years of experience in ETL development
• 5 years of experience in tools for data extraction and migration
• System analysis SoftwareAG webMethods InRules SSRS MS Team Foundation Server , .Net

Education Required :

Bachelor’s Degree in Computer Science, Information Systems or other related field. Or equivalent work experience

Advanced Systems Design, Inc. is :

• A leading Information Technology provider for Federal, State & Local government agencies.
• A certified minority-owned small business government contractor with capabilities related to Public Health IT, Criminal Justice, Transportation, and Defense.
• A certified service-disabled veteran-owned company with a proud 42-year track record of providing successful innovative solutions for our government customers.
• A drug-free workplace in accordance with the Drug-Free Workplace Act of 1988.
• Applicants who have a signed offer of employment or contractor agreement are subject to : the pre-employment testing protocol : background investigationdrug screening

Our Employees :

• Are actively working on next-generation technology projects with the U.S. Department of Veterans Affairs, CDC, and a wide array of Federal, State, and Local agencies throughout the United States
• Are eligible for wide-ranging benefits and perks, including but not limited to : Comprehensive Health Insurance with PPO and HDHP / HSA optionsDental InsuranceVision InsuranceShort / Long-Term DisabilityGroup Life Insurance - Company PaidVoluntary Life Insurance401(k) Plan with Employer MatchPaid Time Off (Vacation / Sick)Holiday Pay - Company Paid Federal HolidaysTuition AssistanceProfessional Certification Incentive PlanEmployee Referral PlanTechnology Exposure
30+ days ago