Siebel Oracle DBA

Siebel Oracle DBA

Job Code: TJ_3401
Job Location: Dallas, Texas
Zip Code: 75209
Job Category/Title: Database Administrator/DBA
Employment Category: Full-time
Position Type:
Travel Required: No
Interview Type:
Education: Associate Degree
Experience: 5-10 year(s)
Required IT Skills: ETL, Oracle, Oracle DBA, RAC, Shell Scripting
Job Description: Experienced Oracle DBA, with hands-on experience on Oracle 11g R2 RAC and knowledge on Siebel

Essentials:
•Knowledge on Siebel is an added advantage
•Installation, configuration, Patch upgrade of Oracle 11gR2 database & configuration setup
•Capacity planning of critical prod/non-prod databases and expertise in RAC &ASM
•Monitoring database performance by checking Session Waits, locks and long operations running on the database and resolving the performance issues
•Proactive and reactive monitoring the alert log for the database performance, troubleshoot and resolving the performance issues.
•Experience in DR Configurations and DB switchover
•Generating AWR/ADDM reports on regular basis to identify the database performance at peak load
•Trouble shooting day to day production databases issues in 24*7 production support environments with a dedicated team
•Implement shell scripts to monitor DB activities and automation of batch jobs and RMAN
•Implement SQL scripts to monitor and to get information on free space, Extents, Tablespaces, Tables and Indexes
•Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes
•Enrolling and Administering the Database Users
•Expertise in Partition tables, Backups and Restorations
•Migrating the data from one database to the other using RMAN and Export / Import Utility and partitioning the big tables
•Implementing Security features as specified by the Client’s Security policy and for external Audits
•Involved In database up-gradations and migrations like RDBMS upgradations (8i,9i,10g,11g) RAC migrations and file systems to ASM
•Experience on OLTP and OLAP databases
•Cloning of production databases for creation of DEV/UAT environments and Report servers
•Managing Database objects, partitioned tables, Large tables, Indexes, Reorganization, Log mining, Export/Import, Analyze and Golden Gate

Desirable:
•Awareness on latest industry trends and technology advancements
•Siebel CRM Data structures
•ETL / Informatica
•Tool customization & administration experience


Responsibility of / Expectations from the Role:
Be travel-ready
Articulate and Presentable
Carry out Due-diligence and defines roadmap for service virtualization
Experience with 24×7 support of production database environments – complex query performance tuning (of existing applications), Hardware and Software specification and design
Experience working with Oracle Support Services familiar with Oracle’s escalation procedures.
Define and documents best practices, standards, checklists, guidelines etc.
No. of Posts: 1
Job Expiry Date: May 31, 2016
Telecommute: No
Contact Information Login To View