MySQL / PostgreSQL Database Administrator Resume Raleigh, NC - Hire IT People

SUMMARY

I am a highly skilled IT professional with over 7 years of professional database experience providing mission critical database solutions to clients. Background experience involves working with technical teams (Including offshore teams) and clients to determine data design and requirements, data storage, performance analysis, data integrity, high availability, security in both transactional or data warehouse environments. I have experience working in the Cloud Environment mainly AWS. I have not only helped various companies migrate their data to AWS but have also managed their data in AWS. I am also skilled using AWS Redshift for data warehouse purposes.

PROFESSIONAL EXPERIENCE

MySQL / PostgreSQL Database Administrator

New Penn Financial - Raleigh, NC

Responsibilities:

Pioneered the development and implementation of both MySQL and PostgreSQL databases.
Development, test and production databases DBA support and everyday maintenance.
Installed and Configured MySQL databases with proven best practice configurations. Comfortable with my.cnf parameter file customizations.
Changed Storage Engine from MyISAM to INNODB storage engine to increase performance and betterment of integrity constraints.
Performed 5.5 to 5.6 upgrade and patching of MySQL database software.
Optimizing databases and queries in MySQL Server Environment
Strategize Backup for maximum uptime and efficiency. Using tools like xtrabackup, mydumpyer, mysqldump etc.
Performed migration of MySQL from Rackspace server to AWS RDS
Track Issues and troubleshoot as needed in a timely manner. Using jira ticketing system and automated alert systems like MONyog, Zabbix, Sensu and Grafana.
Replication & Recovery organization's best practices. - Master-Slave, Master-Master. Clone and set up new environments.
Performed regular database maintenance task: defragmentation, upgrades and storage management.

MySQL Database Consultant

Confidential -Charlotte, NC

Responsibilities:

Work with various Clients in maintaining and managing their Databases from Oracle, MySQL, PostgreSQL and Maria DB
Performed both major and minor upgrades of MySQL for various clients.
Create Action Plans for various projects including upgrades, patching, Backups e.t.c
Knowledge and usage of other Replicator tools like Tungsten to manage Replication for High Availability Environments.
Performed various minor upgrades for Clients.
Identified and fixed various broken Replications in MySQL
Performed failovers using MHA for various Clients.
Performed Schema Changes using percona tool kit like pt-online-schema change
Created a plan to check for Data consistency across all clusters using pt-table-checksum
Upgraded Mysql from 5.5 to 5.7 for various clients.
Configured all users to use ssl for extra added layer of security.
Working with development and Application teams for Database related changes.
Support third party applications such as PhpPgAdmin, Zabbix, Grafana, Stack driver to monitor and administer Database Operations for both MySQL and PostgreSQL Databases.
Upgraded MariaDB from Version 10.0.12 to 10.0.24 for a Client.
Maintained database concurrency by setting proper locks for queries, solved table locking issues, concurrent inserts and external locking issues.
Performed MySQL Migrations from one server to another for various Clients.
Installed and Configured MySQL for various Clients.

Database Administrator

Confidential - Columbia, MD

Responsibilities:

Database Administrator (Junior)

Confidential

Responsibilities:

Managing Schema Objects
Installation and Management of Oracle Database using database configuration assistant Creating Tables, indexes, Tablespaces and views.
Managing Database security using traditional audit statements and fine grain auditing.
Granting and Revoking Privileges as required by the Lead Database Administrator.
Solving various connectivity problems involving TNS and Listener Documenting database structure, changes, problems, issues for future reference
Backing up database, tablespaces and schemas using RMAN
Analyzing the Tables and Indexes on performance base regularly.
Monitoring of the Alert Log File.
Configuring Various RMAN parameters as required by the Lead Database Administrator.
Monitoring the user sessions and taking the appropriate action to kill the inactive sessions
Creating and rebuilding indexes as necessary