SUMMARY:

• Five plus years of experience in Information Technology as a Database Administrator in Oracle, MySQL, MariaDB, PostgreSQL, Systems Analysis, Design, Development and Knowledge of MongoDB. Database Administrator with experience designing, installing, creating databases, configuring datafiles, multiplexing control and redo log . A self - motivated results-driven and reliable team player with strong technical skills with an established reputation for effectively working with diverse group of people and adaptability to changing environments.
• Professional and motivated, having over 5 years of DBA work experience in the software industry with Oracle 10/11g and over 3 years with MYSQL, MariaDB and PostgreSQL Databases
• Experience in Database Administration, development, design, maintenance and production support of relational databases, business applications, new server setup, Oracle, MySQL, MariaDB and PostgreSQL database Server installation, upgrade, migration.
• Sound Knowledge of MySQL Database versions and development.
• Outstanding ability to prepare Data backup plans and test disaster recovery activities.
• Strong Oracle, MySQL, MariaDB and PostgreSQL database skills and brief general system administration skills on UNIX, Linux and Windows environment.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Experience with MySQL backup and recovery using manual and enterprise backup (MEB)
• Hands-on experience in administration of MySQL databases.
• Solid understanding of code versioning tools such as GIT.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance.
• PostgreSQL and MariaDB installation, configuration, migration, upgrades and patches
• Huge experience in MySQL replication setup and configuration.
• Expertise in Oracle RAC and ASM installation and administration.
• Experience in Oracle Data Guard configuration and administration to ensure high availability, data protection, and disaster recovery.
• Good analytical, problem-solving skills, verbal and written communication skills.
• Excellent in managing priorities in a fast-changing environment.

TECHNICAL SKILLS:

Databases: Oracle 10g / 11g, MYSQL, PostgreSQL, Mariadb databases

Operating Systems: UNIX, Linux, Windows

Programming Languages: SQL, PL/SQL, Java, python

Script: Having knowledge of UNIX\Linux shell scriptDatabase Tools: Oracle SQL Developer, OEM, Toad, Sql Loader, Rman, MEM, PhpPgAdmin, percona xtrabackup, mysqldump, pg dump, mydumper, GIT, percona tool kit.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Silver Spring, MD

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of MySQL and PostgreSQL databases on Linux and Windows OS
• Helped setup MySQL replication (Master-slave and Master-Master)
• Performed SQL tuning using EXPLAIN plan, tuning configuration parameters for optimal database performance.
• PostgreSQL and MariaDB installation, configuration, migration, upgrades and patches
• Upgraded MariaDB from version 10.0. 12 to 10 .0.24
• Suggested improvements for performance by query optimization.
• Working with development teams for database related changes and requests.
• Setup, troubleshoot and fix backups and restore data using tools such as mysqldump, Mydumper, MySQL enterprise backup and percona Xtrabackup.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Partitioned 2TB tables to improve query performance
• Support third party appliactions such as PhpPgAdmin to monitor and administer database operations for PostgreSQL
• Space management and capacity planning.
• Backup of PostgreSQL databases using pg dump and restoring from backup.
• Disaster recovery analysis and testing on both MySQL and PostgreSQL databases.
• Installing and monitoring MySQL and PostgreSQL databases using standard monitoring tools like Nagios.
• Designing database structures, creating indexes, views and partitioning tables for better performance.

Database Administrator

Confidential, Columbia, MD

Responsibilities:

• Planning, installation, configuration, management and troubleshooting of Oracle 11g databases on Linux and Windows OS
• Setup, troubleshoot and fix backups and restore data using tools such as Mydumper, MySQL enterprise backup and percona Xtrabackup.
• Implementation of MySQL stored procedures, triggers and views.
• Helped setup MySQL replication (Master-slave and Master-Master)
• Performed SQL tuning using EXPLAIN plan, tuning configuration parameters for optimal database performance.
• Maintained database concurrency by setting proper locks for queries, solved table locking issues, concurrent inserts and external locking issues.
• Monitoring for 24x7 Production environment, resolution of severe performance and user access issues
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
• Backing up systems using Oracle Enterprise backup, mysqldump, mydumper and Percona xtrabackup.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity
• Troubleshooting and resolving various Oracle connectivity problems.
• Network troubleshooting and administrative support for the development staff.
• Installation and management of Oracle database using database control
• Creating and managing documentation on the configuration and support of the Oracle databases
• Performing bulk load into the database using SQL Loader
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Using standard and fine grain database auditing for data security
• Administering database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights
• Provide database administration on production, testing and development database servers.
• Regular Monitoring of the Alert log Files and trace files on a Day to Day Basis.
• Identifying and removing Fragmentation, row migration/chaining of database objects.
• Analyzing the Tables and Indexes on performance base regularly
• Monitoring Tablespaces and Datafiles utilization.
• Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.
• Multiplexing control files and redo log files
• Performing physical backups using RMAN utility.
• Performing Complete Media Recovery of Database depending on the nature of failure.
• Configured and implemented the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
• Performed flashback on database, flashback drop, flashback table.
• Extensively using DATAPUMP and Export /Import utilities for logical backups.
• Performing database cloning using RMAN.
• Monitoring the user sessions and taking the appropriate action to kill the inactive sessions
• Creating and rebuilding indexes as necessary.
• Performed various performance goal oriented database tuning.
• Used explain plan, AWR, ADDM, SNAPPER and various Oracle Advisors to tune the database.
• Performed instance tuning, memory tuning, query tuning and complete database tuning.
• Applied quarterly CPU patches to different version of databases.
• Upgraded Oracle 10g database to 11g.
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
• Part of the team that installed, configured and managed 11gR2 (RAC) on ASM storage
• Managed RAC databases using CRSCTL, SRVCTL and grid control
• Part of the team that configured and setup Oracle 11gR2 Data Guard.
• Managed Data Guard using Data Guard broker.
• Troubleshoot and resolved log gap in Data Guard Configuration.

Database Administrator

Confidential, Laurel, MD

Responsibilities:

• Managing Schema Objects
• . Installation and Management of Oracle Database using database configuration assistant
• Creating Tables, indexes, Tablespaces and views.
• . MySQL query optimization and performance tuning and troubleshooting.
• . MySQL administration on production environment - installation, tuning, backups, resource optimization and distribution, Innodb and MyISAM storage engines, replication in large-scale environments.
• 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.
• . Backing up systems using Oracle Enterprise backup and mysqldump
• 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