Database Administrator/Developer
Professional Solutions LLC, Quantico, VA, United States
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 toolsin order todeterminethe accuracy of the software discovery capability for various software products in use within the USMC.
Assistinestablishingthe datamappings between data elements in the different discovery toolsin order toensure 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 requirea high levelof comprehensive analysis to ensure data integrity ismaintainedand information presented is complete andaccurate.
Use Structured Query Language (SQL) to manipulate datain order toperform data analysis. Examples of approved database technologies, to perform data analysis,includesOracle 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.
Additionalduties as assigned.
REQUIRED SKILLS / EXPERIENCE
Firm understanding and ability to use Structured Query Language databases such as:
Microsoft SQL Server
3+ years'experience inSQLServerdevelopment.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 BIexperience highly desired.
Ability to analyze data migration plans to includemapping ofsource to target databases.
Ability to communicate effectively with project leaders and senior managementregardingkey milestones, successcriteriaand risks.
Expert in database design for relational database management including data warehouse, datamart, 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.
EDUCATION
BS degree from an accredited institution or 8 years of relevant technical experience
REQUIRED CERTIFICATIONS
IAT Level II
CompTIASecurity+ CE certification preferred
SECURITY CLEARANCE REQUIREMENT
Able to pass Federal National Agency Check with Inquiries (NACI)and obtain aSecret Clearance
Active DoD Secret Clearance preferred
TRAVEL
CONUS
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 toolsin order todeterminethe accuracy of the software discovery capability for various software products in use within the USMC.
Assistinestablishingthe datamappings between data elements in the different discovery toolsin order toensure 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 requirea high levelof comprehensive analysis to ensure data integrity ismaintainedand information presented is complete andaccurate.
Use Structured Query Language (SQL) to manipulate datain order toperform data analysis. Examples of approved database technologies, to perform data analysis,includesOracle 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.
Additionalduties as assigned.
REQUIRED SKILLS / EXPERIENCE
Firm understanding and ability to use Structured Query Language databases such as:
Microsoft SQL Server
3+ years'experience inSQLServerdevelopment.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 BIexperience highly desired.
Ability to analyze data migration plans to includemapping ofsource to target databases.
Ability to communicate effectively with project leaders and senior managementregardingkey milestones, successcriteriaand risks.
Expert in database design for relational database management including data warehouse, datamart, 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.
EDUCATION
BS degree from an accredited institution or 8 years of relevant technical experience
REQUIRED CERTIFICATIONS
IAT Level II
CompTIASecurity+ CE certification preferred
SECURITY CLEARANCE REQUIREMENT
Able to pass Federal National Agency Check with Inquiries (NACI)and obtain aSecret Clearance
Active DoD Secret Clearance preferred
TRAVEL
CONUS