DBA Oracle And SQL

Tata Electronics Private Limited; Assam; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Tata Electronics Private Limited is seeking a skilled Database Administrator (DBA) with 5+ years of hands-on experience managing Oracle and SQL Server databases in a manufacturing setting. The candidate will maintain performance, integrity, and security of enterprise databases integral to MES, ERP, and quality systems.

Responsibilities include backups, disaster recovery, tuning, data integration, and automation. Familiarity with GMP/ISO environments and cloud services is a plus.

Qualifications

• 5+ years of Oracle and SQL Server administration experience.
• Experience with manufacturing IT systems (MES, ERP, QMS) is preferred.
• GMP/ISO‑compliant environments knowledge is a plus.
• Exposure to cloud databases (AWS RDS, Azure SQL) is beneficial.

Responsibilities

• Administer and maintain Oracle and SQL Server databases.
• Ensure database availability, reliability, and performance across environments.
• Perform regular backups, restorations, and disaster recovery planning.
• Tune performance (AWR, execution plans, indexing) for high availability.
• Support data integration between manufacturing systems and SAP/SCADA/PLM.
• Maintain data integrity and security with proper access controls and auditing.
• Collaborate with application teams for schema changes, migrations, and upgrades.
• Automate DBA tasks using scripts and scheduling tools.
• Participate in root cause analysis for production issues.
• Implement replication and high availability solutions where applicable.
• Document architecture, procedures, and standards.

Skills

Oracle DB architecture

SSMS

Backup & Recovery

Query optimization

Scripting

HA / Clustering

Manufacturing IT systems

Education

Bachelor’s degree in Computer Science/IT or related field

Job description

Job Description:

Job Summary:

We are seeking a skilled and proactive Database Administrator (DBA) with at least 5 years of hands‑on experience in managing Oracle and SQL Server databases in a manufacturing environment. The ideal candidate will be responsible for maintaining the performance, integrity, and security of enterprise databases critical to operations, MES, ERP, and quality systems.

Key Responsibilities:

• Administer and maintain Oracle (preferably 12c/19c) and Microsoft SQL Server databases.
• Ensure database availability, reliability, and performance across production and development environments.
• Perform regular backups, restore operations, and manage disaster recovery plans.
• Monitor and tune database performance (AWR, execution plans, indexing) to ensure high availability and low latency for applications like MES, ERP, QMS.
• Support data integration between manufacturing systems, equipment, and enterprise IT systems (e.g., SAP, PLM, SCADA).
• Ensure data integrity and security, implementing appropriate access controls and auditing.
• Work closely with application teams to support schema changes, data migration, and system upgrades.
• Automate routine database administration tasks using scripts and job scheduling tools.
• Participate in root cause analysis for database‑related production issues.
• Implement and maintain replication, high availability (RAC, AlwaysOn), and clustering solutions where applicable.
• Document architecture, procedures, and standards.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience in Oracle and SQL Server database administration.
• Strong knowledge of PL/SQL, T‑SQL, stored procedures, triggers, and views.
• Experience in managing databases for manufacturing applications (MES, ERP, QMS).
• Understanding of data modeling, ETL processes, and data warehousing concepts.
• Familiarity with GMP/ISO‑compliant environments is a plus.
• Exposure to cloud database services (AWS RDS, Azure SQL) is an advantage.
• Certifications like Oracle Certified Professional (OCP) or Microsoft Certified: Azure Database Administrator preferred.

Key Skills:

• Oracle DB architecture and tools (OEM, RMAN, Data Pump)
• SQL Server Management Studio (SSMS)
• Backup & Recovery strategies
• Query optimization and performance tuning
• Scripting (Shell, PowerShell, Python optional)
• High availability / clustering / failover
• Knowledge of manufacturing IT systems

Soft Skills:

• Strong analytical and problem‑solving skills
• Good communication and documentation abilities
• Ability to work under pressure and manage multiple tasks
• Collaborative mindset to work with cross‑functional teams (IT, Production, Quality)