1. Utilizing DB2 database management system products and tools in order to store, analyze, and retrieve data.br 2. Using database physical and logical design principals and tools in order to model logical designs, establish relationships between data object entities, merge relationships, normalization and physically implementation.br 3. Designing, developing, and maintaining databases.br 4. Monitoring, diagnosing, and troubleshooting overall system signatures thereby understanding the CPU, memory and disk usages and issues.br 5. Managing and deploying application database modifications.br 6. Utilizing tools such as IBM i Collection Services to monitor, diagnose and troubleshoot issues; Visual Explain to advise and diagnose optimizer recommendations.br 7. Utilizing performance tools such as IBM iDoctor and Job Watcher to collect, investigate and analyze performance data.br 8. Experience writing SQL and programming in order to understand and analyze complex SQL stored procedure code and make optimization recommendations.br 9. Designing, implementing, and maintaining database security strategies that provide the appropriate level of security for users and applications
Categories: eb3
0 Comments