| DB2 Database Architect || Cincinnati, Dallas, Austin, or Philadelphia at Dallas, Oregon, USA |
| Email: [email protected] |
| From: sushant, InfoTech Spectrum [email protected] Reply to: [email protected] Job Title: DB2 Database Administrator Location: Cincinnati, Dallas, Austin, or Philadelphia Duration: 5+ Months (Possibilities of Extension) Need 15-18 + years of Arctitectural level candidate Note: Yellows are must have experience. JD: "DB2 DBA (Database Administrator) experience typically involves managing and maintaining IBM's DB2 database, which is used for both transactional and analytical workloads. A DB2 DBA's responsibilities and required skills can be broadly categorized as follows: Key Responsibilities: Installation and Configuration: 24/7 operational support. Installing and setting up DB2 database software on different platforms (e.g., Windows, UNIX, Linux). Configuring the database environment, including storage, memory, and security settings. Database Design and Architecture: Designing databases and schemas to meet business requirements. Creating and managing tablespaces, tables, indexes, views, and constraints. Planning database architecture for performance, scalability, and redundancy. Performance Tuning: Monitoring and optimizing the performance of the DB2 databases, including tuning queries and indexing strategies. Analyzing execution plans and making adjustments to ensure the best performance. Backup and Recovery: Establishing backup and recovery strategies, including automated and manual backups. Performing database recovery in case of data corruption or failure using tools like DB2 HADR (High Availability Disaster Recovery). Security Management: Managing user roles, privileges, and security policies. Ensuring compliance with data security standards like encryption, access control, and auditing. Database Maintenance: Regularly monitoring and maintaining database health using DB2 tools. Running reorganization utilities, updating statistics, and managing tablespace growth. Patching and Upgrades: Applying patches, fixes, and version upgrades as needed to ensure the system remains up to date and secure. Replication and High Availability: Setting up and managing replication between DB2 databases. Implementing high availability and disaster recovery solutions, including clustering and HADR setups. Scripting and Automation: Writing scripts for database monitoring, backups, automation of routine tasks, and scheduling jobs using tools like cron or DB2 native tools. Troubleshooting and Incident Resolution: Resolving database-related issues such as connectivity problems, slow query performance, or system crashes. Working with support teams to troubleshoot and resolve critical incidents. Essential Skills: SQL Proficiency : Strong knowledge of SQL for creating, querying, and managing databases. Knowledge of DB2 Tools : Experience with tools like DB2 Control Center, db2look, db2pd, and db2diag. DB2 Optimization : Expertise in performance tuning, including indexing, query optimization, and memory allocation. Backup and Recovery Management : Familiarity with DB2 backup utilities and disaster recovery protocols. Scripting : Ability to automate tasks using Shell scripting (on Linux/UNIX) or PowerShell (on Windows). Operating System Knowledge : Understanding of OS-level administration on platforms such as AIX, Linux, or Windows. High Availability Solutions: Experience with DB2 HADR, replication, or clustering solutions. Security Management : Hands-on experience with database encryption, role-based access control, and compliance standards. Typical Tools and Technologies: IBM Data Studio : For DB2 database administration and performance monitoring. DB2 HADR : For high availability and disaster recovery. DB2 Optim Performance Manager : For monitoring and tuning DB2 databases. IBM Guardium : For database security and auditing. A DB2 DBA role usually demands excellent problem-solving skills, attention to detail, and the ability to work under pressure to ensure databases are running optimally and securely. " Keywords: DB2 Database Architect || Cincinnati, Dallas, Austin, or Philadelphia [email protected] |
| [email protected] View all |
| Wed Sep 11 04:15:00 UTC 2024 |