Dear all,
Please let me know if you would be interested for the below mentioned position, please send the resume to hemant.si...@infogium.com. *Oracle DBA* *Duration- 6+ months* *Location- Malvern, PA* *Financial services industry *experience required *Face to face interview * *Oracle DBA* *Description* Oracle Systems Administration in both development and production environments with experience in Oracle Product Advanced Replication, Advanced Queue and Relational Database Management System Internals and knowledge of Real Application Clusters. Maintain and keep Oracle products viable for daily use, troubleshooting and client support. Be responsible for Oracle product configurations, installations, integrations, and help in architecture designs. Support during release upgrades, and automation of release deployments. Work with development team on daily basis to work on adhoc requests and assist them in deploying changes and optimize the process to reduce manual work by effectively using sql loader, expdp, impdp and other utilities. Work with other teams to develop best practices, run book and provide advanced technical troubleshooting for applications and database systems with emphasis on root cause analysis. Understand server clustering techniques and the impact on database configuration and performance Develop advanced shell scripts, SQL and PL/SQL scripts in support of database operations Very good knowledge on Oracle memory structures, Backup & recovery Concepts, Performance Tuning, CDC, Grid Control, Golden Gate and Oracle Network Concepts 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. Perform ETL Administration Ability to work in fast paced, constantly changing environments and able to manage multiple environments Very good communication skills and consistently high performer in meeting business needs Requirements Hands-on, technically adept DBA, capable of performing required DB tasks Deep knowledge with Oracle 11g/12c databases, strong RAC/clustering experience, OEM, CDC, RMAN, Oracle Grid and Golden Gate experience required. Migrating the schemas using traditional exp/imp, Oracle Data pump utilities and Data on Demand technologies such as Artifico Strong troubleshooting/performance tuning skills- tkprof,10046 trace, baseline, profile,etc required . Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers). Ability to implement automation to reduce manual administrative tasks through use of jobs, shell scripts, PL/SQL, cron job, or other techniques.. Must demonstrate proficiency in UNIX and be able to administer Oracle databases running in Solaris and RHEL. High level experience with writing shell scripts Very good understanding of how memory, CPU, Disks work on the UNIX environment Oracle Recovery with Archiving, Oracle Export and Import Utilities, Artifico Demonstrate experience with backups, recovery, performance tuning and optimization on oracle OEM, statspack, AWR experience needed Experience of execution plans and how to use them to optimize/improve query costs and create new indexes Monitoring database performance during application performance testing and recommending database changes Experience backing up databases from one environment and restoring them in other database environments Experience with upgrading oracle databases from oracle 11g to 12c. Perform ETL Administration responsibilities for the Information Management group using Informatica Perform Informatica code migrations and monitoring according to standards & established processes. Perform all Informatica administration functions such as user access accounts, roles, setting standards etc. Perform Informatica software upgrades as needed. Proactively monitor development, test and production Informatica implementation servers. Provides technical consulting on complex projects considering ETL best practices & desired results Troubleshoots performance issues with Informatica software & code as needed. Provides input regarding technical design and development of applications using existing and emerging technology platforms. Provide support to ETL application development/production teams as needed. Implementation of security standards and roles Deploy/ migrate code across multiple tiers Implement migrations, upgrades, patches and service pack implementations Provide user support by investigating issues/problems, enforcing standards, and answering inquiries Works with different teams to ensure best practices for code development are followed and optimal configuration of ETL infrastructure Regards….. *Hemant Singh* Infogium Technologies, LLC hemant.si...@infogium.com | Contact: +1-678-648-8258 | www.infogium.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 sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.