# data[].attributes.body
1. Grooming of Change SME
2. Focus on continuous technical development and retooling
3. Succession planning
4.  Leadership development
5. Continuous Metric Management

# data[].attributes.body
1. . Lessen U1 for capacity issues - RFS Process Familiarity
2. Quarterly Business, CSAT and Projects Update with the RUN Team
3. Support in changing db job names for autosys
4. New Autosys servers where db does not have access

# data[].attributes.body
1. Automation for patch installation
2. Automation for Code Deployment
3. Toad Software

# data[].attributes.body
📌cbmccus177p database jobs
a. clear ownership of the database jobs - AO has access to the jobs we monitor, they are allowed to modify, OI, off ice the jobs. This can cause conflict/confusion between CIBC and DB team.
b. Approval on standardizing the database jobnames just like in MOA autosys server.

📌For non -production backups ( level 0 backups) - for newly created databases, schedule the weekly backups on the weekdays to avoid failures of Prod weekend backup. For existing databases, non prod backups need to be rescheduled to weekdays as per the BUR Team

# data[].attributes.body
1. Final approach if PDIT/Refresh are billable tasks.
2. SME development for change team
3. SKills assessment and TNA
.

# data[].attributes.body
📌LOB AO complete contact (capacity reference)

📌RFS process improvement (team coordination, scope of service)
📌Non C non SQL Supported CIs

# data[].attributes.body
1. CMDB : Complete list of Applications with MAPID and the databases that they are using (all tier)
2. Doogle : Standardization of data. Should not always be free text but instead pull-down list with defined values especially the critical fields

# data[].attributes.body
1. OEM template to exclude non impacting ORA errors to avoid ticket flooding
2. Standard format in registering targets for monitoring in OEM.
3. Fast track migration of problematic Gen 4 farms / clusters.

# data[].attributes.body
1. OEM Automation (API/WINAUTOMATION) - Alvin/Steph
2. Billing Automation (CONFIGURATION MANAGEMENT) - Alvin/Steph
3. Onboarding Access Automation (NEWLY HIRED EMPLOYEE) - Alvin/Lori :)

# data[].attributes.body
FORMAT: WISH - YOURNAME
note: Money not allowed :)
ex 1. API Automation - Lori
ex 2. Auto routing of tickets to ASO for non-supported SQL - Lori

# data[].attributes.body
Billing - religiously filling chargeable hours for every project related tasks.

Will explore automated report that will send email on the list of project related tasks - daily governance

HO Huddles- Assign on shift DBAs to all handover changes to drive ownership and reduce response time to internal/external emails.

Pending measures of success

Ensure we continue to achieve success rate/ meet center's metrics. Ex. correct tagging on changes, thorough reviewed

How do we sustain?

# data[].attributes.body
📌Minimize manual work effort in notifying ADM/ LOB for capacity increase recommendation 6-12MTF or TS consumption (automated mail notif)

📌Push CIBC for Proactive Capacity planning not relying on re-active alerts  - Capacity Deck for CIBCs consumption per LOB
WHats the next step? Risk Acceptance? Hall of Shame?
(ex. SQL non prod)
📌

# data[].attributes.body
1. Cookbook Creation
Goal is to close out and complete based on target deadlines
2. Automation Initiatives
Watch out on pending automations  what are the roadblocks
a. ACL
b SQL / BU dashboard
c DB up and down check for tier 1
d Doogle
e PDT Schema Automation
3. Enhance SQL/ORACLE RTPA Automation

# data[].attributes.body
1. Use Business Criticality in ESL to tag incidents as [KPE] to assist team with prioritization of incidents.
Challenge: how to identify non prod sevables
2. Effective cross-skilling - target is 80%.
Help needed: formal training for SME (Technical - Community of practice - DB2, Netezza)
3. Drive ownership of technical SMEs and POCs of mini teams and make them more visible in the team.

# data[].attributes.body
1. Minimize total backup failure - 177p unixl59, 530 and 531
Plans in the past: Map the schedule of activities - 1 server at a time (in progress)
Roadblock:
Accountability of BUR on the criticality of Backup failures - regular reboot whos in charge? Pending discussion between unix, bur and db
testing (in progress)
2.Configuration issues
Escalation to build (in progress)
SQL - Pending Craig
3. Realtime(daily) ticket analysis - hold off

# data[].attributes.body
1. Sustain GREEN SLA and Focus on RED SLAs (P3/P4)
2. Career Talks
3. Leadership Development
4. Support NGDM Leads and remove roadblocks

# data[].attributes.body
- CMDB completeness and accuracy
CHallenge: Getting RUN to be aligned with new updates made by Build to Runbook
- RTPA process continuous improvement
- Billable CI review to further ensure that the team is neither losing from nor overcharging the account (Invoicing)
-Activate PROD servers identified without SCOM alerting