SQL Application Developer (Active Top Secret Clearance Required)
Make an impact by joining the Service
Source team where our mission is serving individuals with disabilities. Explore new opportunities!
Source is an organization of talented men and women who drive innovation, embrace change, and serve humanity. Job Summary Responsible for developing, testing, report writing and deployment of Internal and external web applications for mail tracking systems desktop/laptop PCs, server computers, Services, web APIs, and/or mobile devices for tracking and delivery Systems. Create and update data from application for custom reports that would be exported from SQL Server. This candidate would also assist with the installation and management of 3rd party applications including tracking system Windows Mobile devices, androids, Honeywell Intermec CN51 and Honeywell CT60 barcode reader, hands on training of users and procedures of devices related to tracking operations. Primary Duties The requirements listed below are representative of the knowledge, skill, and/or ability required. These duties and responsibilities will be rated on the Annual Performance Review. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Write optimized queries, views and triggers for integration with other applications solutions that optimize, measure, track, and support improved business performance Perform development activities using standard web technologies for internal applications (i.e., HTML5, Java
Script, and CSS3) that work across multiple device platforms Use back-end programming languages (e.g., ASP, Java, C#, MVC, MVVM etc.) in addition to the front-end scripting languages (HTML5, Java
Script, CSS3) to optimize write operational Reports, Visual Basic .NET (VB), C#, Java
Script, Crystal Report performance, security, and scalability to meet Operations’ needs Develop programs to transmit information between the web application front-end, modeling & analytic models, and applicable back-end databases Collaborate with Systems IT team and Operations teams to integrate optimization modeling and predictive analytic capabilities into Web Application environment This position’s dutiy workload percentages are listed below: Writing queries, Daily and Monthly Reports 40% Verifying:
SQL, backups, testing, disaster recover, transaction logs, full back up of data 40% Computer Setup: Peripherals Setup, Scanners, Label Printers, managing mobile devices, and tracking application, installation of tracking application, troubleshooting issues 20% Additional
ResponsibilitiesCoordinate with end-users, Operations team, and support partners to identify needs, goals, and business objectives Lead the research and analysis of current and trending technology, reports and tools that support business challenges Perform testing to identify application flaws participate in design and code reviews Participate in maintenance, application loads, and troubleshooting as necessary Recommend procedure standards to ensure application design and coding is produced with proper integrity, security and performance Perform data modeling and optimization, preliminary data received from customer designs, data analysis, and creation of new records and information updates as needed Responsible for setup installation/configuration and management of 3rd party tracking system software to include zebra label printers, barcode scanners and managing windows mobile and android devices Write custom monthly reports from existing data using SQL queries and crystal reports Perform feasibility studies, cost/benefit analysis, and user training in response to user requests. Perform team leader functions for projects involving multiple parties: manage deadlines; provide status reports; facilitate final testing and project sign-off Responsible for ensuring backup and data recovery of all local databases and file directories applications Develop monthly customized reports for monthly and yearly trending reporting requirements Perform and maintain daily backup, transaction log and full backups of data Define, analyze, design, develop, test, and implement software applications with accuracy and timeliness Manage mail operations reports for all internal and external database’s metering, internal web gal and Sclogic Support internal tracking system operations, mobile devices and all peripherals May be required to provide levels of training to end users
QualificationsEducation, Experience, and Certification(s) 3-5 years of experience managing or maintaining an Information System or other DoD equivalent preferred 3-5 years of Experience with maintaining, creating, storing T-SQL complex procedures and writing SQL queries preferred 3-5 years of MVC, Entity framework and C# experience highly preferred DOT NET or Visual Basic .NET (VB), C#, Java
Script, Crystal Report, SQ
L server reporting services (SRS) preferred Bachelor’s degree in Computer Science or related field and 3-5 years of experience working with databases, Master’s Degree preferred. Associate’s degree with 6-8 years of related experience can be substituted for a Bachelor’s degree. Active Top Secret Government Clearance Required to be considered Must be able to accrue a public trust through Department Of Homeland Security Experience with Government Service Contract Act (SCA) preferred Experience with data processing flow charting techniques preferred Project management experience preferred Working technical experience with designing, building, installing, configuring and supporting database servers, including SQL servers preferred Hands-on database tuning and troubleshooting experience preferred Knowledge, Skills, and Abilities Strong understanding of database structures, theories, principles, and practices Strong understanding of configuring SQL failover and redundancy in virtual environments Knowledge of applicable data privacy practices and laws Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The noise level in the work environment is usually quiet to moderate. What We Offer – for Benefit Eligible Employees May Include: Because Service
Source hires the best people, we work hard to provide benefits that make their lives better, so we offer a comprehensive benefit program which features: Health coverage for you and your family through Medical, Dental, and Vision plans Financial protection with 100% company paid Disability, Life, Accidental Death & Dismemberment insurance A 403(b)-Retirement plan in which the company matches dollar for dollar on a generous percentage matching up to 3% of your contribution Tax advantages through Flexible Spending and Health Savings accounts that allow you to pay for specific healthcare and dependent care expenses with pre-tax dollars To help you manage your work and life needs, we offer an Employee Assistance Program, Wellness Program, and Tuition Assistance A generous paid time-off program in which the benefits increase based on your tenure with the company Service
Source is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity and Affirmative Action Employer, making decisions without regard to race, color, religion, sex, national origin, age, veteran status, disability, or any other protected class. If accommodation is needed in the application process, arrangements can be made with the local regional office http://www.servicesource.org/contact-us. We are an E-Verify Employer and a drug-free workplace. Pre-employment background checks are required for all employment positions.
PAY TRANSPARENCY POLICY STATEMENT: The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information