Principal Database Administrator

The Ash Group; Aurora (IL); Remote; USD 80,000 - 120,000; Full time

Job summary

A leading company seeks a Database Administrator to provide support for Microsoft SQL Server. The role involves maintenance, installation, and configuration of databases, ensuring high availability and performance. Candidates should have a Bachelor's degree in computer science and at least 5 years of experience in SQL Server administration.

Benefits

Well-Funded General Employees Retirement Plan

On-site fitness center

Internal educational programs for career advancement

Qualifications

• 5 years of experience as Database Administrator of Microsoft SQL Server 2008 or higher.
• 2 years of Windows Server administration experience.
• MS SQL Server certification strongly preferred.

Responsibilities

• Provides primary support for all lines of business Microsoft SQL Server instances.
• Administers production SQL Server Reporting Services and Integration Services.
• Responsible for configuration and management of production SQL Server.

Skills

Advanced knowledge in administration and tuning of Microsoft SQL Server

Working knowledge of Windows Server and Desktop

Documentation of technical procedures

Skill in technical writing

Education

Bachelor’s degree in computer science or a related field

Tools

Microsoft SQL Server

SQL Server Reporting Services

Integration Services

Job description

Setting: Mostly remote, but will need to come onsite as needed

Manager: Josh Smith

*** Must reside in the State of Colorado at time of hire. ***

WHY WORK WITH US?

• Well-Funded General Employees Retirement Plan
• Light rail station minutes away
• On-site fitness center and overall employee well-being programs
• Internal educational programs to assist with career advancement.

WHAT DOES THE ROLE ENTAIL?

Provides primary support in the maintenance, installation, configuration of Microsoft SQL Server and other relational, line of business database services. Reporting development/support, reporting databases, developing packages and triggers along with procedures to improve application performance. Establishes and maintains DEV/TRAIN/PROD instances. Interacts with other IT Divisions and City employees.

WHAT ARE THE DAY-TO-DAY EXPECTATIONS?

• Primary support for all lines of business Microsoft SQL Server instances, including all upgrades and migrations to new versions when necessary. Provides support as required for other databases.
• Administers production SQL Server Reporting Services, Integration Services, and SQL Agent Jobs.
• Responsible for the configuration and management of production SQL Server (Always on Availability groups/Mirroring/Replication), ensuring a highly available SQL Server production environment.
• Assist with the deployment of SQL products and services in development and COTS application deployment as required.
• Ensure all database servers are backed up and tested to meet the business’s Recovery Point Objectives (RPO).
• Performs database services such as job processing, tuning, archiving, and installing upgrades to test and production database environments.
• Co-Lead the future implementation of Business Intelligence, Data Lakes, Data Warehouses, Business Analytics, as resources and funds allow.
• Responsible to ensure that the SQL Server environment meets established security requirements.
• This position may serve as the lead on specific projects or initiatives.
• Performs additional duties as assigned.

MINIMUM QUALIFICATIONS & WORKING CONDITIONS

Education:

• Bachelor’s degree in computer science or a related field.

**A combination of relevant education and experience may be substituted for the minimum education and experience requirements on a year for year basis.

• Experience:5 years of experience as Database Administrator of Microsoft SQL Server 2008 or higher.
• 2 years of Windows Server administration, including experience in Web application implementation in a Microsoft SQL Server environment.
• Knowledge:Working knowledge of Windows Server and Desktop.
• Advanced knowledge in administration and tuning of a Microsoft SQL Server and other relational databases.
• Experiencing support cloud and, especially, virtualized on-site instances using tools such as DH2i’s DxEnterprise or Nutanix’s NDB.
• Documentation of technical procedures.
• Skill in technical writing desired.
• Knowledge of migrating SQL to cloud or virtualized platforms is a plus.
• Familiarity with SSRS or other reporting tools.
• Ability to work with customers to elicit and help them define their requirements.
• Licenses Or Certificates Required:
• MS SQL Server certification is strongly preferred.

WORKING CONDITIONS

Physical Demands:

• Light physical work requiring ability to life a maximum of 50 pounds, including lifting 25 pounds overhead.
• Regular lifting and carrying of computer equipment.
• Moderate walking and standing.
• Vision to read and interpret reports and other written documents.
• Hand/eye coordination for operation of computer keyboard.
• Frequent speech communication and hearing to maintain communication with managers, employee users and citizens.
• Normally works in a clean, comfortable environment.
• System support issues may require working outside the office environment and in or around emergency response vehicles.
• This position generally is remote but must be able to come to the Office as needed. Employee must be in Colorado.
• Equipment Used:
• Standard business and professional tools and equipment including computers, laptop computers and mobile computing devices.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Government Administration

Referrals increase your chances of interviewing at The Ash Group by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified when a new job is posted.

Sign in to set job alerts for “Database Administrator” roles.

Denver, CO $114,816.00-$165,845.33 1 month ago

Denver, CO $89,301.33-$121,194.66 1 month ago

Denver, CO $114,816.00-$165,845.00 1 month ago

Denver, CO $89,301.33-$114,816.00 1 month ago

Denver, CO $139,000.00-$157,000.00 4 months ago

Database Administrator / Systems Eng-IT, Staff / TS/SCI / Onsite: CO

Staff Database Administrator - R10193924

Database Administrator - EPIC Cache/Iris

Denver, CO $80,000.00-$120,000.00 3 weeks ago

Superior, CO $70,000.00-$110,000.00 2 weeks ago

Multiple Positions at Charles Schwab & Company, Inc

Denver, CO $250,000.00-$290,000.00 2 weeks ago

Denver, CO $112,597.33-$152,810.66 1 month ago

Slalom Flex (Project Based) – Senior SQL Server Database Administrator

Denver, CO $144,768.00-$209,109.33 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.