Innovations technological

Location: Des Moines, IA

Duration: 18 months

Start Date: late May/early June

Interview: will hire off phone screen

Minimum Qualifications:

§ 7+ years experience in database administration and design and/or modeling or equivalent combination of education and experience.

§ Proven experience in implementation of high availability solutions with Oracle 10g/11g RAC, CRS, Physical and Logical Standby database, Active Data Guard, LogMiner, Materialized views, Bi Directional Streams Replication, Golden Gate and Quest SharePlex.

§ Proven experience in Grid Control (Oracle Enterprise Manager) scheduling jobs, RMAN/backups/Recovery, import/export and data pump

§ Extensive experience in performance tuning of RAC and large scale Oracle databases (>1TB)

§ Demonstrated experience in database architecture, data modeling and schema design

§ Population and tuning of databases, ETL processes, SQL queries while meeting business requirements and client's needs

§ Proficient in SQL, PL/SQL, shell scripting and analyzed Batch programs

§ Proven ability to troubleshoot and trace data related issues throughout the architecture

§ Proven experience of large scale OLTP and OLAP and DSS database deployments

§ Demonstrated experience in meta-data management and data traceability techniques

§ Experience in using data quality and data profiling technologies and utilizing the tools like Explain plan, AWR, ADDM and implementation of partitioning and indexing.

§ Must be strong in analyzing reports generated from tools and action plan to overcome performance issues.

§ Excellent verbal and written communication

Preferred Qualifications:

§ Bachelor's degree in IT (Computer Science, Information Systems, etc.) or related field and 9+ years related experience or equivalent combination of education and experience in information systems design and development

§ Oracle Database Administrator Certification "10g" or "11g"

§ Experience with Oracle technologies (partitioning, indexing, security, encryption, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Oracle total recall, Oracle RAC, XML Manipulation, Scheduling, etc.)

§ Experience in Oracle RDBMS internal, Oracle Network and Transparent Data Encryption (TDE).

§ Experience in orchestrating the coordination of data related activities to ensure on-time delivery of data solutions to support business capability requirements including data activity planning, risk mitigation, issue resolution and design negotiation

§ Demonstrated experience with designing and managing relational database technology with multiple RDBMS vendors (Oracle preferred) in OLTP, data delivery and OLAP usage

§ Demonstrated ability in designing effective management of reference data

§ Experience with multiple data extract and delivery designs and developments including Pub/Sub, ETL, Operational Data Stores/Subjects Data Marts/Analytical

§ Familiar with Data standards/procedures and data governance and how the governance and data quality policies can be implemented in data integration projects (Knowledge and experience in using Data profiling and Data Quality tools)

§ Proven experience with Agile methodology and understanding of SDLC in an agile environment

§ Experience for integration Database layer and application layer (Java) like Hibernate

§ Experience with build systems like SVN, Maven and Continuum.

Thanks & Regards

Sareen Bhaskaran | Sr. Resource Manager | ProSoft Technology Group, Inc.

Emailsareen@prosoftgroup.com| Phone 630-689-2960 x 145| Fax 630.725.1900 | Toll free 630.725.1800

Alternate email id recruitersareen@gmail.com| YIM sareen_recruiter  

2001 Butterfield Rd, Suite 305, Downers Grove, IL, 60515 |  www.prosoftgroup.com

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. ProSoft accepts no liability for any damage caused by any virus transmitted by this email.