Database Administrator (2 post)

Mechatronics Systems Pvt. Ltd.

Pune District

On-site

INR 600,000 - 1,000,000

Full time

44 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mechatronics Systems Pvt. Ltd. in Pune is seeking a Database Administrator to manage upgrades, patching, migrations, and high-availability configurations. You will design backup and recovery solutions, optimize queries, and monitor system performance across large database environments.

The role requires 3+ years of IT/CSE-related database experience, knowledge of NoSQL, MongoDB, and SQL clusters, and strong diagnostic skills for cross-database interactions.

Qualifications

  • Experience with database upgrades, patching, and migrations.
  • Ability to design and implement backup and recovery solutions.
  • Ability to monitor resources and troubleshoot database performance issues.
  • Experience with capacity planning for large database infrastructures.
  • Proficient in query optimization and cross-database queries.

Responsibilities

  • Manage database upgrades, patching, migrations and changes.
  • Develop and implement backup and recovery strategies for databases.
  • Monitor resources usage; perform troubleshooting and diagnostics.
  • Perform capacity planning for the database infrastructure.

Skills

Query Writing
SQL
NoSQL
MongoDB
SQL Cluster Replication
Master-Master / Master-Slave Rep
Replication Troubleshooting
Performance Tuning
Capacity Planning
Database Upgrades
Backup and Recovery
Patching & Patches
Stored Procedures & Triggers
Indexing & Data Modeling
SQL Server / RDBMS Concepts
On-call Support
Cross-Database / Cross-Server Queries
Operating Systems Interaction
Load/Hardware Analysis

Education

BSc./MSc./BCA/MCA/BE/B.Tech/M.Tech/ME in IT/CSE

Tools

MS Active Directory integration

Job description

Minimum Experience : 3+Year
Minimum Qualification : BSc./MSc./BCA/MCA/BE/B.Tech/M.Tech/ME in IT/CSE
Location : Pune(Relocate to Client Side)

Responsibility :
  • Databaseupgrades, patching, migrations
  • Develop and implementdatabasebackup and recovery solutions
  • Control system resources usage, perform troubleshooting and diagnostics activities
  • Analyze resources usage (Infra andDatabase), analyze growth patterns, Perform Capacity planning for theDatabase Infrastructure.
  • Collect and analyzedatabaseperformance information; identify and implement solutions for performance problems
  • Query optimization and tuning skills including crossdatabaseand cross server queries, analysis and troubleshooting interactions betweendatabases, operating systems and applications with regard to performance and resources usage
  • Experience indatabaseprogramming concepts including structured query language, stored procedures and triggers
  • Creatingdatabasetables, setting up indexes, data constraints and DB views Analyze, predict through trend analysis and resolvedatabasesystem, storage and application issues
  • Monitor SQL jobs in production and be responsible for load/hardware analysis mapping, fault tolerance and security.
  • Evaluate and implementdatabasetechnologies and utilities
  • Review and implementdatabasechanges
  • Provide timely response to system alerts and participate in the on-call schedule (if applicable)
Technical Skills :
  • Extensive Knowledge in Query Writing, Trigger Writing, SQL function Writing, Creating Joins, Creating View
  • Extensive Knowledge of Relational Database Design with higher normalization
  • Good Knowledge of No-SQL, Mongo Db, etc.
  • Expertise in SQL Cluster Replication methods andadministration
  • Experience in Master-Master/ Master-Slave replication and troubleshoot replication issues
  • Experience working in large [50+]databaseinstance environments with size ranging up-to 1TB having Master-Slave replications, group replication, InnoDB Cluster and DB Upgrades
  • Experience of working in large landscape/environment where multipledatabaseflavors are running.
  • Should be capable of Owning, Leading and coordinate operational tasks, customer escalations, process improvements.
  • Hands-on architecture, installation, upgrade, production support, cloning, and advanced configuration skills.
  • installation and configuration such as MS Active directory integration
  • Excellent technical knowledge in different SQLversions.
  • Experience in patching strategy for Hotfixes and Cumulative Updates.
    Good understanding on RDBMS concepts anddatabasedesign skills.
Competency Requirement :
  • Excellent communication and inter-personal skills.
  • Should be a quick learner with an eye for detail.
  • Ability to prioritize work.
  • Drive for results within deadlines.
  • Demonstrate a high degree of self-motivation and tenacity to get the job done.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Epergne Solutions • Tamil Nadu

On-site
INR 600,000 - 1,200,000
Database Administrator
Database Administrator

Epergne Solutions • Bengaluru

On-site
INR 800,000 - 1,400,000
Database Administrator
Database Administrator

Epergne Solutions • Maharashtra

On-site
INR 600,000 - 1,200,000
Database Administrator
Database Administrator

Epergne Solutions • Hyderabad

On-site
INR 650,000 - 1,200,000
Database Engineer/Database Administrator (DBMS)
Database Engineer/Database Administrator (DBMS)

Cerebra • Ernakulam, Chennai, Bengaluru

On-site
INR 1,500,000 - 2,100,000
Database Administrator
Database Administrator

Tata Consultancy Services Limited • Pune District, Chennai, Bengaluru

Remote
INR 1,500,000 - 2,500,000
Database Engineer
Database Engineer

Harbinger Systems • Pune District

Hybrid
INR 1,500,000 - 2,300,000
Associate Tech Specialist / Tech Specialist- Database
Associate Tech Specialist / Tech Specialist- Database

Harbingergroup • Pune District

Hybrid
INR 2,000,000 - 3,500,000
Senior Database Administrator (Oracle / SQL Server / PostgreSQL)
Senior Database Administrator (Oracle / SQL Server / PostgreSQL)

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,600,000
MS SQL DBA CONSULTANT (Mumbai)
MS SQL DBA CONSULTANT (Mumbai)

Swathi Business Solutions • Mumbai City

On-site
INR 1,500,000 - 2,200,000