SUMMARY

• Over 8 years experience in Oracle Database Administration.
• Worked on9i, 10g, 11g R2 Oracle and SQL Server 2005/2008 on SQL Server RDBMS.
• Proficient in Oracle Backup and Recovery using RMAN and user managed backups.
• Proficient in ASM creation, administration and management.
• Proficient in data refreshes and data movement with export/import and Data pump
• Build, administered and managed Data Guard.
• Proficient in Flashback Recovery and other restore/recovery techniques.
• Experience monitoringOracleRDBMS availability, database exports, table space, and extents reports.
• Worked on Grid control for monitoring
• Comfortable with both command - line and GUI interface.
• Install and managed databases on Windows.
• Very proficient on Linux, AIX, HPUX and Solaris.
• Poses strong administrative skills in RHEL.
• Managed different sizes of database ranging from100GB to 2.5TB.
• Experience inon-callsupport and24x7DBAforproductionenvironment.
• Extensive experience onproviding solutions to developer/user requests.
• Extensive experience in resolving issues and bugs related to databases.
• Proficient in performance and maintaining large volume of data.
• Experience on Migration and Upgrading from 9i to 10g to 11g R2.
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for hot and cold Backups.
• Hands on experience of database Backup and Recovery using RMAN.
• Strong experience inOEM(OracleEnterprise Manager),OracleData Guard, SQL Loader and STATSPACK, Explain Plan and TOAD.
• Proficient in writingUNIXShell scripts to automate business process and daily backup.
• Worked withoraclewhile troubleshooting RDBMS/patching issues.
• Hardworking, result oriented good interpersonal and communication skills.
• Extensive experience in supporting multiple production databases running24 x 7mission-critical/OLTP applicationsdemanding high availability and increased performance

TECHNICAL SKILLS

Operating Systems: RHEL, Windows, AIX, CentOS, HP-UX, AIX

RDBMS: Oracle9i, 10g, 11g R1/R2

High Availability: HAS, ASM, Data Guard

Languages: SQL, Shell scripting, T-SQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Database Modeling: TOAD

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Oracle Database Administrator

Responsibilities:

• Create & maintainOracledatabases across multiple platforms.
• Builds included everything from configuring the Solaris, AIX and HP-UX environments, installingOraclesoftware and patching to desired levels including one off patches, creating instances, recompiling invalid objects, recalculating statistics.
• Develop, Implement and administer database policies and procedures.
• Applied patches and migrated databases from one platform to another, along with upgrade from Oracle9i to 10g and maintain an updated platform matrix.
• Workedwith developers and troubleshoot applicationsissues.
• Increased company's main application performance, by providing proactive tuning and setting database maintenance plan for mission critical application running
• Conducted optimization and performance tuning of database, SGAand space management.
• Managed archived redo files, loading data for users by using SQL*Loader
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs, periodically clean up these file systems, and also monitor RMAN Hot Backup Scripts.
• TunedOracleInitialization Parameters.
• Support developers in tuning Database and applications for optimal performance.
• Upgrade, analyze and testing of the test and production database.
• Created database physical/logical layout design and procedures for production, Development, test servers.
• Performed capacity planning to create and maintain the database environments.
• Gathered Database Instance Statistics & generated reports using STATSPACK
• Design and implement database backup and recovery procedures using RMAN and Data pump.
• Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security.
• Configuration of server with OLTP system, runtime connection & load balancing.
• Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
• Implemented security protocols for the database.
• Provided 24x7 on-call supports for production and Test databases.

Environment: Oracle, OEM 11g, RedHat Linux, DataGuard, SQL, PL/SQL, SQL Loader,Oracle11g, Windows NT, Unix Sun Solaris 9 and IBM AIX 5.3, 6.1 servers, Lotus Notes, Salesforce, Rational change, Google corporate email.

Confidential, Milpitas, CA

Oracle DBA

Responsibilities:

