TERENCE TITA

PostgreSQL Database Administrator

adjm0f@r.postjobfree.com 240-***-****

I am a proactive PostgreSQL database administrator, detailed oriented, team player with four (4) years of experience working on different PostgreSQL versions (9,10 and 11). existing on different platforms such as Linux. Unix and Windows. A good experience in setting up servers from scratch, performance tuning, security, shell scripting, backup and recovery, vacuuming, reindexing, replication, migration and refreshes. Managing Applications and databases both on premises and cloud.

I also have 2 years comprehensive experience in AWS Solution Architect. I have knowledge in various AWS services like EC2, S3, EBS, Glaciers, VPC(Nat, peering, NACL, VPN), IAM, Cloud Watch, Cloud trail, Cloud Front, RDS, DMS, SCT, DynamoDB, RedshiftDB, ElasticCache, Auto Scaling, ELB, Route 53, Cloud Formation, SNS, SQS, SWF, API Gateway, Lambda

GRAINGER BUSINESSES – LAKE FOREST, IL

Feb 2019 – Present

PostgreSQL Database Administrator/ AWS Solution Architect

Responsibilities:

Installing and configuring new servers as per need by developers or customers.

Monitoring environments using monitoring tools, custom scripts and other supporting tools like PgBadger.

Cloning the Development and TEST environments with production data as per customer's request.

Configuring third client software PgAdmin-IV to access the database server.

Configuring the backup jobs on customer system.

Experienced in performing Patch, and Upgrades.

Develop and enhance scripts to automate and execute various DBA tasks.

Performed streaming replication Master to multiple slaves and cascading.

Logical replication of single objects and replication slots of high availability and DR

Assist engineering team and developers in the design of appropriate DB Schema and indexing strategy for performance and scalability, Materialized views and Stored Procedures

Helped supporting a mission-critical database environment with 24x7 On-Call Support including weekends.

Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.

Planning, deploying RDBMS Tuning and performing other weekend maintenance activities as a part of On Call support.

Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgresql production and development databases.

Implement solutions for backup/restore using pg_basebackup and pg backrest, management/monitoring and perform upgrades and patching.

Help scope and develop technical proposals to achieve customer needs.

Implemented and oversee PostgreSQL networking High Availability using hba.conf and connection pooling with PgBouncer.

Documented every step in my environment on projects to ease the work of team members

Experienced in testing database security and enterprise policy guidelines according to established best practices.

Created user accounts, granted and revoked permissions based on needs.

Hands-on experience and good knowledge of AWS services: EC2, S3, VPC Endpoints, Subnetting (Private and Public), Route53, ELB, Auto scaling, SQS, SNS, IAM, DynamoDB, Cloud Front, Cloud Formation, Cloud Watch, Cloud Trail, Storage Gateway, internet Gateway.

Created AWS S3 buckets, Managed cloud trail logs and objects within each bucket.

Involved in 24x7 support rotation for Production, Test and Development Databases.

Worked with Custom AMI's, created AMI tags modified AMI permissions.

Setup and configure Database using AWS instances and RDS with PostgreSQL, fully monitored.

Take snapshots of databases and using AMI to restore these snapshots

Responsible for allocating, releasing, associating, and disassociating elastic IP addresses.

Created Security Groups, configuring Inbound /Outbound rules, creating and importing Key Pairs.

Created and managed IAM user accounts and role based policies for access to AWS services.

Implemented and maintained monitors, alarms, and notifications for EC2 instances using Cloud Watch and SNS

Created, configured and ensured connection to RDS databases, Elasticache, Dynamo DB, Amazon Redshift databases

Plan, build and configure network infrastructure within VPC with public and private subnets, configure routing tables, security group and internet gateway.

Provision AWS resources using management console as well as Command Line Interface.

Implement and maintain the monitoring and alerting of production and corporate servers/storage using Cloud Watch

Configured NACL, Security Groups to secure the application and VPC network depending on access parameters provided and conditions.

Migrated databases and workloads from on premise servers to the cloud using tools such as AWS SCT, DMS, and AWS server migration service

DIALOGTECH - Chicago, IL

Aug 2017 – Jan 2019

PostgreSQL Database Administrator/ AWS Solution Architect

Responsibilities:

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 9.3 to 12.

Build, configure, and manage PostgreSQL server databases through multiple environments, from development to mission-critical production systems for various projects and tasks.

Set up and controlled user profiles and access levels for each database segment to protect important data.

