Sr Administrator (Support & Operations)

Job description

Job Summary : Key Responsibilities Database Administration & Operations • Install, configure, upgrade, and maintain IBM DB2 database environments. • Manage DB2 databases across cloud, on-premises, and hybrid platforms. • Perform database capacity planning, performance monitoring, and optimization. • Implement database standards, policies, and best practices. • Manage database backup, recovery, and restore processes. • Troubleshoot database incidents and perform root cause analysis. Cloud Database Management • Design and support DB2 deployments on cloud platforms such as AWS, Azure, or Google Cloud. • Develop automated provisioning and deployment processes using Infrastructure as Code (IaC). • Support cloud migration initiatives, including database assessment, migration, and validation. • Optimize database resources for cost, performance, and scalability. Performance & Availability • Monitor database health and proactively identify performance bottlenecks. • Tune SQL queries, indexes, buffer pools, tablespaces, and database configurations. • Implement High Availability (HA), Disaster Recovery (DR), and business continuity solutions. • Support database replication, clustering, and failover mechanisms. Security & Compliance • Implement database security controls, encryption, and access management. • Conduct vulnerability assessments and support audit requirements. • Ensure compliance with organizational and regulatory standards. • Manage user roles, privileges, and data access controls. Automation & DevOps • Develop and maintain automation scripts using Shell, Python, or PowerShell. • Integrate database operations into CI/CD pipelines. • Implement monitoring, alerting, and self-healing capabilities. • Collaborate with DevOps and Site Reliability Engineering (SRE) teams. Collaboration & Support • Work with application development teams during design, testing, and deployment phases. • Participate in project planning, architecture reviews, and cloud transformation initiatives. • Provide technical guidance and mentoring to junior database administrators. • Maintain operational documentation and knowledge repositories. ________________________________________ Required Qualifications • Bachelor\'s degree in Computer Science, Information Technology, Engineering, or related field. • 5+ years of experience in Database Administration with at least 3+ years supporting IBM DB2. • Hands-on experience with cloud platforms (AWS, Azure, or GCP). • Strong knowledge of DB2 LUW administration and architecture. • Experience with database backup/recovery, HADR, replication, and performance tuning. • Experience in Linux/Unix environments. • Knowledge of scripting and automation using Shell, Python, PowerShell, or Ansible. • Familiarity with monitoring tools and troubleshooting methodologies. • Strong analytical, problem-solving, and communication skills. ________________________________________ Preferred Qualifications • IBM Certified Database Administrator (DB2) certification. • Cloud certifications (Azure Administrator, AWS Solutions Architect, Google Cloud Associate/Professional). • Experience with Kubernetes, OpenShift, or containerized database environments. • Knowledge of Terraform, Ansible, Jenkins, GitHub Actions, or similar DevOps tools. • Experience working in enterprise production support environments. • Exposure to other database technologies such as Oracle, SQL Server, PostgreSQL, or MongoDB. ________________________________________ Technical Skills Database Technologies • IBM DB2 LUW • DB2 HADR • DB2 Replication • Database Security & Encryption • Backup & Recovery Cloud Platforms • Microsoft Azure • Amazon Web Services (AWS) • Google Cloud Platform (GCP) Operating Systems • Linux (RHEL, SUSE, Ubuntu) • UNIX • Windows Server Automation & DevOps • Shell Scripting • Python • Ansible • Terraform • Jenkins • Git/GitHub Monitoring & Performance Tools • IBM Data Server Manager • Instana • Grafana • Prometheus • Cloud Monitoring Services _______ Key Responsibilities Job Summary : Key Responsibilities Database Administration & Operations • Install, configure, upgrade, and maintain IBM DB2 database environments. • Manage DB2 databases across cloud, on-premises, and hybrid platforms. • Perform database capacity planning, performance monitoring, and optimization. • Implement database standards, policies, and best practices. • Manage database backup, recovery, and restore processes. • Troubleshoot database incidents and perform root cause analysis. Cloud Database Management • Design and support DB2 deployments on cloud platforms such as AWS, Azure, or Google Cloud. • Develop automated provisioning and deployment processes using Infrastructure as Code (IaC). • Support cloud migration initiatives, including database assessment, migration, and validation. • Optimize database resources for cost, performance, and scalability. Performance & Availability • Monitor database health and proactively identify performance bottlenecks. • Tune SQL queries, indexes, buffer pools, tablespaces, and database configurations. • Implement High Availability (HA), Disaster Recovery (DR), and business continuity solutions. • Support database replication, clustering, and failover mechanisms. Security & Compliance • Implement database security controls, encryption, and access management. • Conduct vulnerability assessments and support audit requirements. • Ensure compliance with organizational and regulatory standards. • Manage user roles, privileges, and data access controls. Automation & DevOps • Develop and maintain automation scripts using Shell, Python, or PowerShell. • Integrate database operations into CI/CD pipelines. • Implement monitoring, alerting, and self-healing capabilities. • Collaborate with DevOps and Site Reliability Engineering (SRE) teams. Collaboration & Support • Work with application development teams during design, testing, and deployment phases. • Participate in project planning, architecture reviews, and cloud transformation initiatives. • Provide technical guidance and mentoring to junior database administrators. • Maintain operational documentation and knowledge repositories. ________________________________________ Required Qualifications • Bachelor\'s degree in Computer Science, Information Technology, Engineering, or related field. • 5+ years of experience in Database Administration with at least 3+ years supporting IBM DB2. • Hands-on experience with cloud platforms (AWS, Azure, or GCP). • Strong knowledge of DB2 LUW administration and architecture. • Experience with database backup/recovery, HADR, replication, and performance tuning. • Experience in Linux/Unix environments. • Knowledge of scripting and automation using Shell, Python, PowerShell, or Ansible. • Familiarity with monitoring tools and troubleshooting methodologies. • Strong analytical, problem-solving, and communication skills. ________________________________________ Preferred Qualifications • IBM Certified Database Administrator (DB2) certification. • Cloud certifications (Azure Administrator, AWS Solutions Architect, Google Cloud Associate/Professional). • Experience with Kubernetes, OpenShift, or containerized database environments. • Knowledge of Terraform, Ansible, Jenkins, GitHub Actions, or similar DevOps tools. • Experience working in enterprise production support environments. • Exposure to other database technologies such as Oracle, SQL Server, PostgreSQL, or MongoDB. ________________________________________ Technical Skills Database Technologies • IBM DB2 LUW • DB2 HADR • DB2 Replication • Database Security & Encryption • Backup & Recovery Cloud Platforms • Microsoft Azure • Amazon Web Services (AWS) • Google Cloud Platform (GCP) Operating Systems • Linux (RHEL, SUSE, Ubuntu) • UNIX • Windows Server Automation & DevOps • Shell Scripting • Python • Ansible • Terraform • Jenkins • Git/GitHub Monitoring & Performance Tools • IBM Data Server Manager • Instana • Grafana • Prometheus • Cloud Monit