| 
Location: Harrison, New Jersey, United States
Date Posted: May 03, 07:26 PM
Create Alert. Get emails for Oracle DBA in Harrison, New Jersey, United States
Description
Quanjing Zhang (Jimmy Zhang)
Tel: 973-485-4501 (H), 973-262-0591 (C); Email quanjingz@yahoo.com
OBJECTIVE: To apply for Oracle Database Administrator. SUMMARY: Certified Oracle Professional and Sr. Oracle Database Administrator. Possesses excellent knowledge of Oracle Clusterware, databases, related utilities and tools, physical database design, security management and database and application performance tuning. Offers the technical expertise of an experienced DBA with on a multitude of OS platforms. Proficiencies include Oracle 8i, 9i (RAC) or 10g (GRID) on IBM AIX series 5L.x /Linux, HP-UX, DG Unix G-Aviion 5000-25000 Series, Sun Unix Sparc1-3, Solaris v.2.6 – 10, / Sun Linux/RedHat v.7.4 Linux, Windows NT/2000/2003/XP Client/Server, intranet server. Familiar with SQL, Relational Database Management Systems(RDBMS), middle tier, network, shell scripting, performance tuning, related intermediate knowledge of database Connectivity, SQL/PLSQL, and reporting tools. TECHNICAL SKILLS: Languages: Unix shell, Perl, SQL, PL/SQL, Visual Basic5.0, C, PASCAL, COBOL, RPG II-III, BASIC, Fortran, C , J2EEDatabases: Oracle Database Version 6.x/7.x/8.x/8ix/9i.x/10g.x, current 10g R2 server on Real Application Cluster, Oracle Web Server, Oracle Application Server v.4. –10g, Oracle Server Manager, Oracle Financial Server, Oracle Express Server, Encrypted Database Security, Paradox 5.0, FileMaker Pro, SQL Server.Case Tools: SQL*Loader, SQL*Net, Oracle IMP/EXP, Oracle 10g Datapump, Oracle Enterprise Manager, Quest Central for Oracle, Quest Toad, Quest Spotlight, Embarcadero, Oracle Application 11i(AM, CM, AR, AP, GL., Rapid Clone technology, accounts, responsibilities, and printers), Oracle Financial Analyzer 11i, Statspack viewer, Oracle Express Instance Manager, DBFlush, PLSQL Developer, Oracle 10g AWR, Data Guard, RMAN, Oracle Stream.Systems: Multiple Operating System of Unix, Linux and Windows which include IBM AIX - P610 à P690, DG Aviion 1000 à 25000, Sun Ultraspac, Sun Solaris, HP Tru64 server, Microsoft Windows NT/2000/2003 server, EMC Storage, Veritas clusterware, Data Ware house. and so on.Network: TCP/IP, Novell Netware, and Microsoft Network.Other: MS Office 2005, Wordperfect6.x. Hummingbird, Smaterm, PVCS, MKS, QTP, WinRunner, LoadRunner, VPN, some 3rd party software, Putty, etc. PROFESSIONAL EXPERIENCE:
RBS Sempra Inc., Stamford, CT 06103 02/2008 - 05/2008
Sr. Oracle DBA Consultant
- Planing and perform the project of database upgrade of 10g R2 grid architecture on the environment of Solaris UNIX System, EMC storage and Veritas cluster. As Oracle DBA, duty includes to support 14 production Databases 10 qa and 14 development databases which are separately running in 10g R2 cluster environment and dedicated servers, and work closely with developer’s team to troubleshooting the issues related application performance. Largest prod db has more than 2 TB size.
Travelers Inc., Hartford, CT 06103 10/2007 - 01/2008
Sr. Oracle DBA Consultant- Design and execute the project of database and migration of 10g R2 grid architecture on Solaris, Linux and AIX UNIX system. As Oracle Infrastructure Support Function Team, I am working to set up, maintain and manage 4 10g R2 Grid groups which include 2 or 4 nodes separately, build, modify and set the CRS and ASM, create standby database for Data Guard, Set RMAN in OEM, make the documentation of installation procedure, and develop the distribution package for 10g r2 Client with perl in Tivoli system.
ADP Inc., Florham Park, NJ 04/2007 - 07/2007
Sr. Oracle DBA Consultant- Plan and perform the project of database creation and migration of 10g R2 RAC architecture on Solaris UNIX system. Manage and reset the release procedure, and all releases deploying for daily upgrade. Handle all related database administrator’s activities on 3 production databases, 4 developing databases and 4 QA databases of 9i and 10g R2 including installation; configuration; upgrade, refreshing and patches; database physical and logical design; database security audit and performance tuning. Work with developers closely and support the programming application on corp’s software products
- Support and maintain Oracle Application DB and Financial DB, & related applications. Some Applications are used for Financial service and trades. Duty covers cloning, maintenance, migration, and so on.
- Analyze and resolve database performance issues, database capacity issues, and other distributed.
- Coordinate with technical project managers, PL/SQL developers, and DBA Team to ensure database performance and reliability.. Setup, check, review, modify or tune SQL and PL/SQL procedures, db links, tnsnames, RMAN and so on.
- Execute the plan for database activities such as installation; migration; performance tuning; process monitoring, sql/PLSQL analysis, storage management; capacity planning; disaster recovery; checking alerts, resolving remedy tickets, software installation, DB creation etc.
- Administration of database implementation across all environments - development, systest, QA, integration, staging, production.
- Conducted business process and fit/gap analysis. Plan, lead and actively participate in design, modeling, configuration and testing of Oracle 10g R2 (RAC)Database Server. Create the Oracle Data Warehouse for Research and Analysis of business. Create an Oracle Financial 11i application database for test and development.
- Setup the system to meet the desired business process and requirements based on knowledge about the Service Delivery Life Cycle.
- Troubleshoot and issue resolution with Oracle 10g R2 database creation, testing and maintenance.
- Planed and performed all related database administrator’s activities such as installation; migration; configuration; upgrade, refreshing and patches; database physical and logical design; data modeling, performance tuning; performance monitoring, client/server connectivity; queue optimization; backup and recovery; space management; capacity planning; disaster recovery; database cloning, storage management, implementation, and maintenance of security features of database which all involved online service and 24X7 on call activities.
- Implemented, enhanced, maintained, monitored and troubleshot applications in multiple operating system environments. All Corporate Territory Databases including 15 production databases running in Real Application Cluster (RAC) Environment of IBM Unix AIX v.5.4L platform for Global transactions, 58 databases in same developing test cluster environment, 2 prod databases in Windows2003 platform, 2 Oracle Express servers in window 2003 servers, 3 Web databases in Sun Solaris platform and 2 DBs in Sun Linux platform. Most of the applications are implemented by Oracle Server 9.2.0.7, Data warehouse 10g R1, Oracle 10giAS v.2, Oracle Financial Express Database 2.4 over, and upgrade to 10.7.
- Provided professional, courteous and timely database support to production. Identified, corrected and troubleshoot database problem issued by utilizing all technical resources available. Design, develop and integrated tools and processes to maximize performance of database environments.
- Moved the tested codes to production libraries, monitor the sessions, track the user’s activities and audit SQL/PLSQL and optimize SGA status. Furthermore, create and administrate all database objects including schema’s objects, Unix clone jobs, OCI maintenance, etc. and DB security control, integrity using Oracle Utilities or SQL Developer, evaluate and install vendor software and so on.
- Worked closely and cooperate with oracle application developer’s team and Oracle financial developer team to report the application project status and upgrade the procedure of accomplishment. Support project teams, end users, developers, and system groups on database related issues. Provide technical advice and assistance to the current and new applications. And make unique version release control. Supplied timely and effective resolution to database problems.
- Responsible for database administration related policies, standards, and procedures, fixed bugs and researched solutions for software problems. Resolution involved frequent communication with the users to ensure the quality of the application delivered from developers.
- Designed, implemented and maintained the database routinely; backup & recovery strategy, disaster database recovery procedures, recover the database damage when failure occurred.
- Tuned and optimized sql statements, performed PLSQL Programming based on request of application support group and code rewrites.
- Performed support in design review, database analysis, database object management and troubleshooting including daily administration, batch processing, configuration management, environment migration, tool automation, end user acceptance testing and security control/audit.
- Created and setup OLAP multidimensional database server, support Oracle Application server 9iAS, Oracle Express Server, Oracle Application 11i and Oracle Financial Analyzer, set up Oracle Networking (Net8).
- Oracle Server 7.3/8. and Web Server 2.1 installation, configuration, migration, upgrading, Replication and administration, which involve the physical and logical design, data modeling, enhancing, and customize communication assets management system.
- Setup Database backup & recovery strategy, database performance tuning and auditing.
- Cooperated with application development team, setup oracle development application software, test the database instances, and debug the database; system and security issues.
- Migrated Oracle 7.2.x database to Oracle 8.x database on Sun Solaris & Windows NT systems.
- Tested client/server GUI applications that interface between Unix/PCS and NT workstation platform.
- Supported application team in design, and handled database analysis, database object management.
- Maintained database security management tools and integrity.
- Installed and managed Oracle Server 7.x on Compaq Proliant/NT and Solaris/UNIX.
- Created the Oracle database, allocate system storage and plan for future storage requirements of the
- Database system, setup the backup and recovery procedures.
- Performed start-initiation and shutdown processes, including stopping and starting of server processes, database locks, exports and archival.
- Designed, implementation, integration and/or configuration of new or revised hardware and Oracle database and software, which enhance and support defined business requirements.
- Tested client/server GUI applications that interface between Sun Solaris/PCs and NT server/ workstation & windows 95/98 platforms.
- Worked with data analyst to implement logical and physical database design, modeling.
- Created primary database storage structures (table-spaces) and primary objects (tables, indexes, views, and so on), monitoring performance and storage usage, defragmentation.
- Loaded and convert data into Oracle 7.x database through SQL*Loader from MS Access database.
- Worked on application SQL statement analysis, index analysis, capacity planning and database.
- Performance analysis and tuning, and prepare database backup/recovery.
- PL/SQL programming on Scorpio project for Corp affiliate Market system. Maintain, upgrade and support the on line service to application.
- Create and manage the Oracle RDBMS database v.7x. Build the backup and recovery procedures. Setup the storage control management of database and OCI.
- Worked with users to design and setup new system programs and application reports.
- Daily interaction with programmers, interpretation of business requirements, implementation.
- Troubleshooting problems, Upgrading code, migrating application version.
- Installation and maintenance of Windows NT Server and Workstation with Windows 95.
- Created and manage the Paradox database 5. Build the backup and recovery procedures. Setup the storage control management of database.
- Supported the operation of LAN/WAN, client/server communication and system security.
- Worked with users to design and setup new system programs and applications.
- Daily interaction with users, interpretation of business requirements, implementation.
- Troubleshot hardware, application problems, upgraded software and system backup.
- Data Modeling, created and developed for an application product of Telecommunication.
- Support and interpretation of business requirements, implementation, and its promotion.
- Coding and troubleshooting application problems, Upgrading software.
- Installation and maintenance of Novell Server3.12/Windows NT3.51 Server and workstation with Windows3.1/95.
- Created and managed the Oracle RDBMS database v.5x - v.6x.
- Build the backup and recovery procedures.
- Setup the storage control management of database and OCI.
- Supported the operation of LAN, client/server communication and system security.
- Worked with users to design and setup new system programs and applications.
- Daily interaction with users, interpretation of business requirements, implementation, support with non-technical-users.
- Troubleshot hardware and application problems, upgraded software and performed system backup
- Developed IBM-comparable System production planning and Quality assurance application.
- Tested software, which included the application programs and hardware control drivers.
- Performed application support, programming and technical debug for troubleshooting.
EDUCATION AND TRAINING:
2006 Oracle Data Warehouse, Oracle University, Bristol, CT2005 Oracle10g New Features for Administrator, Oracle University, Iselin, NJ2004 Oracle 11i Application Analyzer, TWD, Bristol, CT2003 Perl Fundamentals, New Horizons, Bristol, CT2002 Oracle 9i New Features for Administrator, Oracle University, Bristol, CT2001 Oracle Financial Express Fundamentals, Oracle University, Chicago, IL2000 Oracle 8i New Features for Administrator, Oracle University, Bristol, CT1999 Oracle Enterprise Manager, Oracle University, Stamford, CT1998 Oracle Certified Professional For Database, Sytrax Oracle, Parsippany, NJ1995 UNIX & NT Server 4.0 Core Tech. TCY Center, New York, NYMS. Computer Science, Wiltshire Univ. London, UKMastering IM & Computer Science, NJIT, Newark, NJBS, Computer Science, Xian University, Shaanxi, PRC
Photos and Video
Photos
Be the first to comment on this listing!