Database Administrator Job @ Paccar

Job Information

Job Description:

Job Functions/Responsibilities
  • Design, implement and support SQL Database transactional and data warehouse infrastructure on-prem and in the Cloud, such as AWS and Azure.
  • Installation, administration and configuration of PostgreSQL.
  • Performing PostgreSQL and SQL DB patching, investigate and remediate vulnerabilities.
  • Support for Microsoft SSIS, SSRS, and SSAS.
  • Conduct performance tuning for SQL Server in various aspects such as Server, database, and stored procedure.
  • Generate scripts for database deployment.  Familiar with DevOps methodology to automate the database deployment.
  • Provide database support estimates for new projects.
  • Support multiple RDBMS engines and work in the AWS Cloud or Azure environment.
  • Support for Agile projects related to databases.
  • Contributes to and maintains database standards.
  • Ensures security is integrated into all data solutions to meet compliance standards.
  • Perform database backup and restore procedures.  Have experience with Disaster Recovery procedures and validation.
  • Support SQL Server database migrations or upgrades.
  • SQL Azure or SQL Server on AWS management experience.
  • Experience in SQL Azure or SQL Server on AWS to perform DB maintenance without direct access to server infrastructure.
  • Experience in SQL Azure database or SQL Server on AWS backup and point in time recovery using best practices.
  • SQL Azure or SQL Server on AWS performance tuning experience and how to analyze log events to log analytics.
  • Experience in Attunity/Qlik Replication Tool to bring data from source to target is a plus.
Qualifications
  • 5+ years’ relevant experience in data modeling and data architect.
  • Expertise with SQL and relational database systems.
  • Experience with SQL and/or PostgreSQL development.
  • Previous experience migrating an environment to PostgreSQL.
  • Knowledge of data warehousing concepts.
  • Knowledge of data mining, ETL, and using databases in a business environment with large-scale, complex datasets.
  • Experience in SQL Azure or SQL Server on AWS to perform DB maintenance without direct access to server infrastructure.
  • Experience in generating scripts for physical database deployment.
  • Familiarity with ETL tools and techniques.
  • Knowledge of more than one database platform, such as MySQL, PostgreSQL, and Oracle.
  • Knowledge of CI/CD pipelines and automating Database deployments.
  • Knowledge of standard data model reports.
  • Must know data normalization and denormalization techniques.
  • Excellent interpersonal and organizational skills, including active listening, problem-solving when under pressure, and facilitation.
  • Strong troubleshooting and problem-solving skills.
  • Strong scripting skills preferred, such as Python programming language or PowerShell.
Education
  • Bachelor’s degree in Computer Science, or related field

Benefits:
Experience Level: Senior
Work From: Onsite

Company Information

View all jobs of Company: Click here

Pin It on Pinterest