12 Jan
Datastore Engineer
Michigan, Ann arbor , 48103 Ann arbor USA

Vacancy expired!

Job Title: Datastore Engineer/DBA

Duration: Contract

Location: Ann Arbor, MI

Required Skills & Experience:As a Datastore Engineer/DBA you will own a suite of data persistence systems, including Oracle, PostgreSQL, SQL Server, MySQL, Cassandra and cloud services such as Amazon RDS.You will align datastore management practices with business-driven IT, DevOps, and Agile such as automated continuous database software and schema change integration, deployment, and security. You will be adopting a full and authentic attitude towards transparency and collaboration with technical and business stakeholders via ITIL and Agile processes such as continuous process improvement, knowledge sharing, change & problem management, and post-mortems.You will support these systems in a 24x7x365 on-call rotation shared with other architects and engineers. Over time, you’ll find ways to automate mundane tasks and focus on building the future.You will help define and document best practice processes and standards for configuring, supporting, optimizing and backing up Datastore Systems as well as mentoring other Engineers, staying current with the latest datastore advances and evaluate the benefits of applying them in our environment.

Job Responsibilities and Duties
  • Implement and maintain complex databases which may include access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
  • Experience with DevOps toolset for pipeline automation, enterprise monitoring, and infrastructure analytics.
  • Ability to learn and transform knowledge into working architectures and operational standards for future datastore solutions based on what is best for the job.
  • Automate every aspect of datastore software and schema change management that can be automated.
  • Meet service level objectives (RPO, RTO, Performance) for services in your care.
  • Plan and execute system upgrades with little to no downtime.
  • Collaborate with a wide variety of talented engineers to help them build reliable and scalable services.
  • Research and deploys best-in-class database technology as ProQuest’s needs change.
  • Create physical database design and implement required database technologies and functions following database standards and best practices.
  • Create, support, and maintain business continuity and disaster recovery practices such as backup and recovery processes and implementation of high availability features.
  • Troubleshoot a wide range of database problems with complex interdependencies and provide corrective action within an appropriate period.
  • Plan database upgrade process.
  • Monitor capacity and performance and proactively resolve problems.
  • Mentor other Datastore Engineers and help to identify opportunities for training.

Qualifications
  • Bachelors’ degree or higher in Computer Engineering or Computer Science or equivalent experience.
  • 5 or more years of managing complex production datastores.
  • Good expertise in one or more of Oracle, PostgreSQL, SQL Server, or Cassandra
  • Strong operational experience in Linux/Unix/Windows environment.
  • Hands-on experience with automation frameworks such as Chef, Rundeck, Ansible and scripting languages such as Shell, Perl, Ruby, Python.
  • Strong automation skills (tool agnostic) and the ability to drive initiatives to automate processes.
  • Strong data modeling and data structure design skills.
  • Configuration management solutions to meet the needs of datastore deployment and management.
  • Ability to review deployment and operational environments, i.e., execute initiatives to reduce failure, troubleshoot issues across the entire infrastructure stack, expand monitoring capabilities, and manage technical operations.
  • Familiarity and comfort with distributed systems.
  • Experience a dministering databases running in the cloud.
  • Superior written communication skills.
  • Passion for stable and secure systems management practices.
  • Strong capabilities to monitor performance and tune database configuration to optimize performance.
  • Ability to work with source control systems.
  • Ability to work with architecture and design tools.

Vacancy expired!


Report job