147 Ofertas de Mysql Database Administrator en Colombia

Database Administrator (DBA)

Position Overview

As a Database Administrator, you will play a critical role in managing and optimizing large-scale web-based application databases that power business operations. You'll support our architectural vision of delivering quality, scalability, performance, and functionality through robust database management. Our proprietary software platform simplifies transportation logistics for customers and carriers, serving as one of our key competitive advantages in the rapidly growing logistics market.

Key Responsibilities

Database Management & Performance

• Maintain and optimize database systems in collaboration with data development and software engineering teams

• Own performance monitoring, tuning, and issue resolution within the database environment

• Proactively identify current state issues and implement effective solutions

• Conduct regular SQL Server audits and SQL job inventory management

Technical Operations

-
Manage SQL transactional replication and disaster recovery operations

• Implement and maintain change tracking systems to monitor database modifications

- Configure and manage TLS encryption certificates for secure SQL Server connections

-
Execute SQL scripts for deployments, production issues, and system maintenance

• Perform code reviews of SQL scripts to ensure quality and efficiency

• Handle production incidents related to SQL Server environments with urgency and precision

Collaboration & Support

• Work closely with Software Engineers, Business Analysts, Quality Assurance, and DevOps Engineers

• Provide technical expertise and troubleshooting support across teams

• Contribute to architectural decisions that impact database performance and scalability

Required Qualifications

Technical Experience

• 3-5 years of experience in commercial-grade business applications with:
• SQL Server Database Administration (2008, 2012, 2014, 2019, 2022)
• Production server management
• SSIS package development and maintenance
• 3-5 years of hands-on experience with SQL transactional replication
• Experience implementing and managing change tracking systems for database auditing
• Proficiency in configuring TLS encryption and certificate management for SQL Server security
• Working knowledge of SAN technologies and third-party monitoring tools
• Expert-level troubleshooting and problem-solving skills

Professional Skills

• Proven ability to thrive in fast-paced, dynamic environments
• Strong attention to detail and commitment to quality
• Excellent communication and collaboration skills
• Self-motivated with strong ownership mentality

Overview
Connecting clients to markets – and talent to opportunity
With 4,300 employees and over 400,000 retail and institutional clients from more than 80 offices spread across five continents, we're a Fortune-100, Nasdaq-listed provider, connecting clients to the global markets – focusing on innovation, human connection, and providing world-class products and services to all types of investors.

At StoneX, we offer you the opportunity to be part of an institutional-grade financial services network that connects companies, organizations, and investors to the global market's ecosystem. As a team member, you'll benefit from our unique blend of digital platforms, comprehensive clearing and execution services, personalized high-touch support, and deep industry expertise. Elevate your career with us and make a significant impact in the world of global finance.

Corporate:
Engage in a deep variety of business-critical activities that keep our company running efficiently. From strategic marketing and financial management to human resources and operational oversight, you'll have the opportunity to optimize processes and implement game-changing policies.

Responsibilities
Job Purpose:
Database Administrator is a highly motivated individual responsible for implementing enhancements to all aspects of the current & future NoSQL/ OpenSource DB architecture. Similarly, they will need to ensure that all database systems are high performing and hi ghly available a t all times.

Primary Duties will include:

