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**

**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