SQL Database Administrator

United Airlines

Gurgaon, Haryana

5 - 6 yrs Exp.

Not Disclosed

02 Feb 2023
8 Applicants
1064 views

Job Description

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 de-supported version remediation and supporting upgrades. Team also works on AWS setup and support across all areas of cloud migrations and production support.

SQL Server Production Support
- Off-hours support for all Tier1 – Tier5 SQL Databases and Instances
- Create 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 Technical Documentation
Backup Recovery and DR

Skills/ Qualifications:

Required

Bachelor's degree
Computer Science, Engineering, or related discipline
5 Years of related experience
Microsoft SQL Server Certification
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

Preferred

Master's degree
Computer Science, Engineering, or related discipline
7 Years of related experience
Microsoft/AWS certifications on DB track
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
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
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

Key Skills

SQL AWS PowerShell PCI SOX GDPR

Other Details

Education

Any Graduation/Diploma , B.Tech/B.E. - Any specialization

Employment Type

Full Time, Permanent

Industry

Aviation / Aerospace Firms

Funtional Area

Maintenance

About Company

This is the story of airline that leads the industry from ground to clouds. Our global cast of over 90,000+ hero characters are each on a journey to be a force for good for our customers, the planet and each other. Come be part of this story, we’re hiring 15,000 people in 2023.

Job Source : https://careers.united.com/us/en/job/GGN00001096/SQL-Database-Administrator

Related Jobs

Database Architect in TCS Bangalore

Tata Consultancy Services - TCS

Bangalore, Karnataka
8-12 yrs Exp.

Big Data Cloud Computing SQL NoSQL AWS Azure