Lead Administrator - L1

Role Purpose

Cassandra and Postgres Database Administrator (DBA)
Job Summary:Cassandra Database Administration:Design, configure, and maintain Cassandra clusters deployed in HSBC.Install, configure, and manage multi-node Cassandra clusters both on-premise and cloud, both public and internalPerform database backups, recovery, and restoration activities.Manage database schemas, tables, indexes, and user permissions.Diagnose and troubleshoot production incidents and resolve performance bottlenecks, including slow queries and resource utilizationissues.Optimize database configurations, query performance, and data modeling for improved efficiency and scalability.Execute repairs in case of data inconsistency and perform JVM tuning and garbage collection optimization.Estimate storage requirements and collaborate with infrastructure teams to ensure adequate resources are provisioned.Regularly review and update security configurations to address emerging threats and vulnerabilities.Set up database monitoring tools to proactively identify performance issues, errors, and anomalies.Respond to database alerts and take appropriate actions to resolve issues.PostgreSQL Database Administration:Collaborate with teams to integrate PostgreSQL databases into the infrastructure and ensure their optimal performance.Perform PostgreSQL database backups, recovery, and restoration activities.Optimize PostgreSQL configurations and query performance for transactional workloads.Design and implement PostgreSQL data models and SQL scripts for transactional workloads.Manage PostgreSQL databases in GCP environments (preferred).Diagnose and troubleshoot PostgreSQL production incidents and resolve performance bottlenecks.Requirements:Cassandra:5+ years of experience in Cassandra database administration.Expertise in installing, configuring, and monitoring Cassandra clusters.Experience in creating column families, bootstrapping, decommissioning, removing, replacing, and repairing nodes.Proficiency in creating keyspaces, tables, and secondary indexes in Cassandra.Strong experience in performance tuning Apache Cassandra clusters to optimize writes and reads.Hands-on experience with Cassandra data modeling and CQL scripting.Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.Experience in managing and monitoring 24x7 production database environments.PostgreSQL:5+ years of experience in PostgreSQL database administration.Expertise in installing, configuring, and monitoring PostgreSQL databases.Proficiency in PostgreSQL data modeling and SQL scripting.Strong experience in performance tuning PostgreSQL databases to optimize writes and reads.Hands-on experience with PostgreSQL in GCP environments (preferred).Proven ability to evaluate database performance, isolate bottlenecks, and implement optimizations in transactional settings.Preferred Skills:Experience with Datastax Enterprise Service (DSE).Familiarity with cloud environments like GCP.Strong troubleshooting and analytical skills.

Do

• Provide adequate support in architecture planning, migration & installation for new projects in own tower (platform/dbase/ middleware/ backup)
  • Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution
  • Conduct technology capacity planning by reviewing the current and future requirements
  • Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable
  • Strategize & implement disaster recovery plans and create and implement backup and recovery plans
• Manage the day-to-day operations of the tower
  • Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues.
  • Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower
  • Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges
  • Develop shift roster for the team to ensure no disruption in the tower
  • Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc.
  • Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps
  • Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness

Team Management

• Resourcing
  • Forecast talent requirements as per the current and future business needs
  • Hire adequate and right resources for the team
  • Train direct reportees to make right recruitment and selection decisions
• Talent Management
  • Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness
  • Build an internal talent pool of HiPos and ensure their career progression within the organization
  • Promote diversity in leadership positions
• Performance Management
  • Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
  • Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
• Employee Satisfaction and Engagement
  • Lead and drive engagement initiatives for the team
  • Track team satisfaction scores and identify initiatives to build engagement within the team
  • Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team
  • Exercise employee recognition and appreciation
    Mandatory Skills: PostgreSQL Database Admin .

    Experience: 5-8 Years .