PROFESSIONAL SUMMARY:

• Work as a highly motivated Oracle DBA with team skills, problem solving skills and communication skills maintaining high customer satisfaction and increasing productivity of the company.

TECHNICAL SKILLS

Tools: Oracle 9i/10g/11g, RAC, Data guard, Streams, ASM, RMAN, EM Grid 9i/10g/11g, expdp, impdp, SQL loader, SQL developer, TOAD, SQL, PLSQL, AWR, ADDM, TSM/TDP

Operating Systems: Linux, Unix, AIX, Sun Solaris, Windows 2003

Databases: Oracle 9i, 10g, 11g, SQL Server 2005/2008 R2

Certifications: OCA 9i, OCA11g

PROFESSIONAL EXPERIENCE:

Oracle DBA Developer

Confidential

• Administer multiple Oracle databases including versions 9i, 10gR2, 11gR2
• Administer Oracle 11g Grid control.
• Build Oracle databases, apply patches on regular basis.
• Build SQL server cluster databases.
• Provide day-to-day support to Oracle databases and SQL server 2005/2008 R2.
• Provide support to different application teams.
• Refresh data from production to non-production databases
• Provide support to backup and recovery of databases using RMAN with TSM/TDP.

Oracle DBA Developer

Confidential

• Provide production support for multiple databases non-RAC, RAC, Streams and Grid11g.
• Support database versions 10gR2, 11R2 on Linux servers.
• Do ETL of data from non-oracle sources to oracle tables using SQL loader and automate the process using windows scripts, triggers and transform data using procedures.
• Provide support to end-users from different teams like development, business etc.
• Provide admin support to APEX applications.
• Provide support for security vulnerabilities for the databases.

Oracle DBA

Confidential

• Provide 24/7 on-call support for multi-terabyte databases version 9i, 10g and 11g through Grid10g.
• Provide production support for multiple databases non-RAC, RAC, ASM, Data Guard and Streams.
• Provide support to applications like Retek, WMS, SOA.
• Ensure data and media recoverability by doing RMAN backups on recovery.
• Convert non-ASM to ASM databases and vice-versa.
• Clone Production databases to Development, QA and Training databases based on requests.
• Coordinate with different customers like business users, developers, managers etc for business reasons.
• Load and unload data using data pump, export and import into partition tables.
• Install, configure and maintain Oracle database and Oracle client as business requirement.
• Set up procedure to audit database regularly to comply with the PCI standards.
• Upgrade and apply Critical Patch Updates to databases and oracle software for security reasons.
• Handle databases on multiple operating systems like AIX, Sun Solaris, Unix, Linux, Windows 2003
• Monitor and tune the database using AWR, ADDM, SQL Tuning Advisor for optimum performance
• Write shell scripts and cron jobs against the databases for business reasons.
• Create objects based on customer requirements for project enhancement.
• Partition tables based on business needs for a better performance.
• Worked on complete project/software life cycle and co-ordinate with different teams to complete projects.

Oracle DBA

Confidential

• Doing Oracle DBA Production Support, to make sure the database is available 24/7
• Backup Production, Development, QA and Training databases everyday using RMAN and NetVault.
• Cloning production databases for Development, QA testing and Training based on requests.
• Upgrade database to versions which is compatible for the patch updates.
• Apply CPU to databases of all different versions for security requirements.
• Monitor the database using EM Grid10g.
• Do data pump, export and import for data loading and unloading.
• Trouble shooting any issues and make sure database was available to the developers 24/7.
• Troubleshoot any backup failures and fix the issues and do database recovery when necessary.
• Coordinate with developers and users determine their requirements.
• Work with different team to assist with different projects and cross-functional projects.
• Restore any database based on the requirement of the IT team.
• Create roles, db links, privileges based on the business needs and assign them to the users.
• Do any database installs as well as forms/reports installs as and when required.
• Manage and Administer Business Objects accounts for developers.
• Work on data dictionaries and schemas.
• Document all troubleshooting steps for future reference.

Contractor

Confidential

• Monitor the database using EM Grid10g.
• Do troubleshooting with database as well as Grid.
• Maintain development databases for the developers and QA testers.
• Refresh Development databases from the Production databases.
• Make sure database was available to the developers 24/7.

Oracle DBA/APEX Developer

Confidential

• Administered six Oracle Database 10g servers on both linux and windows.
• Administered Oracle Application Server 10g on Linux platform.
• Monitor and administer all the systems and their applications using Grid Control 10g.
• Build databases or data marts to store survey data, trawl data and cruise data.
• Handle Data editing, cleansing, validation, auditing.
• Handle Data loading using SLQ Loader, EXPORT, IMPORT, DATA PUMP utilities.
• Develop SQL, PLSQL Procedures, Triggers and Functions.
• Develop Oracle Apex Forms/Reports for biological scientists to analyze data.
• Maintain Oracle security and maintain high performance at all times in viewing and downloading data from the database.
• Wrote Linux shell scripts to backup oracle data.
• Develop web pages using Macromedia Dreamweaver, Fireworks and Adobe Photoshop.
• Expand the database capability to store large images and reports like pdf, gif, jpeg etc
• Create APEX reports to display the large objects like pdf files and images.
• Provide Oracle support to team members and other colleagues.
• Create email accounts, VPN accounts.
• Configure Metalink account for configuring with Enterprise Manager Grid Control.
• Handle all data administration activities from installing software, upgrading etc.