Sateesh D Email & Phone Number

Irving, Texas, Us

• Worked in migrating the PeopleSoft application related databases from on-premises to OCI (including PROD, DR, Active DG, UAT, DEV, TEST) DB’s.• Worked on DR build and DR drill activities (Physical standby and Active Dataguard).• Worked on converting single node Database to RAC database.• Worked on Databases patching to the latest version.• Worked on upgrading the databases from 12.2 to 19.16.• Worked on day-to-day activities and used to manage Incidents, SCTASKS and Changes.• Performed Database migrations from RHEL 5 to 7 and RHEL 6 to 7. • Performed databases patching using Fleet maintenance from OEM. • Performed multiple database refreshes and Databases cloning to restore and recover the old table from backups. • Managed Change Management meetings and worked with the Client and from the Business to get necessary approvals. • Expertise in Configuration of Compute Instance & Database Instance in OCI tenancy. • Expertise in planning and managing of Database Migration from On Premise to OCI

• Managing multiple Oracle production databases on multiple OS platforms in a 24x7 service environment. • Responds to monitoring alerts and high severity tickets (based on Severity levels 1, 2, 3, 4) problem solving and resolution skills in handling scenarios. • Proactively Monitoring alerts, assigning to right queues, resolving in time based on SLA. • Executing Customers Database Change Request scheduled by the change management within the allowed down time. • Creating the users and assigning the roles & profiles as needed. • Performing space management at database level (Tablespaces) and server level (File Systems) and work with UNIX team. • Adding the datafiles to the tablespaces whenever they reach the threshold value when needed. • Checking the database blocking sessions and working with app support team to resolve them. • Configuring DataGuard (DR Site) for High Availability. • Monitoring Redo Transport services, Log apply services in DR environments. • Performing Switchover and Failover in DR environments as per the requirement. • Manually determining & resolving the archive log gap. • Checking the Alert log and trace files and if any error triggers find out the root cause & analyze for resolution. • Participating in team level meetings and giving suggestions/comments/feedbacks on improvement of project process• Monitoring and performing daily incremental backups, weekly backups using RMAN. • Check out CRS status and Administration of RAC Instances using CRSCTL Utility. • Created and managed users, roles, privileges, schemas. • Testing the switchover status of the Dataguard for every Quarterly. • Creating and managing DBLINK to link schema objects residing on remote database. • Supporting to the application team while working on development and test databases. • Creation of the users and grant the respective privileges to the users. • Send the database growth report to the customer on weekly/monthly basis.

Oakland, California, Us

• Creation of the users and grant the respective privileges to the users. • Experienced in Resolving Archive gap issues, trouble shoot network related issues in Data Guard configuration. • Check out Cluster status and Administration of RAC Instances using SRVCTL/CRSCTL • Generating the AWR report and analyzed in first level and will take appropriate actions. • Starting and stopping the Oracle services for UNIX patching. • Configure, Monitor and support Physical Standby databases. • Creating and maintaining the users, secure application roles, privileges and profiles. • Monitoring and troubleshooting RMAN database backups. • Switchover the Primary database to standby database and convert the physical standby to snapshot standby database and vice-versa for application testing. • Worked on day to day activities and used to manage tickets and Changes. • Supported for migrations of Databases from one DC to another DC. • Involved in Database upgrade from 11g to 12c. • Involves in Installation & Configuration of Oracle 12c Real Application Clusters (RAC) databases. • Administering ASM instances, Managing ASM disk groups, Disks with ASMCMD, ASMCA utility • Applied different patches (CPU, PSU, and RU) on RAC & Standalone and OCI databases. • Scheduling and managing Oracle RMAN backup and Logical Backup using Oracle Data Pump utilities.• Monitoring and performing daily incremental backups, weekly backups using RMAN. • Check out CRS status and Administration of RAC Instances using CRSCTL Utility