Skills

• Oracle Grid console management design
• 12 Years
• 3 Expert
• Oracle Database build on Linux
• 6 Years
• 3 Expert
• Oracle RAC configuration
• 10 Years
• 3 Expert
• Oracle Clustering, replication and disaster recovery
• 10 Years
• 3 Expert
• Oracle version 9X, 10G and higher including ASM
• 8 Years
• 3 Expert
• MS SQL Cluster 2008
• 10 Years
• 3 Expert
• Managing Windows multi-node Cluster and implementation
• 8 Years
• 3 Expert
• Oracle Data Guard and SQL database mirroring/replication
• 10 Years
• 3 Expert
• Experience with SOA infrastructure
• 10 Years
• 2 Proficient

Employment History:

Confidential

Senior Oracle Application DBA/Core DBA/SQL server DBA

Responsibilities:

• Work as primary application DBA, to assist upgrading path from 11i 11.5.10.2 to R12 12.1.3.8 oracle E-business Suites in an 11g/RAC environment
• Undertaking installations, upgrades, migrations and patch management of oracle E-business Suites environments Database Application Server
• Perform application and database tuning, performance monitoring and investigative troubleshooting for various customers the main application supported are Human Resource, procure-to-pay, Manufacturing Supply Chain Management, General Ledger and Financials,
• Design HA/DR architecture for current databases, install RAC databases, create physical standby databases total create 15 new standbys , repair broken /behind standby databases to catch up with primary databases if problem occurs.
• Install, configure Sun Solaris Clustering 3.2, Advanced Edition which provides maximum level of service availability and performance for cluster system.
• Clone, patch E-business as requested, document the clone and patch procedures using AD utility for E-business administration, maintenance work.
• Setup GoldGate replications for production database.
• Oracle DBA work for various other applications, for example, SOA, OBIEE and some home-grown products in current environment.
• Setting up of Oracle 12C Cloud Control, Use OEM Cloud control to administrate and monitor all databases
• Create auditing procedure to audit database human resource application .
• Data warehouse tuning, partition newly created tables to improve performance, design related purge strategy.
• Working with system administrators to convert backup server from TSM to Commvault to resolve backup slowness RMAN backup and related backup design and trouble-shooting Collaborate with other leads to test, document, and maintain compleate disaster reocoery procedures
• Added databases to 10g OEM, set up the grid to have centralized control over various databases, set up various metrics and thresholds
• Help developer to tune for example, bulk collection , debug PL/SQL procedures perl/shell scripting as needed.
• Data guard setup for Oracle single instance to ensure HA High Availability .
• Setup and tuning and troubleshooting development/test/production GoldenGate replication in RAC/ASM environment stop/start/reconfigure GG settings for data loading. Active-Active design new tables to avoid replication conflicts create stored procedure to catch errors
• SQL Server DBA support as requested C debug SSIS, sql tuning
• Ensure all appropriate system procedures and change control processes are documented. And make sure they are continuously updated.

Confidential

Senior Oracle Administrator

Responsibilities:

• Work as a senior oracle application DBA, focus on architecture design PowerDesinger for Fedex home-grown applications by applying 11G 11.2.0.3 new feature Performance tuning by creating new stored procedures/using bulk collections/compressions/redesign indexes/partitions program PL/SQL packages to purge obsolete partitions automatically
• Work as R12 E-business DBA in 4-nodes RAC/ASM databases Using AD tools/Autoconfig concurrent manager management patching administrating/monitoring by using Application Manager trouble shooting for Apache webserver and forms servers
• Using exadata off loading/column compression for data warehouse 58TB to improve query speed.
• Administrator for Oracle SOA suite on a two node HP-UX RAC cluster
• Responsible for installation of Oracle clustering with Real Application Cluster RAC , Oracle Automatic Storage Management ASM , and Oracle 10g database software on RedHat Linux.
• Work partially as SQL server DBA as requested, to help daily DBA work: using SSIS for data integration trouble-shooting errors tuning bad sqls.
• Automate database monitoring/administration work by using Perl and shell scripts, maintaining a high-level monitoring, availability and security of data.
• Configured and installed Oracle 10gR1 RAC on Linux nodes and configured Oracle Enterprise Manager using Grid Control over several databases using Oracle Management Servers, Oracle Management Agents and the Repository database.
• Work as project manager for current project, attend various meetings to coordinate project progress/development technical issues direct schedules for development /production release.

