Altamira brings a commercial mindset to solving the most complex national security problems by delivering mission application development, multi-intelligence analysis, and data science technologies and solutions to the defense, intelligence, and homeland security communities. Altamira’s culture of innovation and excellence, and mid-market-size, positions us as the premier next generation leader bringing technology solutions to mission.

Currently seeking a Database Engineer (considering all experience levels) to support a task at NASIC at Wright-Patterson AFB.

The Database Engineer provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The Database Engineer works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

Required Skills:

• Active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance required.
• U.S. Citizenship required.
• PostgresSQL, MYSQL, SQLite, or Oracle database management knowledge
• Management of large amounts of time series data
• Possess knowledge of SQL Server and its tools including the facets of successfully administering a wide range of simple to highly complex environments.
• Experience with data and schema design and engineering
• Demonstrated practical experience with database migration from legacy systems to central repositories
• Demonstrated practical experience with database structures and schemas to improve performance and efficiency of queries
• Be able to evaluate and install new software releases, patches and system upgrades.
• Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage.
• Experience supporting technology strategy / roadmap.
• Experience with development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques.
• Possess good communication skills, both oral and written.
• Must work well in a team environment as well as independently.
• Must exhibit good time management skills, independent decision making capability; focus on customer service.
• Ability to work with the other technical members of the team to administer and support the overall database and applications environment.

Desired Skills:

• Experience with TimescaleDB
• Experience with PostGIS
• Experience migrating existing databases from a distributed operating system to a Kubernetes or other clustered system
• Experience database engineering support to DHS, DoD or Intelligence Customers
• Data Scientist skills and experience
• Understanding of Certification and Accreditation (NIST 800-53) processes as they apply to database technologies
• Operating system and hardware platform knowledge preferred.
• Experience working with large unstructured data sets
• Experience with Map/Reduce technologies
• Experience with process development and deployment
• Trained in Six Sigma Methodology
• ITIL knowledge and certification

Desired Certifications:

• CPSDBA Certified PostgreSQL DBA
• CSSLP Certified Secure Software Lifecycle Professional
• Database specific certifications as appropriate to position
• DODI 8570.1 Compliance at IAT Level I certification

Altamira is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status.

0LCyMYx5w0