Summary


Bhavan Jindal
Oracle DBA 9i OCP - Oracle Certified Database Professional
Cell No : +91 - 9703503760/9000770249


Over 7 + years of experience in the field of Information Technology primarily in the area of Relational Database Management Systems RDBMS.
Extensive database experience using Oracle databases 8i, 9i, 10g, 11g, IBM DB2 8.x, DB2 9.x and Sql Server 2000/2005.
Over 7 + years of experience as Oracle Database Administrator.
Over 2 + years of experience as SQL Server Database Administrator.
Over 1 + years of experience as DB2 UDB Database Administrator.
Extensive experience in implementing Replication, backup and recovery strategies, performance tuning and installation of Oracle and DB2 on Windows, UNIX.
Install and upgrade the Database Server and Application tools and creation of databases.
Provided Expert level services as oracle core/apps DBA, DB2 DBA, SQL Server DBA and worked as team lead.
Provided 24x7 on call Production support.
Making structural changes to the databases.
Assisted in Logical and Physical Database design.
Performed Storage Management and Capacity Planning.
Implemented table Partitioning to improve performance and data management.
Performed SQL tuning by using Explain Plan, Tkprof and some my own scripts.
Analysis of Statspack/AWR report for Database and SQL tuning to detect System/DB bottleneck and improve performance of loads.
Checking and detecting ORA-600 Deadlock and all types of errors and resolving them.
experience in Database Maintenance, Backup and Recovery, Performance Tuning, Database Design, Implementation and Service restoration experience in all kinds of database backups using Hot backups/Cold backup, RMAN backup, Export/Import and Shadow Image.
Expert in using Flashback Database, Flashback Query, Flashback Table and Flasback Transaction.
experience in all kinds of database recoveries using Hot backups, Flashback database, RMAN and Export/Import
Good experience in Cross Platform Tablespace Conversion.
Good experience in RMAN Backup Compression.
Strong Exposure on configuration and management of High Availability Architectures like RAC, Standby Databases/Data Guard
Strong Experience on New Environments setups includes RAC Real Application Cluster and Clustering.
Databases setup/installations/migration and Middleware Installations
Hands on experience on ASM Automatic Storage Management
Implemented ASM using Oracle 10g on HP rx4640, HP Storage Works XP1200 Disk Array.
Replication and administration of data using Oracle 10g STREAMS.
Configure and administration of GoldenGate replication.
Designed and implemented Disaster Recovery Stand by Databases/Data Guard setups.
Performed successful Failovers and Switchovers of database and Oracle applications.
Good Hands on experience in database Upgradation, Migration, Cloning and Patching.
Strong working experience on Linux, AIX Unix, Sun Solaris with SAN and Windows.
Monitoring and configuring databases using OEM Grid and TOAD.
Written UNIX Shell Scripting for monitoring System Synchronization, Database growth size, monitoring free space availability at Database level and at Disk Level, Backups, Performance and Log rotations.
Change Management - - change requests understanding, analysis of implementation, impact analysis, implementation, Feedback solutions
Incident Management - - Problem understanding, impact analysis, Development co-ordination, implementation, Feedback solution.
Excellent communication skills. Exceptional ability to interact with users and all levels of management.


Employment

October, 2008 -  Present
Company Wells Fargo INDIA Role Senior Database Specialist

Working on DBA Support for Oracle Collaboration Suite and Oracle Application Server Environments

Cluster Database Installations and Upgrades 9i to 10g, 10.2.0.1.0 patchset to 10.2.0.2.0 patchset, 10.2.0.2.0 patchset to 10.2.0.4.0
Handling Critical, Emergency Issues in All Production Environments.
Creation and management of ASM Instance.
Restoration of Physical Database structure to raw device.
Critical Patch Update on all Oracle Collaboration Suite Components in every quarter.
Upgraded UDB database from 8.1 to 64 8.2
Migrated UDB database from 32bit to 64 bit code.
Installed fixpak on UDB databases.
Management of Repository Data and Data Structures.
Performance monitoring and tuning.
Created a document for, the best practices to follow daily, weekly, monthly to keep the database Health.
Monitor database performance, like Bufferpool hit ratio, Package hit ratio, Catalog hit ratios.
Capacity Planning for all the Production and Stage Servers Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation.
Gather Database and User Level Statistics and Analyze Overall System Performance.
New Production/Stage Environment Setups Cluster and Non-Cluster.
Applying Database patchsets.
Creation and configuration new Oracle Test Database Instance for Production Database.
Development database Instances Creation.
SQL/Database Instance SGA Tuning by running AWR/ADDM reports, Using sql trace, Explain Plan and analyzing trace files generated with trace events, recommend any changes required.

