Lead Database Administrator - Cloud AWS / Mongo DB / Cassandra
Spectrum
- Location
- Greenwood Village, CO
- Work model
- On-Site
- Level
- Senior
- Salary
- $88.2k/yr
Skills
About this role
This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future. Considering a role where your database expertise shapes mission-critical systems every day? As Lead Database Administrator at Spectrum, you will guide the design, implementation, and maintenance of complex database environments across both traditional (Oracle, SQL Server, Teradata) and cloud-native platforms (MongoDB, Cassandra, Amazon DocumentDB, AWS RDS/Aurora). Your leadership will drive data integrity, scalability, and operational excellence across hybrid and multi-cloud data infrastructure, making a measurable impact on the backbone of our technology infrastructure. How You'll Make an Impact Perform installations and configurations of grid infrastructure, databases, clients etc. Design and maintain access and security administration. Design, implement and maintain backup and recovery strategies on Database Management Systems Design, install, configure and maintains High Availability (RAC, RAC One Node, Data Guard etc.) Database solutions Plan and organize the team's project and work responsibilities by defining project scope, establishing timelines, organizing project teams, and tracking/assigning deliverables, and working with internal/external departments to achieve project objectives Serve as escalation point in absence of leadership in the troubleshooting of alerts (alert log, jobs, disk group, tablespace, etc.) and performance issues. Provide recommendations to team around designs, installs, configures, maintains and troubleshoots High Availability (real application clustering-RAC, RAC One Node, Data Guard etc.) Database solutions Install, configure, troubleshoot and monitor GoldenGate replication Expertise in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues Troubleshoot and resolve alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues Perform capacity planning of different server environments and provides recommendations to management to sustain business growth. Proactively works with development teams to improve database design and procedures on PL/SQL best practices Coach and mentor junior Database Administrators as well as provide guidance on work assignments. Guide database administration team members and advise leadership by communicating issues to a wide variety of internal and external departments to include technical teams, senior leadership, and vendors Gather business requirements and designs, implements multiple projects along with the production support. Create standard operational procedures and templates. Perform research and provides plans to remediate complex business problems Represent the database operations team working closely with clients and partners. Participate in on call rotation Working Conditions Office environment 24x7 on-call support What You'll Bring to Spectrum Required Qualifications Education Bachelor's degree in Information Technology, Computer Science, or related field or equivalent work experience Experience 8+ years of experience working with Oracle/SQL/Teradata and various database management systems in testing, implementation, maintenance and administration in a multiple platform environment Skills Ability to read, write, speak, and understand English Demonstrated knowledge of Oracle 11g and 12c database architecture; knowledge of maintaining medium to large scale database systems (Oracle, SQL, and/or Teradata) In-depth knowledge in Oracle RAC and ASM; knowledge of Instance, database and query tuning to improve the performance of the database/application Demonstrated knowledge of Linux operating systems and shell scripting, Oracle OEM, Oracle GoldenGate, and MySQL database Advanced knowledge of business awareness, critical analysis, and integration of information as well as the ability to develop action-oriented plans Advanced leadership skills and