This site uses cookies. To find out more, see our Cookies Policy
Skip to navigation
Skip to main content
Skip to footer

EDW Application DBA in Columbus at Huntington

Date Posted: 1/11/2019

Job Snapshot

Job Description

The Enterprise Information Management team is seeking an Application DBA for the Enterprise Data Warehouse. The primary responsibility of the role is to implement access layer for EDW users by business function. The Application DBA will be responsible for gathering the requirements and work with infrastructure and Database DBA teams in implementing the solution. This person will also provide recommendations on proper indexing and partitioning mechanisms for table, view structures to provide optimal SQL performance.

Responsibilities:

  • Design and Implement Role Based Access Layer for End User Queries and Reporting
  • Lead the translation of business needs into feasible and acceptable data-centric semantic layer design
  • Segregate views and tables by business function in EDW
  • Build Segregated views for PII and Non PII Data
  • Develop a process to identify personal identifiers like SSN etc. across EDW tables and views
  • Performance tuning of poorly performing SQL queries
  • Publish and guide end users on SQL coding standards and practices for obtaining optimal performance for a SQL query
  • Proactively gather workload characteristics from EDW and provide recommendations to the DBAs for workload adjustments
  • Estimate and communicate the work effort to EDW management, Stakeholders and own the deliverables from inception, review and signoff of the deliverables.
  • May need to perform other EDW Platform functions like capacity planning, SLAs, monitoring etc.

Basic Qualifications:

  • Bachelor's degree preferably in computer science
  • 5+ years of experience in Application DBA role design and implementation of EDW access layer
  • 5+ years of SQL writing and SQL performance tuning experience
  • DB2 Database Design Experience in Indexing, Partitioning
  • Experience in DB2 Role Design
  • Good communication and interpersonal skills for interacting and collaborating with business users, DBA's and application developers

Preferred Qualifications:

  • 5+ years of experience in Data warehousing
  • Experience on Workload Management and Capacity Planning
  • Experience in all EDW ITIL functions

EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details. Huntington does not accept solicitation from Third Party Recruiters for any position.
TOP