experience in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
Enhanced the application performance, by running RUNSTATS, REORGCHK and REORG utilities.
Generated reports of Database statistics using DB2LOOK Utility.
Analysis of AWR report for Database and SQL tuning to detect System/DB bottleneck and improve performance of loads.
Database Backup/Recovery Monitoring hot backups and Monitoring Archivelog Destinations.
Recovered data to a prior point in time using ROLLFORWARD command.
High Availability RAC, Standby Setups.
Tablespace Management, objects creation and user management.
Management of database user s security.
OID Multi-Master, Fan-Out Replication Setups, Configurations and Data migrations.
Configured Replication setup using Oracle 10g Streams
Users Integration Checking, Adding users, Modifying Users attributes, Deleting Users, Indexing Attributes.
Monitoring objects validity and Usage.
Creation and maintenance of Development Database Instance.
Provide input to the Project and Enhancement teams to define database storage structures tablespaces after application developers have designed an application.
Maintain system security.
Refresh Databases and Schemas with Production Database
Used Crystal Report for Analysis and reporting
Coding using PL/SQL, creating Procedures, Triggers, Functions and Cursors using PL/SQL

Strong experience with Dynamic SQL s
Shell Scripting for monitoring System Synchronization, Database growth size, monitoring free space availability at Database level and at Disk Level, Backups, Performance and Log rotations
Change Management - - change requests understanding, analysis of implementation, impact analysis, implementation, Feedback solutions
Incident Management - - Problem understanding, impact analysis, Development co-ordination, implementation, Feedback solution.
Provided 24x7 on call Production support.

September, 2006 -  September, 2008
Company Convergys India Role Database Administrator

Provide Primary DBA support for Oracle Database.
Monitoring Oracle Database 10g with Real Application Cluster RAC in LINUX environment.
Configuration of 1 Oracle RAC node to the Production Database.
Installed and configured Oracle 10gi RAC on RHEL 4 servers with 2 nodes.
Upgrades of Oracle 9i Databases to Oracle 10g Databases.
Creation of database or nodegroups or tablespaces and various objects.
Formulate backup/recovery strategy.

Work in the production support team and maintain operational consistency and efficiency
Provide input to the Project and Enhancement teams to define database storage structures tablespaces after application developers have designed an application
Implementation of reviewed changes to the production databases
Provide primary DBA support to Production support developers

Provide application DBA skills to identify and focus on strategic opportunities
Creating primary objects tables, views, indexes, snapshots, database links, etc once application developers have designed an application
Modifying the database structure as necessary, from information given by application developers
Maintain system security
Controlling and monitoring user access to the database
Monitor and optimize the performance of the database
Maintaining archived data

Collaborate with Enhancement and Production support teams to verify all instances are healthy and up Monitor new alert log entries for any issues ex. ORA-600 errors, frequency of log switches and archiving status
Verify success of database backup
Verify success of database archiving
Verify enough resources for acceptable performance
Monitoring objects validity and Usage
Analyzing database objects and Generate statistics periodically
Performance tuning was an on going process, tuning queries.
Monitoring security policy violations
Look for harmful growth rates
Review tuning opportunities
Tune SQL, I/O, Application and Database
Review Data Fragmentation
Development/Test Instances Creation
Design database schemas using Data Modeling
Refresh Databases and Schemas with Production Database
Design flow of data from Production Database to Datawarehouse using Materialized Views.
Run ETL processes
Coding using PL/SQL, creating Procedures, Triggers, Functions and Cursors using PL/SQL
Developed Jobs to Extract data from Source and to Populate Staging Area.
Migrating data from development data to Stage and Stage to production
Change Management - - change requests understanding, analysis of implementation, impact analysis, implementation, Feedback solutions
Incident Management - - Problem understanding, impact analysis, Development co-ordination, implementation, Feedback solution.
Trained the new DBA in our environment.

