Oracle-Mysql Database Architect, Database Tuning, DB Migration
Last active: 18 days ago
More than 5 years of experience in Oracle and MySQL
Performance Tuning and Health Monitoring the databases in different situations using AWR, ADDM, TKPROF, Statspack, SQL Hints etc.
Tuning complex SQL Statements using Explain Plans etc.
Installation, Configuration, Maintainance, troubleshooting Oracle 10g, 11g on various linux and windows platforms.
Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
Experience in Oracle 11g Active Dataguard, Database Cloning.
Backup strategies, Logical Backup, Hot Backup, Cold Backup with RMAN.
Experienced in migrations of large databases from one server to other (Oracle IMPDP, EXPDP, IMP, EXP utilities).
Great experience in Cross database migrations (SQL Server, MySQL).
Good experience in creating shell scripts (Linux) and batch scripts (Windows) to automate the work.
Implemented cross database communication using Oracle Hetro Service (Excel, SQL Server).
Extensive knowledge of PL/SQL Code, Writing debugging PL/SQL on daily basis (Procedures, Packages, Functions, Triggers etc.).
Writing Complex SQL statements for reporting purposes using best practices.
Providing L1, L2, L3 support to the customers and solve their problems ASAP.
Experience in Crystal Reports.
Experience in ERP, VBA, VB6.
Good knowledge of Oracle RAC, ASM. less
Database designing and maintainance according to business requirements.
Setting up standards for database development as per business requirements.
Performance Tuning and Health Monitoring the MySQL (Percona) database.
Tuning complex SQL Statements using explain plans.
Installation, Configuration, Maintainance, troubleshooting of MySQL (Percona) on Ubuntu and Windows platforms.
Hands on experience in creating and maintaining Clusters with Percona XtraCluster and HAProxy.
Hands on experience in creating and maintaining Master-slave setup.
Hands on experience in writing complex SQL Statements for reporting puproses.
Experienced in writing Triggers, procedure and functions.
Extensive experience in backup and recovery techniques using Percona XtraBackup and MySQLDump.
Good experince in working with Linux Shell.
Invloved in devlopment of social mobile apps from start to end.