Database Administrator II – Information Technology

Come join us to create what’s next. Let’s define tomorrow, togetherDescription Job overview and responsibilities

• SQL Server Production Support

• Off-hours support for all Tier1 – Tier5 SQL Databases and InstancesCreate physical database structures based on physical design for development, test, and production environments

• Coordinate with systems engineers to configure servers for DBMS product installation and database creation

• Install, configure, and maintain DBMS product software on database and application servers

• Assist in the consultation to application development teams on DBMS product technical issues and techniques

• Implement monitoring procedures to maximize availability and performance of the database, while meeting defined SLA's

• Investigate, troubleshoot, and resolve database problems

• Communicate the required downtime with the application development teams and systems engineers to implement approved changes

• Identify, define and implement database backup / recovery and security strategies

• Install and support of DBMS (Database Management Systems) software and tools

• Perform various database activities which include monitoring, tuning, and troubleshooting, with appropriate supervision, if required

• Review deployment for all SQL database changes

• Complete pre-deployment code reviews with application teams as requested

• Review and provide feedback on all SQL code updates

• Work with deployment manages on dates and time for releases including assignments

• Performance Tunning and code review

• Migrations and DB setup (Cloud-AWS, SQL)

• Patching of all SQL Server and some Couchbase

• Work with application teams to create schedule

• Send advanced and timely notifications for database instances to be patched

• Conduct database patching including any troubleshooting and validation post patching

• Code release and Techincal Documentation

• Backup Recovery and DR

This position is offered on local terms and conditions. Expatriate assignments and sponsorship for employment visas, even on a time-limited visa status, will not be awarded. This position is for

United Airlines Business Services Pvt. Ltd - a wholly owned subsidiary of United Airlines Inc.

Qualifications

What’s needed to succeed (Minimum Qualifications):

• Bachelor's degree or 4 years of relevant work experience in Computer Science, Engineering, or related discipline

• Microsoft SQL Server Certification

• 5 Years of related experience

• Proficient in SQL development and administration disciplines with current hands-on experience with the latest SQL Server releases including SQL 2019, 2017, 2016

• Strong background and experience with all BC and DR capabilities of Microsoft SQL Server including Always-On, Mirroring, Log Shipping, and Clustering with a practical understanding of other Infrastructure BC/DC capabilities

• Leverage metrics to drive capacity planning and trending to proactively identify potential problems and mitigate before they result in customer impact

• Understand the place of automation and standardization when delivering stable, maintainable, and performant database services at scale

• Perform platform, database, and query optimization

• Must be legally authorized to work in India for any employer without sponsorship

• Must be fluent in English (written and spoken)

• Successful completion of interview required to meet job qualification

• Reliable, punctual attendance is an essential function of the position

What will help you propel from the pack (Preferred Qualifications):

• Master's degree in Computer Science, Engineering, or related discipline

• Microsoft/AWS certifications on DB track preferred

• Hands-On experience with AWS native databases, compute, storage, monitoring technologies, and continuous integration pipelines

• Experience implementing automation of Microsoft SQL Server deployment and maintenance, and support activities preferred

• Collaborate both vertically and horizontally to evolve overall database services and technology strategies

• Experience supporting SSAS, SSIS, and SSRS

• Very large Database (10+ TB) experience preferred

• Experience with PowerShell or other scripting languages a plus

• Experience with PCI, SOX, GDPR, and SQL Auditing a plus

• Ability to support 24 X 7 United operations databases. Quick learner of new technology and guidelines with flexible, positive attitude and team player with independent decision making

Industries:Airlines/Aviation, Consumer Services, Facilities Services