Pranavanath D

Database Administrator - 13 Years of Experience - Near 75038


Database Administrator


Irving, TX

Education Level:

High School/GED

Will Relocate:



Summary: * 12+ years of Experience in IT industry and as Oracle DBA with Real Application Clusters. * Expertise in Oracle Database Administration. * Expertise in Oracle High Availability and Replication Solutions including Oracle RAC, Dataguard, Goldengate * Experienced in SUN Solaris, Red hat Linux Administration. * Strong experience in Performance Tuning and Troubleshooting of Single Instance and RAC Databases. * Expertise in Installing, Configuring and Upgradation of Oracle Databases from 9i to 10g and 10g to 11g across cross platform. * Knowledge on Oracle Exadata. * Experience in troubleshooting issues with E-Business suite. * Performed Databased Cross Platform migration from HP-Unix/Solaris to AIX. * Experience in SAN, NAS and Virtual Storage iSCSI. * Hands-on experience in Volume managers including Veritas Cluster File system, Veritas Volume Manager VxVM, Oracle ASM, Linux LVM. * Performance Tuning using ADDM, AWR, ASH, Oracle 10g/11g and 12c OEM, STATSPACK, UTLE, UTLB, TKPROF, EXPLAIN PLAIN. * Experience in Configuring Backup and Recovery Solutions using RMAN, IBM Tivoli TSM, Commvalut, Veritas NetBackup. * Experience in Configuring Databases on Virtual Environments (Vmware ESxi) and Cloud (vCloud Director, VCloud Air). * Experience in UNIX Shell scripting. * Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise. * Having hands on experience in Backup, Recovery and Cloning of databases using RMAN. * Knowledge on Oracle Support Process for Technical requests using Oracle Support and other support procedures (TSANet). * Expertise in Patching including Interim, CPU, upgrade patches. * Administrated database of various sizes ranging from 5Tb to 25TB. * Excellent Interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment. * Deep understanding of technology with focus on delivering business solutions. * Posse Strong Communication skills and Analytical Skills that consistently resolves ongoing issues or defects. * Speaker in VMware vForum Singapore on Oracle Database on VMware * Experienced in Project Management, Mentoring and Team leadership. * Proven ability in providing internal Trainings and participated Career Development programs Experience Summary: Bentley University, Boston, MA Feb 2017 to June 2017 Role: Senior DBA / Associate Delivery * Interact with Customers and Business stake holders for Project Implementation and mitigation. * Provides architectural guidance and leadership on best practices regarding software/database development, integrations and tools and technologies * Performance Tuning and Maintenance of Oracle database using Oracle 12c OEM. * SQL query tuning using SQL profiles, SQL tuning advisory, ASH reports and AWR reports. * Upgrading and troubleshooting MySQL to 5.7. * Performance monitoring and Tuning of MySQL database using MySQL Workbench. * Configure and maintain Goldengate Uni-directional Replication for Bentley University applications. * Involved in capacity planning, workload management, system maintenance/ administration, and diagnostics of Oracle databases and Applications including Oracle Fusion Middleware, Oracle WebLogic servers. * Involved in SQL and Database Tuning using SQL Tuning Advisor, ASH, AWR, ADDM reports, and OS tools including SAR, iostat, vmstat, top commands and Oracle diagnosing tools RDA, OSWatcher. * Created and reorganizing Table Partitions, Materialized Views, Indexes, Parallel Execution * Performed large batch jobs, and tuning of SQL queries and database systems. * Design, Develop and document Proof of Concepts (POCs) for AWS and Oracle RAC. * Provide on-site, and on-call 7x24x365 support as needed. * Responsible to maintain University database both Single Instance and RAC Clusters. * Apply CPU/PSU patches, Upgrade databases from 11gR1 to R2 and 11g to 12c. Environment: Oracle 10g/11g, 12c, 11g RAC, Dataguard, Goldengate, MySQL 5.7, MySQL Workbench Toad for MySQL SUN Solaris, AIX, RMAN, IBM Tivoli TSM, JBoss, Oracle Fusion Middleware, Cognos, Apache Tomcat SAN Storage, TOAD, Oracle SQL Developer, Autosys. Dex Media, Dallas, TX June 2016 to Oct -2016 Oracle Tech Lead. Responsibilities: * Lead / Mentor Oracle DBA team both On-site and Off-shore teams. * Gather client Projects and requirements and administer to complete the projects in time. * Share and off-load work to On-site and Off-shore team. * Provide solutions to engineering teams to help integrate applications on Cloud. * Install/Upgrade Oracle 11g Database from 9i and 10g to 11g, and 11g to 12c. * Migrate Databases running on HP-Unix and Solaris to AIX . * Work with Business leads/Managers and provide Database solutions according to their requirements. * Performance Monitoring and Tuning of Oracle 9i through 11g Databases. * Install, Configure, Upgrade and Troubleshoot MySQL databases * Configure MySQL replication for High Availability using virtual IP. * Migrate MySQL to Maria DB for Inter Database applications and Upgrading MySQL 5.6 to 5.7. * Performance monitoring and Tuning of MySQL / Maria DB database using MySQL Workbench. * Performance tuning using Oracle tools STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM, ASH, 10g/11g OEM and 12c OEM, OS Watcher * Use vmstat, iostat, sar, topas, top tools for performance monitoring and tuning at O/S level. * Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using F5 Service Load Balancer (SLB). * Configure and Troubleshoot Shareplex Database Multisite Bi-Directional Replication. * Configure and maintain Goldengate Bi-directional Replication * Migrated 11g databases to different server using Goldengate with minimal down time. * Troubleshoot Physical Standby databases running on 9i and Dataguard for Oracle databases running on 10g and 11g. * Develop and document Proof of Concepts (POCs) for Exadata. * Resolved the issues for Conflicts between Source and Target Goldengate Databases * Troubleshoot Goldengate collision issues and Goldengate DLL Replication * Perform Database refresh from Production to QA and Dev environments, using RMAN and Storage Snap backup. * Create Procedures, Packages, Function and refresh Materialized views.. * Enforce adherence to IT Processes including SDLC, Change management, and other fundamental processes. * Work with Development team on designing standardized data models, and standard and optimal PL/SQL code. Environment: Oracle 9i/10g/11g, Oracle 10g/11g RAC, Dataguard, Shareplex, MySQL 5.6, MySQL Workbench Toad for MySQL, HP-UNIX, SUN Solaris, AIX, RMAN, IBM Tivoli TSM, IBM Power 6/7 e-series servers, SAN Storage, TOAD, Oracle SQL Developer, Autosys.