• Subject matter expert for NoSQL/ OpenSource databases (primarily Mongo Atlas , PostgresSQL but also CosmosDB and other technologies ) within the team, with the ability to share knowledge and train other team members who are primarily MSSQL/Oracle DBAs
• Work with dev teams across the business to identify and migrate N oSQL/ OpenSource databases that are not currently looked after by the DB team.
• On call cover as a part of a rotation with other members of the team
• Take proactive measures to monitor , trend, and tune NoSQL/ OpenSource databases, to meet or exceed baseline stability and performance SLAs
• Create, implement, and maintain NoSQL/ OpenSource DB Health Checks/Monitoring, and have a demonstrated ability to automate NoSQL/ OpenSource DB health reporting/event notification, and corrective actions.
• Developing 'best practice' standards within the DBA team and working with local and remote development teams to ensure these standards are adhered to
• Working with dev teams to help designing and implement highly performant databases
• When performance issues arise, determine the most effective way to increase performance including scaling up or out, server configuration changes, index/query changes, etc.
• Identify code defects and enhancements and develop a detailed root cause analysis that can be leveraged by the product management and development teams to improve application availability and decrease the total cost of ownership.
• Perform all database management responsibilities in NoSQL/ OpenSource DB for production and non-production workloads on premise and in the cloud.
• Adhere to and proactively enhance the firm's compliance with applicable laws, regulations and codes of conduct in all jurisdictions in which the Firm conducts business and which have an impact on its business
• Work to identify risks and enhance control across the business
• Report control weaknesses, illegal, suspicious or unusual activity
• Maintain an appropriate level of competence through ongoing training, making requests for updates or development as required
• Ensuring the clients are treated fairly by knowing the customer and giving suitable advice where appropriate , providing an appropriate level of service, communicating clearly and fairly and ensuring complaints are reported

Qualifications
To land this role you will need:

• Experience of administering other Open Source/NoSQL Databases such as CosmosDB and MariaDB
• Experience of administering MSSQL/Oracle DBs or a willingness to learn other DB technologies
• Experience of working in an Agile/SCRUM environment
• NoSQL/Opensource DB Certification
• Coding skills (PowerShell, C#, Python) to automate tasks and interact with APIs
• Automation and Orchestration tools (Jenkins, Ansible, GIT, TeamCity, Azure Devops , Terraform )

Working Environment:

• Hybrid

Requisition ID:
95511

Job Category:
Digital

Location:
Medellin, Antioquia, Colombia

Join a company that is passionately committed to the pursuit of a better world through positive change. With more than 65 years of business and technical expertise in mining , energy , and infrastructure , our 10,000 colleagues in 150 countries tirelessly work toward bettering the industries in which we operate. With practical solutions that are safe, innovative and sustainable, we think globally while acting locally. Are you looking for an opportunity to join a diverse group of professionals who are committed to remaining exceptional? We look forward to hearing from you.

We're at the forefront of our clients' digital transformation journey , successfully implementing emerging digital services into our clients' projects and operations that unlock a step change in their performance. Join the team to improve project outcomes, leverage the digital twin , deliver systems integration and interoperability, and support decision-making, autonomous execution , and integrated operations and performance centers.

Looking to take the next step in your career? Hatch is currently seeking a highly motivated Database Administrator to join the Digital group in Medellin.

As The Successful Candidate, You Will
Manage a global environment of SQL Server, Azure SQL DB, Oracle and other databases through multiple product lifecycle environments, from development to mission-critical production systems

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security;

Refine and automate regular processes, track issues, and document changes, manage and ensure compliance with database backup strategies

Troubleshoot problems as they occur, including weekends, on-call rotation as required

Complete administration of SQL Server Replication (transactional, peer-to-peer)

Complete administration of SQL Server Clustering, including Always On; additional knowledge of other HA/DR options as asset

Manage and maintain service pack updates, cumulative updates and security patches

Complete general database administration of Oracle 12c/21c Database, including datapump, RMAN backup and recovery

You Bring To The Role
Bachelor's degree

8-10+ years of experience of MS SQL Server production support in a mission critical environment,Microsoft Azure SQL DBs and Oracle OCI environment

Experience in analysis and tuning of T-SQL queries to improve performance, providing baselines and reporting to higher teams on results

Experience with backup, restore and recovery models

Familiarity with server troubleshooting in a Microsoft Windows environment

Experience in Oracle 12c/21c, including RMAN backup and restore and oracle datapump

The ability to plan, organize and work on multiple tasks simultaneously

MySQL, MongoDB and PostgreSQL knowledge is a plus

Advanced English proficiency (spoken and written)

Working knowledge in the following areas is considered an asset:

PowerShell Automation

Familiarity with Azure DevOps, Data factory, System Center Operations Manager, Azure Synapse

Familiarity with Microsoft Azure SecOps, IaaS, PaaS, DBaaS

Why join us?

• Work with great people to make a difference
• Collaborate on exciting projects to develop innovative solutions
• Top employer

What we offer you?

• Long term career development
• Think globally, work locally

Don't meet every single requirement? You don't need to. At Hatch, we are building a diverse, inclusive workplace that fosters innovation. If you're interested in this role, we encourage you to apply even if your past experiences don't perfectly align with the skills we've listed.

We're committed to fostering a workforce that reflects the diversity of the communities in which we operate and serve. Hatch is an Equal Opportunity Employer that considers applicants without regard to age, race, color, national origin, citizenship, religion, creed, gender, sexual orientation, marital status, disability, veteran, or any other protected status. If you have any accommodation requirements, please let us know. We'll do our best to meet your needs in accordance with applicable local legislation.

Job Description PostgreSQL Database Administrator (DBA)

Location: Remote (LATAM only)

Type: Part-time Contractor hours per month)

