Job Description :
Title :: Data Modeler / DBA (80% Data Modeler + 20% DBA)
Location :: Oaks PA
Duration :: Long Term Contract
Contractor
No of positions – 2

Who has good experience in data architecture
PL/SQL programming SQL Programming
Pick up programming languages – shell scripts , pearl and automation languages
Experience in data migration from one application to other application
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