SQL DBA

Location: Noida, India

Thales people architect solutions that enable two-thirds of planes to take off and land safely. We create in-flight entertainment systems that engross 50 million fliers every year and we develop the avionics that control the world’s largest commercial aircrafts. Our simulators train the next generation of pilots for fighter jets, transporters and search and rescue helicopters. And, together, each and every member of our aerospace team makes a difference.

Present in India since 1953, Thales is headquartered in Noida, Uttar Pradesh, and has operational offices and sites spread across Bengaluru, Delhi, Gurugram, Hyderabad, Mumbai, Pune among others. Over 1800 employees are working with Thales and its joint ventures in India. Since the beginning, Thales has been playing an essential role in India’s growth story by sharing its technologies and expertise in Defence, Transport, Aerospace and Digital Identity and Security markets.

Job Title: Production systems Database administrator

Job Profile Title: DBA

Global Business Unit: Thales Avionics, Inc

Location: Noida India

Position Summary

The position of DBA Administrator is responsible for managing databases hosted both on-premises equipment and cloud based systems – AWS, Azure, Google Cloud and others. In addition to the database, support the infrastructure used for hosting the DBs (physical and virtual servers and/or configuration items in the Cloud), support the development teams for all applications identified in the Corporate Road Map. Responsibilities also include planning and implementing new releases and new tools/modules. As a Database Administrator, you will be responsible for installation, configuration, administration, operation, optimization, and support of various databases in the production environments including, but not limited to, Microsoft SQL, MySQL, Cosmos DB, MongoDB, MariaDB, Oracle, etc.The role requires to transform existing on-prem databases to managed services leveraging cloud tools and ensuring compliance with SOC2.

Minimum Requirements: Skills, Experience, Education, Technical/Specialized Knowledge, Certifications, Language

• Bachelor’s degree in Computer Science or Engineering
• 4 to 7 years’ Experience as MS SQL DBA + desirable1 more other database system.
• Minimum 2 years of experience in AWS RDS, RDS Custom and Azure Cosmos databases
• Desirable some experience in Databricks / Datalake
• Excellent written and verbal communication skills
• Good analytical, problem solving, facilitation and negotiation skills
• Multi-task oriented with good organizational skills
• Positive team-oriented attitude
• Ability to work well under pressure

Essential Functions / Key Areas of Responsibility

• Install, configure, patch and maintain various database architecture including Microsoft SQL, Oracle, MySQL, MongoDB etc.
• Tune and monitor all Database instances.
• Approve all production schema changes.
• Approve changes to database design.
• Control all migrations schema objects
• Maintain clustering and high availability on/when needed.
• Monitor and troubleshooting transaction replication
• Analyze, size, and implement databases.
• Assist Developers and Integration team on database activities such as installation, databases creation and migration plan execution.
• Initiate new databases and perform database migrations as needed.
• Assist other teams on benchmark and volume testing.
• Assist service desk team in analyzing database problems.
• Report and follow problem escalation to 3rd party vendor if applicable
• Responsible for maintenance window activities.
• Create and manage databases from through its whole lifecycle (creation to decommissioning).
• Manage databases in adherence to security systems and standards maintaining proper access control in place for users and service accounts database interactions, etc..
• Accomplish capacity planning for current system’s growth and new systems.
• Develop and deploy backup and recovery procedures + ensure it works properly through regular tests.Maintain procedures to reflect change in the environment.
• Install and upgrade new releases.
• Install and upgrade new modules.
• Manage indexes, space and lock contention.
• Configure and troubleshoot databases in a client/server environment.
• Communicate effectively with staff in the US, India and other teams from across the globe.
• Be available for after-hours support.
• Support on managing maintenance contracts for Databases.
• Work closely with systems administrator and developers for installations, support and problem resolution.
• Lead technical projects.
• Participate in projects to provide database management support.
• Maintain separate production, development, and test environments; refresh databases as necessary.
• Provide training and guidance for developers for query optimization.
• PowerBI reports / dashboards.
• Ability to create extraction translation layer (ETL) jobs

Special Position Requirements

• Support if required to be on call to work mandatory weekends when support is needed.
• Be available for on call support on weekends in rotation with team members
• Work during EST timezone (Starting at 5:00 AM in the morning).

YOUR CAREER AT THALES

Future opportunities will allow you to discover other domains or sites. You will be able to evolve and grow your competences in different areas:

Room and attention to personal development

Build your talents in another domain of Thales Group, discovering new products, new customers, new country or go to a more complex Solution

Choose between a technical expertise or a leadership path

Build an international career within a leading Engineering Group

At Thales we provide CAREERS and not only jobs. With Thales employing 80,000 employees in 68 countries our mobility policy enables thousands of employees each year to develop their careers at home and abroad, in their existing areas of expertise or by branching out into new fields. Together we believe that embracing flexibility is a smarter way of working. Great journeys start here, apply now!