Oracle DBA Resume

SUMMARY

Six years of experience in the IT industry. Over five years of experience as an Oracle Database Administrator Experience with Oracle 10G, 11G R2, Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery. RMAN, Data Pump, export/import
Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.

TECHNICAL SKILLS

Software: Oracle Linux 6.1, Microsoft Windows Server 2003, 2008

Databases & Tools: Oracle 10G, 11G Release 2, (OEM) Oracle Enterprise Manager, Oracle Diagnostics Pack, Oracle Performance Pack, ERWin 3.5/4.0, TOAD, SQL*Net/Net 8, Spotlight on Oracle, SQLDeveloper

Operating Systems: Solaris 2.8/2.7/2.6, Windows NT 4.0, HP - UX 10.2/11.0, Windows XP, 7/Vista/98/95

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Installation and configuration of Oracle Linux 6.1 server
Capacity Planning of Small and Medium size databases
Identifying folder structure for databases using OFA.
Creation of databases for development and test environment.
Configuring security, roles and privileges for users.
Management of tablespaces and data storage.
Performance tuning of database and server using OEM.
Worked with ETL architect to develop ETL design.
Database and SQL tuning to improve performance of loads.
Performed SQL tuning by using Explain Plan and Tkprof.
Assisted in logical and physical database design.
Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.

Environment:Oracle 10G, 11G, Oracle Linux 6.1, Oracle DBA Studio, TOAD

Confidential

Oracle DBA

Responsibilities:

Installation and configuration of Oracle 9i server and creation of databases.
Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.
Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
Performed SQL tuning by using Explain Plan and Tkprof.
Making structural changes to the databases when database design changes are to be implemented.
Implementation and maintenance of read only snapshots and snapshot logs.
Migration from Oracle 7.3.4 to Oracle 8.1.6 using Oracle Data Migration Assistant and mig utility.
Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.

Confidential

Oracle DBA

Responsibilities:

Recovery of Database for external customer using RMAN. Used to create and maintain recovery catalog for Centralized RMAN repository. Took user managed backup (Hot & Cold) and recovery. Used SQL Loader for data loading. Used Export/Import utility for logical backup
Creation of different types of tablespaces and adding/resizing data files, multiplexing of Control file and Redo log file. Creation of user accounts, role, profile, granting permission and auditing of database. Creation of different type of indexes, analyzing and rebuilding of indexes. Creating Oracle Objects (Table, View, Sequence, Index, etc.)
Configured, Managed and Troubleshooting oracle database. Configured Listener, Shared server, Archive log mode.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship