Job Search Job Details Applicant Profile  
      

Job Title:  Senior Database Administrator 
Job Number: xxxx E01310 
Travel:  5% 
Job Type:  Full Time 
Number of Openings:  1 
Location:  Niles,IL,60714 
 
Opportunity:  

We are looking for an experience Senior Database Administrator to join our IT team!  This positions will  participate in design, development and implementation of complex databases, often using new technologies. This individual will serve as the subject matter expert for the team.  In addition, they will manage multiple, moderately complex projects and direct activities of a team related to special initiatives or operations. This person will work under minimal supervision, with general guidance from manager. Ths person will also work on complex problems where analysis of situations or data requires an in-depth evaluation of various factors.  In addition, they will administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company's DB2 databases on both midrange (Unix/Linux) environments. In addition, they will implement data models and database designs, data access and table maintenance codes; resolves database performance issues, replication, and other distributed data issues.


  • Create and maintain database objects in DB2 such as tables, indexes, aliases, views, stored procedures
  • Build and Configure database instances including database security and disaster recovery 
  • Design/Implement backup and recovery solutions 
  • Performance tuning of instance, database, and sql queries 
  • Design and administer table partitioning, compression and/or HADR replication
  • Find bottlenecks in AIX/Linux server performance pertaining to database scope
  • Install and setup logical partitioned databases in AIX environment
  • Work with the groups to determine how system changes and upgrades will impact existing and new systems
  • Monitor, maintain, install and test new releases, upgrades and patches
  • Work in both a production and support environment role with regular interaction with the development and support teams to understand database requirements and support needs.
 
Required Skills:  
  • Bachelor's degree in computer science or an equivalent combination of education and experience, are required.
  • 8 + years of DBA Experience in DB2 Midrange environment
  • DB2 Data Partition Feature (DPF) in a multi-partition database environment
  • Backup and recovery strategies in a multi-partition environment 
  • Performance monitoring using IBM tools and snapshot utilities 
  • Troubleshooting experience using IBM tools and snapshot utilities
  • Table space management in a multi-partition environment 
  • Significant Experience in SQL tuning and database design 
  • Experience with midrange tools: CRON, vmstat, topas, etc.
  • Expertise with HADR, DPF 
  • Expertise in writing shell scripts and debugging existing scripts 
  • Expertise in OS and SAN storage concepts and Export, Import, Load, db2move, runstats, reorg, inspect, explain procedures in DB2 
  • Expertise in migration of DB2 database from AIX to Linux
  • Takes initiative  & Strong attention to detail

 

 
Benefits: Health Insurance, Life Insurance, Dental Insurance, Disability Insurance, 401(k), Profit Sharing, Tuition Reimbursement 
      

Phone: (847) 966-2770

©2012 The Bradford Group. All right reserved.