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