Developer/DBA

REHMAN MOHAMMED

Phne:415-***-****

Professional Summary:

Around 7+ years of comprehensive experience on Oracle Platform involving Analysis, Implementation and Support which includes Databases, Applications on Sun Solaris, HP-UX, IBM AIX, RedHat Linux and Windows.

Certificate of Excellence:

Oracle Certified Associate DBA

Oracle Certified SQL Certification

Brainbench Certified RDBMS Concepts

Summary:

Experience working in various domains to deliver new products, upgrades. Resolve application problems to maintain high level of customer satisfaction.

Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.

Experience in Oracle Server installation, configuration, performance tuning, client/server connectivity, query optimization, applying patches and backup/recovery.

Experience Configuring Automatic storage management (ASM) Instance, CRS for high availability databases.

Excellent experience in various migration techniques like export/import, Datapump, backup restore, cloning, and data guard.

Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.

Very proficient in installing and Implementing physical Data Guard.

Experience in upgrading databases from oracle 9i to 10g, 9i,10g to 11g.

Experience in migrating databases from HP-UX to Sun Solaris, Windows to Linux.

Experience in Maintaining Standby Databases (Oracle Data Guard) and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.

Automated many common tasks using Crontab including Backups, Exports/Imports, archiving old records and verification of such processes.

Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces.

Developed UNIX shell scripts.

Used SQL*Loader and PL/SQL statements to load and transform data from flat files.

Experience in taking logical backups of data using oracle data pump utilities EXPDP and IMPDP to move Oracle data from a database or schema to another database.

Good in Implementing Oracle Server security through grants, roles and privileges.

Involved in Performance tuning, database monitoring activities using AWR, STATSPACK, EXPLAIN PLAN, SQL TRACE and TKPROF.

Experience in creating different kinds of partitions on tables and indexes for managing large tables.

Experience in creating different types of indexes for faster retrieval of data and tradeoffs between advantages of having indexed data and the overhead of maintaining indexes.

Monitored indexes and analyzed their status for performance tuning and query optimization.

Hands on experience in applying patches.

Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM)/Grid Control.

Analyzed Automatic Workload Repository (AWR), Active Session History (ASH) reports.

Experienced in generating statistics of database using ADDM.

Tune the SGA components like buffer cache, shared pool to avoid paging & swapping.

Hands on experience working with different FTP clients like Smart FTP, SFTP and SCP.

Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance.

Analyzed Tables, Indexes periodically to optimize the SQL queries.

Strong Knowledge and experience of Creating Users, Public Synonyms, Database Links, roles, profiles, privileges and assigning roles to users.

Experience in Capacity Planning, Storage Allocation and Space Monitoring & Management.

Month end activities and database capacity planning and space management

Extensive experience in Creation, maintenance, location, size of tablespaces, rollback segments and retention time for the flashback files.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills

TECHNICAL SKILLS:

RDBMS Oracle 9i, 10g RAC, 11g RAC.

Tools Oracle Grid Control , Oracle Enterprise Manager, TOAD, PUTTY, Quest Software, SQL Plus, SQL Navigator, SQL Developer, Quest Software, ERWin, VERITAS, MS Office, Hummingbird

Languages SQL, PL/SQL, Shell Programming.

Utilities SQL Loader, Export /Import, EXPDP / IMPDP, AWR, STATSPACK, RMAN

Operating Systems RHEL 4.x, 5.x, 6.x Sun Solaris 8,9,10, HP-UX 10.x, 11.x, IBM AIX 5.2, 5.3, Windows

Professional Experience:

Intuit Mar 2010 – Till Date

San Diego, CA

Oracle DBA

Responsibilities:

24 x 7 production support of business critical Web/Internet access databases.

Installation, Configuration and Administration of Oracle 11g RAC.

Created, configured and managed Data Guard using physical Standby database on a fresh server starting from Oracle Installation

Involved in upgrading application database from Oracle10g to Oracle11g.

Developed hot backup , cold backup and RMAN scripts for database backup and recovery including for both RAC and stand alone instances of databases at predefined schedules

Worked as a team member in RAC implementation projects.

Set up database security, auditing, creating users, creating roles, grating quotas.

Re-organization of tables and indexes

Backup & Recovery of the databases using RMAN incremental backups

Backup & Recovery of the databases using conventional hot and cold backups.

Involved in deciding the data architectures, management policies and database standards for future applications.

Experience in using packages like DBMS_JOBS to schedule tasks Involved in developing UNIX shell scripts to automate and scheduled the database backup jobs.

Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection

Involved in code optimization for better performance.

Involved in training of Oracle developer for handling and resolving the performance issues.

Created/Alter Partitioned tables for large customer related data.

Used DBMS_STATS to gather the statistics along with analyze command

Experience in Extracting, Transforming and Loading data from various Flat Files using SQL loader utility and External Tables.

Monitored the CPU utilization and performance using UNIX utilities.

Created the duplicate databases and did databases refreshes of Production databases on remote nodes using the NFS mount of production servers to the remote nodes,

Used various methods like FTP, SCP, SFTP and PSFTP (from windows) to transfer files from legacy server to DCC servers.

Using Crontab in UNIX environment for scheduling routine tasks.

Performed logical backup using export and import utilities. Performed hot and cold backups.

Performed database performance tuning, stats pack reports automation, stress test on production copy for scalability, resolving production performance issues..

Responsible for capacity planning and space management, and monitoring alert logs for failures, monitoring lock activity.

Database performance monitoring tuning using AWR, ADDM, STATSPACK, EXPLAIN PLAN, SQL TRACE and TKPROF.

Maintaining data integrity and tune database for optimum performance and availability.

Worked with Development team to fulfill the requirements of applications with Database design.