About the Role

We are looking for a skilled PostgreSQL Database Administrator (DBA) to join our team on a part-time basis. The ideal candidate will have strong hands-on experience managing PostgreSQL in production environments, with a focus on performance optimization, scalability, and reliability. You will collaborate closely with engineering teams to ensure best practices in database design, configuration, and operations. This engagement is expected to be 1020 hours per month, providing ongoing support and expert guidance.

Responsibilities

• Monitor and analyze database performance, identifying inefficient queries and recommending optimizations.
• Evaluate current PostgreSQL clusters for appropriate sizing, scaling, and configuration.
• Perform PostgreSQL version upgrades and patching.
• Provide operational support and best practices guidance for Amazon RDS PostgreSQL environments.
• Advise engineering teams on schema design, indexing strategies, and query optimization.

Nice to Have

• Experience with Amazon Redshift administration and optimization.
• Familiarity with ETL pipelines and data integration workflows.
• Experience with disaster recovery planning, backup/restore, and high-availability configurations.
• Knowledge of monitoring tools (CloudWatch, pg_stat_statements, etc.).

Qualifications

• Proven experience as a PostgreSQL DBA in production environments.
• Strong expertise in RDS PostgreSQL, query optimization, and cluster management.
• Ability to communicate recommendations clearly and concisely to engineering teams.

Why Join Us?

• Paid in USD
• 100% remote work from anywhere in LATAM
• Local holidays off and paid
• Birthday off and paid

Interested?

If you meet the requirements and are excited about this opportunity, wed love to hear from you

We are seeking a DBA with a strong background in SQL Server (Always on Availability Group, Transaction Replication, Table Partition, Waits stats, Backups, SQL Programing). Proficient with SQL Server replication, mirroring, log-shipping, snapshot technology. High Availability in a multi-node cluster with Always On, Database server failover, and Windows Server Failover Clustering. Strong understanding and experience optimizing production databases. Strong Cybersecurity knowledge about financial compliance and SQL Server Database security hardening policies.

The position will be 100% on-site.

Job Type: Full-time

Idioma:

• Inglés (Obligatorio)

What is Equisoft? Equisoft is a global provider of digital solutions for insurance and investment, recognized by over 250 of the world's leading financial institutions. We offer a comprehensive ecosystem of scalable solutions that help our customers meet all the challenges brought about by this era of digital transformation, thanks to our business needs-driven approach, industry knowledge, cutting-edge technologies and experts. With its business-driven approach, in-depth industry knowledge, cutting-edge technologies and multicultural team of experts based in North America, the Caribbean, Latin America, Europe, Africa, Asia and Australia, Equisoft helps its customers meet the challenges of this era of digital transformation.

Why Choose Equisoft? With 950+ employees, we are a stable organization that offers career advancement and fosters a stimulant environment. If that's not enough, then check out these other perks below:

