We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

PROFESSIONAL SUMMARY

  • Over 7+ years of experience as a Oracle DBA (11g, 10g, 9i) in IT industry.
  • Expertise in Oracle 11g, 10g, 9i on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4.0/2000/2003 in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility.
  • Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM, SQL Navigator and TOAD.
  • Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, Database Upgrade from 9i to 11g, troubleshooting and basic knowledge of networking and security.
  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK
  • Creation of databases, instances, table spaces, data files, rollback segments.
  • Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers and procedures.
  • Design and implementation of Backup & Recovery using RMAN and SQL scripts.
  • Proficiency in using Log miner, SQL *Loader and Export/Import utilities.
  • Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
  • Setting up Standby Database / Oracle DataGuard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
  • Experience in Migration of Oracle 9i and 10g databases to 11gr2.
  • Experience in installation and configuration of Oracle RAC.
  • Experience working on PL/SQL programming on different databases like Oracle8i /9i/ 10g/ 11g.
  • Experience as 24x7 Production DBA as well as application (development) DBA.
  • Knowledge on Golden Gate with installation, configuration and troubleshooting various issues.
  • Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Installing and Configuring SQL Server 2005 successfully. Transforming data from various data sources using OLEDB connection by creating various DTS packages.
  • Monitoring and managing the use of disk space, memory and connections, Initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, Creating and using segments.
  • Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.
  • Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables
  • Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.
  • Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.
  • Excellent written and verbal communication skills.
TECHNICAL SKILLS

Operating System: Solaris, Linux, HP-UX, AIX, Windows 2000 server, Windows 95/98/2000/NT/XP, VMware
Databases: ORACLE 11g, 10g, 9i, 8i, MS Access,
DB Tools: SQL*Plus, SQL*Loader, Export & Import utility, OEM, Database Configuration Assistant, RMAN, Toad, PL/SQL developer, AWR, ADDM, DataGuard
Languages: SQL, PL/SQL, HTML, Java, C, C++, Perl Scripting, K sh. C shell
Internet: ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript, Flash MX
Software Applications: MS Office, Dream Weaver MX, Adobe Photoshop, MS FrontPage
GUI Tools: Oracle Enterprise Manager, Visual Basic 6.0

TECHNICAL EXPERIENCE

Confidential, Irving, TX Sep 2011- Present
Oracle DBA
Responsibilities:

  • Installed, configured and maintained oracle databases on Linux and Solaris environment.
  • Created Database as per requirements using DBCA and scripts.
  • Startup and Shutdown of individual instance on RAC 2 node environments.
  • Implemented and supported two node RAC environments.
  • Managed ASM diskgroups via asmcmd and database control.
  • Worked on replication technologies such as Shareplex and Dataguard.
  • Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment.
  • Migrated and upgraded oracle database from 9i to 10g on Veritas Cluster environment.
  • Setup jobs and events using Enterprise Manager (OEM) console.
  • Implemented dataguard (physical) for high availability/disaster recovery solution.
  • Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery
  • Wrote shell scripts and scheduled them in CRON for monitoring and health checks of database
  • Monitoring Database growth and space administration.
  • Frequent analysis of objects and schemas.
  • Experience in developing, maintaining and debugging procedures, packages and functions using sql developer.
  • Export & import at full, schema, tablespace and object level.
  • Responsible for Online/Offline database backups and managing Database recovery with RMAN
  • Worked on backup and recovery strategies using RMAN.
  • Performed database tape backups using netbackup and RMAN.
  • Installed, configured and resolved issues on golden gate replication technology.
  • Refreshing or cloning databases from production to development using RMAN and OS level scripts
  • 24X7 support for databases and production operations teams
  • Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database

Environment : Oracle 9i, 10g, 11g, RMAN, Solaris, Linux, HP-AX, VMware, RMAN, RAC, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, Shareplex replication.

Confidential, Franklin Lakes, NJ Jul 2010 – Aug 2011
Oracle DBA
Responsibilities:

  • Perform installation, configuration and of Oracle databases on Solaris, Linux, HP-UX and VMware.
  • Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies
  • Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment
  • Setup jobs and events using Enterprise Manager(OEM) console, enrolled users and maintained system security by controlling and monitoring user access to the database
  • Responsible for developing different databases at various stages of implementation of Projects (Databases for conversion of data, interfaces, training and development)
  • Used Import/Export and SQL * Loader utilities to move data and objects
  • Monitored and maintained database growth and tablespace utilization
  • Devised backup/recovery strategies and implemented it in line with Business requirements (RMAN)
  • Configured and Tested Backups for Oracle Databases by restoration and recovery
  • Involved in the performance tuning and query optimization
  • Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR)
  • Installed and Configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (DataGuard) using CRS and ASM .
  • Upgraded Oracle Database from 9i to 10g and 11g
  • Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times
  • Designed and Implemented Oracle Disaster Recovery Solutions for customers
  • Applied patches in production and test instances
  • Managing Database (User management, Table space management, Performance related issues).
  • Knowledge on basic architecture and functioning of Golden Gate technology.
  • Strong hands-on partitioning and performance tuning skills
  • Strong SQL and UNIX scripting skills
  • 24X7 support for databases and production operations teams
  • Assisting Developers in writing and tuning their queries

Environment : Oracle 9i, 10g, 11g, Solaris, HP-UX, Linux, VMware, RMAN, RAC, SQL*Plus, SQL, AWR, Toad, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, Data Guard, SQL, SQL Server.

