DB2
Apply NowCompany: Codeforce360
Location: Harrison, NY 10528
Description:
Responsibilities:
Qualifications:
Preferred Qualifications:
- 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.