We provide IT Staff Augmentation Services!

Oracle Dba Resume

Kenosha, WI

SKILLS:

  • Oracle Grid console management and troubleshooting
  • Configure and manage Oracle Database built on Linux
  • Oracle RAC configuration
  • Manage, troubleshoot, and configure Oracle Clustering, replication and disaster recovery
  • Experience with Oracle version 10G and higher including ASM
  • Manage and troubleshoot MS SQL Cluster 2005+
  • Implement and manage Windows multi - node Cluster
  • Support and trouble shoot Oracle Data Guard and SQL database mirroring/replication
  • Extensive experience with SQL databases

PROFESSIONAL EXPERIENCE:

Confidential, Kenosha, WI

Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g/11g databases.
  • Part of the team for Oracle database upgrade from 10.2.0.4 to 11.2.0.3.
  • Part of the team for database upgrade from 10.2.0.2 to 10.2.0.4 with logical and physical standby in place.
  • Install, manage & troubleshoot multi node multisite SQL Server clusters.
  • Configured and administer Oracle 10g/11g data guard physical and logical standy as for reporting and DR databases.
  • Creating and maintaining various databases for Production, Development and Testing using SQL Server 2000 provided significant improvements for managing clusters in multi-node architectures using windows server 2008.
  • Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Used Oracle database migration assistant and export/import to migrate the databases.
  • 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.
  • Registered database in recovery catalog & Configured RMAN backups for many databases and subsequently took the RMAN backup.
  • Prepared plans for up gradation of all critical Production Databases from 10g to 11g on Linux and DATAGUARD implementation.
  • Configured databases in OEM 10g grid control for monitoring purposes.
  • Performed SQL tuning by using Explain Plan, AWR, ADDM and Tkprof. Had troubleshot the top 5 timed wait events in AWR to tune the database performance.
  • Had tuned many problematic sql with Oracle SQL tuning advisor and SQL access advisor
  • Automated the database creation scripts through crontab and Windows Control M software.
  • Re- org of tables using new segment management feature of 10g and Quest Live-Reorg tool.
  • Provided 24X7 supports for production problems
  • Supported 40 production databases.
  • Worked in a team of 5 Oracle DBA.
  • Excellent experience with SQL Server 2000 & 2005 and MS - Access.
  • Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) and DTS packages.

Environment: Oracle 11g/10g/9i, data guard with physical and logical standby databases, Sun Solaris 10 on M5000/M3000, HP servers, Oracle Enterprise Manager,Linux, SQL, TOAD, AWR, ASH, ASM,ADDM, TPROF, Explain plan, STATSPACK, SQL tuning advisor, SQL access advisor and Oracle Golden Gate replication from oracle to oracle databases, Oracle RAC.

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

  • Provided 24X7 supports for production problems
  • Supported 26 production databases.
  • Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms.
  • SQL Server Installation, patch application, migration of databases.
  • Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
  • Recovery of database in case of database crash, disk/media failure, etc.
  • Provided System support for both development and 24/7 production environment.
  • Prepared plans for up gradation of all critical Production Databases from 10g to 11g on Linux and DATAGUARD implementation. provided significant improvements for managing clusters in multi-node architectures using windows server 2008
  • Install, manage & troubleshoot multi node multisite SQL Server clusters.
  • Implemented new features of Oracle 9i like Log Miner, Transportable Tablespaces, Locally Managed Table spaces, and Hot Standby Databases for fail-over situations, Multiple Archive-Log Destinations that support Hot Standby Databases etc.
  • Performed capacity planning and sizing of databases based on input from business.
  • Taking care of all alerts for space issues and user requests.
  • Created and Managed the Server Parameter file.
  • Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) and DTS packages.
  • Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries.
  • Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.
  • Performed database cloning from old system to new system.
  • Used EXPORT/IMPORT for table level and full database de-fragmentation.
  • Transported tablespaces between production and development databases.
  • Running scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Environment: Oracle 11g, 10g, 9i, Server Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0,AIX,HP-UX,Solaris Windows Server 2000, UNIX Shell Scripts, TOAD and TKPROF, ASM, Oracle RAC

