Share this Job

SQL Server Postgres Database Administrator Job

Date: Jul 22, 2021

Location: Mexicali, BCN, MX

Company: PACCAR

Company Information

PACCAR is a Fortune 500 company established in 1905. PACCAR Inc is recognized as a global leader in the commercial vehicle, financial, and customer service fields with internationally recognized brands such as Kenworth, Peterbilt, and DAF trucks. PACCAR is a global technology leader in the design, manufacture and customer support of high-quality light-, medium- and heavy-duty trucks under the Kenworth, Peterbilt and DAF nameplates. PACCAR designs and manufactures advanced diesel engines and also provides customized financial services, information technology and truck parts related to its principal business.
 
Whether you want to design the transportation technology of tomorrow, support the staff functions of a dynamic, international leader, or build our excellent products and services — you can develop the career you desire with PACCAR. Get started!
 

Requisition Summary

PACCAR is a global truck technology leader with operations around the world. The Digital Solutions team is helping PACCAR make better decisions faster by moving to the cloud, adopting DevOps/CICD best practices, and unlocking a new level of productivity & value. We are looking for technology leaders to drive this evolution.

 

We are looking for an experienced Database Administrator of SQL and PostgreSQL databases to manage thousands of enterprise-level databases in a scalable database solution. The ideal candidate is enthusiastic about learning new technologies and implementing them to empower internal customers and scale the existing platform. The ideal candidate demonstrates reliable business and communication skills and works with business and technical teams. In this role, you would serve as the expert at designing, implementing, and operating stable, scalable, and low-cost database solutions.  The Database Administrator would design, develop, implement, test, document, and operate large-scale, high-volume, high-performance database structures. Implement data structures using best practices in data modeling.  Will provide operational database services to the organization, and own, track, and resolve database-related incidents and requests. On a day-to-day level, there will be database backups, maintenance, monitoring, and responding to database-related alerts and escalations.

He/she would be tuning performance on queries running over millions of rows of data. The person in this position should be analytical, have a high customer focus, and have a passion for process improvement. The Database Administrator should be a motivated self-starter who can work independently in a fast-paced, ambiguous environment and have excellent business acumen and communication skills to work with business owners to develop and define key business questions.

 

Location: Preferably Renton, WA or open to remotely any U.S. or Mexico location.

Job Functions / Responsibilities

  • Design, implement and support SQL Database transactional and data warehouse infrastructure on-prem and in the Cloud, such as AWS or 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.
  • Good understanding of relational data modeling, including physical database design using Erwin data modeler. 
  • 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.
  • Implement and support SQL Server high availabilities, such as log shipping, replications, and always-on Availabilities Groups.
  • Support SQL Server database migrations or upgrades
  • SQL Azure or SQL Server on AWS management experience is a must
  • 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

  • Bachelor's degree in Computer Science or related field.
  • 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.
  • Knowledge of modeling logical/business data requirements in a data model tool, such as Erwin data modeler.
  • Experience in generating scripts for physical database deployment.
  • Ability to teach data modeling and data design concept to IT and business people.
  • Familiarity with Cloud, NoSQL, and Hadoop data technologies
  • Familiarity with dimensional and data vault modeling techniques.
  • Familiarity with ETL tools and techniques.
  • Knowledge of more than one database platform, such as MySQL, PostgreSQL, Oracle, and Teradata.
  • 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.

Additional Job Board Information

PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability.


Job Segment: System Administrator, Database, SQL, Warehouse, DBA, Technology, Manufacturing