Sr Administrators, Database

T-Mobile T-Mobile · Telecom

This role involves administering Datastax Enterprise Cassandra database clusters, focusing on installation, configuration, patching, upgrades, backup, restore, monitoring, performance tuning, security enforcement, and troubleshooting. The administrator will also guide developers on schema design and automate operational tasks using scripting languages and tools like Ansible and Terraform.

What you'd actually do

  1. Install, configure, apply patches and upgrade binaries of Datastax Enterprise Cassandra database software on Linux Servers.
  2. Configure backup, restore and monitor the backup jobs using Cohesity tool.
  3. Apply experience in configuring and using Datastax Opscenter, Prometheus, Grafana tools to setup effective monitoring for alerts, cluster availability, performance and capacity analysis and take preventive actions based on alerts.
  4. Configure and tune the Database and Operating system environment for optimal performance and resource utilization and guide developers on optimal schema designs for better performance and scalability.
  5. Administer Datastax Enterprise Cassandra clusters in support of T-Mobile business including adding/bootstrapping/removing nodes, consistency tuning, replication and multi-DC configuration.

Skills

Required

  • Database administration with Datastax Enterprise Cassandra which includes DSE components (DSE Core, Search, Analytics/Spark, Graph), Security Management(LDAP, SSL/TLS, Role Based Access(RBAC), audit logging, encryption at rest/in transit), Backup and disaster recovery, planning and testing Datacenter failover procedures. Analyzing logs and metrics for root cause analysis of latency, timeouts, and node failures. Rolling upgrades, patch management, and minimizing downtime in Production
  • Design, configure and manage highly available, scalable and fault-tolerant Datastax Enterprise Cassandra clusters on on-prem and AWS EC2 instances using Ansible, Terraform and AWS Cloud Formation
  • Writing and optimizing CQL scripts, including UDF's(User-Defined functions), Materialized Views and Schema changes ensuring better performance and availability using CQLSH, DataStax Studio, DBeaver, Liquibase
  • Automating administrative and operational tasks using Linux/Unix Shell, Python, Ansible scripts. Enabling streamlined system management, configuration, and deployment processes across distributed environments
  • Advanced performance tuning and troubleshooting of Datastax Enterprise Cassandra clusters including JVM tuning, GC tuning, thread management and disk I/O optimization using nodetool, JConsole and DSE Metrics Collector
  • Monitoring and visualizing database performance, replication health, and cluster metrics using tools Prometheus, Grafana, DataStax OpsCenter
  • Deploying and managing Datastax Enterprise Search (SOLR integration) for implementing full-text search capabilities on NoSQL datasets, including configuring schema.xml, solrconfig.xml, and managing SOLR cores for optimized indexing and querying

What the JD emphasized

  • Datastax Enterprise Cassandra
  • Datastax Enterprise Cassandra clusters
  • issue resolution under 90 minutes