Alteo is looking for an Operations DBA for a permanent job based in Montreal.
Under the supervision of the DB Architect and Senior DBA, the Operations DBA is responsible for setting up, maintaining, and optimizing the various client and internal databases of the company.
The Operations DBA is responsible for supporting the Operations team in all its database installation, maintenance, and support needs.
They support the implementation of the various schemas necessary for the application, as well as their optimization and maintenance.
They are also responsible for setting up backups, managing DB access rights, and regularly applying security updates. By virtue of this position, they collaborate on a regular basis with the Technical Support team and assist them in all their analysis and patching needs related to the database.
Participate in the implementation, administration and maintenance of integration and production client databases.
Collaborate with the Quality Assurance team to provide the environments, tools and data needed to carry out their daily tasks.
Collaborate with the R&D team to provide them with the environments and to prepare the necessary data for the execution and testing of their processes.
Assist, support and train developers in the design, development and deployment of databases and their components.
Develop database migration plans and tools to support client version changes.
Track and ensure the performance, integrity and security of databases.
Set up and control access permissions and privileges of different DB users.
Develop and test plans and mechanisms for database backup and recovery.
Analyze DB performance issues and provide enhancements to ensure adequate application performance for local and remote customers.
Participate in the technical and operational support of our SaaS service from a given point of view.
Assist and train the technical support team for all database issues.
Participate in the drafting and maintenance of operational procedures related to databases.
On occasion, participate in the implementation of the persistence layer and the data model required for the different developments (new features such as bug fixes).
DEC / BAC in IT or equivalent.
3+ years of concrete experience in administration, maintenance and optimization of Oracle or MariaDB relational databases.
Experience in optimizing DBMS performance.
Knowledge of database testing methodologies.
Open to being on-call support of level 2 DB (rotation on evenings and weekends).
Mastery of the SQL language.
Knowledge of Linux or Unix systems.
Knowledge of MariaDB / MySQL or Oracle DBMS.
Experience with PL / SQL.
Attention to detail and customer satisfaction.
Excellent ability to understand and solve complex problems.
Organizational capacity, dynamism, rigor, and autonomy.
Ability to work under pressure with short delays, quick adaptation to new situations.
Communication and listening skills to facilitate teamwork.
Decision making, sense of initiative and leadership.
Mastery of communications, oral and written, in French and English.
Nice to have :
Experience in database modeling.
Experience as a Java developer in a corporate context.
Experience working in an Agile context.
Knowledge of the Java language.
Knowledge of JEE development.
XML, XSD, XQuery, XPath.
Experience with JPA, Hibernate and JDBC.
Knowledge of a database versioning tool such as LiquiBase.
Knowledge of a scripting language (Groovy, Bash, Python).
Experience with PostgreSQL.
Knowledge in data integration, BI or data warehousing.
Knowledge of backup and restore tools such as RMAN or Mariabackup.
Technical environment :
Agile (Scrum) and Lean (Kanban) Methodologies
Oracle and MariaDB
Java 1.8 (JEE + EJB and JSE + Swing)
Wildfly, Hibernate, Docker
Maven, Git, Jenkins, Artifactory
JIRA, Confluence, Zephyr, Zendesk
Job Type Permanent job Job Location Montreal Date 11 / 28 / 2019 Salary According to experience Job ID 2759