Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply on company site
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Myc82b73fzm41nstf6n

Sr. Database Designer/Modeler

Octo Consulting Group Alexandria Full-Time
Apply on company site

Octo Consulting Group is seeking Sr. Database Designer/Modeler 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)
  • BS degree 
  • 10 years of experience 
  • 8+ 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

Recommended skills

Pl/Sql
Relational Database Management Systems
Performance Tuning
Sql (Programming Language)
Data Modeling
Systems Design
Apply to this job.
Think you're the perfect candidate?
Apply on company site

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: 515885

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.