Oracle DBA Resume

SUMMARY

Oracle Certified Professional with 3+ years of IT Experience.
3+ years as Database Administrator with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Oracle 11g/10g/9i.
Expertise and interests include Database infrastructure Design, Administration, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
Used SQLPLUS PL/SQL, RMAN utility and SQL Tuning Advisor.
Using EXPDP and IMPDP for export and import. Using SQL*Loader to load external data in database table based on requirement.
Expertise in RMAN and Oracle Backup and Recovery.
Design Relational Databases model and Implementation as per business needs.
Audited the activities for data access & security issues for production, testing and development database.
Strong knowledge in SQL, PL/SQL programming and debugging and strong UNIX, Linux Shell scripting experience.
Experience in Batch processes, Import, Export, Backup, DB Monitoring tools and Application support.
Expertise in very large Oracle databases of sizes up to 10 TB and experience in Oracle migration from 10g to 11g.
Ability to adapt quickly to changing environments.
Excellent communication and inter - personal skills.
Accustomed to work in a team environment.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 98/2000/XP, Vista.

Programming Languages: Oracle PL/ SQL, SQL, UNIX shell scripting

Databases: Oracle 11g/10g, 9i/8i, MS Access 2000/97, MS SQL Server

Case Tools: Designer 2000, Developer 2000, Toad, Ultraedit.

Reporting Tools: Oracle Business Intelligence, Oracle Reports, Cognos

ETL Tools: Informatica, Talend

Utilities: SQL Loader, Tkprof, Explain Plan, Microsoft Office

Versioning Tools: SVN, Accurev

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Implemented Oracle many Standalone Oracle 11g/10g/9i server as part of Agencies Data center migration.
Upgraded the database to 10.2.0.4 from 10.2.0.1 version using Patchset.
Upgrade Database from 10.2.0.4 to 11.2.0.4.
Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
Oracle performance tuning support pack and RMAN, Oracle Universal Installer, RMAN backup and recovery strategy using incrementally updated image copy backup.
AWR report generation and wait analysis for performance.
Expdp and impdp utility for exporting database across 10g and 11g version. Using version parameter for version compatibility. Using various other parameters for exporting and importing.
Writing SQL and PL/SQL for developmental work to support the product development team. Using arrays in PL/SQL and bulk collect and fetch limit to optimize PL/SQL code. Working with developers to optimize SQL queries.
Using and recommending partition if requires for large tables.
Setting up materialized view for aggregate data summary.
Good Understanding of Oracle SCM development standards and guidelines
Create Oracle EBS DB

Environment: Oracle 11g/10g/9i, Win 2008/03 Oracle unbreakable Linux 5, IIS, FTP, DTS, SSIS, ASP, XSL, XML Web Services, CSS, IIS 7/6, SSRS, SSAS. RMAN, ASM, DATAPUMPInstallation

Confidential

Responsibilities:

Install Oracle 11g, 10g, configure and upgrading databases to higher version
Maintenance/Support
Provided 24X7 on-call support to maintain all databases in production and development environments
Database maintenance, upgrades, and patches releases
Manage database users and security
Implemented ORACLE TDE
Support job processing, scheduling, real-time management, troubleshooting and storage configuration
Capacity Management for existing databases
Day to day database administration tasks
Handled client escalations related to database activities
Cloning Database from production to development
Physical and Logical backups using RMAN
Standby database setup and maintenance
Utilized Oracle Metalink for technical support
Write extensive SQL/PL-SQL code for business needs
Implement Triggers, sequences, functions.
Proactive database monitoring using custom built SQL/PL-SQL and Unix scripts
Identify, trace and tune SQL queries for better performance
Database and application developer’s problems troubleshooting
Application and SQL query tuning to help development team
Helped application development team in tuning and testing queries
Parallel query execution
Proper setting of Kernel parameters
Tablespace fragmentation checks and reorganization of tables
Design, Document, implement Database Maintenance Plan
Document processes and procedures for reuse
Improved standards and guidelines for database changes and application development
Adhered to predefined deliverables and SLA’s
Managed onsite and offshore co-ordination and communication
Design, Developed, Document, Implement and Monitor Backup and Recovery Operations (Using RMAN)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship