- Azure SQL Database, Azure Cosmos DB, Azure Data Factory, Azure Synapse Analytics, and Databricks.
- Certification in one or more database platforms is preferred.
- Able to troubleshoot complex database engine performance or technical issues.
- Collaborate with Application development teams in designing databases and developing efficient queries based on load and use case.
- Collaborate with and understand the infrastructure team dependencies on the database environment.
- Ability to plan and execute tasks related to maintenance, upgrades, failovers, and other database system-sustaining activities as required.
- Strong capacity for logical thinking and the ability to understand complex applications and systems.
- Problem-solving attitude.
- Excellent organization & time management skills.
- Flexibility and adaptability to changes.
Senior Database Administrator - Portsmouth, United States - Amadeus
Description
Job Title
Senior Database AdministratorSummary of the role:
Amadeus Hospitality delivers award-winning solutions that empower hotel organizations of all sizes through cutting-edge technologies and constant innovation. Our organization is focused on providing our customers with the tools they need to stay laser-focused on delivering exceptional guest experiences.
As a Senior Database Administrator, you would report to the Manager of Database Administration, and will assist the database operations team in the implementation, configuration, security, maintenance, and performance tuning/monitoring of the Amadeus Hospitality database tier as assigned. The focus of this role is to ensure the availability and performance of existing and future enterprise applications through the use of Microsoft SQL Server, Azure SQL DB, and other emerging database technologies.
Another key function of this role is to ensure best practices are followed during database design, coding, and the release of applications by the development teams for existing and future enterprise applications.
The individual will partner closely with cross-functional teams that include Development, Product, and Architecture to ensure the delivery of our applications at the highest level of quality and performance.
This is a Hybrid role. The successful candidate may be in the Orlando, FL, or Portsmouth, NH office, 50% of the time. There is no relocation package associated with this role.
In this role, you'll be responsible for the following:
Design and create new SQL databases in support of both on-prem and in-the-cloud applications. As well as maintaining and enhancing the performance of existing databases with a strong emphasis on high availability/fault tolerance and disaster recovery. Collaborate with Architecture and Application development teams in high-level data-tier design for hospitality products. This would include using appropriate database technology, evaluating query patterns, reports and analytics, data movement/distribution (SSIS, Azure DataFactory, etc.), and ensuring the proper usage of supporting indexes, partitioning, and in-memory features. Upgrade databases to the latest versions, monitor overall health using available tools (DPA, extended events, etc.) and take appropriate data management improvement actions like partitioning, indexes, in-memory tables, etc. Manage databases through phases of the Software Development Lifecycle (SDLC), from development through critical Production systems. Collaborate with TechOps to manage and create standards, procedures, and policies for governing database environments. Provide technical guidance to multiple application development teams in the design and development of database components. Provide escalation support, troubleshooting and resolution assistance, and performance tuning aid for the R&D and operational database teams. Provide escalation support, troubleshooting and resolution assistance, and performance tuning aid for the platform and operational database teams. Mentorship, guidance, and support are continually given to fellow DBAs on the level 2 and level 3 DBA teams.
About the ideal Candidate:
Education: Bachelor's degree or higher. Master's degree preferred. Relevant
Work Experience:
8+ years managing Microsoft SQL Server database technologies, such as SQL Server, SSRS, and SSIS for enterprise applications.
2+ years' experience working with Azure or other cloud technologies is preferred
2+ years' experience working in any NoSQL (or other database technologies used in the industry) technology is a plus.
Business Understanding:
Understanding the hospitality transactional patterns for clear and concise capacity management.
Overall domain knowledge and functional understanding of the Hospitality Industry is a plus: CRS, CRM, Loyalty, PMS, Sales and Events, RMS, Service Optimization, Channels and Distribution.
Skills:
Computing:
Language Skills: SQL, T-SQL
Specific Knowledge: Other industry certifications such as SAFe or ITIL are a plus
Other:
Diversity & Inclusion
Amadeus is an Equal Employment Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or a related medical condition), ancestry, national origin, age, genetic information, military or veterans status, sexual orientation, gender expression, perception, or identity, marital status, mental or physical disability status, or any other protected federal, state, or local status unrelated to performance of work involved.
Amadeus endeavors to make accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.
Worker Sub-Type
Permanent
Location
Portsmouth, New Hampshire
Orlando Florida
Time Type
Full time
Diversity & Inclusion
Amadeus is an Equal Employment Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or a related medical condition), ancestry, national origin, age, genetic information, military or veterans status, sexual orientation, gender expression, perception, or identity, marital status, mental or physical disability status, or any other protected federal, state, or local status unrelated to performance of work involved.
Amadeus endeavors to make accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.