Applications Database Administrator
New York, NY

Job Description

Position Title: Application Database Administrator

Position Summary

The Application Database Administrator provides direct support to all JetBlue Staging (UAT), QA, and Development databases. This includes database health checks, performance efficiencies, security, database patching, enforce data policies and user access administration. The Application Database Administrator directly supports efficiency and data integration by managing data job processing schedule timing and ensure all jobs processed. The Application Database Administer makes recommendations regarding database architecture and partners with development teams to define system requirements for new functionality and/or new systems. The Database Administrator excels when working on complex projects, is motivated to deliver results, and exhibits the JetBlue values of Safety, Caring, Integrity, and Passion, and Fun.

Essential Responsibilities

* Full database administration life-cycle including the maintenance, design, setup, installation, patching and implementation of databases in large scale environments.
* Troubleshoot database degradations
* Work with internal application teams to assess and define database requirements inclusive of capacity planning as well as collaborate with the operational DBA team regarding upcoming releases and existing database challenges and ensure code adheres to best practices for existing and new systems.
* Participate in regular code review for all new code deployment efforts as code is advanced through the development life cycle.
* Build, monitor and maintain enterprise non-production database environments.
* Analyze business and technical requirements to determine system design, database architecture, and potential issues.
* Produce design documents to effectively hand over infrastructure architecture to other Operations departments for successful systems engineering and implementation.
* Drive the adoption of reusable technology assets to improve efficiency.
* Contribute to the architectural frameworks and standards to be used by the engineering teams to design technology solutions.
* Identify regulatory risks related to architectural components and develops mitigation strategies.
* Collaborate with other teams in improving communication and teamwork to drive efficiencies and improvements.
* Other duties as assigned



Minimum Experience and Qualifications

* Bachelor's Degree in Computer Science OR demonstrated capability to perform job responsibilities with a High School Diploma/GED and at least four (4) years of previous experience
* Five (5) years of experience in development operations environment
* Four (4) years of experience in database technologies
* Proficiency with MS-SQL 2005, 2008, 2012, 2014, 2016 - SSIS, SSRS
* Extensive knowledge of T-SQL (procedures, triggers, functions)
* Knowledge of DR and HA solutions and their use
* Knowledge of database models and database architecture
* Experience in working with cloud technologies
* Knowledge of cloud computing DB infrastructure and considerations for scalable, distributed systems
* Knowledge and experience working with Azure and CosmosDB.
* Development and architecture experience of Azure/Cosmos database solutions.
* Available for overnight travel (up to 10%)
* Able to work flexible hours and be available for emergency response on short notice
* Able to pass a ten (10) year background check and pre-employment drug test

Preferred Experience and Qualifications:

* Communicates Effectively
* Knowledge of Oracle and/or MySQL
* Knowledge of Tibco Spotfire
* Ability to identify and challenge assumptions
* Ability to manage and minimize risks and escalate when necessary
* Ability to understand and analyze business problems, and a strong inclination to achieve such understanding before designing solutions
* A passion for technology and for solving business problems through innovation
* Knowledge and experience in performance tuning and troubleshooting incidents
* Knowledge of Microsoft server software, administration, and implementation
* Knowledge of networking applications, protocols, routers and firewalls
* Knowledge of technology fundamentals and concepts (Microsoft technologies preferred)
* Knowledge and experience in Microsoft APS (Microsoft PDW)
* Knowledge of scripting languages such as MS PowerShell
* Knowledge of JetBlue's business units and how their needs drive IT work
* Team player with the ability to work well with others and complete tasks with minimal supervision
* Effective project management skills
* Flexibility, agility and change management skills
* Ability to excel in a fast-paced dynamic work environment
* Database deployment via automation and configuration management tools, for private and public cloud environments, and reside in hosted datacenter environments
* Experience in performance tuning: indexing, drive distribution, partitioning & load balancing.
* Experience in routine data maintenance: re-indexing, integrity checking, database shrinking, security, Dynamic Management Views (DMV)
* Experience with DB Snapshots and Resource Governance

Crewmember Expectations:

* Regular attendance and punctuality
* Potential need to work flexible hours and be available to respond on short-notice
* Well-groomed and able to maintain a professional appearance
* When working or traveling on JetBlue flights, and if time permits, all capable crewmembers are asked to assist with light cleaning of the aircraft
* Must be an appropriate organizational fit for the JetBlue culture, that is, exhibit the JetBlue values of Safety, Caring, Integrity, Passion and Fun
* Promote JetBlue's #1 value of safety as a Safety Ambassador, supporting JetBlue's Safety Management System (SMS) components, Safety Policy and behavioral standards
* Identify safety concerns, issues, incidents or hazards that should be reported and report them whenever possible and by any means necessary including JetBlue's confidential reporting systems (Aviation Safety Action Program (ASAP) or Safety Action Report(SAR))

Equipment:

* Computer and other office equipment

Work Environment:

* Normal Office Environment

Physical Effort:

* Generally, not required, or up to 10 pounds occasionally, 0 pounds frequently. (Sedentary)

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by the crewmember(s) assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of individuals in this position. Position Expectations may be subject to change as the needs of the organization change.

JetBlue Airways Corp. is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, marital status, veteran status, sexual orientation, gender identity or expression, disability status, pregnancy, genetic information, citizenship status or any other characteristic protected by law. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

EEO is the Law

EEO is the Law GINA Supplement Back to top