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 (conceptual and logical) and DB designs (physical), using approved Enterprise Data Modeling tool utilizing reverse and forward engineering, that depicts 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 adherence to technical DB design standards in accordance with the approved enterprise Data Modeling and DB Design Standard.
    • 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.
    • Perform DB design, review DB design from development team, and generate initial Data Definition Language (DDL), as needed.
    • Perform review and score development project’s data models to ensure the model conforms to Enterprise’s data modeling standards.
    • Work with development project team’s data modelers to provide review results and recommendations for scored data models
    • Ability to support multiple projects and working with multiple technical leads with various priorities and delivery schedules
    • Analyze existing database queries and provide performance tuning recommendations on an as-needed basis
    • Perform data analysis on production systems on an as-needed basis
    • Responsible for supporting Enterprise’s Data Modeling Tool Suite through administration which includes user maintenance, software upgrades, documenting and researching issues;  identifying tool features to enhance and standardize its’ usage by all data modelers in the organization; provide training on tool features to data modelers on an as-needed basis
    • Experience with multiple RDBMS (Oracle, MySQL, SQL Server and Sybase)
Skills & Requirements
    • BS degree 
    • 8 - 12 years of experience 
    • 4+ years data modeling experience
    • Data modeling, including reverse and forward engineering.
    • Data Modeling Tools: Some experience with a data-modeling tool is required; Oracle.
    • Ability to analyze data sources.
    • SQL, PL/SQL
    • Microsoft (MS) Office Suite (Word, Excel, Visio, etc.)
    • Performance Tuning
  • Desired Skills:

    • TOAD for MySQL and Oracle.
    • MongoDB, Cassandra, XML, JSON, SOLR
    • CQL, XQuery, XPath, XML
    • 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).
    • Experience with Embarcadero’s E/R Studio
    • Exposure to data ware housing, data marts and unstructured data (No SQL databases)

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