Goal templates — Database Engineering — P2

Data & Database Engineering · Database Engineering · P2 — Developing Professional

These are canon-derived frames, not advice: every line is either verbatim JobFrame canon text or a fixed template wrapping it. ⟨target⟩ / ⟨baseline⟩ / ⟨date⟩ are placeholders for the manager to fill in. Nothing here is generated by AI — rows are omitted, never invented, when the canon lacks the underlying field.

SMART goals

One row per canon core output / responsibility this level owns.

JFM responsibility (P2)

Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases

Specific: Deliver: "Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"
Measurable: Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
Achievable: Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
Relevant: Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
Time-bound: ⟨date⟩

JFM responsibility (P2)

Monitors database health and helps troubleshoot basic issues under the direction of senior developers

Specific: Deliver: "Monitors database health and helps troubleshoot basic issues under the direction of senior developers"
Measurable: Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
Achievable: Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
Relevant: Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
Time-bound: ⟨date⟩

JFM responsibility (P2)

Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity

Specific: Deliver: "Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"
Measurable: Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
Achievable: Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
Relevant: Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
Time-bound: ⟨date⟩

JFM responsibility (P2)

Performs backups and supports application developers, documenting database objects and application modules to maintain development standards

Specific: Deliver: "Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"
Measurable: Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
Achievable: Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
Relevant: Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
Time-bound: ⟨date⟩

JFM responsibility (P2)

Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers

Specific: Deliver: "Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"
Measurable: Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
Achievable: Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
Relevant: Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
Time-bound: ⟨date⟩

Copy / print as textshow ▾

1. Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases  [source: JFM responsibility (P2)]
   Specific:    Deliver: "Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"
   Measurable:  Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
   Achievable:  Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
   Relevant:    Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
   Time-bound:  ⟨date⟩

2. Monitors database health and helps troubleshoot basic issues under the direction of senior developers  [source: JFM responsibility (P2)]
   Specific:    Deliver: "Monitors database health and helps troubleshoot basic issues under the direction of senior developers"
   Measurable:  Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
   Achievable:  Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
   Relevant:    Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
   Time-bound:  ⟨date⟩

3. Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity  [source: JFM responsibility (P2)]
   Specific:    Deliver: "Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"
   Measurable:  Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
   Achievable:  Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
   Relevant:    Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
   Time-bound:  ⟨date⟩

4. Performs backups and supports application developers, documenting database objects and application modules to maintain development standards  [source: JFM responsibility (P2)]
   Specific:    Deliver: "Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"
   Measurable:  Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
   Achievable:  Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
   Relevant:    Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
   Time-bound:  ⟨date⟩

5. Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers  [source: JFM responsibility (P2)]
   Specific:    Deliver: "Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"
   Measurable:  Move the metric this drives from ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩.
   Achievable:  Scoped to this level's jfm complexity/problem-solving rubric: "Solves routine, well-defined database tasks in familiar contexts — pre-defined scripts, basic troubleshooting, backups — escalating anything beyond established procedure."
   Relevant:    Advances the Data & Database Engineering · Database Engineering mandate for a P2 — Developing Professional.
   Time-bound:  ⟨date⟩

OKRs

Objectives from this level's core outputs; key results only where a real dimension or capability backs them.

JFM responsibility (P2)

Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases

From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"
Evidence at this level's scope bar: "Defined deliverables / small features" — ⟨target⟩ by ⟨date⟩

JFM responsibility (P2)

Monitors database health and helps troubleshoot basic issues under the direction of senior developers

From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Monitors database health and helps troubleshoot basic issues under the direction of senior developers"
Evidence at this level's autonomy bar: "General supervision; reviewed at milestones" — ⟨target⟩ by ⟨date⟩

JFM responsibility (P2)

Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity

From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"
Evidence at this level's complexity bar: "Some non-routine problems; applies established patterns" — ⟨target⟩ by ⟨date⟩

JFM responsibility (P2)

Performs backups and supports application developers, documenting database objects and application modules to maintain development standards

From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"
Evidence at this level's impact bar: "Own and immediate-team deliverables" — ⟨target⟩ by ⟨date⟩

JFM responsibility (P2)

Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers

From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"
Evidence at this level's decision rights bar: "Routine technical choices within guidance" — ⟨target⟩ by ⟨date⟩

Copy / print as textshow ▾

Objective 1: Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases  [source: JFM responsibility (P2)]
  KR1. From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"
  KR2. Evidence at this level's scope bar: "Defined deliverables / small features" — ⟨target⟩ by ⟨date⟩

Objective 2: Monitors database health and helps troubleshoot basic issues under the direction of senior developers  [source: JFM responsibility (P2)]
  KR1. From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Monitors database health and helps troubleshoot basic issues under the direction of senior developers"
  KR2. Evidence at this level's autonomy bar: "General supervision; reviewed at milestones" — ⟨target⟩ by ⟨date⟩

Objective 3: Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity  [source: JFM responsibility (P2)]
  KR1. From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"
  KR2. Evidence at this level's complexity bar: "Some non-routine problems; applies established patterns" — ⟨target⟩ by ⟨date⟩

