Database Administration (MS SQL & Azure)

5 - 8 years

5 - 10 Lacs

Posted:1 month ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

In this challenging and interesting position, you are the expert for all topics related to databases. You will be part of an international team, that ensures the smooth and efficient operation of various database systems, including Microsoft SQL Server, Azure SQL, Oracle, DB2, MariaDB, and PostgreSQL. Your responsibilities include providing expert support for database-related issues, troubleshooting problems promptly, and collaborating with users and business stakeholders to achieve high customer satisfaction. Your expertise in cloud database services and general IT infrastructure will be crucial in supporting the development of the future data environment at Magna Powertrain. Major Responsibilities Responsible for ensuring the smooth and efficient operation of all database systems, including but not limited to Microsoft SQL Server, Azure SQL, Oracle, DB2, MariaDB, PostgreSQL. Provide expert support for database-related issues, troubleshoot and resolve problems quickly as they arise to ensure minimal disruption. Deliver professional assistance for database-related requests, working collaboratively with users and business stakeholders to achieve high customer satisfaction. Manage the installation, implementation, configuration, administration and decommission of database systems. Plan and execute database upgrades, updates, migrations, and implement changes, new patches and versions when required. Monitor database systems, database activities and overall database performance proactively, to identify issues and implement solutions to optimize performance. Develop and implement backup and recovery strategies, execute backups and restores to ensure data integrity and availability across all database systems. Perform database tuning and optimization, including indexing, query optimization, and storage management. Implement and maintain database security measures, including user access controls, encryption, and regular security audits to protect sensitive data from unauthorized access and breaches. Create and maintain proper documentation for all database systems and processes. Ensure constant evaluation, analysis and modernization of the database systems. Knowledge and Education bachelors degree in computer science / information technology, or equivalent (masters preferred). Work Experience Minimum 5-8 years of proven experience as a database administrator in a similar position. Excellent verbal and written communication skills in English. German language skills are optional, but of advantage. Skills and Competencies In-depth expertise of database concepts, theory and best practices including but not limited to high availability/clustering, replication, indexing, backup and recovery, performance tuning, database security, data integrity, data modeling and query optimization. Expert knowledge of Microsoft SQL Server and its components, including but not limited to Failover Clustering, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). Excellent knowledge of various database management systems, including but not limited to Oracle, IBM DB2, MariaDB and PostgreSQL. Familiarity with further database management systems (eg MySQL, MongoDB, Redis, etc) is an advantage. Extensive expertise about Microsoft Azure database services (Azure SQL Databases, Azure SQL Managed Instances, SQL Server on Azure VMs). Proficiency with other major cloud platforms such as AWS or Google Cloud, as we'll as experience with their cloud database services (eg Amazon RDS, Google Cloud SQL) are an advantage. Comprehensive understanding of cloud technologies, including but not limited to cloud architecture, cloud service models and cloud security best practices. Good general knowledge about IT infrastructure, networking, firewalls and storage systems. High proficiency in T-SQL and other query languages. Knowledge of other scripting languages are an advantage (eg Python, PowerShell, Visual Basic, etc). Experience with Databricks and similar data engineering tools for big data processing, analytics, and machine learning are an advantage. A working knowledge of Microsoft Power Platform tools including PowerApps, Power Automate, and Power BI is an advantage. Excellent analytical and problem-solving skills and strong attention to detail. Ability to work effectively in an intercultural team, strong organizational skills, and high self-motivation. Work Environment Regular overnight travel 10-25% of the time

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Magna International logo
Magna International

Motor Vehicle Manufacturing

Aurora Ontario

RecommendedJobs for You