HonoluluRecruiter Since 2001
the smart solution for Honolulu jobs

Senior Database Administrator, IT - Data and Common Services

Company: Hawaiian Airlines
Location: Honolulu
Posted on: November 19, 2021

Job Description:

Title Senior Database Administrator, IT - Data and Common Services Department Information Technology City Honolulu State HI Part-Time No Part-Time Weekend No Description At Hawaiian Airlines, we are all about welcoming our guests with Hawaiian hospitality and aloha, and taking care of our people, our home and the communities we serve. Join our 'ohana--and be a part of an exciting team of professionals dedicated to serving our--kama'--ina--and introducing our islands to the world!Position OverviewThe Database Administrator implements and maintains various database platforms for the enterprise. Performance and reliability must be ensured at the database level to run business software. Database Administrators must understand the physical and logical database concepts. They are responsible to perform database analysis, tune performance, design database schemas, and ensure the reliability of the database.The Data Administrator also focuses on the identification, classification, integration, modeling, storing, and accessing of information. Data must be understood in terms of its business lifecycle (creation through deletion) and of its technical lifecycle (CRUD - create, read, update, delete) so the optimal solution can be delivered. Members of the job family may work in systems development projects, reporting/analysis projects, or work on projects with data scientists and strategists to gain deeper insights to the information of the company.Data family members should understand the technical underpinnings of database theories (e.g., structured, unstructured) as well as the ability to perform database analysis and maintenance activity.Key Responsibilities

  • Develop technical specifications
  • Enforce, refine and document database standards
  • Work with technical/development leads to design, or review designs for databases
  • Assess and identify database server resource requirements
  • Develop and maintain data models
  • Demonstrate advanced understanding of multiple database platforms
  • Code, test and deploy database changes
  • Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, preventing customer impact
  • Review performance stats and recommend changes for tuning database and application queries.
  • Assist developers in the development and tuning of database queries, stored procedures, indexes, etc.
  • Participate in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
  • Lead requirements assessments for backup and recovery
  • Assume ownership of database related problems; pursue problem resolution and root cause analysis
  • Troubleshoot complex database and performance related issues including after-hours and weekends to meet SLA
  • Install, configure and upgrade database software
  • Perform application related deployments to test and production environments
  • Perform capacity planning for databases
  • Document processes and issue resolutions
  • Analyze and resolve highly complex problems
  • Monitor and tune existing databases of high complexity and high business exposure
  • Use database management tools proficiently
  • Recommend database and system management tools as required
  • Proactively analyze database implementations and provide recommendations for improvements in performance and efficiency
  • Provide leadership and coaching for team
  • Implement operational automation Requirements Minimum Requirements
    • Bachelor's Degree (in lieu of degree - 9 years of work experience in Engineering and/or IT environment)
    • 5 years of work experience in Engineering and/or IT environment
    • 5 years of work experience as a Database Administrator on multiple database platforms
    • Demonstrated experience with computer or network systems hardware and software development methodology/process obtained through formal training, education, and/or work experience
    • Experience with database schema design and development on multiple database platforms
    • Strong in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.
    • Ability to detect and troubleshoot CPU, memory, I/O, disk space and other resource contention
    • Advanced knowledge of performance tuning and query optimization
    • Advanced knowledge of backups, restores, clustering, replication, high availability
    • Experience implementing operational automation
    • Advanced knowledge of indexes, index management, integrity checks, statistics, configuration, patching
    • Must have received the COVID Vaccine by date of hire **All applicants are advised that post-offer and/or pre-employment drug testing will be conducted, and they must successfully pass the drug test. Failure to submit to testing or positive indications of drug use will render the applicant ineligible for employment with Hawaiian Airlines and any employment offer will be withdrawn.Preferred Qualifications
      • B.S. in Computer Science, Engineering or Information Systems
      • Airline or adjecent industries
      • Deep understanding of:
        • Designing, developing, supporting Operational Data Stores (ODS), Enterprise Data Warehouses (EDW) and/or Transactional Databases
        • Cloud platforms such as Snowflake, AWS and Azure
        • NoSQL database technologies, preferably MongoDB
        • Multiple years of experience in two or more of the following platforms:
        • SQL Server
        • MongoDB Atlas
        • Oracle Enterprise and Oracle RAC
        • Snowflake About Hawaiian AirlinesHawaiian -- has led all U.S. carriers in on-time performance for each of the past 17 years (2004-2020) as reported by the U.S. Department of Transportation. Consumer surveys byCond-- Nast Traveler, Travel + Leisure and TripAdvisor have placed Hawaiian among the top of all domestic airlines serving Hawai'i.Now in its 92nd year of continuous service, Hawaiian is Hawai'i's biggest and longest-serving airline. Hawaiian offers nonstop flights within the Hawaiian Islands, between Hawai'i and more U.S. gateway cities (16) than any other airline, as well as service connecting the islands with Japan and South Korea. As a result of the COVID-19 pandemic, Hawaiian has temporarily suspended service in Australia, New Zealand, American Samoa and Tahiti.

          The airline is committed to the health and safety of its guests and employees and has reinforced enhanced cleaning procedures across its business. While the experience may be a little different, the authentic Hawaiian hospitality remains unchanged. Additional details on how Hawaiian is keeping guests and employees safe can be found at HawaiianAirlines.com/KeepingYouSafe .Hawaiian Airlines, Inc. is a subsidiary of Hawaiian Holdings, Inc. (NASDAQ: HA). Additional information is available atHawaiianAirlines.com . Follow Hawaiian's Twitter updates (@HawaiianAir ), become a fan on Facebook (Hawaiian Airlines ), and follow us on Instagram (hawaiianairlines ). For career postings and updates, follow Hawaiian'sLinkedIn page.For media inquiries, please visit Hawaiian Airlines' online newsroom .
          • Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.
          • Please view Equal Employment Opportunity Posters provided by OFCCP here .
          • 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)

Keywords: Hawaiian Airlines, Honolulu , Senior Database Administrator, IT - Data and Common Services, IT / Software / Systems , Honolulu, Hawaii

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Hawaii jobs by following @recnetHI on Twitter!

Honolulu RSS job feeds