Objective 4: Performs backups and supports application developers, documenting database objects and application modules to maintain development standards  [source: JFM responsibility (P2)]
  KR1. From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"
  KR2. Evidence at this level's impact bar: "Own and immediate-team deliverables" — ⟨target⟩ by ⟨date⟩

Objective 5: Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers  [source: JFM responsibility (P2)]
  KR1. From ⟨baseline⟩ to ⟨target⟩ by ⟨date⟩ — tied to: "Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"
  KR2. Evidence at this level's decision rights bar: "Routine technical choices within guidance" — ⟨target⟩ by ⟨date⟩

MBO areas

Key result areas from this level's responsibilities, each with a standard grounded in the canon leveling rubric where one exists.

Area	Standard	Target	Due
Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases	Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."	⟨target⟩	⟨date⟩
Monitors database health and helps troubleshoot basic issues under the direction of senior developers	Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."	⟨target⟩	⟨date⟩
Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity	Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."	⟨target⟩	⟨date⟩
Performs backups and supports application developers, documenting database objects and application modules to maintain development standards	Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."	⟨target⟩	⟨date⟩
Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers	Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."	⟨target⟩	⟨date⟩

Copy / print as textshow ▾

1. Area: Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases  [source: JFM responsibility (P2) — reused, no distinct responsibility content]
   Standard: Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."
   Target:   ⟨target⟩   Due: ⟨date⟩

2. Area: Monitors database health and helps troubleshoot basic issues under the direction of senior developers  [source: JFM responsibility (P2) — reused, no distinct responsibility content]
   Standard: Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."
   Target:   ⟨target⟩   Due: ⟨date⟩

3. Area: Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity  [source: JFM responsibility (P2) — reused, no distinct responsibility content]
   Standard: Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."
   Target:   ⟨target⟩   Due: ⟨date⟩

4. Area: Performs backups and supports application developers, documenting database objects and application modules to maintain development standards  [source: JFM responsibility (P2) — reused, no distinct responsibility content]
   Standard: Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."
   Target:   ⟨target⟩   Due: ⟨date⟩

5. Area: Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers  [source: JFM responsibility (P2) — reused, no distinct responsibility content]
   Standard: Consistent with this level's jfm knowledge-application rubric: "Applies developing knowledge of SQL, indexing, and a primary DBMS platform to assist with maintenance, monitoring, and simpler queries under supervision and detailed instruction."
   Target:   ⟨target⟩   Due: ⟨date⟩

Scorecard

Only perspectives with real canon backing are shown — no Financial or Customer perspective, since nothing in the canon grounds business-financial or customer measures for a role alone.

Internal process

"Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"→ ⟨target⟩ by ⟨date⟩
"Monitors database health and helps troubleshoot basic issues under the direction of senior developers"→ ⟨target⟩ by ⟨date⟩
"Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"→ ⟨target⟩ by ⟨date⟩
"Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"→ ⟨target⟩ by ⟨date⟩
"Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"→ ⟨target⟩ by ⟨date⟩

Role calibration

Meets the scope bar: "Defined deliverables / small features"→ ⟨target⟩ by ⟨date⟩
Meets the autonomy bar: "General supervision; reviewed at milestones"→ ⟨target⟩ by ⟨date⟩
Meets the complexity bar: "Some non-routine problems; applies established patterns"→ ⟨target⟩ by ⟨date⟩
Meets the impact bar: "Own and immediate-team deliverables"→ ⟨target⟩ by ⟨date⟩
Meets the decision rights bar: "Routine technical choices within guidance"→ ⟨target⟩ by ⟨date⟩
Meets the leadership bar: "May guide interns"→ ⟨target⟩ by ⟨date⟩

Copy / print as textshow ▾

Internal process
  - "Assists with routine maintenance tasks under supervision and executes pre-defined scripts against development and test databases"  →  ⟨target⟩ by ⟨date⟩   [source: JFM responsibility (P2)]
  - "Monitors database health and helps troubleshoot basic issues under the direction of senior developers"  →  ⟨target⟩ by ⟨date⟩   [source: JFM responsibility (P2)]
  - "Writes and tests simpler SQL queries and assists with data entry and migration tasks while ensuring data integrity"  →  ⟨target⟩ by ⟨date⟩   [source: JFM responsibility (P2)]
  - "Performs backups and supports application developers, documenting database objects and application modules to maintain development standards"  →  ⟨target⟩ by ⟨date⟩   [source: JFM responsibility (P2)]
  - "Participates in code reviews and learns SQL, indexing, and a primary DBMS platform from senior developers"  →  ⟨target⟩ by ⟨date⟩   [source: JFM responsibility (P2)]

Role calibration
  - Meets the scope bar: "Defined deliverables / small features"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Scope)]
  - Meets the autonomy bar: "General supervision; reviewed at milestones"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Autonomy)]
  - Meets the complexity bar: "Some non-routine problems; applies established patterns"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Complexity)]
  - Meets the impact bar: "Own and immediate-team deliverables"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Impact)]
  - Meets the decision rights bar: "Routine technical choices within guidance"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Decision rights)]
  - Meets the leadership bar: "May guide interns"  →  ⟨target⟩ by ⟨date⟩   [source: level dimension (Leadership)]