Sr Administrators, Database

At T\-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package \- this is Total Rewards. Employees enjoy multiple wealth\-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and access to free, year\-round money coaches. That’s how we’re UNSTOPPABLE for our employees!

T\-Mobile is America’s supercharged Un\-carrier, delivering an advanced 4G LTE and transformative nationwide 5G network that will offer reliable connectivity for all. Sr Administrators, Database is located in Atlanta, GA and will apply deep understanding of Datastax Enterprise Cassandra architecture and internal frameworks to architect scalable distributed and geo\-redundant Cassandra database solutions to handle millions of transactions per hour.

• Telecommuting is permitted, but applicant must work from the worksite location at least 3\-4 days per week. No additional national or international travel is anticipated.

Position duties and responsibilities include, but are not limited to:

• Install, configure, apply patches and upgrade binaries of Datastax Enterprise Cassandra database software on Linux Servers.
• Configure backup, restore and monitor the backup jobs using Cohesity tool.
• 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.
• 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.
• Administer Datastax Enterprise Cassandra clusters in support of T\-Mobile business including adding/bootstrapping/removing nodes, consistency tuning, replication and multi\-DC configuration.
• Enforce enterprise security policies and procedures on databases by creating key spaces, users and managing the user connections, passwords.
• Apply advanced knowledge of various troubleshooting and tuning tasks, including Latency Analysis, Thread state Analysis, cassandra.yaml parameter changes, JVM tuning, compaction and repair with emphasis on issue resolution under 90 minutes.
• Apply advanced knowledge of shell scripting, including command line applications, and batch files to write and maintain shell and CQL scripts in support of database operations.

Minimum requirements:

Experience and education requirements:

PRIMARY REQUIREMENTS: Bachelor’s degree or foreign equivalent in Computer Science, Computer Programming, Computer Engineering, or related, and 5 years of relevant work experience.

ALTERNATIVE REQUIREMENTS: Master’s degree or foreign equivalent in Computer Science, Computer Programming, Computer Engineering, or related, and 3 years of relevant work experience.

Skills requirements: Requires experience in each of the following skills:

1\- 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;

2\- 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;

3\- 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;

4\- Automating administrative and operational tasks using Linux/Unix Shell, Python, Ansible scripts. Enabling streamlined system management, configuration, and deployment processes across distributed environments;

5\- 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;

6\- Monitoring and visualizing database performance, replication health, and cluster metrics using tools Prometheus, Grafana, DataStax OpsCenter; and

7\- 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.

Additional:

• At least 18 years of age
• Legally authorized to work in the United States
• Location: Atlanta, GA.
• Telecommuting is permitted, but applicant must work from the worksite location at least 3\-4 days per week. No additional national or international travel is anticipated.
• This position is eligible for the employee referral program.

Travel:

Travel Required (Yes/No): No

DOT Regulated:

DOT Regulated Position (Yes/No): No

Safety Sensitive Position (Yes/No): No

How to apply:

• Visit https://www.t\-mobile.com/careers
• Create a candidate profile, and apply to requisition number: REQ346907\.

OTHER: Work hours: 40 hours/week. Salary $127,878 to $135,000 per year.

• The pay range above is the general base pay range for a successful candidate in the state listed. The successful candidate’s actual pay will be based on various factors, such as work location, qualifications, and experience.
• At T\-Mobile, employees in regular, non\-temporary roles are eligible for an annual bonus or periodic sales incentive or bonus, based on their role. Most Corporate employees are eligible for a year\-end bonus based on company and/or individual performance and which is set at a percentage of the employee’s eligible earnings in the prior year. Certain positions in Customer Care are eligible for monthly bonuses based on individual and/or team performance, while Retail and Business Sales roles are eligible for monthly or quarterly sales incentives. And since we are ALL owners, EVERY employee at T\-Mobile is eligible for an Annual Stock Grant. For information about T\-Mobile’s amazing benefits, check out https://careers.t\-mobile.com/culture\-and\-benefits.

Candidate’s pay will be based on various factors, such as work location, qualifications, and experience. At T\-Mobile, employees in regular, non\-temporary roles are eligible for an annual bonus or periodic sales incentive or bonus, based on their role. Most Corporate employees are eligible for a year\-end bonus based on company and/or individual performance and which is set at a percentage of the employee’s eligible earnings in the prior year. Certain positions in Customer Care are eligible for monthly bonuses based on individual and/or team performance.

At T\-Mobile, our benefits exemplify the spirit of One Team, Together! A big part of how we care for one another is working to ensure our benefits evolve to meet the needs of our team members. Full and part\-time employees have access to the same benefits when eligible. We cover all of the bases, offering medical, dental and vision insurance, a flexible spending account, 401(k), employee stock grants, employee stock purchase plan, paid time off and up to 12 paid holidays \- which total about 4 weeks for new full\-time employees and about 2\.5 weeks for new part\-time employees annually \- paid parental and family leave, family building benefits, back\-up care, enhanced family support, childcare subsidy, tuition assistance, college coaching, short\- and long\-term disability, voluntary AD\&D coverage, voluntary accident coverage, voluntary life insurance, voluntary disability insurance, and voluntary long\-term care insurance. We don't stop there \- eligible employees can also receive mobile service \& home internet discounts, pet insurance, and access to commuter and transit programs! To learn about T\-Mobile’s amazing benefits, check out *www.t\-mobilebenefits.com**.*

Never stop growing!

As part of the T\-Mobile team, you know the Un\-carrier doesn’t have a corporate ladder–it’s more like a jungle gym of possibilities! We love helping our employees grow in their careers, because it’s that shared drive to aim high that drives our business and our culture forward. By applying for this career opportunity, you’re living our values while investing in your career growth–and we applaud it. You’re unstoppable!

T\-Mobile USA, Inc. is an Equal Opportunity Employer. All decisions concerning the employment relationship will be made without regard to age, race, ethnicity, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, religious affiliation, marital status, citizenship status, veteran status, the presence of any physical or mental disability, or any other status or characteristic protected by federal, state, or local law. Discrimination, retaliation or harassment based upon any of these factors is wholly inconsistent with how we do business and will not be tolerated.

Talent comes in all forms at the Un\-carrier. If you are an individual with a disability and need reasonable accommodation at any point in the application or interview process, please let us know by emailing ApplicantAccommodation@t\-mobile.com or calling 1\-844\-873\-9500\. Please note, this contact channel is not a means to apply for or inquire about a position and we are unable to respond to non\-accommodation related requests.