United States
Working as 24/7 system oracle DBA. Major Roles are given below Performance Tuning, Setup/manage Datagaurd with physical standby and logical standby dbs. Manager several production/QA/Development and data warehouse databases,Setup/manage OEM grid. Supports Production/development and QA teams. Admin oracle installations,patch upgrades, create new databases, Database design and data modeling, manage oracle applications server, http server, create JSP reports using report builder and deply oracle portal layer,Oracle 11g migration with Dataguard(both physical and logical standby) and administer them,Oracle Bi-Directional streams Migration,Oracle partitioning(Both global and local indexes),Oracle column encryption with 11g,Mange automatic memory management and manual memory management,Written several perl scripts, shell scripts and cronjobs,Build data warehousing databases for reporting purpose and partition it,Write batch script to load data into warehousing databases for reporting purpose and partition it, Build several summary tables for few monthly reports,Performance tuning by creating indexes,re-write reports, and materialized views,rebuild indexes, Create schema with just structure and constraints from big databases,Online index rebuild and reclaim more space,write oracle procedures, packages, triggers and functions,setup oracle bi-directional streams and mange streams & dataguard. Oracle database/table export import using exportdp/Importdp utilities and compresssion etc,All other pro-active daily jobs such as making sure backups are working, batch scripts are working, performance comparison etc
• Oracle database partitioning and maintenance of partitioned tables and indexes • Data warehousing administration • SQL server development and some admin experience • Manage Data Guard with primary and Logical standby • Database Migration using Migration workbench • Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation. • Created and implemented logical & physical backups • Setup SQL trace. Monitored and tuned AppSever performance. • Creation of Database, tablespaces, schema objects and stored procedures. • Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems. • The tools used mainly are TKPROF, Explain Plan, STATUSPACK, utlbstat.sql, utlestat.sql scripts, Enterprise Manager and oracle wait events • Extensively used Oracle dynamic performance and troubleshooting views and DBA dictionary view • Created new databases and users, setup RMAN backups, Export, and other monitoring scripts. • Creation of duplicate database by RMAN • Administering Real Application Clusters • Provided 24x7X365 on call production support. • Developed Stored Procedures and Triggers. • Written several shell scripts. • Create both logical and physical standalone databases • maintain, manage, and monitor one or more standby databases • Report customization and automation (Oracle HTML) • Worked with different data loads (Perl and ORACLE data export) • Major participation at all client meetings • Providing technical solutions for various issues • Several server jobs such as shell scripts/cron jobs etc • Installed and setup tomcat/apche server for web development • Set up SQL Loader scripts for various data deeds into oracle from other databases