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