ASHOK
• Over eight years experience as an ORACLE Developer/DBA/Architect
(11g/10g/9i/8i) on UNIX environments like Linux, Sun Solaris, AIX, UNIX, HP-UX
and Windows 2000/NT
• Good experience of Installation and configuration of RAC (Real Application
Server) on different nodes with ASM (automatic storage management).
• Extensively worked on data modeling, physical/logical database designing using
Erwin.
• Normalized database to the 3NF.
• Worked on Sybase Power Designer for Database designing.
• Written stored procedures, functions, triggers for insert/update and
generating reports.
• Experience on ETL processing in Data Warehousing environment.
• Good experience in Unix Shell Scripting, PL/SQL procedures and SQL* PLUS.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad,
Power Explain, and Enterprise Manager.
• Worked with SQL Access Advisor, SQL Tunnig Advisor, Segment Advisor for
performance enhancement.
• Monitoring and optimizing the performance of the Database. Sizing the database
for future growth.
• Good experience in Performance Tuning of database, instances, OLTP, SGA, I/O,
and Rollback segment using different methods and detecting locks.
• Proficiency in the tools and utilities bundled with Oracle Software viz.
Export, import, RMAN, listener, sqlplus, OEM (Oracle Enterprise Manager), Oracle
Grid control, Perl, Java, Oracle Streams and RAC. Worked with Replication tools
such as Shareplex.
• Transported tablespaces and data exports from production and staging
databases. Tuned SQL queries to pull data from data warehouse tables.
• Helping the QA testing team for solving the database issues for projects made
on Java and Perl.
• On call technical support for 24x7 mission critical production databases.
Willing to work beyond regular hours.
Technical Skills
Databases Oracle10g (RAC)/9i/8i, SQL Server 2000/2005, Sybase, MS Access
Tools SQL*Loader, SQL*Plus, T-SQL, Erwin, BMC Patrol, Oracle export/ import
utilities, OEM, RMAN, TOAD, DBArtisia, Crystal Report, SQLBacktrack, Informatica
8.6
Operating System Linux (RHEL), Sun-Solaris, AIX, HP-UX, DOS, Windows
2000/2003/NT
Languages SQL, Shell Scripting, PL/SQL Programming, Java and Perl,
Work Experience
Public Communication Services, CA
July2008 – Feb2009
Role: Sr. Oracle Database Architect/Developer/DBA
Responsibilities:
• Installation of Oracle 11g/10g RAC (two nodes) with Automatic Storage
Management(ASM) on Linux 5.2
• Installation and configuration of SQL Server 2005 on windows 2000.
• Extensively worked on stored procedures and triggers.
• Involved in data warehouse designing.
• Data modeling using Sybase Power Designer and convert it to physical design
and implementation.
• Working experience of ETL process with Informatica 8.6 from mysql to oracle
migration.
• Performed SQL tuning other database activities like tables/users/indexes
creation using TOAD.
• Created Users, roles, profiles, triggers, procedures, functions, and sequences
as per business requirements.
• Customized the Workflow process of the reports by modifying existing
procedures and developing new procedures in the PL/SQL packages.
• Capacity planning considering future growth with different hardware and
software requirements.
• Worked with Perl scripting for data loading from non-oracle to oracle
database, monitoring for Oracle database availability and job scheduling
activities for the database.
• Worked on MYSQL 5.0.37. Involved in day to day activities like user/table
management, SQL performance tuning, backup/recovery database replication for high
availability etc.
• Performance tuning including instance tuning, memory tuning, SQL Tuning using
SQL Tuning Advisor, SQL Access Advisor and Explain plan.
• Implemented oracle auditing and create triggers for tracking database changes
and improve database security.
• Monitoring and managing Production, Development, Test databases.
• Configured and tested Oracle RAC high availability by setting up failover and
load balancing features
• Worked closely with ASM disk group management and management of ASM users.
• Managing and administrating more than 1TB database with larger partitioned
tables.
• Troubleshooting and Tuning of production & RAC databases.
• Configured and implemented Oracle Streams (Advanced Replication) for high
availability.
• Troubleshoot Database performance issues using Automated Workload Repository
(AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for
optimum performance.
• Closely work with SQL loader, Export/Import, Data pump for data transfer.
• Applied oracle quarterly oracle Cumulative Patch using the latest Opatch
utility. Upgraded all servers to the most current Opatch level.
• Created AWR report to tune the instance also used Oracle Enterprise manger to
monitor database activities.
• Experience in supporting production databases in a 24x7 environment.
Environment: Oracle 11g/10g RAC, Mysql 5.0.37, SQL Server 2005/2000, Linux 5.2,
Windows 2000/NT, RMAN, Enterprise Manager, Sybase Power Designer 12.5,
Informatica 8.6, Sql Developer, TOAD, SQL Yog, PHPMyadmin
Walt Disney, CA
Feb2008 - June2008
Role: Sr. Oracle DBA/Developer
Responsibilities:
• Installation and configuration of Oracle 9i/10g on Sun Solaris.
• Upgrade of oracle 9i to 10g on Sun Solaris.
• Worked on Statspack and reports to resolve performance issues.
• Installation and configuration of SQL server 2005 on windows 2000 and written
complex procedures and queries using T-SQL.
• Developed physical data model using Erwin and generated DDL scripts to create
the database tables/indexes/triggers/sequences etc.
• Extensively worked on writing functions, stored procedures and triggers using
sub-queries and joins.
• Worked on client tool like Toad for writing and tuning SQL queries.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat and
Enterprise Manager.
• Closely worked with oracle wait class and wait events for resolving
performance related issues.
• Integrated the Backup status reporting for the entire database in the
enterprise to enable the web reporting using Oracle SQL, PL/SQL and korn shells,
Unix shell Scripting.
• Extensively worked on database security management by creating appropriate
database users/roles and enabling auditing.
• Tuned unorganized SQL queries by viewing explain plans and inserted indexes to
optimize the performance.
Environment: Oracle 10g/9i RAC, SQL Server 2005/2000, Sun Solaris 5.9, Windows
2000/NT, TOAD, RMAN, Data Guard, Enterprise Manager, Data pump, PL/SQL, Unix
Shell Scripting
Wells Fargo Finance & Home Mortgage, IA
July2007 - Dec2007
Role: Oracle Developer/DBA
Responsibilities:
• Installation of Oracle 9i(9208) and 10g (10gR1 and 10gR2 ) on Sun Solaris 5.9
and AIX 5.3.
• Performed logical and physical data modeling with extensive normalization and
proper naming conventions using Erwin.
• Created procedures/triggers to track user activities and data loading.
• Used TOAD to perform SQL tuning and other database maintenance activities.
• Worked on performance tuning of SQL, PL/SQL and analyzed Tables
• Worked on implementation of data warehouse for the production application.
• Bulk data loading from flat files to oracle database using Sql *Loader.
• Troubleshoot Database performance issues using Automated Workload Repository
(AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for
optimum performance.
• Member of the team working with more than 50 databases with maximum size of up
to 1 terabyte of database.
• Design and creating new Oracle Instance (Dedicated connection and shared
server) – based on architectural requirements.
• Configured and implemented Oracle Streams (Advanced Replication) for high
availability.
• Setup all Database environments like DEV, QA, UAT, and Production.
• 10G grid control for monitoring and tuning the database.
• Applied oracle patches, as well as taught other DBA’s on how to install the
quarterly oracle Cumulative Patch using the latest Opatch utility. Upgraded all
servers to the most current Opatch level.
• Capacity planning considering future growth with different hardware and
software requirements.
• Maintained and monitored multiple databases using Oracle Enterprise Manager.
• Successful implementation of BCP database for RAC configuration.
• Troubleshooting and Tuning of production & RAC databases.
• Supported very large database with heavy OLTP and batch activities
• Worked with Perl scripting for monitoring and job scheduling activities for
the database.
Environment: Oracle 10g/9i RAC, SQL Server 2005/2000, Sun Solaris 5.10/5.9/5.8,
AIX 5.3/5.2, Windows 2000/NT, Enterprise Manager, SQLBacktrack, Shareplex, TOAD,
RMAN, Data Guard, PL/SQL, Unix Shell Scripting
Ridley Inc., Minnesota
May06 - July07
Position: Oracle Developer/DBA
Responsibilities:
• Creation and configuration of Oracle 10g database
• Installation and configuration from Oracle 9i database to Oracle 10g and
Performed DBA tasks
• Installed, Configuration and deployment of Oracle 10g database and Real
Application Clusters (RAC) on different nodes with ASM (Automatic Storage
Management) on Linux RHEL.
• Member of a team for Data Warehousing application
• Data modeling using ERWIN with extensive normalization activity.
• Created Users, roles and also worked with backup and restore database in SQL
Server 2005.
• Responsible to write complex PL/SQL stored procedures.
• Worked with DBArtisan for database migration.
• Upgrading the database from existing Oracle 9i to Oracle 10g and Migration o |
