When performing a dual role and after careful planning and designing, what would be the critical factors to consider as a Siebel Administrator and Oracle DBA?
I understand there are so many other tasks involved as a Siebel administrator during the planning and designing stage, but here are a few of the critical steps I have outlined off the top of my head. I took RHEL as an example Linux operating system.
Oracle DBA
Oracle DBA must ensure enough resources are available to spin the new database(s) for Siebel.
Enough resources mean Servers (Virtual/Physical stand-alone), CPUs, RAM, Disk Space, NAS drives/CIFS Shares, Samba Mounts, etc.
As a DBA, work closely with the Siebel development team to ensure their applications efficiently use the database.
As a DBA, work closely with the Siebel Administrator Team (In this scenario, it is the DBA himself).
Careful planning on the users/schemas, grants/privileges, Indexes, Tablespace, firewall policies on the database ports, oracle database listener, RMAN backup, dataguard, TNS names.
As an Oracle DBA, it becomes that person's responsibility to design the Oracle Database architecture and understand how that instance works as per the Siebel application.
As an Oracle DBA,
Install, upgrade, and apply any maintenance releases or Oracle DB patches.
Design the databases = Identify the requirements + create logical design + physical database design.
Manage users/schemas and security.
Manage storage for the database and develop a backup strategy (cold or hot).
Recover the databases in case of failures (RMAN/TAPE/Any other latest methods).
Manage Oracle Database and servers startup and shutdown by automation.
Manage database objects such as Siebel Tables, Siebel Indexes, Siebel Data, and Views.
Evaluate and test new database patches, maintenance releases, and features.
Periodic monitoring and tuning of Oracle databases.
Report and Raise incidents to Oracle support regarding any critical database errors.
Siebel Administrator
Thorough Understanding of Siebel architecture and framework capabilities, including understanding Gateway Server, Siebel Enterprise Server, and Siebel Application Servers.
Design Siebel/OHS/Weblogic/BIP/OBIEE Servers for optimal performance, failover, and scalability. Suggest proper hardware and software load-balancing options for the web and Network teams.
Design and install the Siebel Infrastructure on RHEL servers and distribute the Siebel components onto all the servers.
Install any Missing Library Files on the RHEL boxes corresponding to the Siebel, OBIEE/BIP, IBM LDAP Client, etc.
Gather requirements for Siebel File System and design the File System as per the requirements.
Install Siebel CRM on Windows (Document Servers).
Install OHS/webserver on Linux 64-bit platform and perform OHS/SSL configuration. Install SSL Certs using Oracle Wallet in OHS Webservers.
Work with Security Teams to get the Trusted and User Certs.
Perform Siebel IBM LDAP Configuration by installing the IBM LDAP Client and necessary library files at the root level.
Install Siebel Tools/Siebel Developer Client on Developer machines and Dedicated Windows machines.
Load balance the Siebel servers and configure the Siebel env for High Availability.
Write shell scripts to monitor the Siebel comps, log levels, App servers, web servers, etc.
Create custom Object Managers for each country and tune the Max Tasks, MinMT Servers, and MaxMTServers.
Performed cfgmerge.
Configure Siebel Components as needed to meet the business needs.
Write SQLs during the Siebel upgrade process to ensure the data flow is happening correctly and smoothly.
Monitor the SQLs during the upgrade process for any unexpected data issues.
Worked with QA Teams, BSAs, and Developers after the upgrade to ensure no unexpected issues with the infrastructure, data, workflows, triggers, RCRs, etc.
Comments