Mindteck is looking for zOs DB2 DBA for one its Client in Mehanicsburg,PA.
Understand the concepts of DB performance, HA, and scalability.
Physical database design and tuning.
Bulk loading of source data and source data conditioning.
Database security and diagnostic maintenance.
Capacity planning of database.
Database user security and permissions.
Evaluation and utilization of software products to assist in the management of data.
Planning, installation, and maintenance of DBMS software.
Diagnosis of problems and resolution for application software.
Measurement of DBMS performance and tuning; diagnosis of problems.
Modification of system-level configuration to optimize performance.
Interface with developers for performance and data access requirements.
Development of standards and procedures for the DBMS environment.
Consultation with system administrator regarding O/S - DBMS requirements.
Maintenance of physical integrity of all production databases.
Configuring Database (Buffer Pools, tablespaces, etc.)
Self starter with a positive attitude.
Other duties as assigned.
6+ years experience supporting IBM DB2 (required)
6+ years experience writing and tuning SQL code (required)
Experience using SCM software like Subversion, CVS (required)
Experience with database backup/recovery, cloning, performance tuning, security, replication (required)
Excellent problem-solving, analytical and diagnostic skills . (required)
Familiarity with Java (desired)
Mindteck - 13 months ago