Steampunk's clients are looking to become a facts-based, data-driven, customer-focused organization by leveraging visual analytics platforms to analyze, visualize, and share information, and Steampunk is building and executing a data strategy to support this goal.
Requirements
- Strong command of SQL tools
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Understanding of relational and dimensional data modeling
- PowerShell and Unix shell scripting skills
- Demonstrated experience working with SQL and relational databases, query development and optimization (SQL) as well as working familiarity with a variety of databases, such as Oracle, SQL Server, PostgreSQL, and others.
- Experience with relational SQL and NoSQL databases
- Familiarity with cloud technology, using AWS or Azure. Knowledge of managed service offerings (e.g. AWS EC2, EMR, RDS, Redshift) and demonstrated experience delivering in a cloud environment.
Responsibilities
- Lead and architect migration of data environments with performance and reliability.
- Experience in crafting database / data warehouse solutions in cloud (Preferably AWS. Alternatively Azure, GCP).
- Helping build the structure and design of the database
- Implementing security measures for the data
- Controlling access to the database
- Building different environments for development, testing and production
- Merging and migrating data when necessary
Other
- Ability to hold a position of public trust with the US government.
- 5+ years of experience in database administration, information technology, database architecture, or a related field
- Bachelor's degree in computer science, information systems, engineering, business, or a scientific or technical discipline
- Impeccable attention to detail
- Demonstrated experience collaborating with staff, IT customers, and other technical and non-technical staff and contractors at all levels
