Corp- Corp Jobs: DATABASE ANALYST

Monday, February 11, 2013

DATABASE ANALYST

HI,

This is Rohit from Priserve Consulting INC,I hope you are doing well, please have a look on requirement. If you find it comfortable for any of your consultant respond with his contact details and updated word formatted resume . Reply ASAP.

Job Title : DATABASE ANALYST
Location: Des Moines, IA
Duration: 18 Months

Job Description:
Provides the highest technical expertise for the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases. Handles and leads the most complex or critical data/ database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling. As the recognized technical expert, consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies. Serves as a consultant on technological advancements. Provides oversight, mentoring and leadership to less experienced staff. May represent the organization as an external spokesperson.: 10+ years database design and administration experience.

Additional Job Details:
The Operational DBA position is part of CORE Production Support Operational DB Team. CORE (Common Opportunities, Results and Experience) realizes global opportunities for Wells Fargo’s by: -Achieving company’s vision to satisfy all of our customers financial needs -Building the foundation for ONE Wells Fargo -Retaining and advancing our position in the Lending Industry -Casting team members as the keys to our successful implementations -Creating new way of thinking, innovative skills to enhanced career opportunities Daily activities could include any/all of the following: -Perform Infrastructure support of various Oracle Database concepts, including but not limited to: connections, load balancing, failover, active data guard, CRS, ASM, SQL tuning, scheduling. -Provide on-call support for production environment – including deployments/migrations, running patch, bug fix scripts, and routine maintenance. -Handles and leads the most complex or critical data/database management initiatives, including responsibility for infrastructure and database architecture, design and implementation. -Install DBMS software and database patches (CPU and PSU) -Analyze non-functional requirements and implement Grid Control (Oracle Enterprise ), archiving, scheduling jobs, RMAN/daily backups/Recovery and monitoring strategies. -Perform Data Currency (Data Pump, Export/Import) functions. -Provide proactive monitoring of the database instances, and take preventive steps (setting up alerts) to ensure high availability. -Must be strong in analyzing how Oracle resources are being used during SQL executions. -Expert in utilizing the database tools like TOAD and performance tuning tools like Explain plan, AWR, ADDM, Grid control or similar technologies from other vendors like Quest. -Expert in TOAD and other -Create/maintain documentation of database installations and other DBMS processes. -Partner with development teams to create a high volume transaction system. -Perform software testing using industry standard best practices. -Recommend best practice SQL tuning approaches to CORE development groups -Provide impact analysis reports on database configuration/schema changes -Conduct iterative and high performance tuning of RAC and database environments starting from development -Research and design database/infrastructure solutions for scalability based on business requirements -Demonstrated ability to quickly learn, retain, and apply business rules and terminology, apply good interpersonal skills, and perform effectively under time pressure are critical skills required for this position -Provides oversight, mentoring and leadership to less experienced staff This is an exciting group that is every changing and growing. The ideal candidate for this role will be flexible and thrive in ambiguity. He/She must have the ability to adapt to change quickly and adjust work accordingly in a positive manner. Basic Qualifications: -7+ years in database administration and design.

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 and Gate. -Proven experience in Grid Control (Oracle Enterprise ) 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.

Thanks & Regards,

Rohit Chandel

Tel: - 713 510 4659