Jobs: DB2 DBA

Author: DB2UDB Admin
December 27, 2008

Reference Number:
08-00939

Job Description:
The Senior DBA must be proficient in performing DB2 database and system administration on an IBM Z900 Mainframe/ZOS Operating system. Provide senior level expertise in the architecture, design, and implementation of highly available databases supporting enterprise business applications. Experience and proficiency in database design, monitoring and troubleshooting are a must. Candidate will provide project leadership for various initiatives in the database services area. This individual performs all internal activities related to DB2, vendor supplied system utilities, and custom processing applications. Data Base Administration: · Possess Outstanding Performance and Tuning skills · Performs logical and physical database designs, implements and supports new and existing tables. · Monitors DB2 space usage and database performance. · Performs database reorganizations as necessary. · Evaluates the company technology environment from a DB2 perspective and recommends changes to the department manager on current and future system software requirements to meet the organization’s needs. · Assists in the meeting of service level agreements. · Insures system performance, redundancy, and fault tolerance. · Maintains current disaster recovery plan for mainframe operating systems infrastructure including DB2, system utilities. · Researches and assists the IT manager in the preparation of the annual department budget. · Monitors and make recommendations to management on established procedures for the mainframe DB2 environment in order to minimize the occurrence of errors. Works with internal departments to understand current and future projects to insure the systems programming infrastructure is able to meet the demands of future growth. 10+ years of expertise in the administration of DB2 databases. 10+ years of expertise in relational database design and maintenance. 10+ years of expertise in the use of z/OS/MVS and DB2 database utilities. Experience in DB2 version upgrades is a must. Experience working with Websphere software is a plus. The ability to effectively communicate, both verbal and written, to staff and executive management. In depth knowledge of systems development life cycle methodologies, project planning techniques, and project management principles. Ability to lead projects. College degree required.

Experience Level:
3 Years
Read the rest of this entry »



December 27, 2008

New Generation Software today announced that it is giving away two-user licenses for QPort Office, its business intelligence product that allows users to access Query/400 assets from Microsoft Office. The move is aimed at alleviating the temptation for System i shops to move to another graphical BI environment, DB2 Web Query, when upgrading from i5/OS V5R3, support for which ends early next year.

NGS unveiled Qport Office about a year and a half ago to give System i shops an alternative to the newly announced DB2 Web Query, which NGS maintains is too expensive and difficult to benefit most System i shops. By acting as a Windows front-end for DB2/400 data, Qport Office allows users to combine their knowledge and investment of Query/400 and Excel to bring i5/OS business intelligence into the graphical age, according to NGS.

NGS is betting that System i shops running i5/OS V5R3 would prefer to not spend the time and effort to install and configure DB2 Web Query prior to the end of support on April 30, 2009. Just the same, the temptation may be there to upgrade from Query/400, considering the compelling BI functionality that IBM delivered with DB2 Web Query.
Read the rest of this entry »



November 29, 2008

About the Job

Our client is currently seeking a Senior Specialist Database Admin to work on an upcoming assignment.?

KEY AREAS OF RESPONSIBILITY

The duties of the Senior Specialist Database Admin will include:

*Monitor, maintain and support databases:
*Develop and implement backup, recovery, checkpoint/?restart methodology and procedures to reduce system down time.?
*Monitor and tune databases to resolve any system problems.?
*Provide 7×24 DBA on-call support to various systems.?
*Provide support to the Peoplesoft administration team
*Provide DBA support for Peopletools Upgrade and Major peoplesoft application upgrade.?
*Work with the Peoplesoft administration team to identify, trace and fix performance problems.?
*Review and tune production Peoplesoft queries, SQR, Cobol and application engine programs.?
*Provide support for DB2 connect and CAE
*Provide DBA expertise in application development
*Design and maintain physical databases based on defined requirements such as specified performance and volume.?
*Participate in system and data analysis with application development team to ensure consistent, efficient and easy-to-maintain databases.?
*Plan and execute disaster recovery procedure.?
*Evaluate new database software, tools
*Evaluate and appraise new database software and products by interacting with software vendors/?suppliers, attending seminars, conferences and workshops.?