Evaluating, configuring, and optimizing databases to meet user requirements

Manage ongoing database activities, such as stored procedures, triggers, backups/restore.

Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.

Independently analyze, solve and correct issues in real time, providing problem resolution end-to-end for the various projects.

Refine and automate regular processes, track issues, and document changes.

Collaborate with developers for complex query tuning and schema refinement.

Experience with Performance Tuning and Optimization.

Develop/edit shell scripts and processes for data integration and maintenance.

Performed regular maintenance on databases with scheduled crontab vacuum and manual vacuum full when required

Experience with backups, restores and recovery models.

Troubleshoot and correct internal and external end-user technical issues encountered.

Assist in migration to AWS using SCT and DMS

Hands-on experience and good knowledge of AWS services: EC2, S3, VPC Endpoints, Subnetting (Private and Public), Route53, ELB, Auto scaling, SQS, SNS, IAM, DynamoDB, Cloud Front, Cloud Formation, Cloud Watch, Cloud Trail, Storage Gateway, internet Gateway.

Created AWS S3 buckets, Managed cloud trail logs and objects within each bucket.

Involved in 24x7 support rotation for Production, Test and Development Databases.

Worked with Custom AMI's, created AMI tags modified AMI permissions.

Setup and configure Database using AWS instances and RDS with PostgreSQL, fully monitored.

Take snapshots of databases and using AMI to restore these snapshots

Responsible for allocating, releasing, associating, and disassociating elastic IP addresses.

Created Security Groups, configuring Inbound /Outbound rules, creating and importing Key Pairs.

Created and managed IAM user accounts and role based policies for access to AWS services.

Implemented and maintained monitors, alarms, and notifications for EC2 instances using Cloud Watch and SNS

Created, configured and ensured connection to RDS databases, Elasticache, Dynamo DB, Amazon Redshift databases

Plan, build and configure network infrastructure within VPC with public and private subnets, configure routing tables, security group and internet gateway.

Provision AWS resources using management console as well as Command Line Interface.

Implement and maintain the monitoring and alerting of production and corporate servers/storage using Cloud Watch

Configured NACL, Security Groups to secure the application and VPC network depending on access parameters provided and conditions.

Migrated databases and workloads from on premise servers to the cloud using tools such as AWS SCT, DMS, and AWS server migration service

NEWEDGE - Chicago, IL

Feb 2016 – July 2017

PostgreSQL Database Administrator

Responsibilities:

Installed, configured, and maintained PostgreSQL 9.6, and 10 on Linux and Upgraded from PostgreSQL 9.6.20 to 9.6.21, 9.5 to 10.

Configured PostgreSQL servers from scratch on both default and customized mount points.

Used PGTUNE to generate ideal parameter settings to set up my parameter file optimally.

Built servers from scratch both on default and cutomized mount points

Database monitoring and perfomance tuning databases

Frequent backups through scripts from production environment to development and test environment.

Patch and upgrade postgreSQL 9.6

Upgrade postgreSQL database 9.6 to 10 and 10 to 11

Scheduling and maintaining level 0 and level 1 backups.

Refresh Dev and Test environments with data from production.

Developed/edit PL/SQL packages, DML, DDL, tables, Stored Procedures, functions, cursors, triggers and UNIX Shell scripts.

Involve in fine tuning auto-vacuum and executing full vacuuming on bloated tables

Re-indexing bloated table indexes

Updating the statistics to the query planner for quick query planning.

Set up failovers and pg_promote the replica and pg_rewind the failed master server.

Building servers from scractch and populating them with pgbench, carry out backups and recovery before handing it over to the Dev team.

Operating Systems

(RHEL) CentOS 7&8, Ubuntu, MS Windows, VMware, Unix (Solaris 10, HP-UX, AIX)

Databases

PostgreSQL, RDS, DynamoDB, Amazon Redshift, ElasticCache

Database and Cloud Tools

PGTUNE, pgAdmin4, Pgbackrest, Pgbouncer, Pgrepack, MobaXterm, Putty, WinSCP, Psql, AWS CLI, Workbench/J, Telnet, AWS DMS, AWS SCT, Elastic Balancer, Apache2, JSON

UNIVERSITY OF BUEA Cameroon

-Bachelors of Science in Management, graduated with honors 2011

-PostgreSQL CERTIFIED ASSOCIATE

-AWS Architect Certified Associate

-SQL Fundamental 12c

Work Experience

Education

Contact this candidate