• Hiring Location: LATAM (Colombia, Chile, Mexico)
• Remote Position
• Internal job title: Database Administrator
• Full-time Permanent Role
• Benefits available day 1: Medical, Dental and Telemedicine Program (Colombia & Chile)
• Flexible hours
• Number of hours per week: 40
• Educational Support (LinkedIn Learning, LOMA Courses and Equisoft University)

Role : Reporting to the Director, LATAM Architecture and Systems Integration, and working closely with various project teams and a Senior DBA mentor, the ideal candidate is a team player with strong Oracle Database expertise, experience in complex data environments, excellent communication skills and the ability to thrive in multi-platform enterprise implementations while demonstrating growth potential and technical leadership capabilities.

Your Day with Equisoft

• Guarantee availability and performance of Oracle databases in production environments
• Support legacy data migrations to OIPA systems for life insurance implementations
• Perform troubleshooting and resolution of database incidents with root cause analysis
• Assist development teams in the construction of efficient queries and database optimization
• Identify inefficient queries and provide optimization recommendations
• Participate in technical meetings with English-speaking teams to provide complex technical explanations
• Learn advanced database administration techniques from Senior DBA mentor
• Support backup and recovery operations for mission-critical systems
• Collaborate in infrastructure projects and best practice implementation
• Create automation scripts for repetitive database tasks
• Maintain systems documentation and inventory

Requirements

Technical

• Bachelor's Degree in Computer Science or a related field
• 5+ years of experience in Oracle Database administration (versions 19c/21c preferred)
• 3+ years of additional experience in IT or other database technologies
• Strong knowledge of Entity-Attribute-Value (EAV) models and large volume data management
• Expertise in advanced Oracle partitioning techniques and data organization strategies
• Solid experience with performance tuning and optimization, including AWR analysis, execution plans, and indexing strategies
• Advanced PL/SQL development and Shell/Linux scripting capabilities
• Experience with Oracle Enterprise Manager (OEM) and AWR tools or similar monitoring solutions
• Basic knowledge or exposure to Oracle GoldenGate for data replication and migration
• Familiarity with Oracle Data Integrator (ODI) or similar ETL tools
• Basic understanding of Oracle APEX or willingness to learn data manipulation tools
• Experience with Linux and Windows Server environments

Soft Skills

• Excellent written and verbal communication skills, in Spanish and English (B2 or higher)
• High level of autonomy (8/10) and ability to manage multiple projects simultaneously
• Proactivity and strong problem-solving initiative
• Emotional intelligence and empathy for effective team collaboration
• Rapid learning capability and ability to quickly understand complex technical and business challenges
• Knowledge sharing ability and excellent capacity to explain complex concepts clearly
• Impeccable attention to detail
• Understanding of financial services industry complexities (valued but not mandatory)

Nice to Have

• Oracle Exadata knowledge and experience (moderate importance)
• Oracle certifications (OCA/OCP)
• Experience with Oracle Cloud Infrastructure (OCI)
• AI tools proficiency (Claude, ChatGPT) for task optimization and productivity
• Background in financial services or insurance industry
• Experience with cloud services (AWS, Azure SQL databases)

Spanish version to follow / La versión en español seguirá a continuación.

¿Qué es Equisoft? Equisoft es un proveedor global de soluciones digitales para seguros e inversiones, reconocido por más de 250 de las principales instituciones financieras del mundo. Ofrecemos un ecosistema integral de soluciones escalables que ayudan a nuestros clientes a afrontar todos los retos que plantea esta era de transformación digital, gracias a nuestro enfoque basado en las necesidades empresariales, nuestro conocimiento del sector, nuestras tecnologías de vanguardia y nuestros expertos. Con su enfoque orientado al negocio, su profundo conocimiento del sector, sus tecnologías de vanguardia y su equipo multicultural de expertos con sede en América del Norte, el Caribe, América Latina, Europa, África, Asia y Australia, Equisoft ayuda a sus clientes a afrontar los retos de esta era de transformación digital.

