Successfully migrated Landmark databases environment to RAC One Cluster.Developed automated process of loading Daily Production Report within OFM.Installed and configured ESRI SDE for Petrel, Openwork's and OFM.Handled database server tuning, capacity planning, physical database design and implementation of database Security.Identify resource and performance bottleneck. Working with system administrator to monitor CPU usage, I/O contention, memory paging on UNIX server.Supported Land Mark users within Oracle Database environment.Developed documentation and maintaining dba procedures.Installed, configured and upgraded Oracle, SQL Server software, etc.Installed, configured Oracle12c, ASM, RAC instances, Data Guard and Stand-alone instance.
Working with PL/SQL Team and Involved in all phases of database development, from assessment to QA/QC and support.Installed and configured SQL Server cluster within VMware environment and Oracle Golden Gate.Managed multiples database environments from Oracle 10g - SQL Server 2008R2 -SQL 2012.Created database procedures, scripted, database alerts and monitored scripts.Automated SQL Jobs for nightly backup and reporting.
Working on Business continuance and high availability and Data Integration with Golden gate.Provided consultative services to implement the Memory configuration for Database Instance and ASM instances.Provided assistance to Memory Corruption and Dictionary Corruption Errors.Provided assistance to Customers In Solving ORA- errors.Setup the materialize views for replication.Enhanced Oracle RMAN scripts for nightly backup.Migrating and upgrading the databases to higher versions SQL Server 2008 Setup, Configuration, Security, replication and performance and tuning.Installed, configured Oracle 12c, 11g ASM, RAC instances, Data Guard and Stand-alone instance.Provide troubleshooting assistance with networks and web services. Managed servers in an active directory environment, ensuring that each server has 100% uptime. Performed database and system administration for a corporate network supporting over 250+ employees.Management of schemas, objects, tables & indexes partitioning.Checking for Alert log file for errors and monitoring the Hit ratios.Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).Experience in PL/SQL, stored procedures, triggers and database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.Expertise in Security administration, roles, profiles.Expertise in monitoring, performance tuning and troubleshooting.Experience in Oracle 12c, 10g/11g RAC, Oracle ASM, Oracle Data Guard, and Oracle RMAN.Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11gOEM Grid Monitoring.Significant hands - on experience with oracle installations and version upgrades, Experienced in using 11g features Data pump Flash-Back Recovery, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.Experience includes leading globally distributed teams to manage multiple concurrent product releases, while effectively resolving conflicting priorities.Demonstrated strong partnership with other Service Delivery teams in the successful execution of standard processes (incident management, problem management, release management, change management, etc.).
#Toad sql server schema snapshot Patch#