Database Administrator/Developer

PROFESSIONAL SOLUTIONS LLC

Triangle, United States of America

3 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Intermediate

Job location

Triangle, United States of America

Tech stack

Data analysis

Business Software

Cluster Analysis

Computer Programming

Databases

Data Validation

Data Integrity

Data Mart

Data Mining

Data Structures

Data Warehousing

Relational Databases

Database Design

Microsoft SQL Server

Oracle

Oracle Applications

Powershell

Power BI

Recovery Manager (RMAN)

Shell Script

Project Management

SQL Stored Procedures

PL-SQL

SQL Databases

SQL Server Integration Services

T-SQL

Scripting (Bash/Python/Go/Ruby)

Information Technology

SQL Server Management Studio (SSMS)

Job description

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics and Information Technology Support Services. We are currently seeking a mid-level to senior-level Database Developer (SQL) to join our team of professionals in support of the USMC.

Essential Duties & Job Functions:

Provide asset data analysis and reporting support.
Establish a repeatable process and support the analysis and validation of data extracted from various asset discovery tools in order to determine the accuracy of the software discovery capability for various software products in use within the USMC.
Assist in establishing the data mappings between data elements in the different discovery tools in order to ensure the data is normalized within a license management database.
Use multiple sources and formats to create coherent software product discovery reports for Program Manager, Customer Support and Strategic Sourcing, Software Project Managers, IT Asset Managers and other stakeholders. These reports require a high level of comprehensive analysis to ensure data integrity is maintained and information presented is complete and accurate.
Use Structured Query Language (SQL) to manipulate data in order to perform data analysis. Examples of approved database technologies, to perform data analysis, includes Oracle and MS SQL Server.
Perform quality assurance reviews of reports to ensure accuracy of the results and standardization of processes and procedures across the team of analysts.
Support the identification and cataloging of software procurement data.
Additional duties as assigned.

Requirements

Firm understanding and ability to use Structured Query Language databases such as:
Microsoft SQL Server
3+ years' experience in SQL Server development. Designing data structures (tables/views/indexes), T-SQL programming (stored procedures and functions).
SQL Server Management Studio (SSMS)
Visual Studios, SQL Server Integration Services (SSIS),PowerShell, and Power BI experience highly desired.
Ability to analyze data migration plans to include mapping of source to target databases.
Ability to communicate effectively with project leaders and senior management regarding key milestones, success criteria and risks.
Expert in database design for relational database management including data warehouse, data mart, and data mining.
Must have knowledge/skill of PL/SQL scripting for Oracle Database.
Ability to use SQL Developer,writingDDLstatementsand to effectively create and analyze various database schemas.
Prior experience with Oracle Database Administration (DBA) 11g/12c, E-Business Suite 12.2.x, PL/SQL, ASM/RAC, Application Clustering, Recovery Manager (RMAN), Rapid Clone,AutoConfigand UNIX/Linux Scripting (Shell Script) preferred.