SUMMARY

• Database Administrator looking for a position that will enable me adequately to use my database and Linux administration skills.
• Seeking an opportunity to apply MySQL and PostgreSQL knowledge in a demanding support and production environment while working competently to enable timely completion of projects to meet company objectives.
• I am committed and efficient team player with ability to communicate effectively at all levels.
• 6 Years MySQL Database Administrator
• 5 Years PostgreSQL/EnterpriseDB Administrator
• 6 Years working with Linux Systems
• 4 Years working with databases in AWS

TECHNICAL SKILLS

Linux Operating Systems: RHEL Systems and Centos (5,6,7), Ubuntu (12 14), SUSE (10,11)

Window Operating Systems: Window 2003,2008,2012 and Window XP, 7, 8, 10

Database Servers: MYSQL (5.5, 5.6,5.7,8), MariaDB 10.1,10.2,10.3 and Percona Server (5.5, 5.6 and 5.7) PostgreSQL 9.4, 9.5, 9.6, 10.4

MYSQL Replication: Master - Slave and Master- Master Replication

MYSQL Clustering: Galera Cluster, Percona XtraDB cluster, InnoDB Cluster, NDB Cluster

MYSQL Replication Managers: MYSQL Utilities, MySQL High Availability (MHA)

Monitoring software: Zabbix, Nagios, Percona Monitoring and Management (PMM) MySQL Enterprise Monitor, Collectd.

PostgreSQL Replication: Setup a Streaming Replication for High Availability and Logical Replication.

PostgreSQL Backups Tools: pg dump, pg restore, pg dumpall, pg basebackup

PROFESSIONAL EXPERIENCE

MySQL/PostgreSQL Database Administrator

Confidential, MN

Responsibilities:

• Installing, Configuring and Managing MySQL/Percona Server (5.5, 5.6,5.7) and MariaDB (10.3,) on Linux Redhat/Centos 6,7 platforms.
• Performing tests and evaluations regularly to ensure data security, privacy and integrity.
• Upgrading various version MySQL including 5.1, 5.5, 5.6 and 5.7.
• Configuring MySQL replication for high availability. Setup and configure MySQL master-slave, master-master replication
• Performing occasional database design modifications and perform online schema changes using tools such as Percona toolkit and Openark kit.
• Optimizing databases and queries in MySQL server environment
• Retrieving and updating data from MySQL database server.
• Implementing and maintaining database security (create and maintain users and assigning privileges.
• Server management, query optimization, database management and monitoring.
• Providing daily operational activities such as backups/restores, application troubleshooting.
• Setup database encryption in MySQL/MariaDB. Configuring encryption for data in transit by enabling SSL and for data at rest using encryption keys.
• Designing, configuring, managing, and maintaining the deployment and operations in Amazon EC2, RDS, VPC, S3, EBS, ELB, CloudWatch, CloudFormation, and other AWS resources.
• Enabling Multi-AZ and deploying a read replica with AWS RDS.
• Performing AWS EC2 AMI and EBS backups and restores.
• Establish metrics, monitoring key metrics of database and various AWS services like AWS EC2, AWS RDS, Elastic load balancer, Elastic Block Store (EBS) and many others by using Amazon CloudWatch.
• Managing full AWS lifecycle, provisioning S3 data management with versioning and lifecycle rules, automation and security.
• Creating a disaster recovery solution for my organization using CloudFormation
• Restoring an RDS Instance to a point in time using snapshots
• Building a three tier Network VPC in AWS.
• Creating and testing a peering connection with a private VPC.
• Monitoring AWS databases and resources in EC2 and RDS environments using custom CloudWatch dashboards.
• Installing, Configuring and Managing PostgreSQL (9.5, 9.6,10.4) on Linux Redhat/Centos 6,7 platforms.
• Performing backup and recovery of PostgreSQL databases with pg dump, pg restore, pg dumpall, File system level Backup, restore an offline backup, Continuous Archiving, Base backup using pg basebackup tool and Point-in-time recovery.
• Setup Streaming and logical Replication in PostgreSQL databases.
• Performing PostgreSQL Privileges & User Management: Creating Users, granting privileges, creating views, sequences, schema management and updating statistics of a databases.
• Analyzing Database logs for errors and performing routine table and index maintenance tasks. Resolving table and index level database corruption.
• Performing Database maintenance task, Data Defragmentation and Routine Vacuuming, Vacuum, Vacuum Full, Vacuumdb Utility, Preventing Transaction ID Wraparound Failures, Autovacuuming, Routine Reindexing.
• Performance tuning of PostgreSQL Server.

MySQL/PostgreSQL Administrator

Confidential, IA

Responsibilities:

• Installed, Configured and Managed MySQL/Percona Server (5.5, 5.6,5.7) and MariaDB on Linux RHEL platforms and window environment
• Performed regular database maintenance task: defragmentation, upgrades and storage management
• Created backup/recovery for replication, Cluster failover and disaster recovery.
• Responsible for Database Security and preventing Data loss.
• Performed backup and recovery of databases.
• Performed MySQL upgrades and testing on Redhat and Centos servers.
• Optimized databases and queries in MySQL server environment
• Provided technical input on the setup and configuration of all databases servers.
• Performed maintenance on MySQL databases, running mysqlcheck, analyze and optimize as needed.
• Extensive performance turning for MySQL servers.
• Installed and configured MySQL in AWS EC2 and RDS.
• Monitored AWS resources and MySQL databases in AWS EC2 and RDS.
• Performed backups and restores of AWS EC2 and RDS instances.
• Installed, configured and optimized PostgreSQL cluster.
• Performed backup and recovery of all PostgreSQL databases.
• Performed schema management and database sizing.
• Installed, Configured and Managed PostgreSQL (9.4, 9.5) on Linux Redhat/Centos 6,7. platforms.
• Performed Monitoring and Troubleshooting of PostgreSQL databases.
• Performed PostgreSQL Privileges & User Management: Creating Users, granting privileges, creating views, sequences, schema management and updating statistics of a databases.
• Resolved PostgreSQL database performance issues.

JUNIOR LINUX ADMINSTRATOR

Confidential, Minneapolis, MN

Responsibilities:

• Provided user access and authentication: Creating user accounts and groups.
• Offered administrative utilities: Add users, manage disks, monitor network, Install software.
• Secured and Managed computer.
• Performed file system maintenance and disk space management.
• Troubleshooting hardware and software problems, and taking appropriate actions with IT staff in performing complex testing, server recovery, support, and troubleshooting functions
• Configured Networking, created cron tasks, Setting the default run level, and installed RHEL Systems.
• Utilized Customer service skills while acting as a technical resource to internal departments, and system users
• Education