Analyst III at Spargo Inc

Reston, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Sep, 26

Salary

141941.8

Posted On

26 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Sql Server, Ssrs, Ssis, T-Sql, Database Design, Stored Procedures, Performance Tuning, Data Migration, My Sql, Oracle, Web Services, .Net, Soap Api, Technical Specification Writing, Database Maintenance, Vb Scripting

Industry

Events Services

Description

Title: Database Analyst III Duties: 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, My SQL, SQL Loader, SQL Server Management Studio, SQL Sentry, Web Services, .NET, and T-SQL; gather functional requirements and Business requirements and written 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, connected various applications to the database and written functions and stored procedures; design SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived 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. Requirements: Bachelor’s Degree in Computer Science or closely related field Hours: 37.5+ hours per week Annual Wage: $141,941.80 Employer: J. Spargo & Associates, Inc. Employer/Job Location: 1881 Campus Commons Drive, Suite 350, Reston, VA 20191 Apply by Resume to: Mail resumes to Donna Lynn Copes, VP Human Resources & Client Financial Services, 1881 Campus Commons Drive, Suite 350, Reston, VA 20191.

Responsibilities

Responsible for creating and maintaining client and operational databases using MS SQL Server and related technologies. The role involves developing SSIS packages for data transfer, creating custom SSRS reports, and performing day-to-day database maintenance and performance tuning.