We provide IT Staff Augmentation Services!

Oracle Dba Resume

AtlantA

SUMMARY:

  • Over 8+ years of experience in Database, Software Development including Analysis, Design, Development and Testing of various applications in Oracle Forms/Reports environment
  • Having 6 years of relevant experience in development Infrastructures and production database environments.
  • As a Database Administrator, manage and support database systems, develop and design database and related infrastructure and delivery of database change.
  • Responsible for own learning and development. Have a working knowledge of the Bank's IT infrastructure components and the processes required to maintain the infrastructure.
  • Have an awareness of current IT development and live systems, banks architectures and strategies and computing trends.
  • Have experience of different databases types & associated management techniques (data warehouses, Online transaction processing databases).
  • Have experience in database administration on distributed platforms.
  • Participating in on - call rotations.
  • Have a working knowledge of the technical interfaces to other business and computer systems and infrastructure components to be able to assess risk factors of a change, specify changes and support other areas in their implementation of change
  • Strong analytical ability, Excellent communication skills.
  • Good team player and experienced in liaising with Principals.

TECHNICAL SKILLS:

Languages\ Operating Systems: SQL, PL/SQL, SQL * Plus UNIX, Linux, Sun Solaris, HP-Unix

Tools: SQL Navigator, PL/SQL Developer, Oracle 8, 8i, 9i, 10g, 11g TOAD, SQL Developer

Protocols: Oracle Databases ( OCP ) - 9i / 10g / 10g RAC / 11g ( OCM 10g - in progress )

Others: ITIL (V 3.0 )

EXPERIENCE:

Oracle DBA

Confidential, Atlanta

Responsibilities:

  • Assisting development team
  • Index rebuilding and analyzing tables as per Client’s request
  • Creating / add / split / rename - partitions as per the requirement
  • Creating read-only schemas as per the requirement
  • Grant access privilege for schema objects as per the requirement
  • Monitoring user sessions duing peak hours as per user request
  • Troubleshooting errors after implementing in dev environment.
  • Managing development and UAT databases at OFFSHORE
  • Performing all DB tasks as per all OFFSHORE development team (Cochin/Bangalore/Hyd)
  • Coordinating with ETL admin team and monitor informatica sessions
  • SQL tuning as per user requirement
  • Backup and restore at schema / object level as per users requirements
  • Monitor daily backups ( Lvl-0 & archive backups thro RMAN )
  • Generate AWR reports and analyze as per user request
  • Communicating with Oracle support for SRs as per onsite team request
  • Schema refresh / object refresh - as per user request
  • Tablespace defragmentation activities as per onsite team request
  • Executing Migration scripts as per the schedule ( DB changes only ), as per user request
  • Managing partitions and troubleshoot exchange partitions issues through PACKAGE
  • Verifying RMAN backups
  • Bouncing cluster and database instances during server reboot ( as per the request )
  • Tuning Heavy database loads
  • Verifying archive log deletion script ( RMAN ) on daily basis
  • Construction of Standby database ( maximum availability )

Environment: Oracle 11g ( 2,3 & 4 node cluster ), OEM-GC, Exadata, +ASM, Streams & linux 2.6

Confidential

Oracle DBA

Responsibilities:

  • Development Database support Database monitoring ( as per the requirement )
  • Schema Refresh ( as per client request )
  • Export / Import through exp / expdp - utility
  • Index rebuilding and analyzing tables as per Client’s request.
  • Troubleshooting errors after implementing in live environment.
  • Applying the Configuration releases as per development team request.
  • Running application Batches (written by developers) as per Client’s request.

Environment: Oracle 10g, Data Guard (Physical & Logical), IBM AIX, 5.3.

Confidential

Sr. Oracle DBA

Responsibilities:

  • Building database environment in R.A.C. / non R.A.C with ASM/non-ASM
  • Building Data Guard ( Physical ) standby servers for production servers as per specifications with RMAN backup ( ASM / non-ASM )
  • Deploying Shell scripts for RMAN backup ( database backup, archive log backup, catalog re-sync )
  • Deploying Shell scripts for monitoring and other activities (i.e. disk clean-up, ASM disk group size monitoring, purging old archives in standby )
  • Configuring RMAN settings for backup for every server environments.
  • Deploying backup automation scripts with AutoSYS according to database environment.
  • Changing protection modes (Data Guard) of standby server.
  • Checking Switchover activity of Standby server to production before implementing in live environment.
  • Performing Failover in case of primary database failure and reconfigure failed primary as standby(Data guard Broker )
  • Troubleshooting errors after implementing in live environment.
  • Database support ( includes warranty support after implementing in Live environment )
  • Database monitoring ( as per the requirement )
  • Schema Refresh ( as per client request )
  • RMAN cold backup restoration ( as per client request )
  • Export / Import through exp / expdp - utility

