SOLUTE, Inc. is a dynamic group of professionals that focus on solving the nation’s hardest technical challenges in software engineering, data analytics, and cyber security. The Advanced Concepts team operates like a startup within SOLUTE and is composed of world-class technologists building cutting-edge technologies in an open, innovative environment. Our team uses Agile and Lean approaches to teach next-generation developers to create and build new solutions. The team is close-knit, and values work-life balance and having fun while delivering high quality results.
We are seeking a talented and highly motivated individual to apply their skills and knowledge to develop exciting solutions in support of a satellite communications modernization effort. In this position, we have an opportunity to analyze current systems and make recommendations for a consolidated and unified approach that meets the customer’s requirements.
Position Responsibilities
Primary position responsibilities will be configuring multiple environments utilizing RDBMS best practices in a replicated environment using PostgreSQL. Further work in developing and prototyping a data warehouse as part of a software development sprint team.
- Analyze multiple databases (Oracle, SQL Server, PostgreSQL) for interdependencies, data duplication, and develop a plan to deploy a high reliability data warehouse
- Decompose complex requirements into executable discrete user stories within JIRA
- Define and create database queries for production deployment along with abstracted database APIs
- Participate as a primary interface to other sprint teams, understanding their progress, documenting interdependencies, and identifying roadblocks
- Interface directly with the customer, sponsors and ensure requirements are met
- Model and deploy prototype database designs and iterate solutions based on customer requirements and feedback
- Design and execute effective test procedures on deployed database prototypes
- Document decisions with engineering trade studies, interface control documents, and easy to understand APIs
- Breakdown complex problems into simple solutions focused on customer needs
- Research and recommend software products to solve customer problems
- Contribute to SOLUTE internal product development team
- Preform other duties as assigned
Requirements
Qualifications
- B.S. in Software Engineering, Computer Science, Information Systems, Information Technology or similar with 5+ years of relevant experience, or M.S. with 3+ years relevant experience. 12+ years relevant experience may be substituted for formal education
- Solid RDMS background and experience deploying and configuring Oracle or PostgreSQL databases (EnterpriseDB a plus.)
- Experience with ERD tools such as Erwin or PgModeler
- Proficient with PL/SQL or PL/pgSQL
- Experienced with Data Warehousing methodologies
- Comprehensive understanding of database queries and optimization strategies
- Strong understanding of Linux operating systems (RHEL/CentOS preferred)
- Ability to research, evaluate, and recommend solutions and technologies based on customer needs.
- Familiarity with professional software engineering practices for the full software development life cycle, including coding standards, code reviews, source control management, agile development, build processes, testing and operations.
- Ability to deliver code with modern workflows in git
- Ability and willingness to mentor junior engineers
- Proven analytical and problem-solving abilities
- Ability to effectively prioritize tasks in a high-pressure environment
- Excellent communicator, both oral and written
- US Citizen
- Ability to obtain a Secret security clearance or have active security clearance
Differentiators
The ideal candidate will have a passion for elegant and clean solutions and can operate independently as well as part of a team. Experience with the following will differentiate candidates:
- Active Secret or higher clearance
- RedHat Certification (e.g. RHCSA)
- Understanding of key virtualization technologies and platforms (VMware, KVM, Xen, etc.)
- Knowledge and understanding of the setup/configuration of PostgreSQL replication
- Experience with provisioning and configuration management tools (CloudFormation, Terraform, Ansible, Chef, Puppet, etc.)
- Experience with containerization technologies (Docker, Rocket, etc.)
- Programming ability in a modern language (Java, Python, Go, etc.)
- Understanding of micro-service architectures and decoupled systems
- Experience developing and interfacing with REST APIs