Skip Navigation
Search Our Jobs

Search Our Jobs

Job Description

Database Analyst 4

Job ID 5289648 Schedule Type Reg-Time Work Hours 40 Location West Des Moines, Iowa
Job Description

The Enterprise Database Management (EDM) Lending Database services group provides world class database support for the  Wells Fargo Home Mortgage, Legacy Wells Fargo Financial, Home Equity, and potentially, other lines of business at Wells Fargo. The Database Administration (DBA) team designs, creates, implements, and supports mission critical database systems with respect to security, backup, optimization and other tasks such as Disaster Recovery Planning. 

 

This position will play a key role in providing the highest level of Oracle expertise for performance improvements, problem resolution and database planning for a high-availability, critical Oracle database environment including Exadata.

 

Responsibilities include:

•          Analyzing database performance

•          Database design/planning

•          Capacity planning

•          Resolution and tracking of the most complex Oracle issues

o          Communicating critical support issues identified to Oracle Support Services

         Managing escalations for Severity 1 service requests

o          Creating problem workarounds for open service requests

o          Monitoring service requests and communicating status to others on the team

o          Investigating recent SR reports

o          Filing, tracking, and reporting SRs

o          Recommending best practices designed to minimize future SRs

•          Creating and implementing backup and recovery procedures

•          Creating, filing, tracking, and reporting test cases

•          Researching features and functionality of supported Oracle programs

•          Researching information on problems/questions posed by application DBAs

•          Provide on-call coverage for  first response problem tickets for DBMS from Oracle and patching on UNIX systems, as well as Exadata

o          Looking for the strength to be in Oracle

•          Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities     

The primary support for this position will be supporting Wells Fargo Oracle database applications.  Therefore the resource selected must have hands on working knowledge of:

o          Knowledge and understanding of Oracle Dataguard

o          Knowledge and understanding of Oracle Golden Gate

o          Knowledge and understanding of Oracle CRS

o          Ability to problem solve database issues when on-call 24x7

o          Knowledge of performance data collection, monitoring and improvement

o          Knowledge of backups and recovery

o          Knolwedge of database security administration

o          Knolwedge of database and server performance monitoring, tuning, and capacity planning

o          Effective communication, ability to work independently, and leadership skills are key



Required Qualifications

  • 5+ years of database design and administration experience



Desired Qualifications

  • Excellent verbal, written, and interpersonal communication skills



Other Desired Qualifications

•          3+ years of experience with Oracle technologies (partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, application audit logs, Oracle RAC, scheduling, backup and recovery, and data guard) and UNIX (AIX, Solaris, or Linux).

•          3+ years’ experience with performance monitoring, database and SQL tuning tools such as Explain plan, AWR, Grid control or similar technologies.   Understand and interpret the reports generated from tools and action plan to overcome performance issues.

•          Bachelor's degree in IT (Computer Science, Information Systems, etc.) or related field

•          5+ years related experience in information systems design and development

•          Demonstrated experience with ASM/CRS on Oracle 10G or 11G

•          Demonstrated experience RMAN backup  with Oracle 10G or 11G

•          Demonstrated experience in clustered environments

•          Demonstrated experience supporting logical replication, preference for Golden Gate

•          Demonstrated experience participating in the planning, design and usage of data resources

•          Demonstrated experience providing support to development team on infrastructure and DBA Support

•          Demonstrated experience providing a daily status of application and performance

•          Demonstrated experience with Database Capacity Planning.

•          Demonstrated experience with a UNIX-based programming language (Kornshell, PHP, PERL, C)

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

•          Ability to analyze how Oracle resources are being used during SQL executions

•          Candidate must possess self motivation and strong communication skills (oral and written) to manage customer relations with emphasis on verbal and written communication

•          Demonstrated ability to quickly learn, retain, and apply good interpersonal skills, and perform effectively under time pressure are critical skills required for this position

•          Ability to write and maintain high quality documentation

•          Ability to work off-hours, when required.





Disclaimer


All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act.



Relevant military experience is considered for veterans and transitioning service men and women.

Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.

0162895 CORPORATE FINANCE

Working at Wells Fargo – Our Hiring Process

Find Jobs Near You

Sign up for our Talent Community and receive Job Alerts

Select Your InterestsSearch for a category, location, or category/location pair, select a term from the suggestions, and click “add”.

Related Jobs