Read the rest of this entry »



October 24, 2008

IBM released an update Wednesday to patch at least 10 vulnerabilities in its DB2 database management system (DBMS).

The IBM Fix Packs address flaws in DB2 versions 9.1, 9.5 and DB2 Universal Database versions 8.1 and 8.2. The DBMS is affected by SQL injection vulnerabilities, an error that could result in password disclosure and a flaw that could reveal sensitive data.

Danish vulnerability clearinghouse Secunia gave the flaws a “moderately critical” rating and warned that the flaws could be exploited remotely.

“Some have an unknown impact and others can be exploited by malicious people to cause a DoS (denial of service) and disclose potentially sensitive information,” Secunia said in its advisory.



IBM chills mainframe New Coke

Author: DB2UDB Admin
October 21, 2008

IBM today is taking the wraps off a new line of entry-level mainframes, the System z10 Business Class server. The z10 BC is a cut-down version of the existing z10 Enterprise Class machine, which launched in March 2008 using Big Blue’s quad-core z6 CISC mainframe processor.

It has been a long time since most IT people have thought about IBM as a maker of mainframes, but the company still gets a considerably large portion of its hardware, software, and services sales from mainframes. In fact, some estimates put this as high as half of its sales.

That is why having entry mainframes - while possibly boring to Unix, Linux, and Windows enthusiasts - still matters to Big Blue and the companies that pay what can honestly be called exorbitant amounts of money for mainframes large and small.

The quad-core z6 processor announced with the System z10 server back in March ran at a top speed of 4.4 GHz and was rated at 920 MIPS per core, delivering about 60 per cent more oomph than the dual-core 1.7 GHz CISC processors used in IBM’s System z9 machines. Each core on the z6 chip has 64 KB of L1 instruction cache and 128 KB of L1 data cache, plus 3 MB of L2 cache.
Read the rest of this entry »



Jobs: DB2 Systems Programmer

Author: DB2UDB Admin
September 26, 2008

Company: TEKsystems
Location: Vancouver, BC
Position Type: Full Time, Temporary/Contract/Project
Job Category: IT/Software Development

DB2 Systems Programmer

On behalf of one of our top tier clients, TEKsystems is looking for an experienced DB2 Systems Programmer.

The successful candidate will be responsible for the installation and monitoring of the mainframe computing systems software environments to ensure compliance with IT service requirements.

This resource will have extensive experience planning, integrating, implementing and backup/restoring mainframe DB2 on Z/OS sub-systems to achieve optimum performance, reliability and availability.

Must Haves;

Extensive knowledge of DB2 for Z/OS

QMF, mainframe DB2 tools and utilities within complex enterprise infrastructures

Specialist knowledge of Z/OS (operating system, JES2, TSO, ISPF) software and management principles
Read the rest of this entry »



Database Administrator - IT Search

Author: DB2UDB Admin
September 25, 2008

Company IT Search
Posted 9/23/2008
Salary $70,000 - $90,000 / year
Job Skills DB2, Oracle, PeopleSoft
Job Type W2
Job Duration Full Time
Job Location US-PA-Pittsburgh
Start Date As Soon As Possible
Internal Job # JT2082
Travel none required
Job Requirements

Required Experience: 3 + years designing, implementing, supporting, and tuning database management structures (relational, hierarchical, distributed) and their associated platforms. Data manipulation, normalization, storage allocation, fragmentation and replication for distributed databases. Candidate Must Have DB2/UDB and PeopleSoft.

Desired Experience: Oracle

Degree: BS/BA Preferred

Relocation Paid: No
Read the rest of this entry »



