Iris Tchouasseu

• Planning the Installation, configuration and maintenance of PostgreSQL on EC2, RDS, and Linux (Cent-OS, Debian).
• Taking Backup of PostgreSQL Databases running on AWS RDS using pg_dump, AWS Lambda & AWX Backup, RDS Snapshot.
• Configuring MS SQL Server Option group called "Native-backup-restore" to backup MS SQL databases running on AWS RDS. and store in S3 bucket.
• Creating IAM Users, KMS Keys, VPC, Security group, Parameter group etc.
• Working in collaboration with the SRE Team for database monitoring,
• Monitoring my databases using Dynatrace, Performance Insights, Enhanced monitoring, CloudWacth and Dynatrace.
• Compared 2 different schemas and two different databases to find the missing tables using Pg_Admin.
• Troubleshooting and resolving database integrity issues, performance issues associated with cache missed, bloat, temp_files, deadlocks, locks, frequent checkpoints, index corruption, latency due to the table size, full storage, extension not present in rsd.allow_extensions, CPU spike, conflicts, Index fragmentation using Performance Insights, Pg_stat_activity, pg_locks, pg_stat_database, pg_stat_bgwriter, pg_stat_user_index, pg_stat_all_tables, EXPLAIN ANALYZE etc.
• Reviewing scripts submitted by the development team and working with others teams like Data analysts, developers, business analysts, and project managers to perform the capacity planning required to create and maintain the databases.
• Managing and providing end-to-end support and problem resolution for SQL SERVER and Postgres databases through multiple lifecycle environments such as development, testing, staging to mission-critical production systems.
• Control and establish appropriate database security using search_path, pg_hba.conf, postgresql.conf, database triggers, database schema.
• Enable login and configure pgbadger to analyze the results of load testings in order to address database issues.
• Stand up a production database with a snapshot of the staging environment, shared from a different AWS account.
• Modification of the RDS databases to enable more features like performance insights, enhanced monitoring, delete protection etc.
• Upgraded multiple PostgreSQL databases from 10.x to 12 and 13.x
• Homogenous migration of PostgreQL databases from on-prem to AWS RDS using pg_dump, pg_restore and psql.
• Document resolved issues and update our confluence to help the CloudOps Team on how to resolve known issues..
• Recommend and implement data security by creating users and assigning permissions based on the principle of least privileges and with technologies such as always encrypted, Transparent data encryption (TDE) and SSL Authentication to secure client's sensitive data.
• Assisting deployment teams by running database scripts (MDL, DDL, TCL etc.), by taking a backup of specific database or table as recommended on the Jira Tickets.
• Assisting deployment team with issues related to backup and restore etc.
• Worked with DEVOPS Team to address the database readiness after a new deployment.
• Troubleshooted staging & production databases and resolved issues with corruptions, queries and Database latency;
• Checking fragmentations, database integrity, custom database report.
• memory management, thread and tasks managements, buffer management and configure tempdb, MAXDOP, MAX Server Memory, Min memory per query etc. for MS SQL Server database optimization.
• Configuration of PostgreSQL & MS SQL SERVER Parameter group to address specifics database problem based on the result of our investigations
• Proposing to the Management team a database a maintenance plan strategy to resolve database issues on some critical production databases.
• Configuring streaming replication for somme of our customers running their own on-prem databases for high availability and disaster recovery.
• Building AWS RDS read replica and cross region replication for high availability and disaster recovery.
• Configuring pg_cron extension to automate our AWS RDS db maintenance tasks like VACUUM ANALYZE, REINDEX, CLUSTER.
• Configuring pg_repack for full database vacuum with minimum downtime.
• Scheduled SQL agents to resolve issues with Index fragmentation & kill sleeping processes on MS SQL SERVER databases
• Used basics Kubernetes commands to find information as per business requirement.
• Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
• Monitoring databases for Index, partitioning Memory and I/O utilization,
• Connecting to my RDS MS SQL SERVER using MS SQL Management studio;
• Used EXPLAIN and EXPLAIN ANALYZE to identify and tune SQL queries for performance improvements;
• Switched the Database from Production to Testing and Testing to Production;
• Prepared technical interview questions to interview with few candidates for the position of PostgreSQL & MS SQL Server Database administrator ;
• Familiarity with Parameter store, Route 53, EBS, LastPass etc.

• Create IAM user accounts and role-based policies for access to AWS Postgres on Both RDS and EC2 Instances, Compared custom and default parameters group
• Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic allowed to reach one or more AWS EC2 instances;
• Manage the Space and Storage of Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals;
• Performed database Refreshes and monitored replication delays;
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping;
• Created new cluster and upgraded the cluster to another PostgreSQL sever;
• Database secutity with Row level security, search path, pg_hba.conf and postgresql.conf
• Installed and configured MTK for migration from Oracle to postgresql and EDB advance server;
• Maintained postgresql with PgAdmin 4, Psq;
• Created tablespace, databases, indexes, moving data, granting of necessary privileges in posgresql and EDB advance server from 9.6 to 12.x.
• Performed backup, restore, and created databases using PgAdmin 4, pg_dump and pg_basebackup, pg_backrest.
• Created Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pg_hba.conf file etc;
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Provided response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours;
• Worked with development and operations teams to tune production queries for optimal performance;
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery;
• Configuring monitoring tools for better performance like PEM, CloudWatch, Performance Insight, Postgresql logs.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community;
• Configured and Database installation creating tables, schemas;
• Monitored the database for Index, partitioning Memory and I/O utilization
• Configured Enterprise Failover Manager for fast database failover, and integrate that with pg_pool-II for connection pooling and load balancing to resolve issues with locks and deadlocks.
• Implemented cascading replication for our databases running on EC2.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

• Maintained detailed technical documentation of database architecture and modeling as per business requirements;
• Provided technical assistance for preparation of shell scripts for tasks automation;
• Conducted complete analysis of database capacity and performance requirements;
• Implemented procedures for analysis, consolidation and tuning of

databases for efficiency;

• Implemented a database replication, replication monitoring
• configured pg_bouncer for load connection pooling
• Upgraded databases from 9.6 to 10.x and 11.x using pg_upgrade
• Performed database maintenance tasks like vacuum, analyze, vacuum full, reindex, cluster, create index etc.
• Monitored using Datadog;
• scheduled my jobs using crontab.

• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization;
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access;
• Set user privileges within and outside the database environment from the pg_hba.conf;
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures;
• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals;
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures;
• During production hours, resolved lock/deadlocks and resource contention issues;
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• pg_dump, pg_basebackup, X-TRA backup for MYSQL,
• Monitored my databases using solarwinds;
• created a MySQL and PostgreSQL Databases;
• Familiarity with psql, DML, DDL, DCL etc.
• Performed MYSQL daily Maintenance tasks.
• reload/refresh the privilege or the grants tables;
• started, stopped and reloaded my databases.
• Database security with row level security, search_path, pg_hba.conf and Postgresql.conf.