Sr. Database Designer/Modeler

Location: Alexandria, VA

Req#: 479639
Apply
Company Information
Job Description

Octo Consulting Group is seeking Sr. Database Designer/Modeler(s)  to join our growing team in support of a critical mission for a Federal customer. 

The role will include the following responsibilities:

  • Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models.
  • Create data models (logical) and DB designs (physical), using approved Enterprise Data Modeling tool, that depict the business areas and systems in the technical environment to ensure the integrity of the business data is being maintained; incorporate applicable standard data elements (SDEs); ensure solutions are accessing the system of record for shared or enterprise data; and ensure adherence to technical DB design standards in accordance with the approved enterprise Data Modeling and DB Design Standard.
  • Refine existing data models of the business areas and systems.
  • Facilitate data modeling sessions, ranging from information gathering to model validation.
  • Create the data architecture sections of the system design documents for development efforts.
  • Provide requirements analysis support to development teams and educate project and development teams on the proper usage of the data structures.
  • Analyze data access and modification requirements to ensure efficient data retrieval/ ingestion and optimal DB design.
  • Perform DB design, review DB design from development team, and generate initial Data Definition Language (DDL), as needed.
  • Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the relational DB.
  • Provide optimal design for structured and non-structured data using SQL and NoSQL databases.
  • Enhance DB performance from physical DB design perspective, such as creating indexes, defining constraints, linking tables, and partitioning tables.
  • Provide technical advice and prepare technical documentation on data architecture related trends, issues, and tools and provide input into the agency-wide data architecture standards.
  • Experience with establishing data governance standards and associated processes.  Ability to articulate data standards that should be set at an enterprise and communicate these to various business units
Skills & Requirements
  • BS degree 
  • 6+ years of experience 
  • Data modeling, including reverse and forward engineering.
  • DB Design: Relational DB Management System, NoSQL Database along with Data Warehouse, and Data Mart.
  • Data Modeling Tools: Some experience with a data-modeling tool is required; Embarcadero’s E/R Studio.
  • Oracle, Cassandra, XML, JSON, SOLR.
  • Ability to analyze data sources.
  • SQL, PL/SQL, CQL, XQuery, XPath, XML
  • Microsoft (MS) Office Suite (Word, Excel, Visio, etc.)

Desired Skills:

  • TOAD for MySQL and Oracle.
  • MongoDB
  • Monitor application related jobs and data replication activities
  • Establish and maintain backup and recovery policies and procedures in the development environment,
  • Plan growth and changes (capacity planning).

Location:

  • Alexandria, VA

 

About Octo Consulting Group, Inc.

Octo Consulting Group (Octo) is an industry-leading, award-winning provider of digital services for the federal government. Octo specializes in providing agile software engineering, user experience design, cloud services, and digital strategy services that address government’s most pressing missions. Octo delivers intelligent solutions and rapid results, yielding lower costs and measurable outcomes.

Our team is what makes Octo great. At Octo you'll work beside some of the smartest and most accomplished staff you'll find in your career.  Octo offers fantastic benefits and an amazing workplace culture where you will feel valued while you perform mission critical work for our government.  Voted one of the region’s best places to work multiple times, Octo is an employer of choice!

Octo Consulting Group is an Equal Opportunity/Affirmative Action employer.  All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age, or genetic information. Octo Consulting Group’s commitment to diversity and inclusive selection practices includes ensuring qualified long-term unemployed job seekers receive equal consideration for employment. 

Other Considerations: Relocation will not be offered. Selected applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 80% of time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include use of computer monitor screens up to 80% of time.

For more information please visit: 

www.octoconsulting.com

www.octoconsulting.com/careers