SUMMARY

• An Apt Oracle Database Administrator with over 8 years of extensive experience with Oracle 8i, 9i, 10g, 11g .
• Expert - level skills in Installation, Configuration, Upgrading, Patching, Troubleshooting and Performance tuning of oracle databases on different operating platforms.
• In-depth experience with all facets of Database Design, Backups and Recovery, Security Management, Disk Space and File System Management and Monitoring.
• Experience in providing 24/7 support to Production, Test, Development databases comprising of some of the challenging environments from versions 8i through 11.2.0.3.
• Experience in using backup/recover strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Cloned of various databases using various methods including create control file, RMAN.
• Experience with ASM and RAC setup and administration on Oracle database.
• In depth knowledge of Oracle Database Tuning, Usage of SATSPACK, Database Migration, AWR, ADDM, ASH and UNIX native commands.
• Experience in creating non-production instances using datapump utilities
• Designed backup policies for Single node and multi node environments using RMAN.
• Configured Data guard environments for disaster recovery and high availability.
• Experience with Red Hat Linux, HP-UX, AIX, Sun Solaris and Windows NT/2000/2003.
• Managed many OLTP, OLAP/Datawarehouse database systems
• Worked on Sysadmin tasks like creating and managing users and their responsibilities.
• Proficient in developing Oracle PL/SQL based applications using Oracle Stored Procedures, Functions Packages, Triggers, Materialized views.
• Experience in writing UNIX Shell scripts to automate business process and daily backup, maintenance, enhancement, designing of data dictionaries and performance tuning.
• Knowledge in Cloning databases for development/testing environments using traditional backup methods as well as using RMAN.
• Experience in database design and data modeling using tools such as Erwin.
• Proficient in OEM (Oracle Enterprise Manager),Data Guard, SQL* Net, SQL * Loader, SQL Navigator, TOAD, Export, Import and SQL*PLUS.
• Building Dataguard Databases LPDC & SIDC.
• Strong analytical and problem solving skills. Ability to work within team environment and independently when needed.
• Strong interpersonal and leadership skills worked with users and have tried to resolve their technical issues in the applications and database issues.

TECHNICAL SKILLS

OPERATING SYSTEM: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows NT/2000/2003.

DBMS: ORACLE 8i/9i/10g/11g, MS ACCESS, SQL Server 2003/2008.

TOOLS: Oracle Enterprise Manager, Power Designer, ERWIN, TOAD, SQL* Loader, SQL*Plus,Crystal Reports, RMAN, exp/imp, Datapump.

LANGUAGES: SQL, PL/SQL, UNIX Shell scripting, C, C++, SAS, VB, ASP.NET.

ETL: SQL Server Integration Services(SSIS).

PROFESSIONAL EXPERIENCE

Confidential, Cherry Hill, NJ

Oracle Database Administrator

Responsibilities:

• Create and Managed user, Indexes, table spaces, datafiles, logfiles as per needed.
• Worked with other Team members of the production support group to resolve daily tickets/issues created in their ticketing System.
• Create standby database using Dataguard to provide high availability.
• Work on database backups and disaster recovery strategies using RMAN.
• Provided support for database backup, recovery, load and refresh activities
• Applied client patches and other patches as required.
• Support production databases on24x7 on call basis.

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

• Administered and maintained Oracle10g,Oracle 11g databases along with 2 node RAC databaserunning on Sun Solarisenvironments.
• Provide Production environment support and Troubleshoot performance issues.
• Perform database performance monitoring and tuning using OEM Gridto ensure databases run at peak performance. Worked on Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Created and maintained database objects using TOAD or SQL*Plus.
• Performed Object migration/Code promotion from one database environment to another including production releases either using Datapump utilities.
• Create and Managed user, Indexes, table spaces, datafiles, logfiles as per needed.
• Performed disks add, disks drop and disk rebalancing as per required in ASM.
• Work on Functions, Procedure, triggers, synonyms and profiles as per needed.
• Provided support for database backup, recovery, load and refresh activities.
• Design and Implement database security by defining roles and privileges.
• Applied Regular Security patching on oracle database and interim patching for various bug fixes on database products.
• Created UNIX shell scripts and SQL scripts for routine databases administrative duties.
• Worked with other Team members of the production support group to resolve daily tickets/issues created in their ticketing System.
• Scheduled jobs in Autosys including Backup, monitoring Scripts and other maintenance, security jobs.
• Ensured batch jobs and loads completes successfully every day.
• Supported application development through SQL tuning.
• Ensured DR servers are in Sync with production environment.
• Startup/Shutdowndatabase environments as needed.
• Liaised and worked with Oracle support to resolve database issues.

