Aws Security

JUVETTE MUNJI

PROFESSIONAL SUMMARY

Professional PostgreSQL Database Administrator performing core DBA duties including all the basic database administration skills of physical structure, SQL and SQL applications, database administration, web connectivity, and overall architecture and database analysis on windows, Linux, and Unix environment. Strong interpersonal and analytical skills. Collaborate, accountable and a strong detail-oriented team player.

WORK HISTORY

POSTGRES DBA, 09/2017 – 09/2020

AT & T / Chantilly, VA

• Install and configure both enterprise edition of postgres and open source Postgres.

• Create a postgres database instance on AWS.

• Configure the group parameter on amazon RDS.

• Manage IP traffic using a security group.

• Create an EC2 instance on AWS.

• Create and manage Aurora PostgreSQL databases on AWS.

• Online migration of postgres databases to AWS using amazon DMS.

• Migrate EC2 instances to RDS and Amazon Aurora postgres.

• Configure PgAdmin to monitor PostgreSQL databases instance on AWS.

• Test, monitor, upgrade, and tune new and existing PostgreSQL databases on linux and windows.

• Create databases, schemas, tables, users, tablespaces, and views

• Install and configure connection pooling tool like pgbouncer.

• Configure streaming, logical, and cascading replication for high availability (HA).

• Installed and setup repmgr for high availability solutions with a witness for automatic failover.

• Install and configure postgres monitoring tools like PEM and PgAdmin.

• Identify, troubleshoot and tune active database system hardware issues for better performance, optimized queries by creating indexes whenever its necessary, reindexing for unused indexes.

• Performed logical and physical Backup of Databases using Pgdump, Pgdumpall, pgbasebackup and used pgbackrest for scheduled weekly and daily backups.

• Test backups to confirm if there are restorable to assure data availability.

• Implement and test disaster recovery strategies and practices of the production databases.

• Ability to work under pressure, thrive in a fast-paced and prioritize deadline.

• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.

• Upgrade postgres database from 11 to 12 using pgdumpall, logical replication and pgupgrade utility.

Address : 8503 glenmont dr,

Fredericksburg, VA 22407

Phone : 915-***-****

Email : adhwhc@r.postjobfree.com

SKILLS

Problem-solving skills

Detail oriented

Communication skills

Analytical skills

Organization

Troubleshoot

Performance tuning and optimization

• Implement data models, database designs, data access, table maintenance and code changes together with our development team.

• Provide 24/7 production support to the team on critical events and situations outside normal work hours.

• Work together with development and operation teams to tune production queries for optimal performance.

• Carryout table partitioning to increase performance.

• Configuring log analyzation tools like pgbadger.

• Automate the configuration management of database and big data systems.

• Setup maintenance plan vacuuming, database sizing, maintaining least privileges, and logging.

• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples

• Run EXPLAIN and ANALYZE to identify performance issues.

• Prepares and/or reviews activity, progress, and performance reports

• Bash shell scripting to automate routine backup and recovery operations.

• Carryout table partitioning to increase performance.

• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios.

• Maintain custom vacuum strategies at table and database level

• Monitoring the bloat report on every table and performing maintenance with minimal downtime.

• Update security patches to enterprise edition (EDB) of postgres

• Studied and stayed current on features and functionality of PostgreSQL. POSTGRES DBA, 02/2014 – 07/2017

Bank of America / Richmond, VA

.

• Grant security permission to users on databases,schemas and tables.

• Detect and diagnosed system problems like CPU, memory, disk space, I/O and other resource contention issues

• Configure, assign privileges to users, auditing to ensure security and integrity of the databases.

• Perform backups and Point in time recovery using a tool like pgbackrest.

• Moved databases from Production to Testing and Testing to Production with pgdump.

• Creating Database Links from Testing to Production databases.

• Used ETL method to extract databases from different database sources and load to data warehouse for analysis and access data whenever is needed with talent tool.

• Performed routine tasks like monitoring the database for Index, partitioning Memory and I/O utilization.

• Monitoring the production PostgreSQL alert logs for database errors.

• Check Alert Log errors and make necessary actions to rectify them.

• Limiting the memory space and granting the necessary roles.

• Controlled client connectivity using pg_hba.conf files.

• Upgraded from 9.3 to 9.4, 9.6,10 and changing environmental variables.

• Creating new clusters and upgrade from one cluster to another.

• Installed and working with tools like Putty, Mobaxterm, Barman, WinSCP.

• Implement disaster recovery solutions by setting up a delayed standby for Point in time recovery strategy.

• Managing tablespaces, data files, redo logs and database objects.

• monitor PostgreSQL Performance load testing on lower environment before moving databases to production servers.

• Creation of Clone Database for Development/Testing Environments.

• Worked as team member to provide 24x7 on-call production database support to ensure a proactive problem recognition and resolution.

EDUCATION

Bsc biochemistry university of buea Cameroon 2010-2013 CERTIFICATIONS

.

Contact this candidate