May, 2005 -  August, 2006
Company Core Database Systems India Role Senior DBA

Education

Skills


RDBMS ORACLE 10g/9i DB2 UDB 8. x/9 .x, SQL Server 2005, Oracle Tools/Utilities RMAN, EXP/IMP, DataPump, SQL * Loader, SQL *Net, DBVERIFY, TKPROF, EXPLAIN PLAN, SQL Trace, UTLESTAT, UTLBSTAT, STATSPACK, Flashback, Automatic Workload Repository AWR, Automatic Database Diagnostic Monitor ADDM, Automatic Shared Memory Management AMM, STREAMS, OLTP, Data Guard or Stand by Database DB2 Tools/Utilities Control Center, Replication Center, Configuration Assistant, DB2 Processors, Satellite Administration Center, Command Editor, Task Center, Health Center, Journal, Information Center, Visual Explain, Snapshot and Event Monitor, Languages SQL, PL/SQL, UNIX/Linux Shell Scripting Operating System UNIX, Tru64 UNIX, LINUX, Solaris and WINDOWS NT/2000, Creating and Managing File Systems, Raw Devices and Logical Volumes, Installing OS Patches, Creating User Accounts Hardware HP rx4640, HP Storage Works XP1200 Disk Array, HP EVA8000, SUN E450 SUN E4500/E6500, Compaq Proliant ML 350 and IBM Pseries. Programming Languages Visual Basic, C/C++ Others/Tools TOAD, Oracle Enterprise Manager OEM Grid, Erwin, SpotLight, WinSCP, Putty, Cygwin, Telnet, Control-M, Autosys


Miscellaneous

Responsibilities
Responsible for Oracle 8i/9i logical and physical databases design
Created users, tablespace, roles and assign the privileges to them
Rebuilt indexes on monthly basis for tables which have lot of DML activity using database table monitoring
Setup database auditing, granted privileges to users through system/object roles
Managed Temporary tablespace and Rollback segments and monitored their growth
Created and Administered database users by allocating sufficient memory and storage space quota and Interacting with users to gather additional requirements
Developed some Unix Shell scripts to automate database operation and database monitoring
Implemented database refresh with the hot backup using DUPLICATE or full export
Used EXPORT/IMPORT to do table level and full database defragmentation
Creating Indexes and Monitoring Performance
Data loading using SQL Loader from Text files to Database
Perform Daily Logical backups using experience
Perform RMAN operations Incremental Backups
Coding PL/SQL, SQL and Unix Scripts
Server and Clients Installations for New Clients
Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
Performed SQL Tuning by using explain plan and TKPROOF
Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at Operating System
Provided 24X7 on-call production database support
Trained a new DBA in our environment
Company MSI Systems India Role Programmer Analyst promoted to DBA Duration June 2002 to May 2005 Environment Visual Basic, SQL Server 7, ORACLE 8i
Responsibilities
Database Design and Creation of Database Objects and Creating Users and Maintaining Security for various Teams
Coding and Testing
Managing database security and creating and assigning appropriate roles and privileges as required by the application.
Creating tablespaces, tables, indexes, users, etc., maintaining OFA compliance.
Sizing database objects for effective space management and optimal performance.
Database server tuning. This included tuning the shared pool, database buffers and redo buffers.
Database backups and recovery. Developing scripts for cold backup.
Establishing connectivity through ODBC data sources.
Making structural changes to the databases when design changes are to be implemented.
Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space
Installation of Oracle client tools and establishing connectivity to databases
Developing PL/SQL programs for data manipulation.
Database and Website Maintenance
Resume of Bhavan Jindal