Confidential

Senior Oracle Application DBA for Lending Department

Responsibilities:

• Performance tuning for OBIEE of data warehousing database Heavy SQL tunings for ad-hoc SQL queries
• Migrate Oracle database from Oracle 10g to 11gR1 RAC environment setting up RAC standby database setting up/tuning GoldenGate database replication from legacy production data warehouse database to production
• Installed, configured and setup SOA 10g suite on HP-UX boxes-included a cold standby-each had 32GB RAM, 4 CPU.
• Install, configure Sun Solaris Clustering 3.2, Advanced Edition which provides maximum level of service availability and performance for cluster system.
• Install, Configure Oracle 11G Grid control, Mass deployment database intelligent agents.
• Fulfil full application DBA daily activities, including user management creating users, profiles for resource management, tablespace, privileges, roles, quotas, sequence, synonyms, table, index, etc. space management tablespace/segment , monitoring space usage, alert log, memory, disk I/O, CPU, database network connection
• Perl scripting for DBA universal automation work across multiple operating systems setting up repository database in dedicated server for mass database monitoring installing Sybase client 15
• Utilizing 10g physical/logical standby with Data Guard, applying Real Time. Apply in conjunction with Maximum Protection to get benefits of both zero data loss as well as minimal downtime in the event of power outage/ database failure.
• 11gR2 Oracle RAC Real Application Cluster database administration.
• Implement/administrate ASM Automatic Storage Management
• Developing relational database models using a tool such as ERWIN or Rational Rose.
• Developing logical data models from existing business requirements.
• Data analysis - interviewing subject matter experts and documenting requirements.
• Data design - data modelling and logical database design create cubes
• Transition of logical database models to physical databases.
• Physical database maintenance and tuning.
• Oracle PL/SQL development to improve database performance/monitoring
• Data encryption VPD FGAC setup
• Experience with EMC Symmetrix V-Max for virtual data environment.
• Database backup/recovery design/monitoring Set up Flashback database feature for quick logical errors correction.

Confidential

Senior Oracle Application DBA/Developer/team lead

Responsibilities:

