InfoSys – Oracle Training Topics
FNNI Organization Structure and Teams to be Familiar With
Buildings
FNTS
FNIC
DFS (Investments)
Lauritzen Banks
FNBO
o Credit Card
o Banking
o FNIT
Infrastructure Operations and Infrastructure Engineers (System Administrators)
Client Engineers (SCCM, VDI, Software Deployment)
Storage Engineers (Rubrik, vSAN, FSx)
Command Center / Network Operation Center (NOC)
Service Desk
Office hours
Data Centers
FNBO
o TC (Tech Center)
Tech Center Building, Omaha, NE
o VMC (VMWare Center)
East-1, AWS, Northern Virginia
o AWS Native
Primary - East-1, Northern Virginia.
Secondary Approved - Oregon
FNTS
o CoLo = Rented space in a datacenter
o CoLo/TC (Tech Center)
Primary Data Center. Omaha, NE
o CoLo/LC (Lisle Center)
Secondary Data Center. Lisle, IL
o Mainframe (We rent from FNTS)
Server names
o Some TC servers will be in VC
information Security and Security Measures
Email
o Retention
o Scanning of incoming and outgoing mail
o Reporting Spam
o Phishing attempts
o Attachment scanning and manipulation
Penetration Testing
Intrusion Protection System (SQL Injection Detection)
Firewall (Checkpoint and NSX)
Desktop Monitoring
Antivirus and threat detection (SentinelOne)
Vulnerability scanning (Qualys)
Proxy (Netskope)
Security logging (Splunk)
Installing or downloading software
Overview of Email
Pager emails (request a pager contact)
Team group email
ServiceNow Overview and Configuration
Previously named OneSource
Review ITIL – Incidents, Service Requests (DATs), Change Requests, Problems
Review Agile – Stories, Epics, Projects
Vulnerability tasks
Adjusting On-Call
Creating Reports
How to search through inactive material
Forms we frequently use
o Requesting Storage, CPU, Memory
o Retirement of Servers
o Info sec forms for Firewall, Accounts, etc
WazzUp
o What is it?
o Maintenance Mode
Overview of Zoom
Meetings/Collaboration
Calling
Documentation is, or will be eventually, all stored in SharePoint. We will give a brief overview of the site.
Links
Shares
Folders
Important documentation, policies, and procedures
On-call calendar
o We will likely be retiring the use of the calendar as we likely won’t be tracking Infosys’s
on-call schedule
There are several shares your account will have access to in order to support imports and exports. There
are also team and IT shares we need to review:
Team file share
o \\master\fnshares\daentsys
IT share
o \\master\fnshares\it_transfer
Various DMZ’s Oracle servers might be in:
DMZ3D
DMZ3Q
DMZ3P
MASTER
o This is the account you get by default you login to your PC with
o Management DMZ – for OEM
FNBO purchases support with Oracle. You will need to register an account with your FNBO email address
so we can grant access.
Regarding the Oracle environment, there are several things to look at:
Versions and Editions of Oracle we support
Licensing
Review basic configuration standards
Audit configuration
Any settings configured to support TLS (1.2)
Components, services, or extra features enabled or installed for Oracle
Installation scripts overview and location.
Servers
o List of servers and how to access
o Permissions on the server
o Logs location
o Any server related performance monitoring tools or scripts
Integrations with SMTP (if applicable)
Any scheduled jobs (crontab?) on servers
Database mail and SMTP servers
Patching Process for Oracle and Linux
User access (if applicable)
Service accounts access (if applicable)
VMWare
Our clusters in each data center
Snapshots
Backup Solutions:
Rubrik
o SLAs
Retention
Frequency
o VSS and Snapshots
o Reports
o Live Mounts
o Client and configuration
o Refreshing hosts
Backups writing to disk (if applicable)
Encrypted databases and TDE
CipherTrust
Re-encryption activities (if applicable)
Any automation, reporting, or documentation surrounding Oracle servers
Auditing
What to provide Auditors when requested
Items to review in an audit report
Disaster Recovery
VCDR / VCLR / Live Recovery
Replication or High Availability Solutions (if applicable)
Backup and Restore
DR Sites (Lisle, AWS)
Monitoring and Alerts
OEM
Automation on servers that could alert
Places you need to adjust when on-call
Dynatrace
Password Vault (CybeArk)
How to access files
Standards for account creation
Data Warehouse Environment
Identify the team that manages the DW
Identify any integration or exports they have with DB2
How servers are provisioned
Architecture Diagram (website)
The Form (some exceptions may occur)
o Approvals
Tools we utilize
Putty, Multiputty Manager, XMING, SQL Developer, Oracle Client, Notepad++, Visual Studio
Code, etc.
Teams
Channels and Team Chats
On-Call and After Hours Responsibilities
Monitoring email
Response time and responding to pages
Addressing incoming Service Requests (DATs) and Incidents, and other similar requests
Current schedule and when we have switched over
Monitoring active alerts in OEM
Activities over patch weekends
Other External Systems we use
DS Info
Venafi - Getting SSL Certificates
Intranet
o Stop Codes
o Cost Centers
Workday (training)
H drive / OneDrive / Roaming profiles
File Transfer systems
Axway
NDM (Stirling Direct Connect)
Scheduled server (Visual cron)
Applications of interest that we support:
Peoplesoft
Hyperion
TDS
MTS
ESDS
Mobile
Etc.
Organization Holiday Freeze of Changes (see schedule in ServiceNow)
Releases, deployments, and anything surrounding changes