DB2

Apply Now

Company: Codeforce360

Location: Harrison, NY 10528

Description:

Responsibilities:
  • Creates schemas and sub-schemas in consultation with application project team.
  • Submits recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery specifications.
  • Proposes detailed specifications and flowcharts and coordinates installation of revised or new database systems.
  • Sets up and performs backup, recovery, and Stats Updates procedures.
  • Works with relevant staff, to identify and transform business requirements into physical data models.
  • Performs monitoring and tuning for performance, and recommends Application database enhancements.
  • Develops transaction logging and security features.
  • Understands and uses normalization methods and design methodologies.
  • Develops, documents, and enforces the standards, security procedures, and controls for access to ensure integrity of the database system.
  • Works with system engineers or application developer to evaluate and implement technical enhancements.

Qualifications:
  • Bachelor's degree in computer science, software engineering, or related field.
  • Five years of collective experience as a Senior DB2 Z DBA with Version 9,10.11, & 12.
  • Experience with Online utilities, indexing strategies, index management and statistics for 500 million+ row tables.
  • Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Attention to detail and results oriented, with a strong customer focus.
  • The ability to work within a team environment.
  • Problem-solving and communication skills.

Preferred Qualifications:
  • Working knowledge BMC Monitoring Tools.
  • Knowledge of AWS and Azure (Azure SQL and DW) platforms.
  • Knowledge of IDAA.

Similar Jobs