SUMMARY:

Senior position as an Oracle Database Administrator with Great Cybersecurity functional experience and knowledge. Dedicated and highly driven professional database administrator that bring result to an organization, knowledgeable in Oracle technologies (e.g., RAC, ASM, OEM/Grid, RMAN, Partitioning, Data Guard, Golden Gate) in production and other environments. Systems Development Life Cycle (SDLC), in addition to vulnerability management. A proven goal - getter and team lead with strong positive customer service. A result-oriented person and a team player, quick to catch up with new technology and environment. Able to thrive in fast-paced and challenging environments where accuracy and efficiency matter with over 10 years in IT industry.

PROFESSIONAL EXPERIENCE:

ORACLE Database Administrator

Confidential, Atlanta, Georgia

OPERATING SYSTEMS: Windows NT/2008/2012, Sun-Solaris, HP UNIX, AIX, Linux Red hat, Sun Solaris. DATABASES: Oracle 8.x/9.x/10g, 11g,12c on GPO/Manufacturing, Edc. and other environments. OEM 12c (A 24/7 PRODUCTION DBA).

Responsibilities:

• Perform production activities on 24 x 7 supports as on call member of a dba team.
• Managed database in different environment in addition to GPO and manufacturing environment using tools like Jsitemanger, HPSA client and a lot more.
• Perform database patching both on Edc. and GPO/manufacturing environment.
• Managed databases on Unix, Linux and windows environment.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Installed and managed Golden Gate
• Create, reviews and deploy application builds, releases into production, Test and pre-production environment.
• Managed databases including space management, Rollback segments and Extents management, table spaces and data files management, monitoring and resizing.
• Multiplexed control files and redo groups’ members and replicated data using snapshots and db. links.
• Performed Performance monitoring and tuning through Alert logs and Trace files for problem queries, tuned Shared Pool size, Library Cache, Buffer Cache, used oracle database block size efficiently, optimized sorts operations, monitored table space I/O, tuned rollback segments and monitored and detected locks and latch contentions and eliminated the dead locks.
• Installed, configured and maintained hot standby database for high availability.
• Cloned databases for developers testing. Loaded data SQL*Loader. Executed hot, cold and logical backup and restore procedures.
• Managed system resources creating user profiles and roles.
• Performing Database Refreshes for testing and development, cold and hot backups using Recovery Manager (RMAN) utility to back up, restore, and recover data files, control files, and archived logs in GPO/Manufacturing and other environments
• Developed scripts to carry out routine checks on databases. This included checking whether all databases are running, listener is up, UNIX error messages, disk space availability, segments nearing max extents, checking regularly the alert logs and trace files for errors.
• Created databases on a four (4) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASM. Experience managing RAC and ASM

Confidential, Chantilly, Virginia

ORACLE DBA (A 24/7 PRODUCTION DBA)

OPERATING SYSTEMS: Linux Red hat, Sun Solaris, LINUX, UNIX - (AIX, HP-UX, SUN SOLARIES, IBM), Windows 2008, TOAD, SQL - LOADER, PL/SQL, RAC (ASM STORAGE)

DATABASES: Oracle 9i/10g/11g, OEM (grid control) STIP application, Data guard, web logic, windows databases.

Responsibilities:

• Responsible for C3E migration environment; installed and migrated Oracle database (Servers) on Sun Solaris, UNIX, Linux and Windows to Exadata Environment (machines).
• Created databases, storage structures and database objects for migration purposes.
• Experience in Data guard installation and configuration and using it for migration.
• Experience in database upgrade and migration using Import & Export (Data Pump), Transportable Tables space, Golden Gate.
• Performed database refreshes for testing and development, cold and hot backups and used Recovery Manager (RMAN) utility to back up, restore, and recover data files, control files, and archived logs.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis
• Developed shell scripts and PL/SQL procedures and scheduled Cron Jobs and DBMS SCHEDULER to monitor the database performance and for user management.
• Monitoring and tuning of the database performance using STATSPACK, Explain Plan and TKPROF.
• Optimized tuning of user sessions and system level performance using SQL TRACE and gathered statistics using DBMS STAT.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• RAC, ASM
• Create databases on a four (4) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASM
• Drop disk group from the ASM storage

Confidential

Sr. Oracle DBA (2407 PRODUCTION DBA)

OPERATING SYSTEMS: Unix/Linux, AIX, Standby, Replication, Windows, VERITAS HA Cluster, web servers, discoverer, SUN-Solaris, Enterprise Manager.

DATABASES: Oracle 10/9i/8i, Windows, Oracle Warehouse Builder, RAC, ASM, Data Guard, Replication, web servers, discoverer, Production, Development and test environment.

Responsibilities:

• Refreshed development and test databases from production database using Exp/Imp 0r data pump to provide the latest data in the development/test database for the developers.
• Executed file system, server based (RMAN) backups and logical (exp) backups. Executed complete and incomplete media recovery procedures (Time/Change/Cancel-based).
• Create databases on a four (3) nodes RAC that uses automatic storage management (ASM)
• Added disk to disk groups in ASM
• Created database, database objects like table, index, DB Link, users, rollback segments, and views and analyze relevant objects to collect statistics to tune the system performance
• Perform production activities on 24 x 7 supports as on call member of a dba team.
• Implement and maintain database security (create, and maintain users and roles, assign roles/privileges
• Experience using monitoring tools such as Grid Control/fog light to monitor table spaces, Memory Structures, Rollback Segments, Logs and Alerts
• Creating and managing standby database (standby setup/configuration)
• Experience with backup and Recovery strategies (RMAN, cold backups, hot backups exports, data pumps) Data guard.
• Apply quarterly patches/rolling patches to oracle 10/11G.
• Managed VL databases in Terabytes sizes, Managed warehouse database including PeopleSoft database environment.
• Good troubleshooting abilities (expert in performance tuning system, query and server), good understanding of oracle application, knowledge of managing distributed architectures, good knowledge of windows environment and supported software databases.
• Control of database operating environment, including allocation of space for users, tuning shared memory parameters and maintenance of logical and physical logs.
• Reviews and implement application builds, releases into production, Test and pre-production environment.
• Installed and managed Golden Gate
• Install oracle quarterly CPU/Rolling patches.

Confidential, Reston, Virginia

Sr. Oracle DBA

OPERATING SYSTEMS: Windows 2008, OEM, Toad, LINUX, UNIX - (AIX, HP-UX, SUN SOLARIES, IBM), TOAD, SQL - LOADER

DATABASES: Oracle 10g/11, RAC (ASM STORAGE), SQL Server 2008, DATAGUARD, Enterprise Manager (OEM), RAC, ASM, Data Guard, Replication, Production, Development and test environment.

Responsibilities:

• Perform production activities on 24 x 7 supports as on call member of a dba team.
• Implement and maintain database security (create, and maintain users and roles, assign privileges)
• Good troubleshooting abilities, good understanding of oracle application, knowledge of managing distributed architectures, good knowledge of windows environment and supported software databases.
• Control of database operating environment, including allocation of space for users, tuning shared memory parameters and maintenance of logical and physical logs.
• Reviews and implement application builds, releases into production, and pre-production environment.
• Experience in oracle 11.5.10.2 E-Business suite application and 10G Release 2, 11gR1 database version.
• Experience in patching, installs, upgrade and perform standard database operations including export, table restoration and re organizations appropriate for support level.
• Experience using monitoring tools such as Grid Control/fog light to monitor the databases/applications.
• Creating and managing standby database.
• Experience with backup and Recovery strategies (RMAN, cold backups, hot backups exports, data pumps) Data guard.