Analyst III

Spargo Inc•Reston, VA

5d•$130,000 - $141,942•Remote

About The Position

This is a remote position for J. Spargo & Associates, Inc. The role is responsible for creating, updating, and maintaining client and operational databases. The analyst will also create custom reports utilizing SQL Server Reporting Services, develop stored procedures, triggers, views, and user-defined functions, and manage regular updates for membership, exhibiting company, and session information across multiple databases. The position involves setting up scheduled imports, exports, and reports for clients, configuring badge runs based on specific criteria, and creating, scheduling, and monitoring SQL DTS/SSIS packages for data updates and maintenance. The analyst will utilize various database technologies including MS SQL Server, SQL, MySQL, SQL Loader, SQL Server Management Studio, SQL Sentry, Web Services, .NET, and T-SQL. Responsibilities include gathering functional and business requirements, writing technical specifications, creating database objects (tables, views, stored procedures, triggers, cursors) using DDL and DML statements, and developing stored procedures and views for efficient data retrieval and application development. Performance analysis using DMVs, Wait-States, and Performance Monitor Counters is also required, along with designing and implementing SSIS Packages for data transfer, validation, and archiving across different platforms and DBMS. Day-to-day database maintenance tasks such as monitoring, backups, space management, and resource utilization are expected. The role involves using various SSIS transformations, scripting (VB) for data decryption/encryption, extracting data from diverse sources (SQL Server, Oracle, .CSV, Excel, Text files) via FTP/SFTP, and integrating web service calls with SSIS for data download using SOAP API. Collaboration with the DBA team for SQL server upgrades and assisting the production team with bug analysis and resolution are also key duties.

Requirements

Bachelor’s Degree in Computer Science or closely related field

Responsibilities

Create, update, and maintain client and operational databases.
Create custom reports utilizing SQL Server Reporting Services.
Create and maintain stored procedures, triggers, views, and user-defined functions.
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.