Database Administrator Team Member

SARAH NANTONGO SEBINA

Cell: 202-***-****) Email: adu5tx@r.postjobfree.com

US Citizen

Executive Profile

Experienced and Goal-Oriented /dedicated and reliable Database administrator with outstanding presentation, communication, cross-cultural team management skills, Servant leader and people's person. High-energy, with a great entrepreneurial approach and ability to relate to all sectors. Expertise

• Ensured data recoverability by implementing systems snapshot, IAM, RDS Replicas, and application-level backup to S3 and configured S3 events to set up automated communication between S3 and other AWS services.

• Improved PostgreSQL and MS SQL databases architecture by staying current on new features.

• Implemented best practices on PostgreSQL and MS SQL Databases and Servers.

• Refreshed data between environments.

• Run and create SQL queries and stored procedures.

• Collaborate with other teams in IT to ensure the security of the DBMS.

• Provided technical documentation for processes and procedures.

• Configured PgBouncer for connection pooling and generated statistical reports using PgBadger.

• Implemented and supported Log Shipping.

• Analyzed log files to find and fix inefficiencies.

• Ensure Minor upgrades/patches and Major upgrades.

• Implemented logical replication using publisher-subscription method.

• Set up streaming replication between master and slave and supported on going replication for Disaster recovery.

Professional Experience

Database administrator

May 2022-January 2023

Alvaria Inc.

• Worked as team member to provide 24x7 on-call production database support.

• Installed, configured, maintained, and troubleshooting MS SQL servers.

• Knowledge of T-SQL and experience writing and optimizing queries for MS SQL databases.

• Experience with database design, including normalization and indexing for performance.

• Backup and recovery procedures for MS SQL databases.

• Experienced with MS SQL replication and high availability configurations such as Always On.

• Knowledge of other database technologies such as MySQL, Oracle, and PostgreSQL. Database administrator

May 2008-2022 Whole

Foods

• Migrated high availability webservers and databases to AWS EC2 and RDS with minimum or no downtime.

• Experience in Installing and Configuring PostgreSQL version 9.6, 10, 11, and 12.

• Experience in implementing disaster recovery solution using PostgreSQL native Streaming Replication.

• Experience in Backup & Recovery including PG dump, setting up WAL archiving for continuous archiving, and third-party tools such pgbackrest, BART (Backup and Recovery Tool), and Barman.

• Performed on demand automatic failover tests using.

• pg_ctl promote command, pg_autofailover, repmgr, Enterprise Failover Manger (EFM).

• Installation and Configuration of various tools such barman, pgpool-II, pgbouncer, pgbackrest repmgr, pgAdmin, pgagent for different PostgreSQL needs.

• Implemented High Level Security idea for database protection by creating database roles, and modifying the host-based authentication file, and SSL Certificate authentication.

• Experience in PostgreSQL cascading replication.

• Experience in Linux scripts to automate database tasks such Vacuuming, database backup, database monitoring etc.

• Experience in SSL Certificate Configuration.

• Collaborate with development, architecture, and release teams, providing architectural design. recommendations, driving standards for effective PostgreSQL transition to production operations.

• Experience in Cloning standby database using repmgr & automatic/manual failover with repmgr.

• Worked as team member to provide 24x7 on-call production database support.

• Upgrade from 9.3 to 9.4, 9.6,10,11,12 and changing environment server to server.

• Experience in migrating on-premises databases to PostgreSQL databases on AWS EC2, RDS

• Worked on AWS PostgreSQL databases for App migration into private cloud.

• Worked on AWS Database Migration Services for migrating data to RDS.

• Supported Main DBA functions in RDS and documenting in confluence page.

• Hands on experience in encrypting data using AWS Key Management Service (KMS).

• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.

• Involved in 24x7 support for mission critical applications.

• Configured and installed, involved using AWS services such as EC2, S3, RDS CloudWatch. Architecting new DBA solutions in AWS.

• Worked on integrating KMS to AWS CloudTrail to monitor logs used by keys for compliance Databases. Safe

Auto

Ohio

2000-May 2013

Document Analyst

• Maintained program records, including employee databases, employees' hours and expenses, client information records, and a myriad of other requests.

• Hired, supervised, and managed 60+ employees, and held weekly staff meetings and quarterly evaluations to ensure each department stayed within guidelines of company.

• Ensured weekly transportation logs were accurately completed.

• Effectively managed vehicle fleet by scheduling and maintaining logs on all agency owned vehicles with routine oil changes and checkups.

• Implemented databases to automate repetitive processes using client data to better manage workflows across our environments.

• Created and leveraged safety modules and procedures for security and client safety.

• Operated computer and standard office equipment

• Responsible for trouble shooting computers.

Education

Bachelors in Health Education

Contact this candidate