Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

ARNAUD TIAM

Otsego,MN

Summary

Accomplished Senior PostgreSQL Engineer at DYNATA, specializing in performance tuning and high availability solutions. Successfully reduced query execution time by 60% through advanced optimization techniques. Adept in AWS cloud databases and automation, fostering collaboration with DevOps teams to enhance security and compliance practices. Passionate about leveraging technology for operational excellence.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior PostgreSQL Engineer

DYNATA
05.2022 - Current
  • Managed and optimized PostgreSQL DBA workloads on AWS RDS/Aurora, ensuring high availability and robust disaster recovery solutions.
  • Designed and implemented replication strategies (including streaming replication and read replicas) to enhance database reliability.
  • Developed automated backup & recovery solutions, leveraging Ansible, Terraform, and AWS Lambda to streamline database maintenance.
  • Conducted query optimization and performance tuning, reducing query execution time by 60 % and improving system efficiency.
  • Administered and fine-tuned MySQL databases alongside PostgreSQL, ensuring cross-platform consistency and reliability.
  • Integrated cloud database monitoring with CloudWatch, Datadog, and pg_stat_statements, proactively identifying and resolving performance bottlenecks.
  • Worked closely with DevOps teams to implement security best practices (Security & Compliance), including IAM policies, encryption (SSL/TLS), and role-based access control (RBAC).
  • Ensured seamless database automation and infrastructure management through Terraform, reducing manual intervention and enhancing deployment efficiency.

RDS Aurora PostgreSQL Database Engineer -L5

AMAZON WEB SERVICES
09.2020 - 04.2022
  • Administered multi-terabyte PostgreSQL & MySQL databases in AWS and on-premise environments.
  • Configured MySQL replication and PostgreSQL streaming replication to ensure fault tolerance.
  • Conducted database migrations from on-premise PostgreSQL to AWS RDS/Aurora, reducing operational costs.
  • Developed PL/pgSQL procedures and triggers to enhance database functionality.
  • Ensured database security and compliance through user access management, encryption, and audit logging.

PostgreSQL & Oracle DBA

NEWSEUM
09.2018 - 08.2020
  • Database Upgrades & Migrations: Upgraded PostgreSQL versions using pg_dump, pg_upgrade, and logical replication. Migrated on-premises Oracle databases to AWS RDS for PostgreSQL and Aurora PostgreSQL-compatible mode.
  • Database Administration: Managed user roles, privileges, table creation, and schema modifications. Ensured database security through pg_anonymizer and best practices.
  • High Availability & Disaster Recovery: Designed and implemented logical & streaming replication across multiple regions for disaster recovery. Configured full & incremental backups (cumulative and differential) using RMAN and performed point-in-time recovery (PITR).
  • Performance Optimization & Monitoring: Tuned performance using indexes, constraints, and query optimization. Managed vacuum, analyze, cluster operations for database maintenance. Monitored PostgreSQL databases with Zabbix, CloudWatch, pg_stat_statements, and generated reports using pgBadger.
  • Production Support & Agile Practices: Provided 24x7 production & development support using Jira Agile. Created Standard Operating Procedures (SOPs) for team reference.
  • Collaboration & Knowledge Sharing: Continuously learned new database technologies and shared knowledge with the team to improve overall efficiency.

Junior Database Administrator

Merck & Co
03.2015 - 08.2018
  • Assisted developers with SQL code troubleshooting as well as tweaked applications, procedures and SQL when necessary.
  • Developed RMAN backup and recovery strategies and procedures.
  • Performed database patching for bug fixes and mitigate security vulnerabilities.
  • Test recovery and support continuity of operations procedures.
  • Performed user administration.
  • Performed all aspect of database operations and maintenance (O&M) 24x7 remote support and on call rotation.
  • Installed and configured Oracle 10g, 11g servers and created databases in Linux environments.
  • Researched, tested, and made recommendations of data validation tools.
  • Established and implemented backup/recovery and patch scheduling as well as exported and imported databases frequently into the development and test environments and for archiving purposes.
  • Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
  • Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.
  • Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.
  • Resolved locking issues, inconsistencies and assisted in batch processes.

Education

Master of Science - Pharmacy

Université Des Montagnes (Bangangté-Cameroon)
12-2012

Skills

  • PostgreSQL Administration – Performance tuning, query optimization, indexing, partitioning
  • AWS Cloud Databases – Amazon Aurora (PostgreSQL/MySQL), RDS, EC2-hosted PostgreSQL
  • MySQL – Administration, replication, performance tuning
  • High Availability & Replication – Streaming replication, logical replication, read replicas
  • Backup & Recovery – PITR (Point-in-Time Recovery), WAL archiving, pgBackRest, pgBarman,
  • SQL & PL/pgSQL – Complex queries, functions, stored procedures
  • Infrastructure as Code (IaC) – Terraform, CloudFormation
  • Automation & Scripting – Bash, Python, Ansible
  • Monitoring & Performance Tools – pgAdmin, AWS CloudWatch, Datadog, Prometheus, Grafana
  • Security & Compliance – IAM, encryption (SSL/TLS), auditing, role-based access control

Certification

  • September 2021- AWS Certified Database -Specialty Certificate.
  • August 2021- Oracle Database 12c Administrator Certified Professional.

Languages

English
Full Professional
French
Native or Bilingual

Timeline

Senior PostgreSQL Engineer

DYNATA
05.2022 - Current

RDS Aurora PostgreSQL Database Engineer -L5

AMAZON WEB SERVICES
09.2020 - 04.2022

PostgreSQL & Oracle DBA

NEWSEUM
09.2018 - 08.2020

Junior Database Administrator

Merck & Co
03.2015 - 08.2018

Master of Science - Pharmacy

Université Des Montagnes (Bangangté-Cameroon)
ARNAUD TIAM