Ref No.: 18-09113
Location: Tampa, Florida
Act as subject matter expert to lead the Infrastructure Security Reporting Team in gathering security information and metrics from a wide range of information security tools to facilitate vulnerability data collection, compliance to security baselines, and security event management. Create both high level metrics based management reports and dashboards in addition to remediation reports for the operational staff. Normalize all collected data, store that data in our information security data warehouse, create the necessary views to represent that data correctly, and provide data feeds to other groups within the organization. Implement, execute, and improve work processes and process automation to improve efficiency and efficacy. Performs related duties as assigned or requested.




 Strong T-SQL Skills (Queries, Subqueries, Stuffs, Cross-Applies, Views, Stored Procedures)
 Strong ETL and Data Normalization Skills, SSIS
 Database programming and relational design concepts in support of interactive and batch systems
 Ability to translate business requirements and defined rules and produce viable, robust technical solutions that take advantage of RDBMS technologies in a heterogeneous environment
 Excellent command of languages/platforms, specifically SQL (multi-DBMS platforms)
 In-depth knowledge of relational database concepts and the enforcement of referential integrity
 Solid development and testing of queries, stored procedures, functions and integrated database components
 Able to support job executions and data synchronization across multiple environments
 Programming: C#, VB Script
 API Integration: SOAP, REST, JSON
 Understanding of Security Analytics and Metrics Including VDC, CSB, SEM, and ITAM
 Automation: SCP, SSH, FTP Scripting (WinSCP Preferred)