• AdministratingOracleProduction/staging/ Development databases.
• InstalledoracleCluster ware, ASM binaries,Oracledatabasesoftware, created RAC databases on RHEL4.x
• Managed cluster resources, modified resource settings for HA solutions.
• Administer ASM by managing disk groups with external redundancy.
• Upgrade Databases from 9i to 10g R2.
• Performed RMAN backups (full backups, archived log backups and incremental backups).
• Implementing Backup strategy on the basis of RMAN & Data Pump utilities.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Perform database analysis, design, coding, testing and implementation of database structures.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Utilize SQL Loader to load data from flat files
• 24 X 7 Production Support. Responsible for Backup & Recovery forOracleDatabases
• Applied CPU patches.
• Worked on databases on Windows.
• Building and Re-building Indexes and Monitoring Index Usage

Environment: Oracle10g, 11g, Toad, RMAN, SQL*Loader, Windows, RHEL 5.x, Solaris 5.x

Confidential, Norfolk, VA

Oracle DBA

Responsibilities:

• Setup and configure SunOS, IBM AIX server environment forOracledatabase
• Setup Unix server environment parameters forOracledatabase
• Created/maintained profile forOracleDBAusers and other users for security
• SetupDBAgroups, file systems, home locations, andORACLE SID for database creation
• Created databases
• Performed database building and release implementation, troubleshooting/debugging and post release objects recompile for applications
• Performed data broke fix for development
• Maintainedtablespaces/datafiles, partitions for performance and space usage
• Created/ maintained/rebuilt tables, indexes, constraints, partitions
• Created/ customized shell scripts to do various database jobs
• Scheduled/ maintainedcronjobs anddbmsjobs
• Setup multi master replications,repadminuser, db links, rep groups, rep objects, and refresh groups
• Created/ maintained/ refreshed materialized view andmviewlog
• Performed, maintained, & monitored jobs of data loading, databases replication and backup
• Maintained storage and space efficiency such as database blocks de-fragment, tables and indexes rebuild and stats gather
• Administered user/schema/group/role/profile privileges for security enforcement
• Implemented release buildings of database, load java objects, tuning SQL queries, PL SQL, functions, procedures, and packages to fix issues with the developers, testers including offshore developers in all environments
• UpgradedOracle9i to 10gR2, patch implementation including environment and parameter configuration, backup, system setup
• Performed Ad hoc tasks from developers, testers and project managers.

Environment: SunOS 5.8, AIX 5.3, GNU/Linux,Oracle9i /10g, Windows, SQL Plus, SQL Developer, OEM, RMAN

Confidential, Wilmington,DE

Oracle Database Administrator

Responsibilities:

• Extensively used system life cycle for project planning
• Extensively worked in DSS and Data warehouse
• UpgradedOraclefrom 9.2.0.3 to 9.2.0.6 and migrated database as part of tech refresh
• Created standby (Data Guard) database as part of replication
• Configure database control parameters for database - DB block size, DB Cache Size, open cursors, Query rewrite enabled, open links, tuning database memory components like SGA, Shared Pool, Library Cache, Dictionary Cache and buffer Cache, Parallel Automatic Tuning
• Managed database and schema security using roles, profiles and VPD
• Extensively worked with distributed database environment like Materialized Views for fact tables and cubes
• Extensively working with troubleshooting databases and tuning like I/O, SQL tuning, memory this includes distributing database files across disks, explain plan, TKPROF, SQL Trace, Analyze, Hints, Stats pack etc.
• Developed complex PL/SQL stored procedures, functions, packages and triggers
• Created and implemented database monitoring scripts using PERL
• Provide critical production and development support to Application users and developers
• Handling huge databases like 5, 8 and 10+TB databases

Environment: Oracle10g/9i, RMAN, OEM, BMC Tools, PERL, Solaris 2.8, IBM AIX, Sun Systems and IBM Servers, HU-UX, HP9000