Spargo Inc

Role Description This is a remote position for J. Spargo & Associates, Inc. Responsible for creating, updating, and maintaining client and operational databases; create custom reports utilizing SQL Server Reporting Services. - Create and maintain stored procedures, triggers, views, and user-defined functions for use in Reporting and Registration/Housing Application. - Create and run regular updates for membership, exhibiting company, and session information for multiple databases. - Create and run scheduled imports, exports, and reports for clients for multiple departments/databases. - Set up badge runs for registration department based on provided, specific criteria. - Create, schedule, and monitor SQL DTS/SSIS packages designed to update, export, and maintain client data. - Create, maintain, and update databases using database technologies, such as MS SQL Server, SQL, MySQL, SQL Loader, SQL Server Management Studio, SQL Sentry, Web Services, .NET, and T-SQL. - Gather functional requirements and business requirements and write the technical specifications. - Create database objects like tables, views, stored procedures, triggers, and cursors using DDL, DML statements as per functional requirements. - Develop stored procedures and views for managing efficient data retrieval and application development. - Use DMVs, Wait-States & Performance Monitor Counters to find the root cause of performance slow-downs. - Create databases and schema objects including tables, indexes, and applied constraints. - Connect various applications to the database and write functions and stored procedures. - Design SSIS Packages to transfer data across different platforms, validate data during transferring, and archive data files for different DBMS. - Perform day-to-day Database Maintenance tasks - Database Monitoring, Backups, Space Management, and Resource Utilization. - Use SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, and Send Mail task. - Extensively use SSIS script task (VB) to decrypt and encrypt data to SQL server database. - Extract data from various sources like SQL Server 2008 R2/2014, Oracle, .CSV, Excel, and Text file from Client servers through FTP and SFTP in SSIS packages. - Schedule SSIS packages to import/export OLTP data for multiple databases. - Integrate web service calls with SSIS to download data using SOAP API. - Work with DBA team to upgrade existing SQL servers. - Format SSRS reports using the Global variables and expressions. - Assist the production team in analyzing bugs & resolving them. Qualifications - Bachelor’s Degree in Computer Science or closely related field. Requirements - 37.5+ hours per week. - Annual Wage: $141,941.80. Company Description - J. Spargo & Associates, Inc. - 1881 Campus Commons Drive, Suite 350, Reston, VA 20191. Application Process Mail resumes to Donna Lynn Copes, VP Human Resources & Client Financial Services, 1881 Campus Commons Drive, Suite 350, Reston, VA 20191.