About Exatech Inc

Exatech Inc is a staffing and recruiting company.

company website →

Oracle DBA L3 with 12C← All Jobs

2016-02-23 | Charlotte, NC | DOE | 6 Months Contract


Description

Job Description:
• Mandatory to have a very strong Oracle DBA (L3 and above) with strong communication, management skills and leadership qualities.
• 24 * 7 Support.
• Experience resolving Oracle Network I/O such as SQL Net, ODBC,LDAP,JNDI and MPL.
• Strong knowledge in Oracle agent, GI, Golden Gate Replication.
• Exadata knowledge is desired.
• Closely work with Vendors, Stay Up-to date with Product Features.
• Expertise in Application Partitioning, Information Remnance, Denial of Service Protection and Boundary Protection mechanisms Administers and ensure proper statistics all database objects.
• Troubleshoot RMAN Performance, OS Huge Pages ,OS Kernel Settings, Identify and Resolve Disk I/O Hotspots and fragmentation.
• Troubleshoots SQL Query Performance Issues, problem scenarios, on Oracle Identity Manager, OID and Database Vault.
• Perform Database Upgrade to new Oracle version, quarterly PSU upgrades.
• Effective interpersonal skills, enhancing Partners to use newer trends in technology and SQL Best Practices.
• Knowledge of Logical and Physical Database Design, assisting Teams to adhere Governance during Implementation.
• Strong skills in Oracle Database Performance using AWR,ADDM,ASH,SQLT, Oracle Data UNLOADER.
• Demonstrate excellent knowledge and practical skills in Oracle 12c AWR Warehouse and ASH Analytics.
• Strong Understanding of Oracle Optimizer, optimizer parameters, parsing mechanism and how optimizer influences in controlling, stabilizing execution plans.
• Accomplished in handling Performance Benchmarking and configuration, of in-memory database tuning and other middleware.
• Strong Knowledge in Predictive Index Reorganization utilizing Index Advisory and Reducing LIOs.
• Thorough knowledge of Performance Reporting using OEM Grid 12c and BI Publisher dashboards.
• Thorough knowledge of Oracle Code Action and benchmarking in Massively Parallel Systems.
• Application Code Reviews in PL/SQL, Performance Testing using Oracle Database Replay and using SQL Performance Analyzer.
• Ability to detect and resolve system waits involving cache buffer chains, detecting benefits from super-sizing of PGA.
• Thorough knowledge of Dimensional Data Modeling and traditional ER modeling and leveraging Performance Impacts on DWH systems.
• Strong Performance Tuning Skills in Distributed Global Data warehouse Architecture, Data Marts and Operational Data Stores.


Share:

Apply
Your Name here
Your Email Address
Enter your message to the company explaining why you are a fit for this job
Please use Microsoft Word format


Similar Jobs: