| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
EMAIL AVAILABLEEXECUTIVE SUMMARYOver 20 years IT experience (including development and system engineer)with 18 years plus core/Apps DBA experience, capable to design thereliable, scaleable architecture and build the manageable enterprisetechnology for a company in the industry.Expert level experience in Oracle 9i/10g/11gR2 RAC, Data Guard,EBS11i/R12, OEM Grid Control, RMAN backup/recovery, and Networker.Expert level experience in Oracle installation, upgrade, large systemarchitecture designing, capacity planning, consulting, backup/recovery.Expert level experience in performance tunings on SQL statements, indexes,network, OS and DB parameters using various tools such as tkprof,Statspack, SQL trace, AWR, ASH, ADDM, RACCheck, etc.Knowledge of the best practice in SQL and PL/SQL coding for theperformance.Experience as a Principal Consultan for Oracle Corp.Experience as an Oracle DBA instructor in one of Oracle training schools.Experience in mentoring other DBAs.Experience in OBIEE, Hyperion, ASCP, Streams, GoldenGate, AS10g/FM11g,Linux, Solaris, AIX, HP-UX, Shell Script, NetBackup, MySQL and SQL Server.Strong ability in identifying problems, developing new ideas, and findingthe best solutions.Experience on 24 by 7 on call for production database support ormaintenances.Highly self-motivated and detail-oriented individual with excellentcommunication and personal skills.Broad knowledge in related areas such as Linux, Unix, Solaris, AIX, HP-UX,Suse Linux, Network, TCP/IP, Storage LUNs, Partitioning, Interconnect, Loadbalancer, Python, HTML, PHP, and CSS.EDUCATION: B.A., Computer Science, Queens College of the City University ofNew York, 9/1/1987TRAINING:AWS Architecture, EMR Big Data on AWS, Teradata, Data Modeling and DatabaseDesign, Oracle7 SQL and PL/SQL, Oracle8 Database Administration, Oracle7Performance Tuning, Oracle8 Backup and Recovery, Oracle Parallel Server forIBM RS6000, Oracle Parallel Server Administration, Oracle7 SymmetricReplication, Oracle8: New Features for Administrators, PeoplesoftConfiguration and Administration, Unix, C, C++, SQR3, PowerBuilder, ALC,JCL, CobolCERTIFICATIONSOracle7/8 Certified Professional DBA, 1998Systems Enginneer, EDS, 12/31/1990EXPERIENCESr. Database Administrator, Confidential, 2013 to present, Phoenix, AZCreated Oracle/PostgreSQL/Cassandra NoSQL databases on AWS RDS/EC2 forOracle Access Manager upgrade. Created Chef scripts to automate the Oracleinstallation and database creation on EC2 servers.Performed Oracle 11g RAC and Dataguard installation and configuration forInformatica repository databases on Linux multiple times including RQA andproduction environments. Performed hardening on Oracle databases based onthe PCI compliance requirements.Uesed the dbms_redefintion tool to redefine column data types on multiplevery large tables in the data warehouse with almost no outage.Used partition exchange to moved old data from very large tables toarchive tables with almost no downtime.Performed upgrade from 11.2.0.3 to 11.2.0.4 on multiple clusterenvironments.Provided the DBA supports for the Data Warehouse migration to Teradata14.10 database. Set up the DEV/QA/Production database environments theproject team. Worked with Teradata consultants and off-shore consultants toresolve various issues during migration.Implemented the backup strategy using RMAN and Networker. Scheduled thebackup to tape and monitored the daily backup jobs including incrementaland archivelog backups.Provided the DBA supports for the Reservation System migration/upgrade.Worked with the vendor on various issues during and after migration.Resynchronized the standby database in production using the Rman backupwhen the standby was out of sync with the primary due to lost ofarchivelogs caused by the server reboot.After the QA database was corrupted, with RMAN, rebuilt the entire QA RACand Data Guard environment with two nodes on the primary site and two nodeson the standby site.Applied PSU in rolling fashion in the RAC and Data Guard environments.Created the document for operation and maintenance. Performed the standbyswitchover test.Configured the Goldengate extracts/datapumps/replcats for onewayreplication.Installed/Upgraded OEM repository/OMS/agents to 12.1.0.5 and configured OEMto monitor hundreds of production databases and send alerts to DBA team,Operation personnels and business owners. Also installed Goldengate pluginand configured the new OEM to monitor the Goldengate processes usingjagent. Investigated and troubleshot various issues and performed the rootcause analysis and provided solutions to fix various issues. Performedvarious tunings for performanance issues.Provided the database security related reports to the Compliance departmentand remediated various security concerns based on the compliancerequirements.Cloned production database from RAC to single instance on the AIX stageserver, then the single instance was cloned to the QA in RAC configuration.As a DBA SME, reviewed and approved various database change requests/tasksincluding the design details documentations, database modifications, anddatabase access, etc.Sr. Oracle Apps DBA/DBA Lead, Murad Inc., El Segundo, CA, April2008 to Feb2013Installed and configured the Oracle 11gR2 database in the RAC environment.Configured kernel parameters, NTP, and hangcheck-timer kernel module;installed required rpms and ASMlib 2.0 on Redhat Linux 5.3. Configured SSHand enabled SSH user equivalency. Worked with the System Administrator toconfigure the private, public, and virtual IP addresses for RAC. Installedthe Cluster Verify Utility, Oracle Grid Infrastructure (clusterware) 11.2.0and the Oracle Database 11.2.0. Created LUN partitions and ASM diskgroupson EMC CX3-40. Also installed the patchset update PSU 11.2.0.1.2 on the topof 11gR2 Grid Infrastracture (clusterware) and RAC installation on allnodes. Installed Cluster Health Monitor (IPD/OS).Deconfigured, deinstalled, cleaned up and rebuilt the clusterware on thecrashed node and added the node back to the cluster.Designed and implemented the backup/recovery strategy and configured RMANwith EMC Networker and tested backup/recovery scenarios by restoring orduplicating from hotbackup without target and catalog connection orduplicating from active database. Performed logic backup using Data Pump.Configured the Data Guard and created the standby database using RMANduplicate from active instance. Tested switchover and failover proceduresin both SQL*Plus and the Data Guard Broker command line. Reinstated thefailed primary database using the flashback database feature.Installed, setup, monitored, and troubleshot the GoldenGate for the bi-directional (active-to-active) replication. From primary to secondary, onprimary, created extract/traillog group, datapump (extact, extsrc),extrail, rmttrail; on seconday site, create replicat group. From secondaryto primary, on primary, created EXTRACT group, datapump, remote trail; onprimary, created the replicat group. Used Conflict Detect and Resolution(CDR) to resolved uniqueness conflicts occurred during insert and updatereplication, update conflicts and delete conflicts such as no data found.Also configured the parameter files including getbeforecols, comparecols,resolvecols, reperror, etc, for conflicts resolution and various errorshundlings. Troubleshot and resolved various errors.Installed and configured OEM Grid Control master agent using Oracle 11grepository and client agents on multiple nodes.Upgraded the RDBMS from 10.2.0.2 to 11.2.0.1 and applied patchset11.2.0.1.2 and other required or recommended patches. Migrated andconverted the database characterset from US7ASCII to AL32UTF8.As required by the PCI compliance, created the wallet and configured theTransparent Data Encryption (TDE). Also configured Database vault andenabled the audit option.Monitored the performance and generated AWR, ADDM and ASH (Top Clusterevents and Top remote instance waits) reports for perfomance tunings.Reviewd RACCheck report and configured hugepage. Monitored theinterconnection bandwidth utilization such as RX, TX and packets errors,dropped, overrun, collisions, interrupts and worked with SA to fix variousinterconnect issues. Reviewed AWR report for high Global Cache Block AccessLatency and tuned UDP.Tuned various SQL statements to reduce the high I/O waits by creatingmissed indexes or function based indexes; increased initrans on few tablesand indexes to reduce the block contention for ITL (Interested TransactionList); tuned SGA size to minimize the number of connection timeoutoccurance; increased log_simultaneous_copies value to lower redo copy latchwaits.Provided DBA support on both Oracle Applications 11i/R12 production (multiTB) and development environments running on Red Hat Linux, includingcloning, patching, backup, tuning, troubleshoot, etc.Installed/configured Fusion Middleware/Weblogic/OBIEE11g/SOA/IDM, Hyperion,OBI Apps, DAC server repository, Informatica server/client.Installed/configured Oracle NoSQL database, MySQL 5.5, MySQL Cluseter 7.2,MySQL Workbench, MySQL Enterprise Backup/MonitorProvided support on the whole life cycle of Oracle E-Business R12implementaion. Installed Oracle Appplications EBS Release 12.1.1. AppliedHRMS HRglobal patches and performed other post installation configuration.Analyzed the requirements for RUP2 and Oracle Financial Critical PatchCollections (CPC). Upgraded R12.1.1 to R12.1.2 by applying RUP2 patchsetthen to 12.1.3 laterly. Also upgraded the database from 11.1.0.7 to11.2.0.1. Cloned R12 instances from development to test then to productionand vice verse using RapidClone utility (adpreclone.pl, adcfgclone.pl).Configured R12 Workflow notification mailer. Defined printer styles, types,and Pasta definition various profiles. Configured the mobile WMS (WarehouseManagement System) and various printers using the PASTA.Sr. Oracle DBA/DBA Lead, Raytheon, Fullerton, CA, Mar 2007 to Apr2008,ContractDesigned the highly available and scalable the architecture with the OracleReal Application Cluster, Data Guard, Grid Control, and Streamstechnologies included. The architecture will support 24 by 7 availabilitywith maximum 59 minutes down time per year and one thousand DMLs per secondand 42 TB data on EMC CX-380. Researched, evaluated, and recommened thehardware, software, and storage technologies, performance, and capacityrequired to support the architecture. Also performed the benchmark test onEmc CX-380 and Sun Storage 6540.Installed and configured the RAC environment on Sun Solaris. InstalledOracle 10.2.0.1, the patchset 10.2.0.3, the Cluster Verify Utility, OracleClusterware 10.2.0.1 and the patchset 10.2.0.3. Created the ASM and clusterdatabase instances using DBCA and created TNS listener using NETCA.Configured the Transparent Application Failover (TAF) and both client-sideand server-side Connection Load Balance (CLB) in tnsnames.ora. Using theDBMS-SERVICE package, configured the RAC to use the Load Balancing Advisory(LBA) to determine how to balance new connections based on information inthe SERVICE_METRIC's event (SME) and other FAN events.Installed and configured the Oracle Enterprise Manager Grid Control and itsagents on multiple nodes.Configured the Data Guard in Maximum Availability mode, enabled Flashbackfeature on both the production and the target standby databases, enabledthe Data Guard Broker configuration, configured Redo Transport Services inLGWR SYNC mode, and configured the Fast-start Failover Observer and enabledthe Fast-start Failover.Configured, tested, monitored, and tuned Streams replication in themultiple source and multiple target environment. Turned on the supplementallogging on both db and table levels. Created db links, StreamsAdmin andgranted privileges. Created the queue tables, AnyDataQueue, rules and rulesets tapply process, capture process, and propagation process. Manuallyinstantiated objects and started/stopped capture, propagate, and applyprocess for testing and troubleshooting. Packages used are dbms_rule_adm,dbms_streams_adm, dbms_adadm, dbms_capture_adm, dbms_propagation_adm, anddbms_apply_adm. Troublshot and fixed various issues related to capture,propagation, apply, network, truncate, DDL, etc. Also configured thereplication from Oracle to SQL Server using Microsoft's Oracle Publisher.Sr. Oracle DBA, AMC, Orange, CA, OCT 2006 to Mar 2007Provided the DBA support on the production and QA databases in the Oracle10g RAC and Data Guard environment.Tuned the SQL statements and tested various tuning options and improvedperformance 300% better for few reports utilizing AWR (Automatic WorkloadRepository) snapshots, ASH (Active Session History) report, and ADDM(Automatic Database Diagnostic Monitor).Designed and tested backup strategy using the RMAN and Netbackup.Providing the DBA support for the application teams throughout thedevelopment cycle.Troubleshoot various issues such as performance related issues,connectivity issues, space management issues, report job failure issues,etc.Refreshed the test and QA databases using data pump utilities.Sr. Support Engineer, Quest Software, Aliso Viejo, CA, OCT 2005 to Sep2006Installed Shareplex 5.1.0 and patches on Solaris, HP-UX, and Linux. Set upand tested various replication configurations and features such as one way,multiple targets, peer to peer, horizontal and vertical partitioning,intermediate replication using named queue, multi-thread post, etc.Worked with clients to resolve various Shareplex issues related to libraryerrors, slow capture or post performance, log wrap, export or impor idle,core dump, queue corruption, compare hanging, reconcile hanging, out ofsync between source and target, configuration, network connection error,and Oracle database related issue such as full table scan, index problem,privilege problem, slow performance such as inittrans contention, etc.Sr. Oracle DBA, Toyota Financial Services, Torrance, CA, October 3rd 2004to Oct 7th 2005, ContractProviding the database support for five application teams throughout thedevelopment cycle and production databases in Oracle9i and Oracle10genvironment.Installed, configured Oracle10g software and upgraded databases fromOracle9i to Oracle10g.Designed and tested backup strategy using the RMAN and Netbackup.Designed, created, and maintaining the logic and physical database modelsusing ErWin 4.0.Tuning the SQL code and tested various tuning options. Created the bitmapindex and partitions by list and improved performance for few major reportsfrom few minutes to few seconds in a large data warehouse database.As a team member, worked with the migration team to migrate the databasesfrom one data center to the new data center.Sr. Oracle DBA, New York City Government, New York, Feb 2003 to Apr 2004,ContractProvided DBA support on Oracle Applications 11.5.7 (HR, FIN) productionrunning on Sun Solaris and development support on development and QAdatabases.Installed and configured Oracle 9.2.0.1.0 multiple times on multiple SunSolaris machines. Created more than fifteen databases and Auto UndoManagement for rollback segments. Created locally managed tablespaces withsegment space management auto option. Created spfile from pfile. Alsoinstalled the Oracle Patchset 9.2.0.4 on top of each Oracle9i binaries andupgraded all Oracle9i databases to 9.2.0.4 release.Migrated multiple Oracle8i databases to Oracle9i release. Converteddatabase characterset from US7ASCII to WE8MSWIN1252 then to multiple-bytecharacterset AT32UTF8. Configured and tested automatical database startupand stop. Created multiple listeners on the development machine.Improved performance by tuning session_cashed_cursors, log_buffer,checkpoint, redo logs. Eliminated Checkpoint Not Complete message.Minimized I/O contention on redo log activity.Sr. Oracle Apps DBA, ON Semiconductor, Phoenix, AZ, June 2002 to Sep 2002 -ContractAnalyzed and documented all requirements and impacts for Oracle Apps 11iupgrade from 11.5.1 to 11.5.6 (FIN, HR, INV, Order Management, inventorymanagement, iMarketing, iPayment, iStore; Manufacturing) in a three-tier(multi-node middle-tier) Solaris environment. Before upgrading theproduction, cloned the production and tested the upgrade procedure threetimes in the testing environment.Recreated the digital certificate files adsign.txt using adjkey. RepackagedJinitiator using adjbuild.sh.Regularly purged Concurrent Request and Manager data, Obsolete WorkflowRuntime data and Signon Audit data.1 Sr. Oracle DBA/Lead, Princeton eCom, Princeton, NJ, Dec. 2000 to Feb.2002Managed the DBA team to supported on 24 by 7 mission-critical productiondatabases (the largest one is around 1 TB), which provided thousands ofinternet and IVR users for the online billing servicesPerformed the capacity planning and designed the file layouts. Designed thenew database architecture that is two-dimensional and modulated by thevertical industry and horizontal services.Designed the VLDB data warehouse open architecture and models for one ofclient companies. The architecture could be scaled up to 131 TB datacapacity using the Oracle9i Real Application Cluster (RAC) technology in afour E4500 cluster configuration.Designed and implemented the backup/recovery strategy using RMAN andNetbackup tools to improve reliability, manageability, and scalability onthe backup/recovery and ensure the business continuity services.Sr. Oracle DBA/Lead, Bigfoot Interactive, New York City, NY, Sept. 1999 toNov. 2000Managed a multi-million dollar project which involves migration of allproduction databases from Microsoft SQL Server on Windows NT to Oracle8.1.5 on Sun Solaris 2.6.Performed research, analysis, evaluation on hardware, software requirementsin order to build a system environment with high reliability, availability,manageability, and scalability. Evaluated and hired the consulting servicesand brought in the advanced technology such as Veritas Clustered Serversand Quick I/O file system.Worked with consultants to install and configure Sun Solaris 2.6, disk RAID0+1, Veritas Clustered Servers, Quick I/O file system, DLT tape library,Netbackup, SQL Backtrack.Sr. Database Administrator, HIP Company, New York City, NY, 1998 to August1999Provided both Oracle and Peoplesoft support to more than a hundred users inmultiple locations. The support activities including installation ofOracle7 and Oracle8 Servers on Windows NT platform and Peoplesoft softwareon client users' PCs, refreshing development and test databases fromproduction, monitoring and performance tuning, troubleshooting, backup andrecovery, startup and shutdown of Peoplesoft AppServs and processschedulers, data conversion from Sybase to Oracle using Crystal Report andData Junction andSQL*Loader.Principal Consultant, Oracle Corporation, New York City, NY, August 1997 toOctober 1998Provided DBA support for SAP application in both production and developmentenvironments for one of fortune 500 clients.Designed the enterprise architecture for one of the largest insurancecompanies to integrate systems on various platforms (IMS/DB2/Lotus Notes onIBM mainframe/AIX, Oracle on Solaris, Access on NT) from 23 internationalbranches. The integrated system can eliminate data redundancy, streamlinethe workflow, enhance reporting and analysis capabilities, increaseefficiencies in distributing bonding products internationally to agents andclients by providing a single input, output, and query data source ofinformation on account, agent, claim, underwriting, reinsurance, contract,transaction, job, activity and premium by branch.Database Administrator, AT&T, Lincroft, New Jersey, 1996 to 1997 - ContractAs a development DBA, provided the DBA support to the development and QAteams including debug of the stored procedures and packages, applicationtuning, data modeling, reverse engineering, logical and physical backup andrecovery, etc. Upgraded Oracle Servers and existing databases to Version7.2 on HP-UX 9.04 Unix machines and to Version 7.3 on HP-UX 10.20 Unixmachines.Oracle Database Administrator and Developer, NDB Brokerage, New York City,NY, 1993 to 1996Installed and configured Oracle 7.2 Server, SQL*NET 2.2, ODBC, Oracleclient software, and the data modeling tool Designer 2000 in Windows NT.Designed the logical and physical database model for the Oracle applicationusing Oracle Designer2000. Created the database, multiple instances,tablespaces, segments, procedures, tables, indexes, roles, and users on theOracle 7.Systems Engineer, EDS, Bedminster, New Jersey, 1989 to 1993Developed and maintained the Agency Information System used to processmillions of records in the DB2 database which contains 2 years ofstatistical data collected from about 21,000 Western Union Money TransferAgencies all over the World.HARDWARE AND SOFTWAREHP9000, Sun E4500/6500, SP/2, IBM RS6000, disk arrays, tape library, IBMmainframe, Bridge, Routers, EMC Symetrix, EMC Clariion CS450, MS Windows,etc.Oracle7/8/8i/9i/10g/11g, RAC, Data Guard, OEM Grid Control, OBIEE, Streamsreplication, Shareplex, Advanced Replication, Oracle Applications10.7/11/11i, Oracle Application Server 10g, SQL, PL/SQL, SQL*Loader, RMAN,exp/imp, MS SQL Server, HP-UX, AIX, Solaris 2.6, Linux, VCS, VeritasNetbackup, SQL*Net, Korn shell, Apache, etc.-----------------------6 |