¿Por qué elegir Equisoft? Con más de 950 empleados, somos una organización estable que ofrece oportunidades de desarrollo profesional y fomenta un entorno estimulante. Si eso no es suficiente, echa un vistazo a estas otras ventajas:

• Lugar de contratación: Latinoamérica (Colombia, Chile, México)
• Puesto remoto
• Título interno del puesto: Administrador de bases de datos
• Puesto permanente a tiempo completo
• Beneficios disponibles desde el primer día: Plan de salud (Colombia y Chile)
• Horario flexible
• Número de horas semanales: 40
• Apoyo educativo (LinkedIn Learning, cursos LOMA y Equisoft University)

Funciones : bajo la supervisión del director de Arquitectura e Integración de Sistemas para Latinoamérica y en estrecha colaboración con varios equipos de proyecto, el candidato ideal es una persona con capacidad para trabajar en equipo, con sólidos conocimientos de bases de datos Oracle, experiencia en entornos de datos complejos, excelentes habilidades de comunicación y capacidad para prosperar en implementaciones empresariales multiplataforma.

Tu día a día en Equisoft

• Garantizar la disponibilidad y el rendimiento de las bases de datos Oracle en entornos de producción.
• Apoyar las migraciones de datos heredados a los sistemas OIPA para implementaciones de seguros de vida.
• Realizar la resolución de problemas y la resolución de incidentes de bases de datos con análisis de la causa raíz.
• Ayudar a los equipos de desarrollo en la construcción de consultas eficientes y la optimización de bases de datos.
• Identificar consultas ineficientes y proporcionar recomendaciones de optimización
• Participar en reuniones técnicas con equipos de habla inglesa para proporcionar explicaciones técnicas complejas
• Aprender técnicas avanzadas de administración de bases de datos de un mentor DBA sénior
• Apoyar las operaciones de copia de seguridad y recuperación de sistemas críticos.
• Colaborar en proyectos de infraestructura y en la implementación de mejores prácticas.
• Crear scripts de automatización para tareas repetitivas de bases de datos.
• Mantener la documentación y el inventario de los sistemas.

Requisitos

Técnicos

• Licenciatura en Informática o un campo relacionado
• Más de 5 años de experiencia en administración de bases de datos Oracle (se prefiere las versiones 19c/21c)
• Más de 3 años de experiencia adicional en TI u otras tecnologías de bases de datos
• Sólidos conocimientos de modelos Entidad-Atributo-Valor (EAV) y gestión de grandes volúmenes de datos
• Experiencia en técnicas avanzadas de partición de Oracle y estrategias de organización de datos
• Sólida experiencia en ajuste y optimización del rendimiento, incluyendo análisis AWR, planes de ejecución y estrategias de indexación
• Capacidades avanzadas de desarrollo PL/SQL y scripting Shell/Linux
• Experiencia con Oracle Enterprise Manager (OEM) y herramientas AWR o soluciones de supervisión similares
• Conocimientos básicos o experiencia con Oracle GoldenGate para la replicación y migración de datos
• Familiaridad con Oracle Data Integrator (ODI) o herramientas ETL similares
• Conocimientos básicos de Oracle APEX o disposición para aprender herramientas de manipulación de datos.
• Experiencia con entornos Linux y Windows Server

Habilidades sociales

• Excelentes habilidades de comunicación escrita y verbal, en español e inglés (B2 o superior)
• Alto nivel de autonomía (8/10) y capacidad para gestionar varios proyectos simultáneamente
• Proactividad y gran iniciativa para la resolución de problemas
• Inteligencia emocional y empatía para una colaboración eficaz en equipo
• Capacidad de aprendizaje rápido y habilidad para comprender rápidamente retos técnicos y empresariales complejos
• Capacidad para compartir conocimientos y excelente capacidad para explicar conceptos complejos con claridad
• Atención al detalles
• Comprensión de las complejidades del sector de los servicios financieros (se valora, pero no es obligatorio)

Se valora

