We provide IT Staff Augmentation Services!

Oracle Dba/mysql Resume

5.00/5 (Submit Your Rating)

Stamford, CT

SUMMARY

  • Over 4 + years of DBA and Development work experience in the software industry with MySQL(4.x,5,x) and SQL Server 2000/2005.
  • Strong MySql and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
  • Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins,Views, Cursors and SQL on databases: MySQL, Oracle10g, OMWB tool.
  • Expertise in snapshot, import/export, db optimization with the help of explain plan.
  • Automatic data retrieval and research based on my client’s input into a scheduler I’ve created, automated scripts do research on given legal APIs to identify possible legal matters related to the data.
  • Database administrator with hands on experience in 24x7 production support, implementation, Configuration, Upgrades, Replication, Performance Tuning/ Optimization/ AWR, ADDM, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance, Database Migration, ASM.

PROFESSIONAL EXPERIENCE

Confidential - Stamford,CT

Oracle DBA/MySQL

Responsibilities:

  • Upgrade Oracle 11gR1 to 11gR2 using DBUA,
  • Oracle Database performance tuning and SQL tuning using SQL Trace, AWR, ADDM, and Explain Plan
  • Analyzed SQL statements, worked on reorganization of tables, and rebuilt indexes to enhance performance
  • Performed tuning of shared pool, library cache, and data dictionary cache
  • Configured ASM and constructed workarounds for ASM metadata corruption and configured user log on load balancing as well as failover on RAC database,
  • Responsible for applying all Oracle security patches, security patches via Metalink, CPU patches, and release patches on all Oracle 11g RAC databases
  • Management of table space growth, monitoring data file additions, as well as extent growth
  • Creating and configuring new test databases for production and development
  • Created users while granting them appropriate privileges and roles
  • Performing hot, cold, tablespace level backups
  • Implemented database auditing for data security, and remediate high-risk violations in production environment
  • Implement automated backups via RMAN
  • Developed hot, cold, and logical back scripts to automate backup procedures Environment
  • Provide 24x7 Remote/ on call production supports

Environment: Oracle 11gr2, Oracle Enterprise Linux 5.2/6.4, RMAN, RAC, ASM, OEM, Data pump, SQL*Loader, Toad, and SQL developer, MySQL server 7.0

Confidential - Pleasonton,CA

MySQL Database Administrator

Responsibilities:

  • Upgraded MySQL persona server from 5.5 to 5.6 on test and production servers
  • Managed 3-Terabyte database hosted on Amazon AWS and Firehost in integration, UAT, QA, Development and Production environment.
  • Managed MySQL instances and backups on AWS
  • Participated in DR and Capacity Planning activities with systems engineer and systems architect.
  • Managing high availability and optimal performance of the MySQL databases
  • Find existing database areas for improvement (remapping of tablespaces, adding indexes, etc)
  • Managing schema and user accounts and database objects including permissions and grants
  • Monitor and maintain the database backups, diagnose and resolve database backup failures.
  • Responsible for troubleshooting and problem solving of MySQL Database.
  • Enforce security standards and controls to ensure the integrity and security of the data resources.
  • Responsible for implementation and release of database changes according to Change management system
  • Integrate configurations and applications,Managed Database security and Purged Transaction logs

Confidential 

MySQL/Oracle Database Administrator

Responsibilities:

  • Created, implemented and managed custom databases on Linux and windows platforms.
  • Worked in a database environment hosting tomcat/weblogic application servers
  • Provided MySQL and Oracle database administrative support to various user groups (application developers, data managers etc); created and maintained Oracle database objects (schemas, tables, indexes etc).
  • Analyzed and tuned voluminous SQL code.
  • Designed, developed and implemented technology-based systems for a wide range of applications for different user groups.
  • Performed capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance.
  • Performed backup and recovery tasks on MySQL servers
  • Performed backup and recovery on Oracle database using RMAN and cold back -ups using shell scripts.
  • Using RMAN to restore and recover control and data files respectively.
  • Performed a flashback and point in time recovery.
  • Creating a database recovery catalog and registering databases to the recovery catalog database.
  • Scheduling backups using the CRONTAB utility.
  • Supported system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments.
  • Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
  • Control and monitor user access to the database using roles, and profiles.
  • Monitoring Alert logs for any errors, problems or processes running
  • Create and Assign Roles, Privileges and Profiles to Users.
  • Created non-default listeners for databases.
  • Knowledge in cloning using cold backup, hot backup and RMAN
  • Performed data migration from a database in one server to a database housed on another server using database link.

We'd love your feedback!