Responsible for architecting, developing, securing and tuning a large Postgres 9.6 database that supports multiple applications. Must be able to design table architecture, build views, scripts, queries, indexes, and secure the data. Must understand VPD and visibility. Must understand how to analyze, troubleshoot, and improve query performance. Experience migrating data from MongoDB to Postgres is a plus. Must have TS/SCI with CI Poly. Must have current Security+CE certification.
Education/years of experience:
High School diploma/GED with 12 years of experience, or Associates degree with 10 years of experience, or Bachelors degree with 8 years of experience, or Masters degree with 6 years of experience, or PhD with 4 years of experience. Skills & tasks: Exceptionally Complex, Inter- Discipline, Inter-Organizational. Can perform tasks of senior level technicians, specialists, and or managers not performed at Level 3 due to the size and/or complexity of the tasks. Individual Work/Teamwork or Leadership/Management: Leadership/ Management - May work individually or as a key member of a senior leadership team. Oversees and monitors performance across several disciplines, and when required, takes steps to resolve issues Guidance: Provides expert guidance and direction to Government and Vendor senior level technicians and managers. Directs multiple contractor and subcontractors teams through to project completion. Training & Certifications: DoD 8570 compliance or information assurance certification commensurate with technical objectives and services required within the task order. Applicable software or hardware training and certifications commensurate with the technical objectives, services required, and IT environment specified within the task orde In addition, serves as the technical lead of multiple software development teams. Selects the software development processes in coordination with the customer and system engineering. Recommends new technologies and processes for complex software projects. Ensures quality control of all developed and modified software. Delegates programming and testing responsibilities to one or more teams and monitor their performance.