Database Administrator 3

$96,700 - $151,300/Yr

Paccar - Kirkland, WA

posted about 2 months ago

Full-time - Mid Level
Kirkland, WA
Machinery Manufacturing

About the position

PACCAR is seeking a Database Administrator 3 to manage and maintain the company databases of simple to high complexity. This position will help optimize database configuration and access, resolve database performance and capacity issues, and perform database recovery and backups. The role involves database development and SSIS package creation and maintenance, as well as managing SSIS Package/Job schedules and troubleshooting. The Database Administrator will be responsible for managing backups and restores, building and managing databases/instances, and ensuring instance and database security. Performance tuning is a critical aspect of this role, along with maintaining test, certification, and production environments. Compliance with the change control process, patching compliance, and audit compliance are also essential responsibilities. In addition, the Database Administrator will manage Reporting Services (SSRS) and Power BI, engage in SQL design and development consulting, and create and maintain detailed standard work/procedure documents. Providing technical support and guidance to end users, completing daily operating system health checks, and supporting scheduled after-hours maintenance are also part of the job. The ability to be on call for 24/7 support is required, ensuring that the databases are always operational and performing optimally.

Responsibilities

  • Manage and maintain company databases of varying complexity.
  • Optimize database configuration and access.
  • Resolve database performance and capacity issues.
  • Perform database recovery and backups.
  • Develop databases and maintain SSIS packages.
  • Manage SSIS Package/Job schedules and troubleshoot issues.
  • Manage backups and restores of databases.
  • Build and manage databases/instances.
  • Ensure instance and database security.
  • Conduct performance tuning of databases.
  • Maintain test, certification, and production environments.
  • Comply with change control processes.
  • Maintain patching compliance and audit compliance.
  • Manage Reporting Services (SSRS) and Power BI.
  • Engage in SQL design and development consulting.
  • Create and maintain detailed standard work/procedure documents.
  • Provide technical support and guidance to end users.
  • Complete daily operating system health checks.
  • Support scheduled after-hours maintenance.
  • Be on call for 24/7 support.

Requirements

  • 5+ years of experience in database administration required.
  • 2 - 5 years' experience administering SQL Server databases/instances required.
  • In-depth knowledge of installing, troubleshooting, and administering SQL Server 2014+ required.
  • Proven experience with SQL Server Reporting Services (SSRS).
  • Proven experience with SQL Server Integration Services (SSIS).
  • Proven experience with Power BI Server.
  • Strong documentation, organizational, and administration skills.
  • Strong oral and written communication skills.
  • Experience with Windows Server considered a plus.
  • Experience with SharePoint considered a plus.
  • Experience with visualization software (Tableau, Power BI, etc.) considered a plus.
  • Experience with AWS, S3, Redshift, Aurora, Azure considered a plus.
  • Experience with data warehousing considered a plus.
  • Experience with Agile methodology considered a plus.
  • Bachelor's degree in Information Technology or related field required.
  • MCSE or related SQL certification preferred.

Nice-to-haves

  • Experience with Windows Server considered a plus.
  • Experience with SharePoint considered a plus.
  • Experience with visualization software (Tableau, Power BI, etc.) considered a plus.
  • Experience with AWS, S3, Redshift, Aurora, Azure considered a plus.
  • Experience with data warehousing considered a plus.
  • Experience with Agile methodology considered a plus.

Benefits

  • Health savings account
  • AD&D insurance
  • Paid holidays
  • Disability insurance
  • Health insurance
  • Dental insurance
  • Flexible spending account
  • Tuition reimbursement
  • Paid time off
  • Employee assistance program
  • Vision insurance
  • 401(k) matching
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service