Senior Database Administrator, IT - Enterprise Data
Hawaiian Airlines
Phoenix, Arizona, No
2d ago

Position Overview

The 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.

Senior Database Administrators must understand the physical and logical database concepts. They are responsible for performing database analysis and maintenance activities.

Key Responsibilities

  • Enforce, refine and document database standards
  • Work with technical / development leads to develop / review database designs
  • 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 to prevent 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
  • Proactively analyze database implementations and provide recommendations for improvements in performance and efficiency
  • Provide leadership and coaching for team
  • Implement operational automation
  • Minimum Requirements

  • Bachelor’s Degree or equivalent combination of professional work experience and education
  • 5 years’ work experience in Engineering and / or IT environment
  • 5 years’ work experience with MongoDB and Ops Manager in a replica set environment
  • 3 years’ work experience with SQL Server
  • Work experience with Linux
  • Work experience with AWS
  • Demonstrated experience with computer or network systems hardware and software development methodology / process obtained through formal training, education, and / or work experience
  • Experience with design and development of multiple database engines
  • Experience with database schema design
  • Strong in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Ability to detect and troubleshoot CPU, memory, I / O, disk space and other resource contention
  • Proficient knowledge of Performance Tuning and Query Optimization
  • Proficient knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
  • Implement operational automation
  • Expert knowledge of indexes, index management, integrity checks, configuration and patching as well as how statistics work, how indexes are stored, and how indexes can be created and managed effectively
  • Preferred Qualifications

  • B.S. in Computer Science, Engineering or Information Systems
  • Airline or similar industry experience
  • Experience with sharding in a MongoDB environment
  • Working knowledge of Oracle Enterprise Databases and Oracle RAC
  • Experience providing Level 3 technical support
  • Expert understanding of : NoSQL database technologies, preferably MongoDB Designing, developing, supporting Operational Data Stores (ODS) and / or Enterprise Data Warehouses (EDW)Cloud platforms such as AWS and Azure Big Data technologies, such as Hadoop, MapReduce, Hive, Spark,etc.
  • About Hawaiian Airlines

    Hawaiian® has led all U.S. carriers in on-time performance for each of the past 15 years (2004-2018) 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 90th year of continuous service, Hawaiian is Hawaii’s biggest and longest-serving airline. Hawaiian offers non-

    stop service to Hawai i from more U.S. gateway cities (13) than any other airline, along with service from Japan, South Korea, Australia, New Zealand, American Samoa and Tahiti.

    Hawaiian also provides, on average, more than 170 jet flights daily between the Hawaiian Islands, and over 260 daily flights system-wide.

    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’s LinkedIn 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)

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form