BEIJING, Sep 23, 2008 (MARKET WIRE via COMTEX) — IBM (IBM:International Business Machines, the International DB2 User Group, today announced the first global competition to identify the next generation of software developers. Known as “The Search for the XML Superstar,” the contest will be open to all university students, faculty and professional developers across China, India and Southeast Asia testing knowledge of and skills in XML (eXtensible Markup Language) and database technologies.

“When universities and businesses collaborate, they build the next generation of skilled information technology leaders to create new opportunities, fuel economic growth and solve challenges that improve the human condition,” said Inhi Cho Suh, vice president of IBM Data Management Marketing. “This competition and our collaboration with IDUG is yet another example of our goal to cultivate individuals and communities with experience in innovative XML database technologies in hyper-growth markets such as Southeast Asia, China and India.”
Twenty-five years ago, relational database technology was invented by IBM Research, delivering the first commercially available database software program in the early 1980s. IBM has continued to invest and lead in the delivery of significant innovations in data server technology such as DB2 software with pureXML support to provide a seamless flow of information of both XML and relational data, regardless of format, platform or location.

“This competition is an effective way to bring real world industry experience to students to keep them in touch with IT trends and emerging technologies,” said Min Wang, Assistant Director, School of Software Engineering, Tongji University. “We believe the XML competition will promote this exciting technology among students faster than any textbooks. Participants who benefit from it are finding themselves already one step ahead.”
Read the rest of this entry »



September 13, 2008

PROCOM
DB2 DBA AIX DPF / EEE - T44513
Job Type: Contract
Location: Toronto, ON, CA
Job Category: Computers, Computers-Software, Computers-Hardware
Industry: Information Technology
Relevant Work Experience:
Number Of Positions: 1
Salary:
Company Url: http://www.procom.ca
Posted Sep 5, 2008
Email your resume: sunnyd@procom.ca

A leading provider of IT services in North America, PROCOM and PROCOM SERVICES currently have more than 2800 consultants on assignment and place hundreds of people in permanent positions annually. For over 30 years, we have been finding high-quality jobs for our candidates. Our policies of maintaining open communication with both clients and candidates consistently make us the IT Firm of Choice.

Position: DB2 DBA AIX DPF / EEE
Mandatory Skills: DB2, AIX, DPF / EEE
Location: Toronto (GTA)
Duration: 3 - 6 months
Start Date: ASAP

Job Description:

We are looking for DBA DB2 Administrator with extensive experience in AIX environment and Data Partitioning Feature or DPF Certification.

If you are available and qualified please email your resume to: SunnyD@Procom.ca

PROCOM SERVICES
A leading provider of IT services in North America, PROCOM and PROCOM SERVICES currently have more than 2800 consultants on assignment and place hundreds of people in permanent positions annually. For over 30 years, we have been finding high-quality jobs for our candidates. Our policies of maintaining open communication with both clients and candidates consistently make us the IT Firm of Choice.

PROCOM and PROCOM SERVICES are committed to employment equity and make every attempt to allow equal representation for all within the workplace.

We would like to thank you for your interest. Please note that all submissions will be assessed. However, only suitable candidates will be contacted further.

Please submit your most recent resume to: SunnyD@Procom.ca



Cobol IMS/DB2/CICS - Mastech

Author: DB2UDB Admin
August 4, 2008

LOCATION: US-PA-Camp Hill
COMPANY: Mastech
INTERNAL JOB #: 11792054
POSTED: 8/2/2008
JOB SKILLS: COBOL, DB2, Mainframe
JOB TYPE: 1099
Job Term: Full Time
PAY RATE: Depends on Experience
TRAVEL: none required
Will Sponsor H1B Visas
Will Accept Contractors

JOB DESCRIPTION:
Title: Mainframe ProgrammerDuration: 8+ month contract Location: Camp Hill, PA / Pittsburgh,PA Job Summary:–This position functions as a senior team member. –The incumbent is responsible for the definition, development, and implementation of new systems, and major enhancements to existing systems, as well as production support for systems with high complexity. –Requires good organizational skills and good time management skills, and strong analytical and problem solving skills. –The incumbent is capable of providing project leadership for major feasibility or business systems analysis studies. –The incumbent is capable of directing a team, delegating assignments, providing technical guidance and applying project management expertise. –The incumbent must be able to work effectively with all levels of management and staff, and with customers in defining requirements.Required Skills:Position typically requires 6-10 years of experience in application development as outlined above. Skills may include (but not limited to): COBOL, IMS Batch and Online, DB2, Expediter, Endevor.Preferred Skills:MUST HAVE COBOL, IMS Batch and Online, some DB2.
Read the rest of this entry »