Application Database Administrator in Maryville, TN at First Horizon National Corporation

Date Posted: 1/30/2020

Job Snapshot

Job Description

The Application Database Administrator (DBA) (Oracle) will be the focal-point for all application-level support. The Application DBA will work with application owners/Lines of Business throughout the Software Development Life Cycle. The maintaining of the Oracle database will require an immersion into the application processes and close coordination with the System DBA’s (Oracle) to understanding system-level changes, requirements, etc. Basic duties of the Application DBA will include (but not limited to)

Writing and maintaining applications

Working with Server Architects to establish database requirements (SGA, PGA, UGA)

Validate/confirm Vendor specified recommendations

Work with Application Owners throughout SDLC

Work closely with System DBA’s for system performance issues

Work with QA/Dev teams for Database performance validation/sign-off

Coordinate and validate Change requests, version updates, etc.

Creation and maintenance of schema objects: tables, indexes, views, sequences etc.

Standard data management\\steward tasks:

Copying data between tables.

              Loading small to medium sets of data into the database (table and schema level).

Customer DML (Data Manipulation Language)

SQL code optimization (using tools such as Explain Plan, TKProf etc.).

Helping users write and optimize SQL.

AWR, ADDM and ASH Reports as needed to troubleshoot issues.

Respond to Application/Database issues

Available on-call for customer-facing application issues

Work with Application Owners/Vendors and System DBA’s to identify underlying issues/work through resolution

Desired Experience:

10+ years Oracle experience

Advanced troubleshooting (JVM, memory utilization, etc.)

Architectural design and implementation

5+ years Agile Development experience

Strong background working with API’s and Cloud-based solutions


Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)