• Conocimientos y experiencia en Oracle Exadata (importancia moderada).
• Certificaciones Oracle (OCA/OCP).
• Experiencia con Oracle Cloud Infrastructure (OCI)
• Dominio de herramientas de IA (Claude, ChatGPT) para la optimización de tareas y la productividad
• Experiencia en el sector de los servicios financieros o los seguros
• Experiencia con servicios en la nube (AWS, bases de datos SQL de Azure)

Equisoft is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Únete a Teamcore: donde la data impulsa la innovación en el retail

En
Teamcore
, transformamos cómo las marcas de consumo masivo y retailers gestionan su ejecución comercial a través de
inteligencia artificial, datos y automatización
.

Nuestra tecnología permite a las compañías
mejorar la disponibilidad de producto, optimizar procesos y aumentar las ventas
, impactando directamente en la experiencia del consumidor.

Hoy, seguimos creciendo en toda Latinoamérica y buscamos a un
Database Administrator (DBA)
para fortalecer nuestro equipo de ingeniería, asegurando que nuestras bases de datos funcionen con
máximo rendimiento, seguridad y disponibilidad
.

Sobre el rol

Como
DBA
, serás responsable de diseñar, implementar y mantener las bases de datos que sostienen la operación tecnológica de Teamcore.

Tu misión será
garantizar el rendimiento, la estabilidad y la seguridad de los datos
, trabajando en conjunto con los equipos de desarrollo, operaciones y seguridad para asegurar una infraestructura sólida y escalable.

¿Qué harás?

• Diseñar y modelar bases de datos relacionales y no relacionales.
• Administrar entornos SQL y NoSQL (PostgreSQL, MySQL, MongoDB).
• Configurar y mantener instancias de bases de datos en
  GCP y AWS
  .
• Monitorear el rendimiento y optimizar consultas, índices y esquemas.
• Implementar
  estrategias de seguridad, respaldo y alta disponibilidad
  .
• Automatizar tareas rutinarias mediante herramientas como
  Ansible, Terraform o CloudFormation
  .
• Planificar y ejecutar migraciones y actualizaciones de bases de datos.
• Colaborar con desarrolladores y equipos de producto para mejorar la eficiencia en el acceso a datos.

Requisitos clave

• Formación en
  Ingeniería Informática, de Sistemas o afines
  .
• 3+ años de experiencia
  como Administrador(a) de Bases de Datos.
• Experiencia sólida con
  PostgreSQL, MySQL y MongoDB
  .
• Experiencia administrando bases de datos en
  cloud (GCP, AWS)
  .
• Conocimiento en
  seguridad, replicación, recuperación ante desastres y performance tuning
  .
• Experiencia con
  Linux/Unix
  y scripting.
• Capacidad analítica, orientación al detalle y foco en la confiabilidad.

Requisitos deseables

• Experiencia con
  BigQuery, Redshift o DynamoDB
  .
• Conocimientos en
  observabilidad (monitoring, logging, alerting)
  .
• Certificaciones en
  GCP o AWS
  .
• Experiencia en
  empresas SaaS o tecnológicas
  .
• Inglés técnico intermedio o avanzado.

Si eres una persona metódica, analítica y apasionada por la estabilidad y la eficiencia y además disfrutas colaborar con equipos de ingeniería y producto en un entorno de crecimiento constante
queremos conocerte

Database Administrator (DBA)

Written and Verbal English is REQUIRED

Position Overview

As a Database Administrator, you will play a critical role in managing and optimizing large-scale web-based application databases that power business operations. You'll support our architectural vision of delivering quality, scalability, performance, and functionality through robust database management. Our proprietary software platform simplifies transportation logistics for customers and carriers, serving as one of our key competitive advantages in the rapidly growing logistics market.

Key Responsibilities

Database Management & Performance

• Maintain and optimize database systems in collaboration with data development and software engineering teams

• Own performance monitoring, tuning, and issue resolution within the database environment

• Proactively identify current state issues and implement effective solutions

• Conduct regular SQL Server audits and SQL job inventory management

Technical Operations

