Tobias Elad Email & Phone Number

Houston, Tx, Us

United States

Research and identify solutions to software and hardware issuesDiagnose and troubleshoot technical issues, including account setup and network configurationAsk customers targeted questions to quickly understand the root of the problemTrack computer system issues through to resolution, within agreed time limitsPerformed installation, configuration and monitoring of Postgres 11, 12 and 14.Upgraded some of our database clusters from Postgres 11 to Postgres 14.Performed migrations from Oracle to AWS RDS using AWS SCT AND DMS.Set up logical replication to replicate tables across different databases.Configured PostgreSQL Streaming Replication for high availability and load balancing with the use of pg_basebackup.Made use of bash scripting to automate and execute various DBA tasks.Responsible for all backup and recovery of databases using pg_dump, pg_restore.Talk clients through a series of actions, either via phone, email or chat, until they’ve solved a technical issueProperly escalate unresolved issues to appropriate internal teams (e.g. software developers)Provide prompt and accurate feedback to customersRefer to internal database or external resources to provide accurate tech solutionsEnsure all issues are properly loggedPrioritize and manage several open issues at one timeFollow up with clients to ensure their IT systems are fully functional after troubleshootingPrepare accurate and timely reportsDocument technical knowledge in the form of notes and manualsMaintain jovial relationships with clients

• Performed installation, configuration and monitoring of Postgres 11, 12 and 14.• Upgraded some of our database clusters from Postgres 11 to Postgres 14.• Performed migrations from Oracle to AWS RDS using AWS SCT AND DMS.• Set up logical replication to replicate tables across different databases.• Configured PostgreSQL Streaming Replication for high availability and load balancing with the use of pg_basebackup.• Maintained database security via unique database roles and object permissions.• Made use of bash scripting to automate and execute various DBA tasks.• Responsible for all backup and recovery of databases using pg_dump, pg_restore.• Tuned autovacuum parameters to ensure up-to-date table statistics and to reclaim space consumed by dead tuples.• Provided security of databases by controlling users access with the help of configuration files such as pg_hba files• Monitored and troubleshooted database replication issues.• Collaborated with application development teams to support and resolve any issues encountered.• Installed and configured Nagios as monitoring tool for disk usage, CPU utilization, list of open files etc. and sending alerts to our teams based on the same.• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.• Installed pg_bouncer for connection pooling for all PostgreSQL databases running on AWS RDS.• Participated in on-call production support on a rotation basis.

Remote

● Installed, configured and maintained existing and new Oracle and Postgres databases.● Reviewed database design and made recommendations such as creating indexes and implementing table partitioning for faster data retrieval.● Established and maintained security and integrity controls with the use of auditing and TDE (Transparent Data Encryption)● Created database links between two databases to access the table data from one local database to remote database.● Used RMAN to perform Oracle database backups (full, incremental and cumulative) and recovery.● Used Oracle DataPump to perform refreshes of data from production to stage and vice versa.● Developed project plans for implementing database environments. Provided input to technical projects and oversaw the tactical aspects of all database related tasks.● Diagnosed, resolved and implemented preventive measures to prevent availability and performance problems of all supported database environments.● Tuned autovacuum parameters to ensure up to date table stats and reclaiming of space consumed by dead tuples.● Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.● monitored Oracle Dataguard replication and PostgreSQL Streaming Replication to ensure effective recovery in case of disaster occurrence.● Used Point-In-Time Recovery to bring back database or tablespace to a specific point in time after scheduled recovery or accidental data loss. ● applied the latest security patches to database, which are provided by PostgreSQL open-source community.● Proactively tuned our databases by monitoring disk space, load average, tablespace growth, index states to prevent performance issues.

Bachelor Of Science - Bs, Cloud Computing

Bachelor Of Science - Bs, Geology/Petroleum Engineering