Database Architect
Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
Expert
• 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 Months High Availability and Disaster Recovery (HADR) for Db2:
Experience in setting up, configuring, and managing Db2 HADR solutions to
ensure business continuity and data resilience.
• 60 months Google Cloud Platform (Google Cloud Platform) Expertise: Experience with Google Cloud Platform
services relevant to database deployments, such as Compute Engine (for bare
metal instances), networking (VPCs, firewalls), storage (Persistent Disks), and
IAM for access control.
• 60 months Scripting and Automation: Experience in scripting languages such
as Bash, Python, or Perl for automating routine database administration
tasks, deployments, and monitoring.
• 72 Months DB2 Database Administration Expertise: Experience in
administering DB2 databases on Linux environments, including installation,
configuration, performance tuning, backup/recovery, and security
management
• 84 Months Red Hat Linux Proficiency: Experience with Red Hat Linux
operating systems, including command-line administration, scripting, and
system troubleshooting.
• 84 Months Database Performance Tuning and Optimization Expertise:
Experience with analyzing and resolving performance bottlenecks in Db2
databases, including query optimization, index management, buffer pool
tuning, and workload management.
• 84 Months Monitoring and Alerting: Experience with setting up and utilizing
monitoring tools (e.g., Dynatrace, Data Management Console, or Google Cloud Platform''s native
monitoring tools) to track Db2 and RHEL system health, performance, and to
configure proactive alerts.
• 84 Months Security Best Practices: Experience in implementation of security
best practices for both Db2 databases and RHEL systems, including user and
group management, access control, encryption, and vulnerability
management.
• 60 months Troubleshooting and Problem-Solving: Experience in analyzing
and problem solving to quickly diagnose and resolve complex issues related
to Db2, RHEL, and their interaction within the Google Cloud Platform environment.
• 84 Months Backup and Recovery Strategies: Experience in designing,
implementing, and testing robust backup and recovery strategies for Db2
databases, including full, incremental, and log backups, and performing point-
in-time recoveries.