**Hi, reply to ku...@sunmergesystems.com and aditya.sunme...@gmail.com *2 references from the candidate to submit to the client.*
*Title -Sr. Oracle DBA with Mainframe experience - DB2/UDB* ** *12 mos contract + extensions* *Location: Manhattan, NYC* *Experienced Oracle DBA running on AIX platform with knowledge of DB2 for MVS and UDB for AIX. * *Responsibilities* :include working with application development teams to install and migrate releases, data fixes, as well as scripting procedures and administration of databases for the City of New York. Excellent skill on Performance tuning and trouble-shooting, Such as database tuning, SQL tuning. Ability to find and resolve the problem quickly. Good knowledge of the logical and physical database. Data warehouse, VLDB, database design and configuration are a must. Ability to work with application vendor in a quick pace fast turnaround environment. Strong Communication skills are required. * * *Oracle AIX 11g**:* knowledge of “SQLPLUS, SQLNET, dblinks, Data-Pump, cold and hot backup using RMAN, Ability to work with application team to review SQL and PL/SQL and a strong AIX UNIX Scripting (ksh) skills, with the ability to automate repeatable processes such as data pulls and loads. Knowledge of Oracle Gateway, Oracle Streaming, OEM 10G Grid Control, Netbackup, EMC Symmetric, and BCVs. Responsibilities may also include installation, configuration, and tuning. Good knowledge on how to handle Metalink and SRs. Knowledge of Symantec I3 is a big plus. *DB2 for Z/OS V9*: Knowledge of Z/OS (MVS) operating system access, i.e. TSO, ISPF, IOF, JCL, etc. (ability to code and debug CLISTS and REXX is desirable). DB2 access and maintenance tools such as SPUFI, DSNTEP2, QMF. Use of DB2 performance monitoring – BMC Main View. Able to use EXPLAIN command to assess DB2 optimizer access paths Knowledge of DB2 Utilities: IMAGE COPY, RECOVER, INDEX REBUILD, REORG, RUNSTATS, MODIFY, etc. Able to administer DB2 Access (privileges) in conjunction with authentication package ACF2 (Computer Associates). Knowledge of DPROPR; create and maintain registrations and subscriptions using Replication Center. Knowledge of DB2 programming techniques and methods: Packages, Plans, Dynamic SQL, CICS. CA scheduler, code and debug DB2 Stored Procedures and functions, use of Work Load manager address spaces. *Additional knowledge of UDB for AIX is a plus*: Knowledge of UDB on open systems, placement for system objects (catalog, tools, diaglog, etc), recovery object (copies, logs, etc), storage objects (tablespaces, indexes, buffer pools). Code and debug scripts to run utilities; RUNSTATS, BACKUP, etc. (understanding of interacting with NETBACKUP, CA Scheduler desirable). Experience in creating databases, creating and changing Database and Data Base Manager configurations and creation of aliases and nodes to enable connectivity between database clients and servers. Knowledge of BMC Patrol a plus Participate in on-call rotation and flexible work hours to support project development. May require participation in quarterly disaster recovery testing. Thanks & Regards, Aditya Kumar IT Recruiter Sunmerge Systems Inc. Tel: 201 377 5953 Fax: 732.981.0405 www.sunmergesystems.com ku...@sunmergesystems.com IM:aditya.sunme...@yahoo.in <im:aditya.sunme...@yahoo.in> Gtalk:aditya.sunme...@gmail.com <gtalk%3aaditya.sunme...@gmail.com>