SUMMARY:

• Oracle DBA Sr. with extensive experience in performing Oracle database administration, tuning and design of backup policies.
• More than nine years of experience in production environments, most of them mission critical systems, RAC’s and VLDB’s, combining strong analytical and troubleshooting skills.
• Proficient with UNIX/LINUX operating systems and extensive experience with shell scripting.
• Strong knowledge of Oracle versions 9i, 10g and 11g, as well as HP/AIX/Solaris UNIX and most important distributions of Linux.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential

Responsibilities:

• User management
• Export/Import operations from production environment to test
• Log’s check tools, with big file’s truncation and compressed storage
• Capacity for adding space to tablespaces in a controlled manner
• Reorg/Stats operations of critical tables, with its index rebuilds, for the development team

Sr. Oracle DBA

Confidential

Responsibilities:

• Patch installation and version upgrades in production instances
• Instance creation over file systems, raw devices or ASM
• Configuration of startup parameters (in init.ora or pfile), as well as dynamic parameters
• Management and analysis of big log files, as alert or listener logs
• Monitoring instance’s health with custom made shellscripts, using Automatic Workload Repository (AWR), and Activity Session History (ASH) among other tools.
• Worked with Oracle support to resolve various issues within the database by opening and following SR's
• Live session’s tracing (detecting I/O, memory or access contention)
• Helped with complex queries, as well as their tuning using various tools like explain plan, AWR and traces/TKPROF
• User creation, granting and revoking privileges and resources, using profiles and roles
• Database's objects creation (views, triggers, constraints, sequences, packages, functions...)
• Use and proper configuration of export/import (also data pump version) for logical backup and schema creation in test environments
• General use of RMAN (Backup/Recovery/Restore), locally and using a catalog, and troubleshooting
• Use of flashback queries to recover rows or tables.
• Manage of partitioned/sub partitioned tables and their indexes
• Schedule and maintain table's statistics gathering/reorgs and index rebuilds
• Load data using SQL*Loader, and creation of specific control files (*.ctl)
• Locking of Users during load timings, killing of resource intensive user sessions
• Work as part of team and provide 24x7 supports when required
• Generated working documentation for the DBA team use
• Extensive use of ticket's systems (Remedy BMC)
• Providing support to development team to solve production's issues
• General use of TOAD among other tools.
• Knowledge of DB2 LUW version 10.

Sr. Oracle DBA

Confidential

Responsibilities:

• Oracle software installation over different operating systems (mainly UNIX/Linux, also Windows)
• Patch installation and version upgrades in production instances
• Instance creation over file systems, raw devices or ASM
• Configuration of startup parameters (in init.oraor pfile), as well as dynamic parameters
• Management and analysis of big log files, as alert or listener logs
• Database monitoring with OEM and custom made shellscripts
• Worked with Oracle support to resolve various issues with the database by opening SR's
• Tuning OS, storage and resolving I/O and contention issues
• Use of Crontab and DBMS JOBS to automate the monitoring jobs
• Helped with complex queries, as well as their tuning using various tools like explain plan, AWR/Statspack reports and traces/TKPROF
• Live session’s tracing (detecting I/O, memory or access contention)
• User creation, granting and revoking privileges and resources, using profiles, roles or Resource Manager
• Database's objects creation (views, triggers, constraints, sequences, packages, functions...)
• Use and proper configuration of export/import (also data pump version) for logical backup and schema creation in test environments
• Oracle session’s monitoring, identifying blocking sessions and performance
• Monitoring instance’s health, using statspack, Automatic Workload Repository (AWR), and Activity Session History (ASH)
• Use of Automatic Database Diagnostic Monitor (ADDM)
• General use of RMAN (Backup/Recovery/Restore), locally and using a catalog, and troubleshooting
• Cloning instances (cold copies or using RMAN)
• Use of flashback queries to recover rows or tables.
• Manage of partitioned/sub partitioned tables and their indexes
• Schedule and maintain table's statistics gathering/reorgs and index rebuilds
• Load data using SQL*Loader, and creation of specific control files (*.ctl)
• Locking of Users during load timings, killing of resource intensive user sessions
• Parallel load system's design
• Use of SRVCTL (server control utility) and ASMCMD (manage and monitoring of ASM)
• Oracle Applications installation and configuration, as well as managing services and component’s deploy
• Use graphics using awstat
• Installation and configuration of OMS and agents, over different platforms, to monitor OS, databases and application servers
• Work as part of team and provide 24x7 supports when required
• Communication with Oracle support for bug's identification and resolution for Service Requests
• Generated working documentation for the DBA team use
• Extensive use of ticket's systems.
• Providing support to development team to solve production's issues

Sr. Oracle DBA

Confidential

Responsibilities:

• Oracle software installation over different operating systems (mainly UNIX/Linux, also Windows)
• Patch installation and version upgrades in production instances
• Instance creation over file systems, raw devices or ASM
• Configuration of startup parameters (in init.ora or pfile), as well as dynamic parameters
• Management and analysis of big log files, as alert or listener logs
• Database monitoring with OEM and custom made shellscripts
• Worked with Oracle support to resolve various issues with the database by opening SR's
• Tuning OS, storage and resolving I/O and contention issues
• Use of Crontab and DBMS JOBS to automate the monitoring jobs
• Helped with complex queries, as well as their tuning using various tools like explain plan, AWR/Statspack reports and traces/TKPROF
• Live session’s tracing (detecting I/O, memory or access contention)
• User creation, granting and revoking privileges and resources, using profiles, roles or Resource Manager
• Database's objects creation (views, triggers, constraints, sequences, packages, functions...)
• Use and proper configuration of export/import (also data pump version) for logical backup and schema creation in test environments
• Oracle session’s monitoring, identifying blocking sessions and performance
• Monitoring instance’s health, using statspack, Automatic Workload Repository (AWR), and Activity Session History (ASH)
• Use of Automatic Database Diagnostic Monitor (ADDM)
• General use of RMAN (Backup/Recovery/Restore), locally and using a catalog, and troubleshooting
• Cloning instances (cold copies or using RMAN)
• Use of flashback queries to recover rows or tables.
• Manage of partitioned/sub partitioned tables and their indexes
• Schedule and maintain table's statistics gathering/reorgs and index rebuilds
• Load data using SQL*Loader, and creation of specific control files (*.ctl)
• Locking of users during load timings, killing of resource intensive user sessions
• Parallel load system's design
• Use of SRVCTL (server control utility) and ASMCMD (manage and monitoring of ASM)
• Installation and configuration of OMS and agents, over different platforms, to monitor OS, databases and application servers
• Work as part of team and provide 24x7 supports when required
• Communication with Oracle support for bug's identification and resolution for Service Requests
• Generated working documentation for the DBA team use
• Extensive use of ticket's systems (custom software)
• Providing support to development team to solve production's issues
• Use of DB Artisan and TOAD, among other tools.

Sr. Oracle/UNIX Systems Technician

Confidential

Responsibilities:

• Optimized ETL (validation and load) processes of main Data Warehouse in production environment.

Jr.Oracle/UNIX Systems Technician

Confidential

Responsibilities:

• Created UNIX scripts for operation and monitoring production’s systems

Jr. Oracle DBA

Confidential

Responsibilities:

• On Call Technician for multiple clients and projects (Oracle/UNIX related).