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.
