Objectives

• Seeking a position as an Oracle DBA/Architect that will utilize my 24+ years IT experience (20+ years as DBA and 4 as a UNIX admin).

SUMMARY

• Certified Oracle Database Administrator, wif a proven track record in successful implementation and problem solving.
• Extensive expertise in large database environments including
• Implemented multiple RAC/GI release 11GR2 wif ASM, ACFS, and EMC’s Powerpath on LINUX
• Implemented Grid Infrastructure on a standalone node
• Implemented Time finder cloning for a reporting Database wif assistance from storage team
• Implemented active data guard in RAC to RAC and standalone environments.
• Database installation, configuration, upgrades, migration, and maintain over 450 databases mostly in ACTIVE/PASSIVE environment using VCS
• SQL performance tuning using Oracle Stored Outlines, SQL Profiles, ASH, and Oracle tools and utilities e.g., tkprof, and SQL tracing etc.
• Experienced in creating, configuring Linux systems in cloud infrastructure (AWS).
• Experienced in migrating Oracle database to Amazon web services (AWS) RDS using Oracle as well as AWS tools.
• Database performance tuning and analysis using STATSPACK and AWR reports.
• Implemented Oracle 10g RAC in a two node Solaris environment using ASM and oracle Clusterware on Solaris
• Backup and Recovery using RMAN wif VERITAS Net backup and legato.
• Managed databases in EXADATA for data warehouse
• Worked wif PeopleSoft upgrade team as primary DBA. Changed DB character set from a Western European to AL32UTF8
• Experience wif DB compression, Table Partitions, Pluggable databases, Oracle’s Native Encryption (over the Wire), TDE (Table level and tablespace level)
• Managed DBA team in Manager absence
• Certified Sun Solaris admin

TECHNICAL SKILLS

Software: Oracle 8, 9, 10, 11G, 12C, Grid Infrastructure (RAC), Grid control/cloud ACTIVE/PASSIVE, SQL*Plus, PL/SQL, TOAD, DataGuard, UNIX Shell scripts

Operating Systems: Sun Solaris and RedHat LINUX.

PROFESSIONAL EXPERIENCE

Confidential, New York

Lead ORACLE DBA

Responsibilities:

• Implemented multiple RAC environments using Oracle Grid Infrastructure 11GR2 wif ASM, ACFS, PowerPath
• Implemented Active Data Guard in RAC to RAC(11GR2) and standalone environment
• Setup a reporting environment using Time Finder cloning
• Application performance tuning using using SQL tracing, TKPROF, Stored Outlines, SQL Profiles, Migrating SQL Profiles from one DB to another and explain plan
• DB performance tuning using STATSPACK, AWR, and dynamic performance view. Tuned major issues wif some critical applications like 311 call center, Snow Plow, and Calendar event.
• Migrated Oracle databases from on - premise to AWS Cloud (EC2) successfully.
• Prepare and scope migration path for moving the entire on-premise into the cloud (Oracle/AWS).
• Supported Oracle databases in AWS Cloud.
• Installed and configured of GoldenGate on 11g/12c database for data replication.
• Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.
• Resolved the issues in conflicts between the target and source database in GoldenGate
• Provide database support for 450 databases including 30+ production
• Lead Pilot on designing and implementation for application and database new releases
• Implement Backup and performed DB recoveries using RMAN wif NetBackup
• Tuned large pool for rman and made sure it uses large pool and runs backup asynchronously.
• Installed and configured Oracle 12c Multi-Tenant Container Database and Pluggable Database format.
• Tunned shared pool, buffer pool etc for optimal database performance
• Tunned rollback segments for optimal transaction processing
• Implemented PGA AGGREGATE TARGET for our environment to reduce sorts on disk to enhance database performance
• Implemented DR for many environments using VERITAS Volume Replicator, True Copy, Data Guard

Confidential, New York, NY

Lead ORACLE DBA

Responsibilities:

• Performed as a consultant for Dept. of information Technology and Telecomm. NYC
• Designed and implemented a complex DB environment for multiple applications in a shared VCS environment
• Created different environments for 311 call center as backend to Siebel application. Also supported DB for many other applications like GIS, Genesys, and Portal etc.
• Configured RMAN wif Veritas Netbackup to backup our production and DR environments
• Setup a test 10G RAC environment on two nodes in Solaris, cluster using ASM.
• Heavily involved in database performance tuning using statspack wif load runner and SQL tuning using session tracing i.e., extended SQL trace 10046 and 10053 and tkprof. Tuned 34 SQL statements by creating Stored OUTLINES and tuned many more by creating indexes, dropping indexes, and changing WHERE clause in SQL statements
• Changed DB character set from US7ASCII to UNICODE i.e., AL32UTF8

Confidential, Dallas Texas

Oracle DBA/Consultant

Responsibilities:

• Responsibilities included backup and recoveries of all production databases using RMAN and legato and also through conventional way i.e. by putting each tablespace in backup mode and copying the data files relating to that tablespace to a different location and when done copying; put the tablespace in normal mode. All backups were done through scripts i.e. rman and Shell.
• Planning, testing, and documentation of disaster recovery.
• Performance tuning using UTLBSTAT and UTLESTAT and dynamic performance views, De-fragmentation of tablespaces, and rebuilding of indexes.
• Created a standby database.

Confidential, Dallas Texas

Oracle DBA/Remedy Admin

Responsibilities:

• Installed Oracle 7.3.4 and 8.X on 5/6 servers including Enterprise 450, 250, 3500, and Ultra 2. Loaded OS on database servers and partitioned disk drives according to OFA using Veritas Volume manager for Disk partitioning, stripping, and mirroring.
• Installed Veritas Volume manager on a couple of servers.
• Created and maintained many databases for applications like Remedy and auto-answer.
• Created user accounts, roles, tablespaces, rollback segments, assigned privileges and roles to users.
• Migrated user accounts from one database to another database.
• Backup and recovery. Both Hot and Cold backup through conventional way.
• Migration and upgrade of Remedy and Arweb application.
• Wrote some SQL scripts to get different kinds of data from database and dump it in the text file for reporting and sever inventory purposes.

Confidential, Dallas Texas

UNIX Systems Administrator

Responsibilities:

• Systems Administrator for UNIX Help Desk. Supported three NIS/DNS domains.
• Systems Administration for 850 Unix boxes, mostly Solaris
• Areas of support included NIS, DNS, NIS+, NFS, and automounter, configuring NIS Slaves. Installed many NIS slaves and NFS servers.
• Installed Solaris 2.5, 2.6, and 2.7 on 60/70 workstations/servers using jumpstart. Also installed Solaris and SunOS from CD. Deployed workstations to the user cubical making sure that network drop is hot.
• Moved workstations from one subnet to another subnet and sometimes from one NIS domain to another. dis included changing the IP and subnet mask of the Workstation, NIS map and DNS files.
• Responsible for hardware (memory, Disk Drives, CPUs and Cards) installations and replacements on Sun boxes mostly SPARCstation 5, 10 and 20, Ultra1, 2, 10, and 20 and Enterprise 450.
• Created user accounts, groups, added users to groups, added external disk drives.
• Responsible for printing and print servers. Supported 10/15 printers mostly HPs and two plotters connected to the network through JetDirct.

Confidential, Fort Worth, Texas

UNIX System Administrator/Application Support

Responsibilities:

• UNIX Systems Administration for 500 Sun workstations and 15 network printers.
• Install, upgrade, and support electrical design applications e.g. SPW, matlab. Supported floating licenses for these applications. Used FlexLM and FlexAdmin for license upgrades. Developed web pages for these applications for internal customers only. Arranged onsite application specific training for our customers.

Confidential, Dallas Texas

Software Engineer

Responsibilities:

• Developed shipping label software for international distribution network using C language on SCO UNIX.
• Maintained some C programs and C shell scripts.
• Wrote a C program that calculated standard deviation of wafers.