Environment: Oracle 11g, Data Guard (Physical), RMAN, AIX 5.3, Linux, Veritas NetBackup, AutoSYS

Confidential

Oracle DBA

Responsibilities:

  • Checking status of Database clusters in all the nodes.
  • Checking listeners on all nodes.
  • Checking Tablespace check, alert log check, o/s partitions, Database growth
  • Checking whether archive log partitions and clusters are mounted for all RAC instances
  • Checking no. of active sessions and checking SAR report at o/s level every one hour as per instruction.
  • Checking Blocking lock at database level every half an hour as per instruction.
  • Checking previous day backups are successfully written into tape.(RMAN backup, EXP backup & Archive backup )
  • Scheduling full database backup using RMAN
  • Generating full database backup using EXPORT utility on disk on daily basis and writing into tape.
  • Copying archived logs generated on all RAC instances….into separate tape on daily basis.
  • Generating incremental backup (Differential only) and writing into tape on daily basis.
  • Tune the SQL queries as per request
  • Granting permissions, rebuilding indexes as per request
  • Exporting/Importing Schemas as per the request
  • Troubleshooting Oracle errors (if any )
  • Analyzing tables / Rebuilding Indexes in the said frequencies.
  • Coordinating with Development team in case of any issues.
  • Updating DBA-Daily monitoring sheet and sending to Management by every week-end.

Environment: Oracle 9i (RAC), RAW, HP-cluster ware, Oracle 10g iAS, HP-UNIX 11.23

Confidential

Oracle DBA

Responsibilities:

  • Verify whether if all instances are up in all servers.
  • Daily alert log file check
  • Disk space check at O/S level.
  • Database tablespaces check
  • Statspack snap shot generation check
  • Daily export backup log check verify success of database backup to tape verify success of database archiving to standby database taking cold backup during weekends ( Sat & Sun )
  • Data replication during the first week of every month.
  • Restoration of data from tape if required by users
  • Setting indexes to tables as per request. application server monitoring
  • Execution of scripts as per user instruction verify enough resources for application performance ( if application is slow )
  • Analyzing table and rebuilding indexes as per instruction
  • Installation ( Oracle 10g rel1 in Linux 4. 0 )
  • Have involved in 10g upgradation activity ( from 10g rel1 to rel2 )
  • Knowledge of Standby Configuration ( Physical )

Environment: Oracle 9i, 10g, Sun Solaris 9.5, Linux 4.0, Windows NT, Toad, SQL Navigator, Pl/SQL Developer.

Confidential

Oracle DBA

Responsibilities:

  • Connectivity Check. Freespace Check. DR Sync Check. Backup Check. Statspack Check
  • O/S Partition Check. Alert Log Check
  • Rebuilding Indexes and ANALYZE tables.
  • Taking HOT backup, EXPORT Utility backup before perform Application Migration.
  • Rebuilding Indexes and Analyzing Schemas.
  • Analyzing the tables as per instruction.
  • Troubleshooting ORA errors.

Environment: Oracle 9i, IBM AIX 5.3, SnapImon, Physical standby (Manual)

Confidential

Oracle Forms Developer & Development Database support

Responsibilities:

  • Checking tablespaces whether running in sort of spaces
  • In case of locks, checking the session id and serial no and killing that particular session and updating the B/l no or booking no from particular database tables.( i.e. Document number )
  • Taking backup by Export/Import utility.
  • Creating database users and db objects as per client requirement.
  • Creating database procedures / functions / triggers and applications triggers in Forms environment as per requirement
  • Running the modified procedures/triggers in all database and compile the invalid objects accordingly.
  • Taking backup of forms executables and report executable files.
  • Interaction with End users and Business Process Owners to understand issues and requirements
  • Prepare Test Plan for all testing done and getting it approved by users.
  • Training to end user.
  • Coordinating with all department heads for integration of modules Accounts, Logistics, documentation (Import/Export), Operations

Environment: Oracle forms 6 and reports 6i, forms server, reports server, Oracle 8i, SQL Navigator, PL/SQL Developer.

Confidential

Oracle Database Analyst & development and support

Responsibilities:

  • Daily monitoring (tablespace, alert log, o/s partitions (arch folder) etc
  • Creating db users, db objects and granting necessary privileges as per instructions
  • Taking export / import as per requirement (exp utility)
  • Analyzing tables and rebuilding indexes as per instruction

Environment: Oracle forms 6i, reports 6i, Oracle 9i, Unix AIX-4.3

Hire Now