-
Manage SQL transactional replication and disaster recovery operations

• Implement and maintain change tracking systems to monitor database modifications

- Configure and manage TLS encryption certificates for secure SQL Server connections

-
Execute SQL scripts for deployments, production issues, and system maintenance

• Perform code reviews of SQL scripts to ensure quality and efficiency

• Handle production incidents related to SQL Server environments with urgency and precision

Collaboration & Support

• Work closely with Software Engineers, Business Analysts, Quality Assurance, and DevOps Engineers

• Provide technical expertise and troubleshooting support across teams

• Contribute to architectural decisions that impact database performance and scalability

Required Qualifications

Technical Experience

• 3-5 years of experience in commercial-grade business applications with:
• SQL Server Database Administration (2008, 2012, 2014, 2019, 2022)
• Production server management
• SSIS package development and maintenance
• 3-5 years of hands-on experience with SQL transactional replication
• Experience implementing and managing change tracking systems for database auditing
• Proficiency in configuring TLS encryption and certificate management for SQL Server security
• Working knowledge of SAN technologies and third-party monitoring tools
• Expert-level troubleshooting and problem-solving skills

Professional Skills

• Proven ability to thrive in fast-paced, dynamic environments
• Strong attention to detail and commitment to quality
• Excellent communication and collaboration skills
• Self-motivated with strong ownership mentality

POSITION OVERVIEW

The Database Administrator's role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

RESPONSIBILITIES & ACCOUNTABILITIES

Strategy & Planning

• Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Acquisition & Deployment

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Conduct research and provide advice regarding the selection, application and implementation of database management tools.

Operational Management

• Create models for new database development and/or changes to existing ones.
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize and allocate physical data storage for database systems.
• Plan and coordinate data migrations between systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Create, or support creation of, required reports in response to business user needs.
• Perform database transaction and security audits.
• Identify, report, and manage database security issues, audit trails, and forensics.
• Implement security measures and frameworks, while ensuring compliance.
• Establish appropriate end-user database access control levels.
• Develop routines for end users to facilitate best practices database use.

STATISTICAL CLASSIFICATION

Operates infrastructure services in a "Managed Services" mode for Corporate, Packaging, Publication Papers, and Energy. Offers a selection of services to Tissue and ensures interoperability with their outsourced and managed services.

Corporate and DR data centers, 1000+ virtual servers, 20+ virtual hosts.

Complex 10Gbps and 40Gbps data networks, Fiber Channel networks, Wireless networks.

Wide Area Network with 60+ connected sites with both private line MPLS and Internet VPN links; some locations with High Availability routing and Cellular LTE failover technologies.

QUALIFICATIONS

• College (CEGEP) degree in Information Technology or bachelor's degree in computer science, Information Technology, or a related field. Certifications or degrees are preferred.
• 5 years of work experience in a DBA administrator role

Technical requirements

• SQL Server: Expertise in SQL Server installation, configuration, performance tuning, and high availability setups.
• Oracle JDE: Knowledge of Oracle JD Edwards database administration, including performance tuning, system upgrades, and integrations.
• SAP: Knowledge managing SAP, with a focus on database optimization, system replication, and SAP module integration.
• Performance Optimization: Advanced skills in database tuning and query optimization, including indexing, partitioning, and system resource management.
• Backup & Recovery: Experience in implementing and managing backup, recovery, and disaster recovery solutions across SQL, Oracle JDE, and SAP platforms.
• Security & Compliance: Familiarity with database security best practices, including encryption, access control, and compliance management.
• Cloud Experience: Knowledge of cloud-based database solutions (AWS, Azure, Oracle Cloud) and experience with cloud migrations for enterprise ERP systems.
• Scripting & Automation: Knowledge in scripting languages (e.g., PowerShell, Python, Bash) to automate routine database administration tasks.
• Data Migration: Experience with cross-platform data migrations, upgrades, and consolidation, including ERP systems (JDE, SAP).

LANGUAGES

• English spoken and written.