Oracle EBS DBA
Montreal, QC · On-site
... junior (L1) DBAs. Responsibilities: 1. Core Administration & Remediation Execute vulnerability ... Review and execute DML/DCL/DDL scripts and data fixes according to quality and security standards.
Oracle EBS DBA
Montreal, QC · On-site
... junior (L1) DBAs. Responsibilities: 1. Core Administration & Remediation Execute vulnerability ... Review and execute DML/DCL/DDL scripts and data fixes according to quality and security standards.
We're currently hiring for a Junior HR & Systems Specialist to join the Edelweiss Software Group ... Experience in data analysis. Experience with multi-country labor laws and compliance. Why Is This ...
Quick apply
We're currently hiring for a Junior HR & Systems Specialist to join the Edelweiss Software Group ... Experience in data analysis. Experience with multi-country labor laws and compliance. Why Is This ...
Benefits Specialist
Boucherville, QC · Hybrid
Administer employee benefits programs, including group insurance and retirement plans. * Manage ... Strong aptitude for data administration and management, with a high degree of accuracy and ...
Quick apply
Benefits Specialist
Boucherville, QC · Hybrid
Administer employee benefits programs, including group insurance and retirement plans. * Manage ... Strong aptitude for data administration and management, with a high degree of accuracy and ...
Junior Data Administrator information
What does a junior data administrator do?
A Junior Data Administrator is responsible for supporting the management, organization, and maintenance of a company's data systems. They assist in ensuring data accuracy, integrity, and security by performing routine data entry, updating records, and generating reports. Junior Data Administrators also help with data backups, troubleshooting database issues, and following data management policies. Their work supports the efficiency and reliability of the organization's information systems, often under the supervision of more senior data professionals.
What are the key skills and qualifications needed to thrive as a junior data administrator?
To thrive as a Junior Data Administrator, you need a solid understanding of database fundamentals, data entry accuracy, and basic knowledge of data management best practices, typically supported by a relevant degree or coursework. Familiarity with database management systems (such as SQL Server or MySQL), spreadsheet software, and sometimes data visualization tools is often expected. Attention to detail, problem-solving abilities, and effective communication are valuable soft skills for this position. These skills and qualities are important because they ensure data integrity, efficient operations, and smooth collaboration within data-driven teams.
What are some common challenges faced by junior data administrators, and how can they be addressed?
Junior Data Administrators often encounter challenges such as managing large volumes of data with strict accuracy requirements, adapting to new database technologies, and troubleshooting data inconsistencies. To address these, it's important to develop strong attention to detail, seek mentorship from experienced team members, and actively participate in training sessions to stay current with tools and best practices. Collaborating closely with IT and data analyst teams can also help junior administrators learn effective problem-solving strategies and build a solid foundation for career growth.
What is the difference between Junior Data Administrator vs Data Analyst?
| Aspect | Junior Data Administrator | Data Analyst |
|---|---|---|
| Required Skills | Basic data entry, database management, attention to detail | Data interpretation, statistical analysis, reporting |
| Certifications | Relevant certifications like Microsoft Office, database fundamentals | Data analysis certifications like Microsoft Excel, SQL, or Tableau |
| Work Environment | Data entry teams, database management departments | Business intelligence, marketing, finance teams |
| Typical Tasks | Maintaining databases, data cleaning, inputting data | Analyzing data trends, creating reports, data visualization |
While both roles involve working with data, a Junior Data Administrator primarily focuses on managing and maintaining databases, whereas a Data Analyst interprets data to provide insights. The roles often overlap in skills like database knowledge and certifications, but their core responsibilities differ significantly.
Full-time
Posted 25 days ago
Job description
Job Description Job Title: Oracle EBS DBA Location: Montreal (in-office daily) Job Type: Full-time salaried role OR Contract The Oracle EBS DBA will serve as a Subject Matter Expert (SME) responsible for end-to-end database administration, with a primary focus on vulnerability remediation and CPU patching. This role handles escalated incident response, root cause analysis, change management, and technical mentorship for junior (L1) DBAs. Responsibilities: 1.
Core Administration & Remediation Execute vulnerability remediation and independent CPU patching across production systems as the primary operational focus. Manage installation, configuration, maintenance, upgrades, and support for Oracle Database production servers. Perform database refreshes, object reorganizations, indexing, space management, and datafile administration.
Execute backup and recovery operations using RMAN, including handling complex database recovery scenarios. Manage database user access, security, and audit concepts. 2.
Oracle E-Business Suite (EBS) Operations Administer Oracle E-Business Suite R12.2.x, including ADOP patching, ad-utilities, product patching, and EBS cloning. Configure and maintain EBS Workflow Mailer and GL modules. 3
Incident & Change Management Provide resolution and root cause analysis (RCA) for P1 through P4 incidents, proactive maintenance, and complex troubleshooting. Review and execute DML/DCL/DDL scripts and data fixes according to quality and security standards. Follow ITIL policies across Incident, Problem, and Change Management (IPC).
Create standard operating procedures (SOPs) and documentation. Escalate vendor, system, or service risks to management and Oracle Support as necessary. 4.
Collaboration & Support Partner with cross-functional teams to design and implement solutions aligned with business requirements. Provide technical guidance and support to junior (L1) DBAs when applicable. Qualifications: Oracle & Database Core: Strong expertise in Oracle Database (including v12c, PDB & CDB architectures) and general familiarity with Sybase and SQL Server.
Oracle EBS: Hands-on experience with Oracle EBS R12.2.x, ADOP patching, EBS cloning, and workflow management. Backup, Performance & Tools: Deep proficiency with RMAN backup/recovery, OPatch, shell scripting, export/import utilities, character set conversion, database monitoring tools, and analyzing ADDM/ASH reports for performance tuning. Operating Systems: Strong Unix/Linux (Solaris/Linux) background
Process Knowledge: solid understanding of ITIL frameworks (Incident, Problem, and Change Management). Bachelor's or Master's degree in Computer Science, Information Technology, Systems Engineering, or a related technology field. Strong analytical, troubleshooting, and problem-solving skills.
Excellent written and verbal communication skills. Ability to work independently with minimal supervision in a high-energy, results-driven environment. Capital Markets domain experience is preferred.
Titre du poste : Administrateur de bases de donnees (DBA) Oracle EBS Lieu : Montreal (en presentiel tous les jours) Type d'emploi : Poste salarie a temps plein OU Contrat L'administrateur de bases de donnees (DBA) Oracle EBS agira a titre d'expert en la matiere (SME) et sera responsable de l'administration complete des bases de donnees, en se concentrant principalement sur la correction des vulnerabilites et l'application des correctifs CPU. Ce role prend en charge le traitement des incidents escalades, l'analyse des causes profondes, la gestion des changements et le mentorat technique pour les DBA juniors (L1). Responsabilites : 1.
Administration principale et correction Executer la correction des vulnerabilites et l'application autonome des correctifs CPU sur les systemes de production, en tant que priorite operationnelle principale. Gerer l'installation, la configuration, la maintenance, les mises a niveau et le soutien pour les serveurs de production de bases de donnees Oracle. Effectuer le rafraichissement des bases de donnees, la reorganisation des objets, l'indexation, la gestion de l'espace et l'administration des fichiers de donnees.
Executer les operations de sauvegarde et de restauration a l'aide de RMAN, y compris la gestion de scenarios complexes de restauration de bases de donnees. Gerer l'acces des utilisateurs aux bases de donnees, la securite et les concepts d'audit. 2.
Operations Oracle E-Business Suite (EBS) Administrer Oracle E-Business Suite R12.2.x, y compris l'application de correctifs ADOP, les utilitaires AD, l'application de correctifs produits et le clonage EBS. Configurer et maintenir les modules EBS Workflow Mailer et GL. 3
Gestion des incidents et des changements Assurer la resolution et l'analyse des causes profondes (RCA) pour les incidents de P1 a P4, la maintenance proactive et le depannage complexe. Reviser et executer les scripts DML/DCL/DDL et les correctifs de donnees conformement aux normes de qualite et de securite. Suivre les politiques ITIL a travers la gestion des incidents, des problemes et des changements (IPC).
Creer des procedures operationnelles normalisees (SOP) et de la documentation. Escalader les risques lies aux fournisseurs, aux systemes ou aux services aupres de la direction et du support Oracle, au besoin. 4.
Collaboration et soutien Collaborer avec des equipes multifonctionnelles pour concevoir et mettre en uvre des solutions alignees sur les exigences de l'entreprise. Fournir des conseils techniques et du soutien aux DBA juniors (L1), le cas echeant. Qualifications : Bases de donnees et Oracle : Solide expertise en bases de donnees Oracle (y compris les architectures v12c, PDB et CDB) et familiarite generale avec Sybase et SQL Server.
Oracle EBS : Experience pratique avec Oracle EBS R12.2.x, l'application de correctifs ADOP, le clonage EBS et la gestion des flux de travail (workflows). Sauvegarde, performance et outils : Maitrise approfondie des sauvegardes/restaurations RMAN, d'OPatch, des scripts shell, des utilitaires d'exportation/importation, de la conversion de jeux de caracteres, des outils de surveillance des bases de donnees et de l'analyse des rapports ADDM/ASH pour l'optimisation des performances. Systemes d'exploitation : Solides connaissances en environnement Unix/Linux (Solaris/Linux)
Connaissance des processus : Solide comprehension des cadres ITIL (gestion des incidents, des problemes et des changements). Baccalaureat ou maitrise en informatique, technologies de l'information, genie logiciel ou dans un domaine technologique connexe. Fortes capacites d'analyse, de depannage et de resolution de problemes.
Excellentes competences en communication ecrite et verbale. Capacite a travailler de maniere autonome avec un minimum de supervision dans un environnement dynamique et axe sur les resultats. Experience dans le domaine des marches des capitaux (Capital Markets) privilegiee.