Position: Oracle Database Administrator/Informatica ETL Administrator
Location: Oaks, Pennsylvania 19456
Duration: 6+ Months Contract
Phone+ Skype
2 Weeks to Start
*Oracle Database Administrator/Informatica ETL Administrator – Oaks/PA*
*Minimum Requirements:*
o Hands-on, technically adept DBA, capable of performing required DB
tasks
o *Deep knowledge with Oracle 10g/11g databases, strong RAC/clustering
experience, OEM, CDC,RMAN, Oracle Grid and Data Guard experience required*.
o Migrating the schemas using traditional exp/imp and Oracle Data pump
utilities
o Strong troubleshooting/performance tuning skills required. Must be
able to improve SQL performance results through use of hints or outlines.
Ability to diagnose problems and triage/resolve issues across various tiers
(application, network, database, server, or storage tiers).
o Ability to implement automation to reduce manual administrative tasks
through use of jobs, shell scripts, PL/SQL, cron job, or other techniques..
o *Must demonstrate proficiency in UNIX and be able to administer Oracle
databases running in Solaris and RHEL.*
o High level experience with *writing shell scripts*
o Very good understanding of how memory, CPU, Disks work on the *UNIX
environment*
o *Oracle* Recovery with Archiving, Oracle Export and Import Utilities
o Demonstrate experience with backups, recovery, performance tuning and
optimization on oracle OEM, statspack, *AWR experience needed*
o Experience of execution plans and how to use them to optimize/improve
query costs and create new indexes
o Monitoring database performance during application performance testing
and recommending database changes
o Experience backing up databases from one environment and restoring
them in other database environments
o *Experience with upgrading oracle databases from oracle 10g to 11g.*
o *Perform ETL Administration responsibilities for the Information
Management group using Informatica*
o Perform Informatica code migrations and monitoring according to
standards & established processes.
o Perform all Informatica administration functions such as user access
accounts, roles, setting standards etc.
o Perform Informatica software upgrades as needed.
o Proactively monitor development, test and production Informatica
implementation servers.
o Provides technical consulting on complex projects considering ETL best
practices & desired results
o Troubleshoots performance issues with Informatica software & code as
needed.
o Provides input regarding technical design and development of
applications using existing and emerging technology platforms.
o Provide support to ETL application development/production teams as
needed.
o Implementation of security standards and roles
o Deploy/ migrate code across multiple tiers
o Implement migrations, upgrades, patches and service pack
implementations
o Provide user support by investigating issues/problems, enforcing
standards, and answering inquiries
o Works with different teams to ensure best practices for code
development are followed and optimal configuration of ETL infrastructure
o Handle additional responsibilities progressively.
Description:
o Understand and apply advanced database administration, management and
performance tuning techniques
o Provide advanced technical troubleshooting for applications and
database systems with emphasis on root cause analysis
o Configure and tune hardware and software to insure optimum performance
and resource utilization
o Understand server clustering techniques and the impact on database
configuration and performance
o Develop advanced shell scripts, SQL and PL/SQL scripts in support of
database operations
o *Manage Real Application Clusters (RAC) *
o *High degree of skill with database commands and utilities such as
exp, imp, sql loader, expdp, impdp, etc*
o Very good knowledge on Oracle memory structures, Backup & recovery
Concepts, Performance Tuning, CDC,Grid Control, Data Guard and Oracle
Network Concepts
o *Solid experience with the Unix operating system and command set as
well as competence with shell scripting*
Ability to write, debug and tune sql and pl/sql, packages, procedures,
functions, triggers, etc.
o Perform ETL Administration
o Ability to work in fast paced, constantly changing environments and
able to manage multiple environments
o Very good communication skills and consistently high performer in
meeting business needs
Thanks,
*Kuldeep Yadav {KD}*
*Technical recruiter*
*Net**2**Source Inc.*
*[email protected] <[email protected]>*
*Gtalk&Yahoo:: kd.intime*
*Direct ::2014792783*
*Tel: (201) 340.8700 x 4**52**|*
*Fax: (201) 685.8135*
*Address: 15 Exchange Place, Suite # 500, Jersey City, NJ - 07302*
*Website:* www.net2source.com
*Microsoft Gold Certified Partner **|** Cisco Certified Premier Partner **|**
Oracle Gold Partner** | **IBM Business Partner** | **ISO 9001:2008
Certified Company** | **NASSCOM Certified Company **| **E-Verified*
--
You received this message because you are subscribed to the Google Groups
"American Vendor--IT Consulting" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sap-vendor.
For more options, visit https://groups.google.com/d/optout.