Environment: Sun Solaris 5.10,Linux,Oracle 9i and 11g, SQL plus, Import/Export, Datapump, TOAD, Oracle Grid Control, Oracle RAC, Oracle Dataguard, Automatic Storage Management, Oracle Application Server.

Confidential, Stamford, CT

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle9i, 10g, 11g databases on Linux 5.4 environment.
• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases
• Implement Oracle 10.1.2 2 node RAC on Enterprise Linux 5.4 in a Test environment.
• Migrated databases from 9i to 10g, 11g and interplatform migrations.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Create standby database using Dataguard to provide high availability.
• Create UNIX scripts to monitor databases for alert log messages, tablespaces growth and database health check.
• Created database objects and table with DailyRange partition as per the requirement.
• Create and Manage user, table spaces, roles. Profiles, synonym, datafiles etc.
• Perform Capacity planning to support terabyte databases.
• Create and implement backup and recovery strategies using RMAN configuration.
• Provide troubleshooting and problem solving support to application developers.
• Cloned databases using user-managed as well as RMAN.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Tune and optimize SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR and ADDR report generated from snapshots taken at the peak business hours.
• Performed data Migration using exp/imp or Datapump utilities and transfer .dmp file either using SCP, FTP or SFTP to different servers as per requested.
• Applied client patches and other patches as required.
• Support production databases on24x7 on call basis.

Environment: Oracle 9i/10g/11g, RAC, TOAD, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN, UNIX and Linux, Oracle DATAPUMP.

Confidential, Brampton, ON

Oracle DBA

Responsibilities:

• Creation and configuration of Oracle 10g database.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Installing and troubleshooting RHEL 4.0 for Oracle 10g.
• Upgrading the database from existing Oracle 9i to Oracle 10g.
• Managing Redo log files, Tablespaces, Data files, Indexes, Undo Segments, and Temporary segments.
• Responsible to write complex PL/SQL stored procedures and UNIX shell scripting.
• Involved in advance recovery methods like PITR and TSPITR.
• Work on logical backup using and full/partial export/import and Data Pump.
• Work on database backups and disaster recovery strategies using RMAN.
• Troubleshoot Database performance issues using TKPROF utility and STATPACK utility. Tuned database for optimum performance.

Environment: Oracle 10g/9i, RHEL 3.0/4.0, Windows 2000/NT, Enterprise Manager, TOAD, RMAN, Data Guard, PL/SQL, UNIX Shell Scripting.

Confidential

Jr Database Administrator

Responsibilities:

• Oracle installation, Creation of database, which includes physical and logical design.
• Created and implemented Database Backup script for Hot backup, archive log backup and catalog syncing
• Installed Oracle 10g on development environment on HP UX and Windows Server 2008. Upgraded Oracle database development and testing using manual upgrade process
• Administered SQL Server database for Yellow Pages web synonyms mapping for categories and directories services.
• Migrated data from sql server to Oracle for data validation and reporting.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of development, UAT, and production environments.
• Perform server installations, configuration, upgrades, maintenance of Data and Replication servers, contingency testing, implementation and enforcement of the standards, scripting and documenting.
• Provide 24x7 production supports on rotated basis. Environment includes multiple Oracle Servers, distributed database systems, Oracle replication across multiple locations
• Maintain disaster recovery and replication databases to reduce the impact of any database or server outages configuring and maintaining replication environment. Setup Replication Site, Creating Master Groups, and Snapshots Group. Designing Conflict Resolution Methods, Refresh Methods. Trouble Shooting and Resolve Replication Problems. Security setup for multimaster and snapshot replication
• Tuning the server environment, including the CPU and RAM, Monitoring and tuning disk I/O subsystems
• Detecting and correcting instance performance problems. Locating and tuning SQL statements
• Tuning SGA, Rollback segments, Latch contention Issues, Optimize Sort Operation
• Create appropriate indexes for queries and suggesting changes to application developer
• Design and Perform backup schedules
• Testing the production archive log files by performing time-based recoveries on simulation databases
• Performs extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment
• Creating objects required for the application team after carefully estimating the sizes
• Monitors and maintains all production and development databases in a proactive manner to minimize the potential for database outages and performance problems
• Applied, tested & administered Patches/Minpacks/Mega Patches in Development/Test/ Production.
• Talked to Oracle Support, opened TARs and taken pro-active corrective actions.
• UNIX shell scripts for database administration, backup and performance monitoring.
• Electronically documented all the Development/Test/Production Activities for the client Record.

Environment: HP/UX, Solaris, Windows Server 2000/2003, Oracle 8.0.5/8.1.7/9i, Oracle Advanced Replication, Perl, Pro*C, Oracle Expert, Shell ScriptEDUCATION