Key Facts

Remote From:

Virginia (USA)

Category: Financial Analyst

Full time

Senior (5-10 years)

English

Hard Skills

SQL Server Integration Services (SSIS) Database Management SQL (Programming Language) Stored Procedure Trigger Point User Defined Functions SQL Server Reporting Services Performance Analytics

Other Skills

•
Problem Solving
•
Communication
•
Teamwork

Roles & Responsibilities

Bachelor’s Degree in Computer Science or closely related field

Requirements:

Create, update, and maintain client and operational databases
Create custom reports utilizing SQL Server Reporting Services
Develop and maintain stored procedures, triggers, and views
Perform day-to-day Database Maintenance tasks

SPARGO, Inc.

About SPARGO, Inc.

SPARGO, Inc is a full-service event management company providing clients with innovative, attentive management and sales services, nationally and internationally, since 1973. Our continuing success is founded on the fact we understand the needs and expectations of our clients. We realize there is always a degree of "uniqueness" with each client that demands flexibility of our systems, methods and staff. No matter what the size, the smallest meeting to the largest trade show, you can rely on us to be 110% dedicated to the success of your event. Our Mission is to provide cost effective event management solutions through the combination of technology and talent for association and corporate meetings.

Founded: 2018

Company size: 51 - 200

LinkedIn See all jobs →

Job 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.