Confidential, Houston, TX

Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g and 11g and DATAGURAD /Standby switchover/failover technologies to reduce database downtime using DATAGURAD broker.
  • 24 X 7 Production Database Administration, Support and monitoring to ensure proactive problem recognition and resolution of database issues.
  • Actively participated in upgrade and Migration of production and development Database from 9.2.0.6 to 10.2.0.2 using DBUA and applied/rolled-back DB patches whenever required. provided significant improvements for managing clusters in multi-node architectures using windows server.
  • Creating and maintaining various databases for Production, Development and Testing using SQL Server 2000.
  • Performed daily database administration tasks like user management, web connectivity, space monitoring and management, session traffic, load balancing, checking archive space, apply rate monitoring, performance monitoring and tuning.
  • Plan and perform point-in-time recovery of databases as part of disaster recovery implementation.
  • Monitor full and incremental backups by using Recovery Manager (RMAN)
  • Configured OEM (grid control) 11g,10g for diagnosing and monitoring performance related problems such as buffer get, CPU utilization, top DB wait events and top SQL etc .
  • Install, manage & troubleshoot multi node multisite SQL Server clusters.
  • Write SQL/Unix Shell Scripts for gathering capacity planning information, automated AWR/Statspack report collection and compiling estimates based on new client requirements.
  • Reviewing DB application patches before applying also advised changes whenever required.
  • Monitor logical Backup and Recovery by import & export, Data pump, for databases.
  • Troubleshooting, analyzing explain Plan, STATSPACK, ASH, AWR reports and tracing user sessions for performance analysis.
  • Working with Oracle Support, raising SR’s for different Oracle issues using Oracle METALINK
  • Ensuring high availability of Production, Test, and development databases for users to minimize database downtime.
  • Performed database restore for test and development database.

Environment: Oracle 11g, Oracle 10g, Oracle 9i, AIX, HP-UX, Solaris, Linux, Windows Server 2000, TRIVOLI storage manager, ASM,NIX Shell Scripts, DBA Support Portal(ticket system), Oracle Metalink, TOAD, TKPROF, Putty.

Confidential

Oracle DBA/Oracle Developer

Responsibilities:

  • Performed Database Performance Tuning and Monitoring of Databases.
  • Design and implement Security Policies.
  • Deploying roles, privileges, profiles policies for group of users
  • Configuring the Auditing of database at DB or OS level, to monitor illegal use of database
  • Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
  • Controlling and monitoring user access to the database.
  • Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet
  • Created schemas with partitioned external tables for a production environment, using SQL Plus.
  • Involved in extensive design of Sql and shell scripts.
  • SQL Server Installation, patch application, migration of databases.
  • Install, manage & troubleshoot multi node multisite SQL Server clusters.
  • Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
  • Configuring the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
  • Administered Oracle 9i and Infrastructure support using Oracle OEM.
  • Performed test and implemented upgrade of Oracle 8i databases to latest Oracle version (9.2.0) on UNIX.
  • Performed requirement analysis, capacity planning for databases and system infrastructure.
  • Created and managed multiple Instances on one server for testing and development.
  • Recovered and rebuild databases on crashes and media failures.
  • Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
  • Used Stored Procedures for performing complex business logic involving database access and for validating information
  • Responsible for supporting the database with logical backup as well as cold and hot backups
  • Created variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
  • Built Databases and refreshed them by executing the scripts.
  • Developed shell scripts for day to day database administration activities.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Developed validation procedures and error reporting on the data in the intermediate tables
  • Worked on handling exceptions
  • Successfully installed and configured Oracle RAC, ASM and non-RAC database on Solaris, HP-UX, Linux, implemented data files using either ASM or on raw devices for some project.
  • Written SQL Loader Scripts for data extraction and transformation
  • Created Stored Procedures and functions to be used as a part of development work.

Hire Now