Spectrum
The growth of our industry and evolving technology powers our employees’ careers as they move up or around the company.
Advertisement

Sr Database Engineer

Sorry, this job was removed at 2:34 a.m. (CST) on Thursday, January 20, 2022
Find out who's hiring in Colorado, CO.
See all Data + Analytics jobs in Colorado, CO
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

JOB SUMMARY
Develops large and complex databases through creation of logical and physical models of data. Provides leadership through demonstrated expertise in the design, implementation and maintenance of production databases in compliance with application specifications and company policies, standards and procedures. Manages and maintains all production and non-production databases. Demonstrates a mastery of a dedicated platform (Oracle, MSSQL, etc.). Guides multiple projects as a functional expert.
MAJOR DUTIES AND RESPONSIBILTIES

  • Actively and consistently supports all efforts to simplify and enhance the customer experience.
  • Provide leadership on the creation of physical and logical database models according to the business requirements.
  • Perform database engineering and administration tasks in , including design/modeling, SQL and script development, SQL and database tuning, data migrations, backups and recoveries, software installations and upgrades, and DBA support (including after-hours when needed) for three-tier, client/server databases.
  • Collaborate and guide multiple projects by understanding the business requirements for designs, implementation and production support.
  • Design, implement and maintain backup and recovery strategies on Database Management Systems.
  • Provide support for escalations of multiple services and multiple databases of varying complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
  • Expert in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues.
  • Provide escalated support in the troubleshooting of alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.
  • Perform capacity planning of MSSQL environment and provides recommendations to management to sustain business growth.
  • Expert in ETL tools and workflow creation, specifically Alteryx.
  • Design, implement and maintain scheduled jobs to import data from various external systems using ODBC, REST API, and SSIS technologies.
  • Guide the creation of standard operational procedures and templates.


REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
Expert knowledge of T-SQL programming language
Data modeling
Database performance tuning
ODBC
Expert knowledge of database architecture and its implementation
Expert understanding of best practices in maintaining medium to large scale Oracle database systems
Expert understanding of Change Management procedures
Expert knowledge of Instance, database and query tuning to improve the performance of the database/application
Expert understanding of SAN technologies related to SQL server disk layouts
Expert knowledge of Windows/Linux/Solaris operating systems and shell scripting
Ability to communicate orally and in writing in a clear and straightforward manner
Ability to communicate with all levels of management and company personnel
Ability to handle multiple projects and tasks
Ability to make decisions and solve problems while working under pressure
Ability to prioritize and organize effectively
Ability to show judgment and initiative and to accomplish job duties
Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.)
Ability to work independently
Ability to work with others to resolve problems, handle requests or situations
Ability to effectively consult with department managers and leaders
Comfort with having work peer-reviewed for accuracy and design.
EDUCATION
BA/BS in Information Technology, Computer Science, MIS
RELATED WORK EXPERIENCE
10+ years of experience working with Oracle and various database management systems in engineering, testing, implementation, maintenance and administration in a multiple platform environment
7+ years dedicated to a specific platform (Oracle, MSSQL, etc.) demonstrated by mastery
WORKING CONDITIONS
Office environment
24x7 on-call support IDB310 301139 301139BR
Here, employees don't just have jobs, they build careers. That's why we believe in offering a comprehensive pay and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
The pay for this position has a minimum of $85,900.00. The actual salary offer may be higher as we carefully consider a wide range of factors, including your skills, qualifications, experience and location. Also, certain positions are eligible for additional forms of compensation such as bonuses.

See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

What are Spectrum Perks + Benefits

Spectrum Benefits Overview

At Spectrum, employees don't just have jobs, they build careers. That's why we believe in offering a comprehensive compensation and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.

• Paid, on-the-job training and significant opportunities for advancement
• Earn an associate degree, bachelor’s degree or professional certificate tuition-free through our partnership with Guild
• High quality and affordable health care coverage for all employees and their family members
• Spectrum has absorbed the full cost increase for medical, dental and vision for the last 10 years, keeping employee costs flat
• Paid time off including vacation, sick time, personal days and holidays
• 401(k) with 100% match up to 6% of pay plus an additional 3% company contribution to a Retirement Accumulation Plan
• Free and discounted Spectrum services and deep discounts on Spectrum MobileTM regardless of where you live

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Employee resource groups
Employee-led culture committees
In-person all-hands meetings
In-person revenue kickoff
Diversity
Documented equal pay policy
Dedicated diversity and inclusion staff
Highly diverse management team
Mandated unconscious bias training
Diversity employee resource groups
With our business resource groups, we welcome you to be part of a strong community that gives you opportunities to network, develop and grow your career.
Hiring practices that promote diversity
We aim to foster an inclusive culture and workplace where every person feels empowered. No matter your background, identity or beliefs, we welcome you to explore a career with us.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Wellness programs
Mental health benefits
Transgender health care benefits
Financial & Retirement
401(K)
401(K) matching
Company equity
Performance bonus
Child Care & Parental Leave Benefits
Childcare benefits
Spectrum offers discounts at specified per location daycares.
Generous parental leave
Family medical leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Onsite office parking
Spectrum employees have plenty of on-site parking options including lots and a garage.
Recreational clubs
Relocation assistance
Onsite gym
Professional Development Benefits
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
We believe mentoring plays a vital role in career growth. We're proud of our mentorship program here at Spectrum.
Continuing education stipend
Online course subscriptions available
Personal development training

More Jobs at Spectrum

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about SpectrumFind similar jobs like this