Manager Oracle
Resume:
Rajesh Juluru
Seattle,WA
aborqc@r.postjobfree.com
Professional Summary:
* ***** ** ********** ** IT industry as an Oracle DBA in Installation, Configuration, Security Management, Backup and Recovery, Database Upgrade, Patching, Cloning, Migration, Monitoring, Troubleshooting Skills, Problem Analysis, Optimizing, Performance Tuning, Shell Scripting and Documentation in various domains like Banking, Insurance, Finance, and Healthcare.Expertise level experience in both production and development environments involving 8i/9i/10g/11g databases on multiple platforms like, HP-UX, Sun Solaris, IBM-AIX, Red Hat Linux and Windows platforms.Expertise in Installation, Configuration and Maintenance of high availability RAC environment (2, 3 and 4 node clusters) with ASM (Automatic Storage Management) on Oracle 10g and 11g.Installed and Configured Oracle 11gr2 Grid Infrastructure with OCFS file system.Expertise in Configuring, implementing Data Guard 10g/11g in RAC environment. Solid experience in managing Disk Groups ensuring redundancy for ASM file system. Extensive experience in Installation and Configuration of OEM/Grid Control for monitoring and maintaining a highly available environment across all tiers of the application stack. Expertise in configuring Oracle Streams (Unidirectional Table Level) between homogenous databases.Expertise in using Database Links, Materialized Views, and implemented Partitioning Tables to improve Performance.Proficient in using Flashback Technology at the database, table and transaction levels.Performed backup/recovery strategies using User-Managed backup, RMAN-Managed backup, Operating System Backup, Cold and Hot backup, Full, Incremental and Cumulative Backup.Highly skilled in Data loading using SQL*Loader, Export/Import and Logical backups using conventional Export/Import (exp/imp) and DataPump (expdp/impdp).Performed Point In Time Recovery (PITR) and Tablespace Point In Time Recovery (TSPITR) recovery methods using RMAN.Cloned databases using Scripts as well as with RMAN.Solid experience in Upgrading, Migration and applying Patches (Critical Patch Update (CPU) / Patch Set Update (PSU), One-Off Patches) using OPatch and runinstaller to various versions of Oracle (8i/9i/10g/11g). Proficient in using Oracle's Transportable Tablespace (TTS) feature that allows users to quickly move a user Tablespace across Oracle databases.Expertise in Monitoring, Optimizing Oracle database for Performance Tuning and system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, UTLBSTAT and UTLESTAT.Performed Reorg of databases to eliminate fragmentation issues.Expertise in monitoring database daily activities like Alert logs, Trace files, Archive files, Troubleshooting production issues and Performance Tuning issues by using Oracle Enterprise Manager (OEM) and TOAD utilityExcellent skill in writing Procedures, Functions, Triggers and Packages using PL/SQL.Expertise in Shell scripting for day-to-day database administration tasks that include various Cron Jobs for Backups, alert logs and performance.Expertise in using tools like ESM console for designing the security and database access strategies. Solid experience in managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints and Database Access.Handled Large size databases in both OLTP and data warehouse environments with an extensive experience on 24X7 high availability Production environments for large databases and on-call support to developers & end-users.2+ years of experience as a MYSQL DBA in a high traffic, transactional environment.Expertise level experience in Configuration, Administration and Maintenance of MYSQL Database in Production and Development environments.Extensive experience in MYSQL Replication, with both Master-Slave and Master-Master Replication.Expertise in Multi-Datacenter MYSQL Replication.Performed Backup and Restore for MYSQL Databases.Proficient in Tuning of MYSQL processes and queries.Expertise in Monitoring and troubleshooting MYSQL databases.Proficient in managing Netezza and Informatica Production databases using GUI Tools.Exceptional ability to quickly master new concepts and technologies.Capable of working in a Team/Independently with ability to lead a DBA team with project management, technical presentation, communication and time management skills.
Technical Skills:
Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, UNIX,Sun Solaris 2.x/8/9/10, HP-UX 10.x/11.x, AIX 5.x/6.x
RDBMS: Oracle 11g/10g/9i/8i, MYSQL,Netezza,Informatica, MS SQL Server .
Applications: Toad, SQL Developer, Erwin, VERITAS Net Backup, Tivoli,JIRA, Nagios, Zabbix.
Oracle Tools: SQL *PLUS, OEM, RMAN, SQL *LOADER, Imp/Exp, Data pump, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.
Languages: SQL, PL/SQL, Shell Scripting, PERL, C and Java.
Education & Certification:Oracle Certified Professional (OCP) in Oracle 10g Database Administration.Bachelor of Technology from Jawaharlal Nehru Technological University, India
Professional Experience:
Memory Lane, Seattle, Washington March 11 – Till date
Role: Sr. Oracle DBA
Responsibilities:Expertise in the Installation and configuration of Oracle 11gR2/11gR1 on standalone, RAC (Real Application Clusters)using ASM on Red Hat 5.0, IBM-AIX 6.1.Configured SCAN, Transparent Application Failover (TAF), Load balancing, and Fast Application Notification (FAN) for High Availability in 11gR2 RAC.Worked on new 11g tools including Real Application Testing (RAT), SQL Plan Management, SQL Performance Analyzer (SPA) and SQL Access Advisor. Designed and Implemented disaster recovery system Data Guard (Physical Standby database) on 11gR2 RAC environment for the Production databases as per the requirements and specifics tailored to the customer needs.Migrated several RAC systems to ASM and handled the issues raised.Configured Oracle Enterprise Manager Grid Control for monitoring multiple database and notification of database alerts, and installed EM agents (Oracle 11.1.0.7 agents) on multiple database servers.Performed replication using Oracle streams local capture between homogenous databases at Uni Directional table level and monitored Streams Issues using Grid Control.Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.Created Database Links (DB links), Materialized Views, for replication between two databases.Planning Backup/Restoration Strategies like taking level 0 backup in the weekends, level 1 and level 2 backups on the weekday for medium sized databases. For Small databases, taking cold backup twice in a week by shutting down the database.Worked on advance recovery methods like PITR and TSPITR using RMAN. Scheduled backups and recovery for Production and Test Databases on an event of a system crash by using Recovery Manager (RMAN).Performed Database Cloning to setup Test and Development Databases using RMAN.Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.Implemented Transportable Tablespaces on Homogenous and Heterogeneous Platforms.Migration of Oracle database releases from development to regression and to production.Applied patches for 10.2.0.4/10.2.0.5 and 11.2.0.1/11.2.0.2 Applied security patches to all supported database systems and Performed testing.Performed Logical Backups with Export/Import (exp/imp) and Data pump (expdp/impdp) utilities..SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM,ASH, and monitored individual production databases performance on daily basis.Performance tuning of Queries by maintaining Aggregates, Compressing, partitioning, indexing and use of Hints, Stored outlines, Statistics for the same.Performed Fine Grained Auditing on Table in production databases.Monitoring the Alert Logs and User Trace Files for improving database performance and detecting any suspicious activities.Performed database re-organization as required assisting performance and ensuring maximum uptime of the database.Managed cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus.Oracle application system administration (Managing concurrent process, Creation of User, Responsibility, registration of new application, Monitoring user activity)Managed Memory issues, Space management issues and Capacity Planning.Automated the nightly RMAN backups for the Production and Test Databases using CRONTAB utility.Imported data from flat files located in legacy system into database table using SQL * Loader.Setup new MYSQL database instances with master-slave replication.Replicated several Master-Master and Master-Slave in both Production and Data Recovery environments.Checking for data consistency between Master and Slaves whenever required.Worked with development teams to facilitate database performance optimization,including minimization of space complexity and optimization of application queries.Performed database schema changes and large DML updates like target pushes/releases on live systems as requested by development teams and approved and scheduled by management.Performed MYSQL database backup and restore operations as appropriate.Monitoring Production MYSQL Instances with Nagios Monitoring Tool and maintained infrastructure for facilitating ongoing automated database/server monitoring,statistics gathering and alerting.Troubleshooting MYSQL related issues like disk usage,high load,slow queries,performance and identifying the root causes.Worked on issues related to Netezza and Informatica Production databases.24X7 Production support and Troubleshooting of Oracle and MYSQL applications.
Environment: Oracle 11g/10g RAC,ASM, Data Guard, AIX, Red Hat Linux, Oracle Enterprise Manager, MYSQL, InnoDB, Netezza, Informatica, Toad, SQL Developer, Putty, SQL * Loader, PL/SQL, Nagios, Zabbix.
The James Group, Columbus, Ohio May-09– Feb-11
Role: Sr. Oracle DBA
Responsibilities:Configured, Implemented 10g/11g on standalone, RAC with ASM on RHEL, Solaris Servers.Added nodes for the existing RAC and also configured the services.Implemented failover and Load Balancing methods in Oracle 11g RAC. Implemented Data guard by creating Physical Standby databases on 10g/11g for all failover situations.Successfully Migrated non ASM file system to 10g ASM file system of 4.4 TB using RMAN utility.Database monitoring and administration using OEM Grid Control 10g.Implemented data replication through Materialized Views, advanced replication through Oracle streams (Uni Directional table level) in Oracle 10g/11g.Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.Implemented new features of 10g like ASM, Flashback Recovery area, Flashback database etc.Performed Backups and Restore/Recovery procedures on all of Development/Test/Production databases using RMAN.Performed PITR and TSPITR recovery methods using RMAN.Used Transportable Tablespaces in Oracle 10g/11g when moving data across to a Test environment.Assists in planning and providing the migration of Oracle databases to a new release/version of Oracle.Implemented PSU/CPU Patches and ONE-OFF Patches wherever applied using OPatch utility, RunInstaller and Scripts.Performed database upgrade from 9.2.0.6 to 9.2.0.8, 10.2.0.4 to 10.2.0.5Applied Patches for 9.2.0.8/10.2.0.4 and 10.2.0.5/11.2.0.2Refreshing Development/Test/Production environments using Data Pump (expdp/impdp).Tunes and Optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR Report generated from snapshots taken at the peak business hours.Set trace for a session (DBMS_MONITOR), get EXPLAIN PLAN and run TKPROF on trace file to identify SQL problems. Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.Analyzing the tables and indexes using DBMS_STATS package.Developed UNIX shell scripts, Perl scripts for Scheduling Batch Jobs in CRONTAB.Performed general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.Monitoring Database alert log, Process log, and Trace files.Provided on-call support for OLTP database and disaster recovery support. Provided assistance and guidance to Application Services, Operations, System Support, and maintained overall Security for all the Databases.
Environment: Oracle 11g/10g/9i, RAC, ASM, Dataguard, Solaris, Red Hat Linux, Toad, Putty, Oracle Enterprise Manager, Grid Control, PL/SQL.
Nationwide Insurance Columbus, OH Jan 07 – May 09
Role: Oracle DBA
Responsibilities:Installed Oracle 9i/10g standalone, RAC with ASM on HP-UX 11.2, Red Hat 4.Performed conversion of Non RAC single instance to Real Application Cluster (RAC) database instances.Setup, integrated and managed Standby databases for 9 locations getting replicated at corporate office.Worked on Automatic Storage Management (ASM) for managing data in SAN.Configured Oracle Enterprise Manager Grid Control for monitoring multiple databases and notification of database alerts.Setup Basic replication using Materialized views for replicating data.Backup plan designing and implementation using cold/hot backups for database running on raw devices and Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using Data Pump, RMAN backup technology. Worked on PITR, TSPITR scenarios using RMAN.Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.Used Cross-platform Transportable Tablespaces method to move data is more efficient than the traditional method of export and import.Upgraded the production database from 9.2.0.6 to 10.2.0.2 within tight cutover window, around 45 + databases with max database size of 2.6 TB.Applied security patches on both Server side and Client side and Performed testing.Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.Monitor performance, Storage, backup logs, database logs, tables, extents, indexes, and all other back-end objects in production.Capacity planning for tablespaces, datafiles, tables, indexes according to DW requirements and size production instance.Write scripts to automate the synchronization process between local and remote database.Document all the back-end objects, logical and physical data model and database structures.Troubleshoot user related and database related issues using Oracle Metalink.Provided on-call support regarding production related database problems.
Environment: Oracle 10g/9i, RAC, ASM, Dataguard, HP-UX 11.2, Linux Red Hat, Toad, Oracle Enterprise Manager, Grid Control, SQL *Plus, SQL *Loader, PL/SQL.
APCS PVT LTD New Delhi, India. Feb 06 – Jan 07
Role: Oracle DBA
Responsibilities:Installed, configured and upgraded Oracle databases 9i/8i.Customized Data Guard as a tool for Disaster Planning and implementation.Implemented Logical and Physical standby Databases to ascertain high availability of database during system crashes.Created materialized views, table partition for Tuned databases.Monitoring of hot backups, exports on both UNIX and WindowsPerformed refreshes of databases and UNIX servers.Maintained the RMAN repository and customized recovery catalog.Performed database tuning for daily loads and slow response issuesUsed Statspack, Explain plan, TKPROF, AWR, ADDM utilities for Tuning and analysis.Involved in session management and monitored the critical wait events in the database.Involved In query optimization and using rule based optimizers and cost based optimizers.Created and standardized back up scripts using shell scripting.Created indexes, Triggers, Views and Partitions to reduce the time.Involved in user creation and user access control. Involved in Schema creation and management. Implemented Oracle security features and audit mechanisms for Fine grained access control.Used SQL* Loader for data import from remote databasesWritten control files in SQL*Loader to load files in database tables.Involved in production support activities 24/7 during on call and resolved database issues.
Environment: ORACLE 8i/9i, UNIX AIX 5.1, Windows NT, SQL, PL/SQL, Toad, Corncob, Erwin, Import/Export and SQL*Loader.
Syndicate Bank, Hyderabad, India. Aug 04 - Feb 06
Role: Jr. Oracle Developer
Responsibilities:Installed Oracle 8i, database creation, and user managementDatabase link were created to access the data from remote databases.Snapshots were used to get the remote database data into the local database.Logical, cold and hot backup procedures.Periodic refreshing of the production data through export and import.Performed tuning and optimization on SQL queries using explain Plan & Tkprof.Developed applications using PL/SQL.Performed code reviews and developed test plans for backend database modules.Responsible for unit testing, and documentation of the interfaces.Responsible for trouble shooting backend production problems.Created logical and physical system designs.Implemented physical design and created DDL scripts for database creation.Developed different database schemas and objects like tables, views, etc.Loaded data from flat files using SQL*Loader and utl_file.Involved in Troubleshooting errors in different databases.
Environment: Oracle 8i, Windows 95 clients, Sun Solaris, PL/SQL, SQL*Loader, Explain Plan and TKPROF.
Contact this candidate