*Title: Data Modeler / DBA (80% Data Modeler + 20% DBA)* *Location: Oaks PA*
*No of positions – 2 * *F2f with end client * Job Description Has 5+ years of experience in database development and support in Oracle Database (11g/12c) Administration for data migration projects. Experience in design of complex databases models and creation of physical database objects from design, administering and controlling the organization's data resources, including multiple relational and non-relational db systems and servers. Experience in troubleshooting and resolving oracle database problems including integrity issues, performance issues, blocking and deadlocking issues, replication issues,connectivity issues, security issues etc. Experience in Performance Tuning, Query Optimization, Performance Monitoring, SQL Profiling etc using native monitoring and troubleshooting tools.. Experience in finding/troubleshoot Database related issues like CPU,memory,I/O, disk space and other resource contention. Experience in data movement/replication from multiple source system like flat files/excel spreadsheets etc to Oracle Database. Strong knowledge of Oracle export/import using datapump or multi threaded data replication/movement between db servers. Experience in implementing operational automation using scripts (perl, shell scripts, java etc) Knowledge of indexes, index management, database integrity and statistics. Knowledge of Oracle Database troubleshooting tools ( AWR, ASH, ADDM etc) SQL/PLSQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints etc.) Good communication and Documentation skills for processes and procedures ( creating KBs, runbooks, how-to's etc ) Knowledge in a scripting language like Powershell, VBScript, Batch Files, Shell Scripts, Perl, Java *Regards,* *Manju Shree* *Sr IT Recruiter* *IDC Technologies, Inc. 1851 McCarthy Boulevard, Suite 116,Milpitas, CA, USA, 95035* *Phone: 408-457-9381-4085|Fax: 408-608-6088 <408-608-6088> | * *Email: **ma...@idctechnologies.com* <kara...@idctechnologies.com>*| Web: * *www.idctechnologies.com* <http://www.idctechnologies.com/> -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to firstname.lastname@example.org. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.