08/26/2024 updated
AM
100 % available
Oracle DBA/SQL DBA, Lead Consultant, Lead Consultant -Oracle DBA
Dewsbury, United Kingdom
Worldwide
Master in Computer ApplicationIBM AIXSoftware ApplicationsBackup DevicesOracle WebLogic ServerBusiness Process Execution LanguageUnixProfilingDatabasesData FilesData RecoveryOracle Data GuardLinuxDisaster RecoveryMiddlewareOracle ExadataOracle ExalogicFailoverUnix ShellLog FilesLog ShippingMicrosoft Certified Database AdministratorSystem Center Operations ManagementMicrosoft SQL ServersNetBackupNode.JsOracle Business Intelligence Enterprise EditionOracle Cluster File System (OCFS2)Oracle DatabasesOracle ApplicationsOracle SQL DeveloperPerformance TuningWindows PowerShellCloverRecovery Manager (RMAN)Service-Oriented ArchitectureService PackShell ScriptSolaris (Operating System)SQL*PlusSQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesLoad BalancingGrid Packaging TechologySql Server Database AdministrationSystem AvailabilityDatabase OptimizationLiferayDatabase PerformancePerformance MonitorExtreme ProgrammingToad (Software)Operational SystemsNetwork ServerSql Database AdministrationServicenow
Database backups, backing up, BPEL, Clover, data files, Database Recovery, database optimization, database performance, Database, databases, Disaster Recovery, XP, Failover, Grid Control, AIX, IBM AIX, Computer Science, Liferay, Linux, Load Balancer, log files, Log shipping, MS SQL Server, SQL Server Databases, SQL Server, Windows, Windows Platform, Middleware, Veritas NetBackup, servers, node, Operating Systems, Oracle, OBIEE, Oracle Data Guard, DataGuard, Oracle Database, Oracle Databases, 9i, 12c, Oracle DBA, EXADATA, Oracle SQL, Oracle Weblogic, Performance Monitor, performance tuning, Profiler, RMAN, SQL, sql scripts, SSIS, SSRS, SQL*Plus, service packs, SOA, ServiceNow, Shell Scripting, shell scripts, Computer Application, Sun Solaris, high availability, SCOM, TOAD, UNIX, shell, PowerShell scripting
Languages
EnglishFluent
Project history
* Extensive experience in Oracle Database Installation (9i,10g,11gR2,12C,19C) , configuration
and administration on Linux, Sun OS , IBM AIX, & Windows Platform
* Experience in upgradation and migration of Oracle 10gR2 RAC, 11gR1 RAC to 11gR2 RAC.
* Maintenance and Support of Oracle Databases on Linux/AIX with 12c/19c RAC.
* Created DataGuard for the Disaster Recovery of the critical databases and monitoring the Log
shipping by writing shell/sql scripts.
* Actively Performed DR Drill by switchover and switchback activity successfully.
* Creating, Maintaining and monitoring the DB-LINKS created to integrate the different
environments.
* Cloning and Patching of Oracle Database
* Applied Oracle Database patches using OPATCH.
* Troubleshooting the Oracle bottleneck and resolving the performance issues related to
different application issues.
* Performing the Oracle database activities of creation of USERS, granting privilege, creating
roles.
* Maintaining the security of the database by properly adding or removing the roles/grants on
the objects.
* Designed database architecture and perform the Capacity planning on the databases as per the
application requirements.
* Troubleshooting END users issue related to Oracle Database
* Performing Administrative task using Oracle SQL like adding of datafiles, growth monitoring.
* Writing shell scripts to automate monitoring and performing daily database health checks.
* Planning and Managing Database backups
* Monitoring END Users Requests so that performance of the system is maintained
* Experienced In ITIL Framework And In Defining And Developing Processes And Process
Improvements For IT Service Management.
* Clone and Refresh Oracle Database.
* Successfully set up a two-node cluster and RAC database on Linux, IBM AIX and Exadata Server.
* Adding nodes to the existing cluster.
* Configuring and managing OCR and voting disk.
* Incident management, change management, problem management using ITSM tool.
* Backup and recovery strategy using RMAN.
* Creating RMAN scripts.
* Duplicating database using RMAN.
* Refresh database to a previous incarnation using RMAN.
* Hands on experience in Cross platform migration
* Optimizing database performance.
* Worked on 24/7 high availability environments.
* Knowledge of Oracle and UNIX Security and networking.
* Clone database using online/offline backup.
SQL DBA Activities:
* Creating and Administering the SQL Server Databases, managing the growth parameters and
database options.
* Resolving the Disk space issues and finding the root cause and permanent fixes.
* Experience in Database Consistency Checks using DBCC commands and checking server status using
DMV's.
* Experience in automation of SQL Server activities including jobs, maintenance plans.
* Migration of database between the servers and providing technical support for the business
users.
* Developed Backup strategies (Full, Differential, Transition log)for Database Recovery, backing
up database, backing up data files, log files, verifying the integrity of backup files.
* Verifying and resolving the SQL Server Blocking issues and Finding the root cause
* Maintaining High database availability for supporting non-stop Business Operations.
* Experience in applying the service packs and cumulative updates for servers.
* Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update
statistics and monthly maintenance plans such as clean up history etc. to run the databases
efficiently.
* Performing the Failover and Failback operations in the cluster environment and adding the new
Disks and troubleshooting activities.
* Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long
running queries and deadlocks.
* Hands on experience on monitoring tools like SCOM, SPOTLIGHT,ServiceNow.
* Good knowledge on SSIS and SSRS.
* Maintaining the SQL Server Stand-Alone and Failover cluster Instances.
and administration on Linux, Sun OS , IBM AIX, & Windows Platform
* Experience in upgradation and migration of Oracle 10gR2 RAC, 11gR1 RAC to 11gR2 RAC.
* Maintenance and Support of Oracle Databases on Linux/AIX with 12c/19c RAC.
* Created DataGuard for the Disaster Recovery of the critical databases and monitoring the Log
shipping by writing shell/sql scripts.
* Actively Performed DR Drill by switchover and switchback activity successfully.
* Creating, Maintaining and monitoring the DB-LINKS created to integrate the different
environments.
* Cloning and Patching of Oracle Database
* Applied Oracle Database patches using OPATCH.
* Troubleshooting the Oracle bottleneck and resolving the performance issues related to
different application issues.
* Performing the Oracle database activities of creation of USERS, granting privilege, creating
roles.
* Maintaining the security of the database by properly adding or removing the roles/grants on
the objects.
* Designed database architecture and perform the Capacity planning on the databases as per the
application requirements.
* Troubleshooting END users issue related to Oracle Database
* Performing Administrative task using Oracle SQL like adding of datafiles, growth monitoring.
* Writing shell scripts to automate monitoring and performing daily database health checks.
* Planning and Managing Database backups
* Monitoring END Users Requests so that performance of the system is maintained
* Experienced In ITIL Framework And In Defining And Developing Processes And Process
Improvements For IT Service Management.
* Clone and Refresh Oracle Database.
* Successfully set up a two-node cluster and RAC database on Linux, IBM AIX and Exadata Server.
* Adding nodes to the existing cluster.
* Configuring and managing OCR and voting disk.
* Incident management, change management, problem management using ITSM tool.
* Backup and recovery strategy using RMAN.
* Creating RMAN scripts.
* Duplicating database using RMAN.
* Refresh database to a previous incarnation using RMAN.
* Hands on experience in Cross platform migration
* Optimizing database performance.
* Worked on 24/7 high availability environments.
* Knowledge of Oracle and UNIX Security and networking.
* Clone database using online/offline backup.
SQL DBA Activities:
* Creating and Administering the SQL Server Databases, managing the growth parameters and
database options.
* Resolving the Disk space issues and finding the root cause and permanent fixes.
* Experience in Database Consistency Checks using DBCC commands and checking server status using
DMV's.
* Experience in automation of SQL Server activities including jobs, maintenance plans.
* Migration of database between the servers and providing technical support for the business
users.
* Developed Backup strategies (Full, Differential, Transition log)for Database Recovery, backing
up database, backing up data files, log files, verifying the integrity of backup files.
* Verifying and resolving the SQL Server Blocking issues and Finding the root cause
* Maintaining High database availability for supporting non-stop Business Operations.
* Experience in applying the service packs and cumulative updates for servers.
* Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update
statistics and monthly maintenance plans such as clean up history etc. to run the databases
efficiently.
* Performing the Failover and Failback operations in the cluster environment and adding the new
Disks and troubleshooting activities.
* Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long
running queries and deadlocks.
* Hands on experience on monitoring tools like SCOM, SPOTLIGHT,ServiceNow.
* Good knowledge on SSIS and SSRS.
* Maintaining the SQL Server Stand-Alone and Failover cluster Instances.