| Apply To: | https://tibercreek.com/careers/apply/ |
|---|
| Education: | AA/BA/BS degree required. Security+ must be current or quickly obtained. |
|---|
| Experience: | 5+ years relevant work experience. |
|---|
| Clearance: | Active DoD SECRET Clearance is Required. |
|---|
| Related Experience Should Include: | - Working in an Agile environment on a Department of Defense (DoD) contract and familiarity with DoD systems and requirements.
- PostgreSQL database expertise and experience designing, developing, and deploying U.S. Army data management capabilities to a production environment.
- Data Modeling tools to include erwin.
- Knowledge of Army systems and data
- Implementing physical data stores based on logical models.
- Translating functional needs into robust and scalable data storage designs.
- Documenting a data model and its inbound/outbound data feeds.
- Reporting and producing visualization of data for leadership decision-making.
- Knowledge of programming languages such as Java or .NET.
- Good understanding of data development lifecycle and the tools that support it, such as SSIS design tools.
- Understanding metadata concepts and strategies.
- Using tools such as Visio, Visual Studio, and other SQL tools.
- Working knowledge and experience with dimensional modeling principles.
- Knowledge of source code versioning techniques in the context GIT; ability to program data processing cycles (ETL); and knowledge of Business Intelligence Development Studio.
|
|---|
| Job Duties: | - Gather, research, refine, and communicate requirements. Understand and explain how database design meets requirements to developers, managers, customers, and others.
- Implement physical data stores based on logical models.
- Support solution development by translating functional needs into robust and scalable data storage designs.
- Coordinate with the Data Scientist to identify, evaluate, ingest, and integrate new sources of data.
- Create database designs that are performant, appropriately normalized, future-proof, and scalable.
- Accept proposed subject area designs from database leads, refine them and add them to the database model.
- Design, manage and enforce data naming conventions.
- Design and model a database in erwin. Generate Differential DDL from the erwin model.
- Write stored procedures, functions, views, and database scripts.
- Peer review DDL and DML scripts generated by team members.
- Gather and prepare scripts for deployment.
- Attend meetings to keep abreast of development efforts and incoming requirements.
- Troubleshoot data issues that may be caused by errors in DDL, DML, or the Application.
- Support all levels of testing from individual developer testing, to unit testing, UVT, and UAT.
- Triage and prioritize multiple tasks by their urgency and impact.
- Inform application and solution architecture designs balancing the needs of customers and best practices.
- Troubleshoot existing and build new ETL processes that load data from various systems/architectures into the database.
- Design and build multiple ETL data feeds to supply legacy systems with data that meet existing SLAs and DSAs.
|
|---|
| Minimum Qualifiers: | - Unable to work with 3rd party candidates or agencies.
|
|---|