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.