MySQL/Oracle/Mongo/PostgreSQL DBA Resume Sterling, Virginia - Hire IT People

SUMMARY

An accomplished database professional with over 5 years of experience as DBA. Highly disciplined, self - motivated individual specializing in Oracle/MySQL/Mongo database administration.
Proven leadership skills, customer and team oriented with good communication skills and problem resolution/troubleshooting capabilities.

TECHNICAL SKILLS

Software: MySQL (5.x), Oracle (10g,11g), Mongo(2.x), PostgreSQL (9.1.x, 9.2.x)

Tools and command line utilities: Percona toolkit, mysqldump, Recovery Manager (RMAN), Data Guard, Enterprise Manager, Automated Storage Management (ASM), RAC, data pump, AWR, explain plan, Pgadmin.

Enterprise Monitoring systems: Nagios, Netcool.

OS: Linux, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Sterling, Virginia

MySQL/Oracle/Mongo/PostgreSQL DBA

Install, configure, upgrade, migrate (as necessary) and maintain several MySQL instances.
Setup MySQL master-slave and multi-master replication for high availability.
Set up xtrabackup, LVM backups for MySQL servers. Restore as needed.
Expertise in database migration from MyISAM to Innodb storage engine to increase performance.
Upgraded several MySQL servers ranging from versions 4.0 to 5.1 over to 5.5, 5.6.
Set up scripts to refresh Dev/QA/Staging MySQL database from production dumps.
Used Percona toolkit for several day to day activities. For example, pt-online-schema-change to change table structures with no impact to application and optimizing tables without blocking reads/writes. pt-query-digest to identify slow queries and tune as needed. Pt-table-checksum to make sure data is in sync with master.
Troubleshoot replication, corruption issues and fix as appropriate.
Capacity planning for MySQL/Oracle databases. Lead effort of reducing footprint by identifying and decommissioning/consolidating/migrating over 1000 database servers and hosts depending on usage. Power savings alone for this effort so far is ~500K in 2012.
Worked on cross platform Oracle database migration from Windows to Linux, Sybase database migration to MySQL.
Installation, configuration and maintenance of Oracle instances.
Upgrade several Oracle 10g instances to 11g. Apply PSUs and one-off patches.
Implement physical standby databases using data guard for high availability and transparent application failover.
Implement snapshot standby for testing purpose before upgrading production to 11g. Any performance issues or application changes are uncovered so that these are not a problem in production.
Set up RMAN backups appropriately and restore as needed.
Install, configure and support Mongo replicaset. Setup LVM backups, mongodumps for backups.
Set up monitoring by defining optimal thresholds for all database platforms.
Track usage patterns and projected future growth for capacity planning of databases.
Troubleshoot and resolve issues with database connectivity, replication and performance.
Install database changes like tables, indexes based on requirements. Suggest best practices or alternatives where appropriate.
Writing documentation for each of the systems that are supported and posting to the team Wiki pages.
Monitoring database security, password management, applying patches to ensure PCI/SOX regulatory compliance.
Provide on call support.

Confidential,Atlanta, Georgia

Oracle DBA

Maintained a two node RAC for billing.
Responsible for creating database objects based on project requirements.
Maintaining development, test, and production databases.
Worked on database sizing, performance monitoring and tuning.
Enforce and maintain constraints to ensure integrity of database.
Analysis on database design and functionality.
Worked on creating and maintaining database users and roles.
Implement and maintain database security by assigning privileges accordingly.
Responsible for upgrading and patching oracle.
Worked extensively on SQL, PL/SQL, and Shell Scripting.
Optimizing SQL statements using TKPROF, EXPLAIN PLAN, and STATSPACK.
Performed Backup (hot, cold, incremental, tablespace backups) and Recovery using RMAN.
Created partitions & indexes for better performance.
Troubleshoot problems related to database, application and development tools.
Responsible for setting up scheduled & automated back-end jobs.
Worked on testing Backup and Recovery strategies.
Used external tables to load data from flat files to database.
Performing all daily maintenance tasks. Interacting with Oracle customer support as and when required.
24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

We provide IT Staff Augmentation Services!

Mysql/oracle/mongo/postgresql Dba Resume

Sterling, VirginiA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship