RAJENDRA JETTI

Oracle Database Administrator

Career Objective:

To seek a challenging environment that encourages continuous learning and exposure to new ideas

Summary of Experience :

Having 10 Plus years of experience in Information Technology in which 6 years as Oracle DBA and 4 years on SAP BO and SQL/PL SQL. Worked on various domains like E-learning , Banking Financial, Telecom, Retail and Manufacturing Services.

• Experience with complete Software Design Lifecycle including design, development, testing and implementation of moderate to advanced complex systems.
• Experience on Oracle 9i/10g/11g Database planning, installations, upgrade and migrations.
• Extensive Knowledge on Oracle Architecture.
• Experience on Database Performances through Database Tuning, System Tuning and Application Tuning using AWR, ADDM, DBMS SQLTUNE, SQL ADVISOR, DBMS STATS, Explain Plan, SQL Trace, TKPROF.
• Experience on Performance Tuning and solving problems related to indexing, SQL queries, DML operations, and other anomalies or errors.
• Experience on SQL tuning, SQL Profile and SPM package etc.
• Experience on moving data from one database to other using Data Pump Export/Import.
• Extensive experience on RMAN
• Clone of Production databases using RMAN to Testing and training environments.
• Involved in Installation, Configuration and deployment of Real Application Clusters RAC on different nodes and experience in adding and removing nodes.
• Manage RAC environment for Day to Day Database administrator, Performance Tuning.
• Experience on Data guard implementation
• Experience on Oracle GoldenGate.
• Worked on Installation and Configuration of Reporting databases and Disaster Recovery databases.
• Expertise in Oracle Enterprise Manager OEM
• Extensive knowledge on Bigdata Hadoop.
• Extensive experience on Shell scripting.
• Good experience on scheduling cron jobs in Linux.
• Strong knowledge on Data warehouse concepts.
• Worked on various tools like TOAD, Aqua studio, putty, winscp etc.
• Good knowledge on MS SQL 2005/2008
• Experience on SAP BO 6.5 and XI R2.
• Strong knowledge on ITIL concepts
• Ability to grasp and adapt new technologies and systems quickly.

Technical Skills:

• Databases : Oracle 9i/10g/11g, MSSQL
• Operating Systems : Linux RHEL, Cent OS, Windows NT/2000/2003/XP/Vista/windows 8
• Reporting Tools : SAP BO 6.5, Xir 2, IntelliView reporter
• Tools/Utilities : Toad, Aqua Studio, Exp/Imp, expdp/impdp, TKPROF, Putty, WinSCP and Enterprise Manager Grid control OEM .
• Programming : C, C , Core Java, PL/SQL.
• Scripting : Shell scripting, HTML
• Framework : Bigdata Hadoop

Professional Experience:

Confidential

Oracle Database Administrator

Confidential is a provider of enterprise software and mobile applications, communications and commerce services, primarily to the education industry. It is best known as the developer of Blackboard Learning System, a learning platform for higher education, K-12, and professional education institutions.

• Installing patches and upgrades of Oracle database.
• Backup and Recovery using Export/Import, RMAN.
• Refreshing Database as per the requirements of the clients using export and import utilities and RMAN.
• Responsible for Database migrations.
• Day-to-day Database administration activities like, table space issue, mount point space issue, high CPU utilization, locking/blocking sessions, etc.,
• Trouble shooting Database High load and Memory/Process issues
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Versed in Loading external data into the database using SQL Loader, External Tables, etc. and moving data from one database to other using Data Pump Export/Import.
• Clone of Production databases using RMAN to Testing and training environments.
• Performing root cause analysis RCA on Database failures/crash.
• Generating and analysing AWR and ADDM Report for database performance Health Check.
• Resolve performance tuning related issues and queries.
• Perform SQL tuning, creating SQL Profile and SPM package etc.
• Performed database tuning using Oracle Enterprise Manager..
• Responsible for ORA errors when the application team performing any application upgrade
• Installing configuring Oracle clusterware Database Software Troubleshooting using cluvfy handling common issues that arise during integration of the whole bugs, network issues, configuration files issues, OCR issue, deinstallation cleanup of clusterware
• Monitoring the production Oracle alert logs for database errors.
• Responsible to write the SQL queries to generate the reports as per the client requirement.
• Created Unix Shell scripts to automate database operation.
• Configured physical standby database Datagaurd and tested for failover and switchover.
• Experience in unidirectional replication using GoldenGate.
• Experience on writing shell scripts and scheduling the cron jobs.

Environment: Oracle 9i/10g/11g with Redhat, RAC, Expdp/Impdp, RMAN, Golden Gate, Disaster Recovery Oracle Enterprise Manager OEM , Toad, SQL plus, Shell Scripting.

Confidential

Database Consultant

Confidential -based airline. The airline's stated aim is to provide low-fare, high-quality service for long-haul point-to-point service between major metropolitan cities on the Eastern and West Coast seaboards.

• Installation and configuration Standby Database.
• Responsible to perform Oracle upgrades from 10g to 11g.
• Applying PSU and CPU patches.
• Involved in Database migrations Host to Host
• Installation and configuration of RAC and disaster recovery systems.
• Troubleshoot performance issues for the RAC instances
• Experience with Oracle Supplied Packages such as DBMS SQL and DBMS JOB
• Perform Backup and Recovery on Oracle databases.
• Monitoring the database performance using OEM Grid Control
• Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Generated Statspack/AWR reports from Oracle 10g/9i database and analysed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth
• Understanding execution plan of top SQL statements by using Explain plan, Auto trace and Tkprof.
• Scheduled a regular hot backup process and involved the in the backup activities
• Worked on Export Import Utility Classical Data Pump and Transportable Table spaces.
• Performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem
• Clone of Production databases using RMAN to Testing and training environments.
• Involved in Installation, Configuration and deployment of Real Application Clusters RAC on different nodes and experience in adding and removing nodes.
• Configured physical standby database Datagaurd and tested for failover and switchover.
• Calculate the overall server memory and instance SGA memory, if needed to increase the SGA memory
• Tuning Database Design, Instance Parameter Tuning monitoring
• Implement and maintain database security create and maintain users and roles, assign privileges .
• Managed undo segments, control file and Redo Log Files.
• Create and maintain materialized views.