• Senior Oracle DBA/Consultant for Iway's product Iway Service Manager ISM travel to client companies to do demo, install/configure/patch/debug ISM.
• Work as Project Manager with strong database technical skill, using Primavera for PPM.
• Install/set up 11G R1/R2 database RAC in RedHat Linux upgrade 10GR2 to 11GR1 Development data modelling design/programming/trouble-shooting support for all related project.
• Install 11G Grid Control, Weblogic Server 10.2.3 in REDHAT Linux, Mass deploy agent, create repository based on 11G 11GR2 DB.
• Install, configure GGSCI GoldenGate for heterogeneous replication in Oracle Database Oracle to Sybase, Oracle to Oracle
• Setting up Oracle Streams for Oracle-Oracle database replication.
• Design/Programme replication tool for Oracle to Oracle, Oracle to SQL Server, DB2 to Oracle by using different databases' Change Data Capture CDC features Q replication/SQL replication/LogMiner/CDC API Wrapped with JDBC, make a Java Plug-in into ISM
• Set up/monitor/trouble-shooting quest SharePlex data replication
• Database conversion/Migration from Sybase 15 to Oracle 11GR2 by using Oracle SQL Developer Migration in schema level and database level
• Database conversion/Migration from SQL Server 2005 to Oracle 11GR2 by using Oracle SQL Developer Migration in schema level and database level
• Support PeopleSoft 9.0 Financials and Human Resources including Payroll, Tax, Benefits, Staffing, Compensation in Oracle RAC database 11G
• Support E-business R12 SCM, CRM, HR compensation workbench in Oracle 10G
• Using Manhatan software for supply chain optimization.
• Responsible for installation of Oracle clustering with Real Application Cluster RAC , Oracle Automatic Storage Management ASM , and Oracle 10g database software on RedHat Linux.
• Support SAP ERP 2005/SAP NetWeaver 2004s BASIS 7.00 /ECC 6.0 in Oracle database BR Tool Administered whole SAP development lifecycle including documenting technical specs, functional specs, coding, thread testing, unit testing, implementation, and system integration testing Design/Maintain/monitor SAP BW database ST /DB /RS transaction code backup/recovery Configuring, maintaining, and troubleshooting SAP BW cube
• Oracle database Performance database tuning by adjusting index/init.ora/chained-rows/TKprof 30 application design tuning by de-normalizing tables/Minimizing database trips/Minimizing logical reads/Minimizing locks/bundled-query approach etc 70 .
• Install TimesTen database.
• ETL work for Oracle data warehouse environment by using Informatica, Basic Informatica administration.
• Data loading optimisation for a British banking group 200 Million rows .
• Setting up physical standby database Data Guard .
• Oracle VPD /FGAC set up to implement row/column level security.
• PL/SQL programming for store procedures/packages/functions/trigger, shell scripting for automation.
• Configure/scripting DB2 journaling
• Using IBM COGNOS for BI reporting, Ad-hoc query tuning.
• Working on DB2 8/9 UDB on z/OS, DB2/400 on Iserias as DBA for development support Maintain mainframe security TopSecret
• Design/improve quick data migration tool for ISM
• Build test environments SQL server 2008/ Sybase 15 in multiple platforms like Linux, Unix, Windows LUW

Confidential

Senior Oracle/DB2 DBA/ Developer

Responsibilities:

• Migrate/Patch production and all test environment databases from 9i to 10GR2
• Set up some test environments by using 11G , using database Replay feature to test. Upgrade production to 11G 11.1.0.6
• Migrate database from Oracle to Sybase
• Using quest's SharePlex for data replication to achieve better replication performance with low overhead.
• Intensive PL/SQL Development work for Sungard application improvement Procedure, triggers, Package
• Doing Development work based on PVCS version management.
• Using Primavera for PPM.
• Acts as liaison with Oracle, users, management, and Sungard vendor .
• Support Oracle E-business suite R12 in RAC 3 nodes environment Upgrade from 11i 11.5.10 to R12 Patching using Quest STAT for life cycle change management.
• Install, configure TimeTen 11.2.1, trouble-shoot/tuning TimeTen database.
• Support SAP Basis SAP ERP 2004 SAP NetWeaver 2004 BASIS 6.40 ECC 5.0 in Oracle 10GR2 database Using BR Tool for SAP administration Work with designers, clients, and the team of infrastructure to create, define, and support SAP portals
• Responsible for initial and on-going architecture and environment design.
• Design quick large db clone strategy for use in daily testing, training and development.
• Oracle development /shell script to redesign bulk data loading.
• Setup/monitor CDC Change Data Capture Informatic ETL from ODS for production data warehousing database/data mining database warehousing tuning intensive SQLs tuning scripting batch scheduling systems Autosys Unix , and Intel box Exe and Batch files for application
• Install/setup Oracle Identity Manager IDM
• Setup/configure DB2's data replication, experience with SQL replication/Q replication and Event Replication.
• Manage database features materialized views, snapshots, partitioned tables, etc as needed
• Ensure user accountability/security with Oracle fine-grained access control FGAC /VPD/row level security .
• Shell/ Perl scripting to automate almost all critical technology components.
• Coding/debugging JDBC/SQLJ scripts
• Configure the query optimizer to meet application performance goal.
• Apply SQL tuning techniques such as hints, SQL profiles. Store outlines stabilize CBO if necessary/after migration, 10G and SQL plan baselines.
• Using SQL plan management 11G instead of stored outlines to stabilize execution plan after upgrade to get better as well as stable performance.
• Optimize data access, joins, and the physical design of database.
• Setup Oracle streams/Golden Gate for different production environment.
• Working with informatica administrator/developer for ETL data mining work.
• Data guard setup for Oracle single instance to ensure HA High Availability .
• SAP Basis Administrator performing numerous duties including installation, maintenance, and upgrade of SAP application code. HCMS
• Experience with using Oracle Exadata storage server for better data storing/retriving/backup performance.
• Performed MLR upgrades whenever patch was out-migrated SOA server from 10.1.0.3 to 10.1.3.5 MLR 2.
• Responsible for installation of Oracle clustering with Real Application Cluster RAC , Oracle Automatic Storage Management ASM , and Oracle 10g database software on RedHat Linux.
• Using Netezza database for quick data loading and query of data warehousing
• MS SQL server 2005 DBA support for BI applications Integration service IS, Analysis service AS, Reporting Service RS . Debug/tune T-SQL query, SQL server database maintenance backup, space etc SQL Server query optimisation, performance tuning Using SSIS for data imp/exp/transformation /ETL
• Using Oracle Forms to build query and data-entry applications
• Sybase production database support backup/T-SQL performance tuning using BCP for imp/exp replicate data from Oracle db to Sybase database GoldenGate partitioning Sybase db tables using Integration Service for Sybase to Sybase replication
• Database conversion/Migration from Sybase to Oracle 11GR2 by using Oracle SQL Developer Migration in schema level and database level
• Support Meximo applications in DB2 database experience MF TopSecret
• Using Oracle discover for reporting service.
• Using OBIEE for data warehousing support design/analysis/reporting
• DBA support Oracle E-business suites R12 Setting up Concurrent Manager, Using Concurrent Manager create request set/add custom programs Tuning/Troubleshooting Support Siebel application
• On-line hot patching 11g /normal patching
• Toad/I3 tool for general DBA/Development/tuning work.

