Experienced Oracle Database Administrator with a demonstrated history of working in the information technology and financial services industry. Skilled in Oracle, MongoDB, SQL Server, MySQL Server, Oracle EBS, RMAN, Performance Management, Oracle ASM, Data Guard, SQL Tuning and Oracle Enterprise Manager, SSRS, LogShipping, Replication, Performance Tunning, MongoDB ReplicaSet, MongoDB Sharding, Strong information technology professional with a Bachelor's degree focused in Computer Systems Engineering.
Oracle Database 11g, 12c, 19c and application EBS, SQL Server 2008/2012/2014/2016/2017,2019 MySQL Server 5.6, 5.7 8.0. MongoDB 4.2, 4.4, 5.0 replication and cluster administration, MariaDB 10.1.44.
Microsoft SQL Server (2005, 2008, 2012, 2014, 2016, 2017, 2019)
. Installation all types.
. Backups (scheduled & manual) and restore.
. Set up and monitor Disaster Recovery (DR) sites.
. Replication (Log Shipping).
. MSSQL Server failover cluster configuration and monitoring.
. Performance Tuning, PLE, CPU Utilization.
. Verifying daily checklist includes page life expectancy, Locks, CPU Load, Pending IOs, Backups & Logs, Agent Jobs Status & History Purge.
. Configuring DB Mail Service, Profiler and Accounts.
. Configuring Link Servers with Oracle, MySQL and SQL Server.
. Monitoring user access and security.
. Develop, manage and test back-up, cloning and recovery plans.
. SQL Server Scripting.
. Schedule jobs for executing Stored Procedures and backups, for daily, weekly and monthly basis.
. DBMail Configuration and monitoring for email alerts on jobs.
. Working experience on SSRS. Includes Creating and Managing Subscriptions, adding and granting roles and privileges to users.
oracle database 11g, 12c and application, EBS, SQL Server 2008/2012/2014/2016/2017, MySQL Server 5.6, 5.7 8.0. MongoDB installtion, replication and cluster administration.
Around 1.5 years of consulting experience in various areas of Oracle Database and Applications ensuring customer satisfaction in fast-paced, deadline-driven environments.
Overall Oracle Database Administration.
Remote Database Support.
Scripting, Patching, Database Maintenance