Database Administrator II – Information Technology

Other Jobs To Apply

No other job posts for this day.

Description

United's Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions.

Find your future at United! We’re reinventing what our industry looks like, and what an airline can be – from the planes we fly to the people who fly them. When you join us, you’re joining a global team of 100,000+ connected by a shared passion with a wide spectrum of experience and skills to lead the way forward.
 
Achieving our ambitions starts with supporting yours. Evolve your career and find your next opportunity. Get the care you need with industry-leading health plans and best-in-class programs to support your emotional, physical, and financial wellness. Expand your horizons with travel across the world’s biggest route network. Connect outside your team through employee-led Business Resource Groups.
 
Create what’s next with us. Let’s define tomorrow together.

Job overview and responsibilities

United Offshore SQL DBA Team supports critical after hours work to support timely releases and patching activities overnight along with 8pm-8am rotational on call to support for very critical DB operations monitoring and incident support. SQL DBA team in India works along with offshore development teams in code review and troubleshooting for performance issues essential for United’s 24x7 technology support structure. They are actively engaged in migration projects for SQL desupported version remediation and supporting also works on AWS setup and support across all areas of clould migrations and production support.

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

QualificationsWhat’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
Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...