Provided troubleshooting and problem solving support to application developers.

Managed projects by developing implementation plans and timelines, providing weekly status reports, preparing technical documentation pertaining to various projects, exchanging relevant information with management and technical teams, and meeting timelines established.

Environment: Oracle 10g RAC, Oracle 11g RAC, TOAD, OEM Grid Control, RMAN, ASM, Sun Solaris, AIX, HP-UX, RHEL

Dendreon Jan 2009 – Feb 2010

Seattle, WA

Oracle DBA

Responsibilities:

24 x 7 production support of business critical Web/Internet access databases.

Installation, Configuration and Administration of Oracle 11g RAC.

Created, configured and managed Data Guard using physical Standby database for disaster recovery

Involved in upgrading application database from Oracle10g to Oracle11g.

Registered database in recovery catalog & Configured RMAN backups for many databases and subsequently took the RMAN backup.

Implemented archive log threshold deletion script to delete the archive logs after it has been backed up.

Performed migration from Oracle 9i, 10g Release1 to Oracle 10g Release2 RAC database.

Performed logical backup using export/import and data pump utilities.

Used to write scripts to split and compress the dump files on the fly while it is getting generated so that it does not fail due to space issues.

Hugely involve in taking hot backup, cold backup and RMAN backup.

Configured many physical standby databases using dataguard.

Conducted Training sessions for employees for Data guard Configurations

Used RMAN backup, cold backup as well as hot backup to create the standby databases.

Configured the physical standby databases without shutting down the primary database.

Performed switchover testing in case primary fails.

Configured basic replication between production databases.

Troubleshooting and Maintenance of oracle network files like listener, tnsnames.ora and sqlnet.ora.

Performed media recovery of many databases using RMAN backup in the event of database crashes.

Troubleshooted many problems of standby database like missing archive log files, log shipping, listener problem, incorrect archive format

Performed cloning of databases from cold backup, hot backup and RMAN backup

Implemented ASM for some Applications.

Performed Capacity planning for the maintenance of databases on shared servers (SDBU servers).

Provided full technical support to various application teams before the databases moving to production

Perform Backups and Recovery, maintain 24 hours uptime for the database

Managed the databases of various sizes ranging from 50GB to 2 TB

Configuration of distributed databases using database links and snapshots.

Used Oracle 10g Grid to monitor administer and maintain the databases from remote locations using Web Browser.

Worked on capacity planning and database parameter settings based on concurrent users and transaction volumes for Oracle database

Extensively used Crontab on UNIX environment for scheduling routine tasks including: Backups, exports and imports, archiving old records etc.

Used DBMS_STATS to gather the statistics along with analyze command.

Providing the data for the other teams for their development and testing.

Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora

OS Monitoring of CPU utilization and its performance using UNIX utilities like iostat, vmstat, netstat.

Created and managed tablespaces also heavily involved in adding/deleting/ resizing data files.

Monitored growth of data and purged old records through automated scripts.

Supported developers, end-users, creating reports using Business Objects.

Regular Analysis of alert log for error tracing.

Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces. And mailing alerts when required.

Providing the day-to-day DBA support for all Oracle production databases.

Environment: Oracle 9i, 10g RAC, 11g RAC, RHEL, IBM AIX, Sun Solaris, OEM Grid Control , VERITAS, RMAN, ASM, SQL*Loader

Bank of America

Newark, DE Feb 2008 – Dec 2008

Oracle DBA

Responsibilities:

Used Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports

Used Oracle9i new features such as materialized views for daily and weekly reports.

Written SQL scripts for implementation and mentored the end users

Backed up data using Export and import utility.

Utilized RMAN backup to take the backup at the tablespace & database level for the production database

Hot and cold backups of the application database were taken at regular intervals.

Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.

Written Shell Scripts, control files to load data into staging tables

Extensively used PL/SQL Procedures and Functions to transform data before the loading process.

Loading data from flat files into database tables using SQL* Loader

Expertise in UNIX environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRON, AWK UNIX Shell Script (csh, bash, ksh)

Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application

Developed various Complex Queries, Views for Generating Reports.

Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Involved in Unit testing PL/ SQL Stored Procedures and Functions.

Perform analysis of key requirements and transfer knowledge accordingly to the end users

Created SQL reports and data loading scripts for different databases and schemas.

Written Shell Scripts, control files to load data into staging tables

Developed and Tested applications for loading inventory data into database tables.

Environment: HP UX, AIX 4.3, Oracle9i, SQL, PL/SQL, TOAD, Oracle Enterprise report, Application developer, Korn shell, SQL Navigator, SQL Loader, STATSPACK.

Satyam computer

Hyderabad, India Sept 2004 – Dec 2007

Oracle DBA

Responsibility:

My major roles and responsibilities are to Build, installed, and administration of Oracle instances on UNIX/windows systems.

Managing the features like Undo Management, locally managed table spaces and auto segment space management. .

Creation of users & roles, configuring user profiles, scheduling scripts to report space issues at table/index/table space/file system level.

Installation of database as per OFA standards.

Migration of database from Oracle 8.0.5 to Oracle 9i.

Regular monitoring of trace files & log files.

Monitoring hit ratio of SGA components

Maintaining regular backups.

Communicating with Oracle Technical Support

Refreshing the Production over the Development and UAT and also keeping the Test Instances in sync with other instances.

Assisted Developers in tuning SQL and acquiring skills with Oracle. Identify worst performing SQL statements and tuned for better performance.

Working with SQL Loader, for loading the test data during the integration testing

Environment: SQL Navigator, Oracle, 9i, Sun Solaris 2.6, IBM – Netfinity 3500, Windows, PL/SQL, Shell Scripts, ERWin, TOAD.

Contact this candidate