Database2 Database Admin

Dew Software is currently seeking a talented and experienced DB2 DBA to join our team. As a DB2 DBA, you will be responsible for the design, implementation, and maintenance of DB2 databases for our clients. Dew Software is a leading player in the Digital Transformation space, collaborating with Fortune 500 companies to support their digital innovation and transformation initiatives. With a strong global presence and a diverse team of experts, we leverage cutting-edge technologies and innovative approaches to deliver exceptional outcomes for our clients.

Responsibilities

• Design and implement DB2 database solutions based on business requirements.
• Perform database installations, upgrades, and migrations.
• Maintain database performance by monitoring and tuning.
• Ensure data integrity and security of DB2 databases.
• Create and maintain technical documentation related to DB2 databases.
• Collaborate with cross-functional teams to gather and analyze requirements.
• Provide support and troubleshooting for database issues.
• Stay up-to-date with the latest trends and advancements in DB2 technology.

Requirements

• Logical and Physical data modeling                                      
• Data definition language (DDL)
• Normalization and denormalization
• Referential integrity
• Data replication concepts
• Locking strategies
• Reporting tools
• ETL tools
• Datawarehouse concepts, including data mining, data marts, on-line analytical processing (OLAP)
• Scripting
• Database performance tuning/SQL tuning.
• Database security (Encryption/Masking)