POSTGRESQL AND CASSANDRA ADMINISTRATOR

Employment Terms

6 month contract with opportunity to become permanent upon contract completion

Job Types

Full-time, Contract, Permanent

COVID-19 Considerations

We adhere to all Alberta COVID-19 protocols.

Location

Calgary, AB

Who we are:

Competing in a data-driven world, most businesses struggle to capture real value from data and analytics. Data management constraints cause mid-size and large companies to miss key opportunities in the value chain. Companies are left vulnerable to underwhelming performance and encroachment by competitors.

A4 Systems is a world-class team of cyber physical system product developers, transforming quality data into primary competitive advantage. A trusted partner to industries like manufacturing, agriculture, and energy, A4 builds mission-critical SaaS products for customers to achieve breakthrough performance.

We are looking for a PostgreSQL and Cassandra DBA with data science, big data, and cluster experience.

What you’ll be doing:

  • Work with database software to find ways to store, organize and manage data
  • Diagnose and troubleshoot database errors
  • Install and maintain the performance of database servers
  • Assist with database design and development
  • Set and maintain database standards
  • Maintain the integrity and performance of company databases
  • Assess the effectiveness and accuracy of new data sources and data gathering techniques
  • Manage database access
  • Design maintenance procedures and putting them into operation
  • Ensure databases meet user requirements
  • Liaise with programmers, applications/operational staff, IT project managers and other technical staff
  • Manage database security/integrity and backup procedures
  • Implement security measures
  • Define objectives through consultation with management
  • Write reports, documentation and operating manuals
  • Test and modify databases to ensure that they operate reliably
  • Provide user training, support and feedback
  • Write disaster recovery plans
  • Archive data.
  • Guarantee that data is stored securely and optimally

Who you are:

  • Bachelor’s degree in computer science or a related field
  • Minimum 5 years of experience in database administration or database architecture
  • Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
  • Experience with Big Data and clusters is necessary
  • Experience with Linux and Windows Server environments
  • Extensive experience with database technologies (PostgreSQL, Cassandra)
  • Strong command of SQL and SQL server tools
  • Advanced knowledge of database security, backup and recovery, and performance monitoring standards
  • Understanding of relational and dimensional data modeling
  • PowerShell and Unix shell scripting skills
  • Experience with cloud services is a plus
  • Strong mathematical and statistical knowledge
  • Coding knowledge and experience with several languages: C, C++, Java
  • JavaScript, etc.
  • Experience in querying databases and using statistical computer languages: Python, SQL, etc.
  • Experience with distributed data/computing tools: MySQL
  • Excellent written and verbal communication skills
  • Impeccable attention to detail

Sound like the job for you?

Got what it takes to work with us? Great! Send us a link to your resume or portfolio to become part of our talent pool.

 

Send you resume here