Environment: Oracle 9i/10g/11g RAC with Redhat, MS SQL 2005, Expdp/Impdp, RMAN, Disaster Recovery Oracle Enterprise Manager OEM , Toad, SQL plus, Shell Scripting.

Confidential

Oracle Database Administrator

Confidential is a global banking and financial services company. Deutsche Bank was the largest foreign exchange dealer in the world. The bank offers financial products and services for corporate and institutional clients along with private and business clients. Services include sales, trading, research and origination of debt and equity.

• Installation and configuration Standby and RAC Database.
• Up-gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Experience with Oracle Supplied Packages such as DBMS SQL and DBMS JOB
• Perform Backup and Recovery on Oracle databases.
• Responsible for moving data from one database to other using Data Pump Export/Import.
• Backup/Recovery of Oracle databases using Oracle RMAN.
• Monitoring the database performance using OEM Grid Control
• Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR and automatic database diagnostic monitor ADDM .
• Experience in Database Cloning and refreshing using Data Pump Export Data Pump Import.
• Scheduled a regular hot backup process and involved the in the backup activities
• Involved in Installation, Configuration and deployment of Real Application Clusters RAC on different nodes and experience in adding and removing nodes.
• Managing two nodes Real Application Cluster databases on Red hat Linux
• Database refresh from Production to Test as needed.

Environment: Oracle 9i/10g RAC with Red hat, MS SQL 2005,Expdp/Impdp, RMAN, Disaster Recovery Oracle Enterprise Manager OEM ,Toad, SQL plus, Shell Scripting..

Confidential

SAP Business objects consultant.

Confidential multinational corporation that is engaged in the design, development, manufacturing and worldwide marketing and selling of footwear, apparel, equipment, accessories and services. It is one of the world's largest suppliers of athletic shoes and apparel and a major manufacturer of sports equipment.

• Creating, managing users and user groups.
• Used WEBI to create, analyze and publish reports to various user groups
• Developed and created classes with Dimensions, Detail and Measure objects.
• Building Universe, retrieving data using personal data files, Freehand SQL methods and creating complex Adhoc reports
• Created Standard reports and Ad hoc reports using Business Objects Reporter.
• Created Web Intelligence Ad-hoc and canned reports.
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Created hierarchy and conditions at the design level.
• Created reports with filters and measures, Exception Highlighting, Sorting, and Ranking.
• Extensively used Calculations, Sorting, Rank, Slice Dice and Drill Down for creating Business Objects Reports.
• Created Cross Tab, Financial Tables, Master Detail Tabular Report creation.
• Created Daily, Weekly and Quarterly Reports using Business Objects Reports.
• Created Alerters using Business Objects.
• Created Pie Charts for Graphical Analysis.
• Involved in Modifying and Performance tuning of the Existing Reports.
• Published and Scheduled reports from SAP Business Objects and Web Intelligence
• Used WEBI to create, analyze and publish reports to various user groups
• Published Reports to CMC Central Management Console and involved in Scheduling and exporting the reports in different Formats.
• Involved in Analysis, Development, and Testing.
• Involved in unit testing and User acceptance testing.

Environment: SAP Business Objects Xir2 Designer, CMC, Reporter, Web Intelligence , Oracle 10g and SQL Plus, Windows2000.

Confidential

SAP Business Objects Developer.

• Installed and Configured SAP Business Objects on Both Client and Server Installations.
• Confidential is a supplier of telecom services to corporate and government customers worldwide. BT Retail division is a supplier of telephony, broadband and subscription television services with 18 million customers.
• Deployed SAP Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Converted reports from SAP BO 6.5.1 to SAP BO XIR2 using the report conversion tool.
• Created user defined prompts and complex conditions at Universe level for better performance.
• Business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports.
• BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports/SAP Business Objects Xir2.
• Created Compound Analytics, Charts and Goals on the Dashboard Manager.
• Created Cascading Prompts on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Created hundreds of reports in thin client and full client using all the functionalities
• Used the Export option for the Reports to schedule them in Broadcast Agent Server and sent the scheduled reports via Email, Text and Excel formats.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.

Environment: SAP Business Objects 6.5, Web Intelligence, Oracle 10g and SQL Plus, Windows2000.

Confidential

SQL Developer.

Confidential 3rd largest motorway service area MSA operator. It is dealing with chain stores at Service Stations at various locations in the region. There are multiple systems in Road Chef to capture the Sales, Cash, Payroll, Time Reporting and other information about the MSA's.

• Oracle installation and database configuration.
• User creation and providing necessary Roles, Privileges and quota as per the Requirement.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed materialized views for data replication in distributed environments.
• Created Synonyms to provide data access to subscribing parties.
• Resolving user's day-to-day issues.
• Developed the SQL Loader scripts to load data into the staging tables from the flat files.
• User requirements study
• Design various custom reports and essential lexical reports.
• Application developed and maintenance using Developer 2000
• Created database tables and wrote database triggers applicable to business rules.
• Assisted in user support and training
• Loading data to the destination base tables.
• Providing end user training.

Environment: Oracle 9i, Toad, SQL Plus, Developer 2000, Red hat Linux, Windows NT/2000/XP.