Confidential, Redlands, CA Sep 2009- Jun 2010
Oracle DBA
Responsibilities:

  • Supported more than 40 databases size 1 GB to 1.1 TB having maximum 3 instances for each database. Experience in taking Daily and Weekly Physical backups using RMAN
  • Involved in writing korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and to generate Multi-Master Replication. Databases are reorganized to improve performance
  • Developed and maintained stored procedures, functions, packages, and triggers and used Oracle standard packages. Daily monitoring Alert logs, growth of table spaces, size of the tables, top sessions and top 10 SQLs
  • Developed complex queries and PL/SQL procedures on Data Warehousing environment to facilitate strategic plans to higher levels of management. Created Oracle database redo log members and groups managed on-line redo log files. Responsible for Oracle database performance tuning.
  • Cloning of production database to the test environment using Recovery Manager (RMAN)
  • Database Administration and Planning including logical design, physical design, backup & recovery
  • Implemented DataGuard (Standby) for high availability/disaster recovery purpose
  • Developing a backup and recovery strategy and tested several recovery scenarios
  • Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc
  • Installation of Microsoft SQL Server and Backup Server.
  • Database Planning and designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions
  • Creation of Database Devices and Databases.
  • Configured, implemented, supported, and maintained physical and logical databases.
  • Data transfers using BCP. Granting roles and permissions to SQL server users, fixing super user permission, granting & removing permissions of all users, providing security administration by creating groups, users with appropriate roles checking the database Consistency.
  • Monitoring and managing the use of disk space, memory and connections, Initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, Creating and using segments.
  • Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash
  • Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables.
  • Environment: Oracle 11g/10g/9i, Red Hat Linux, AIX, WINDOWS NT/2000, RMAN, RAC, Data Guard, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, SQL Server 2000, SQL Diagnostic Manager, SQL Compliance Manager.

Confidential, Pittsburgh, PA Sep 2008 – Feb 2009
Oracle DBA
Responsibilities:

  • Installation, up gradation and Maintenances of Oracle RDBMS on Linux & Windows platforms.
  • Worked on preparing cluster, configuring and Installation of Cluster ware and Oracle RAC on Red Hat Linux.
  • Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
  • Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
  • Restore and Recovery of database in case of database crash, disk/media failure.
  • Created mappings using transformations to load the data into the target.
  • Installed and configured Standby database (Data Guard) for high availability/disaster recovery purpose
  • Applying patches and works closely with Oracle to make Application environment Up to date.
  • Backups & Recovery Maintenance, Databases Performance Tuning.
  • Typically involved in database Designing, creation and maintenance.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Created users and grant privileges according to the requirements.
  • Export and import of database objects using Data pump utilities EXPDP and IMPDP.
  • Developed shell scripts and PL/SQL procedures and scheduled CRON jobs and DBMS_JOBS to monitor the database performance and for user management.
  • Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
  • Provided System support for both development and 24*7 production environments.

Environment: Oracle 11g/10g/9i, Red Hat Linux, AIX, WINDOWS NT/2000, CRON, RMAN, RAC, SQL*Plus, Data Guard, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, STATSPACK.

Confidential, Bangalore, India Sep 2006 – Aug 2008
Oracle DBA
Responsibilities:

  • Worked in Geographically distributed Onsite - offshore Model.
  • Planning for Oracle DB creation on Linux, UNIX and Solaris environment by providing the requested user with the Database creation template and getting all the required information from the users
  • Oracle Client and Server installation on Solaris development, acceptance and production server
  • Write scripts for database backup using perl and shell scripting language
  • Monitoring Database growth and space administration
  • Wrote scripts to analyze objects and schemas of Oracle databases
  • Resolved performance related and connectivity issues using pl/sql queries for developers.
  • Involved in User management, creating role, profile, dblink, synonyms and materialized views.
  • Performed RMAN backup & Recovery for development, acceptance and production servers
  • Refreshing or cloning databases from production to development
  • Wrote Unix shell scripts & PL/SQL scripts for daily system performance & health checks.
  • Successfully manipulated Stored Procedures, Functions, Triggers and packages using TOAD and pl/sql developer.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
  • Wrote XML scripts for the application as per the customer requirements
  • Creating HTML pages for the front end as per the customer requirements
  • Trained junior database administrators and developers on DB tools and techniques
  • Frequently interacted with users and customers regularly.

Environment: Oracle 9i, 10g, Solaris, Linux, PL/SQL, TOAD, PL/SQL developer, UNIX scripting, Html, XML, Import/Export Datapump.
Confidential, India Jun 2005- Aug 2006
Oracle DBA

Responsibilities:

  • Monitored all the activities of production, test and development databases of BT.
  • Installed, configured and upgraded oracle software on different operating systems.
  • Database designing and implementation.
  • Database creation as per organizational needs.
  • Database security by creating users, roles and grants on objects
  • Applied the patches on all databases.
  • Granted quotas to users on different tablespaces.
  • Creation and management of logical and physical objects
  • Created profiles and granting to users to protect system resources
  • Taken Online, offline and logical backups.
  • Monitoring night jobs and scripts for automation of backup and other jobs.
  • Performed application tuning by using explain plan and analyzing objects
  • Performed database tuning by using tools like tkprof and stats pack.
  • Added or altered the DB parameters at session and instance level dynamically and or in offline.
  • DB links creation for all remote databases.
  • Monitored alert log for any database issues.
  • Configured the Enterprise manager and monitoring database activities.
  • Designed cloning strategy from production databases to development databases.
  • Daily conference with onsite project manager regarding issues and whiteboard activities.
  • Preparing the documentation as per the organization standards given.

Environment: Sun Solaris 2.8, Windows NT/2000, Oracle 8.1.x/9.0.1/9.2.0, PL/SQL, SQL, OEM

REFERENCES
Available upon request

Hire Now