Steampunk is looking for a Data Administrator to architect and develop data models, data warehouses, lakes, and lakehouses, data governance, services, and pipelines for their clients to help them become a facts-based, data-driven, customer-focused organization by leveraging visual analytics platforms.
Requirements
- Demonstrated hands-on experience as an Oracle DBA in a production environment.
- Strong knowledge of Oracle, including architecture, administration, and security.
- Demonstrated on-the-job experience with large-scale data migration.
- Demonstrated on-the-job experience designing storage and retrieval solutions for both structured and unstructured data, in support of data science pipelines.
- Strong command of SQL tools.
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
- 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.
- 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.
- Demonstrated experience working in an agile environment and leading agile projects.
