Senior Oracle Consultant

• Sep 2019 - Present

Senior Database Architect and Consultant

• Sep 2019 - Present

Senior Oracle Consultant

• Jan 2013 - Present

•Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment. •Configured the 2 Node RAC Clustered environment end to end in oracle 11g that includes requirements gathering, Hardware planning, OS installation, CFS configuration, configuring ASM disks, GRID installation, configuring network architecture for clusters and RAC database installation. •Got good knowledge in implementing oracle golden gate feature in a production database and troubleshooting related issues. •Expert in Oracle 11g/10g Data Guard and standby databases, troubleshooting the log shipping issues and logs maintenance. •Expertise in oracle UPGRADE from 10g to 11g/12c and PATCHING the Oracle home through Opatch utility. •Got knowledge on EXADATA database server hardware architecture. •Experience in Oracle 12c/11g/10g – Installation, Migration and implemented new features. Installation includes requirement gathering, licensing, database storage planning, memory planning, storage allocation, database installation, configure database as per company standards. •Expertise in Performance tuning, memory tuning, SQL tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis. •Worked on partitioning, supported partition databases and worked on exchange partitioning concepts for a project. •Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN. •Supporting Data Warehouse Database i.e. over 3 TB in size. •Strong trouble shooting, problem solving, analytical and design skills. •Expertise in Oracle Enterprise Manager (OEM), TOAD, DB Artisan, SQL Developer, ODBC configurations. Good knowledge on SHELL Scripting, UNIX Commands to identify the OS level database parameters and resolve issues. •Worked in 24x7 production support environment and provided on-call and day-to-day support. Show less

Software Engineer

• Aug 2007 - Mar 2011

• Created Oracle database manually and through dbca. • Responsible for taking Incremental hot daily backups and cold backups weekly. • Configured RMAN target db and Recovery catalog db and taken incremental hot backups. • Taken logical backups, export/import of tables, schemas and full database. • Datapump directory creation and logical backups using datapump. • Cloning the production database into test database. • Hands on experience in data-guard, creating a physical standby database. • Listeners and TNS Services configuration for remote servers. • Regular checking of alert log files, udump and bdump trace files and solved various db related issues. • Oracle database Up-gradation from 10g to 11g through oracle home shifting and through DBUA. • Monitoring & managing the tablespaces and data files growth. • Parameter file, Archive log file and control file management. • User account management: Creating users, managing user accounts, profiles, granting roles and privileges to users. • Multiplexing control files and archive destinations and managing it. • Worked with Cluster table, partition table, temporary table creation and management. • Knowledge transfer to new joiners and assist co-workers in technical issues. Show less