Environment: Sun Solaris 9/10, BMC Patrol, Oracle Enterprise Manager Grid control/TOAD Quest /I3/SQL Navigator, Developer 2000 Oracle Forms and Reports/Procedure Builder , JDeveloper, RMAN, Data Pump, SQL Loader, Data Guard, RAC, Crystal Reports 4.6 7.0, Erwin 4.1.4, Windows VISIO, Oracle 9i-10G, Oracle Exadata SQL server 2005/2008, Sybase ASE 15, Informatica, Sungard Procede. Oracle Discoverer, NetApp. GoldenGate, SharePlex, Putty, Hummingbird. Oracle Net Backup. Autosys, Webfocus Netezza SAP

Confidential

Principle Oracle RAC DBA/ Developer /Database Architect SQL Server DBA Sybase DBA

Responsibilities:

• Manage the design, implementation and support of large, complex database environments.
• Manage a geographically dispersed matrixed team of Oracle database administrators
• Effectively manage multiple projects while balancing production needs to ensure deliverables are met.
• Evolve the company's database strategy and work to ensure that new deployments conform to business needs.
• Direct troubleshooting activities during outages, coordinating and engaging internal vendor resources while ensuring timely communication to stakeholders, on-call 7x24.
• Evaluate test proposed changes to the environment in QA, pre-production, and validate in production.
• Install/deploy the OEM Management Agent, establish OEM Grid Control for all instances to centralize the administration work, identify/setup all processing service for EMS monitoring.
• Install Oracle RACs on Sun Solaris OS sun 10 , 2 clusters are three/four nodes and one is two nodes 10.2.0.3 , all using ASM.
• Install Oracle 10g database Release 2 , establish 4 RAC environments on RHEL4 2.6.9-42 Kernel for all Development/QA/Integration Testing/Staging and Performance Testing/Production environment design/configure RAC public/private net bonding/raw device redundancy/ storage multipathing /ASM create/test TAF service.
• Upgrade all 10.2.0.1.0 single/RAC database to 10.2.0.4.0, also applying quarterly critical patch CPU .
• Upgrade older than 9.2.0.4 databases 8.1.7.4/9.0.1.4 to 9.2.0.8 then to 11.1.
• Install Oracle 11g, create 11g database for development environment.
• Install Patch set 10.2.0.4.0 to upgrade OEM Grid control from 10.2.0.1.0 to fix all generic bugs design and debug applications that run on RAC.
• Upgrade single instance databases with/without logical standby databases from 8i/ 9i to 10g.
• Large data loading/movement 1-4 TB from production to QA/test environment by using shell scripting for multi-thread parallel. Make them quick to deliver in narrow time window.
• Create RMAN repository, create recovery catalogs, register database. Design backup strategy for individual database centralize backup tape management using Oracle Secure Backup /Oracle Backup .
• Using BMC SQL track, Grid /DB control, TOAD, Precise-I3 as supplemental tuning tool.
• Fully understanding of how to implement SAP application lifecycle essentially Support SAP R/3 application with HRMS/CRM/SCM application, design/implement its backup strategy stress testing for Business Warehouse database BW .
• Using Veritas Netback and Oracle Secure backup to set up back up library for tape backup.
• Using IBM COGNOS for IBM BI reporting.
• Using SNMP Trap with SA to send alerts for large Oracle environment monitoring.
• Protect individual data elements by using Oracle DBMS CRYPTO package to encrypt data.
• Ensure user accountability/security with Oracle fine-grained acess control FGAC /VPD/row level security .
• Replacing tnsnames.ora with the Oracle Internet Directory OiD .
• Identify performance problems using wait event statistics monitor session-level wait events and collect historical data for root cause analysis interpret common I/O-related wait events diagnose and solve problems related to locking and serialization analyse latency-related wait events identify/resolve bottlenecks in the Oracle RAC environment Troubleshoot RAC databases with LMON/LMD traces.
• Installing, configuration and patching of EBS Prod CM/Mid-tier/DB and SOA Apps
• Oracle DBA support for 11i 11.5.10.2 E-business application support RAC, CIFA-financial .
• DBA Support PeopleSoft application database HCM/Financial Management
• Using Oracle stream for achieving high-speed dynamic data replication/sharing eCommerce expert in installation/configuration techniques use Oracle streams to create a reliable failover database
• Unix shell scripting for cron job.
• PL/SQL programming, debugging, tuning for applications
• JDBC API 2.0/SQLJ programming by using Java to call SQL, PL/SQL
• Using Oracle Forms to build query and data-entry applications
• Data modelling/logical database design.
• Install 10G application server and oracle Portal, Configure and manage the Oracle Application Server 10g infrastructure.
• Install, configure Sun Solaris Clustering 3.2, Advanced Edition which provides maximum level of service availability and performance for cluster system.
• Support Oracle Financials Application 11.5.10 RAC/ASM
• Support Meximo applications/tables in DB2 database
• Support Oracle Demantra for demand management.
• Install/experience GoldenGate against Oracle database for database replication purpose third party
• Install/setup SharePlex log based replication from primary to target for HA.
• Design/tune/ETL for data warehousing/data mart/ODS/EDW experience using Change Data Capture 9i, 10G using OBIEE/OWB Oracle Warehouse Builder for design/date loading/reporting
• Production support for MS SQL Server database 2005/tuning/trouble-shooting/implemetation.
• Oracle R12 E-Business Applications system administrator's project: adds menus, forms, reports, custom programs, applications, responsibilities and objects to the standard delivered E-Business Suite.
• Database conversion/Migration from Sybase 15 to Oracle 10G by using Oracle Migration Workbench in schema level and database level
• Adheres to company network standards naming conventions, security and user groups.
• Apply Oracle E-Business Suite Patch.
• Using OBIEE for data warehousing design, ETL, reporting.
• Create Request Sets for users.
• Define E-Business Suite users, including their security levels and responsibilities.
• Support Siebel application/tables
• Create physical/logical standby databases
• Oracle Production database administration support/trouble-shooting.
• Trouble-shooting ORA-errors/all related Production support.
• Install/create/configure/administer/optimise MySQL 4.1 database
• Install Sybase in Unix Sun Create Sybase database/DBA support/backup
• Using Oracle discover for reporting service.
• DBA support for IBM DB2 Universal Database Release 8.2

