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