Environment: Sun Soaris 5.8/9/10, Red Linux ES 4 kernel 2.6.9-34 , i SQL plus, BMC Patrol, Oracle Enterprise Manager Grid control/TOAD Quest /I3/SQL Navigator, Developer 2000 Oracle Forms and Reports/Procedure Builder , JDeveloper, RMAN, Data Pump, SQL Loader, Data Guard, RAC, Crystal Reports 4.6 7.0, Erwin 4.1.4, Windows VISIO, Oracle 9i-10G, SQL server 2005/2008, Sybase, Informatica, Oracle 11i/R12 E-business suites. Oracle Discoverer, NetApp. GoldenGate, Putty, Hummingbird. Sun/AIX/HP/Linux.

Confidential

Senior Oracle DBA/Developer DB2 DBA Sybase DBA

Responsibilities:

• Migrated/updated database from 8i 8.1.7.4 /9i to 10G, database patching.
• Created EM repository/troubleshooting for OEM/Grid Control.
• Provide different version Oracle production databases support 24 7 for 8i, 9i, 10G/RAC environment also provide SQL server database support.
• Working closely Oracle Developers to provide production support, many trouble shooting works based on different problem scenarios.
• PL/SQL programming for production database, Debugging PL/SQL scripts to correct developer's errors, shell scripting for cron work.
• Coding/Debugging JDBC programs
• Analyzes, develops, tests and implements database designs in development databases, also maintain/troubleshooting development databases.
• Using 9i CDC feature for change data capture
• Install/configure OID.
• Install/setup IDM Oracle Identity Manager
• Install Oracle Portal in Linux server.
• Performance tuning for OS level and database/instance level Involved in application side SQL tuning by hint.
• Using different backup solutions RMAN, BMC SQL Backtrack, hot backup scripts .
• Install/set up/maintain SharePlex for data replication.
• Supporting Oracle 11i's Financials Application General Ledger/ Payables/Receivables/Fixed Assets and Human Resources Applications HRMS/Payroll .
• SAP basis support SAP ERP 2004 SAP NetWeaver 2004 BASIS 6.40 by using BR Tool and transaction code support data loading/performance tuning/star schema/parallelism for SAP BW.s
• Responsible for installation of Oracle clustering with Real Application Cluster RAC , Oracle Automatic Storage Management ASM , and Oracle 10g database software on RedHat Linux.
• Implementing /configuring /monitoring ASM, Veritas and EMC for High Availability requirements.
• Ensure user accountability/security with Oracle fine-grained acess control FGAC /VPD/row level security .
• Support SAP ERP 4.7 for performance issue.
• DBA support for PeopleSoft and E-business suites.
• DBA support for SQL Server 2000/2005 database production and Sybase production , including T-SQL/database performance tuning Migrating Sybase form 12.5 to 15.
• Ongoing Database Administration with DB2, monitor/tune DB2 Performance.
• MySQL database production support
• Install Netbackup Server Software/ agent in client database server, configure backup police/tape device configuration, using VERITAS NetBackup for tape backup

Environment: Sun Soaris/AIX/Linux, i SQL plus, BMC Patrol, Oracle Enterprise Manager Grid control/TOAD Quest /SQL Navigator/I3, Developer 2000 Oracle Forms and Reports/Procedure Builder , JDeveloper, Oracle Warehouse Builder OWB , RMAN, Data Pump, SQL Loader, Data Guard, RAC, Crystal Reports 4.6 7.0, Erwin, Oracle 8i-9i-10G, SQL server 2005/2008, Sybase,Veritas NetBackup Oracle 11i E-business suites. Oracle Discovery. Putty, Hummingbird. SAP Oracle ESB