DBA (Oracle & SQL)
DBA (Oracle & SQL)
Jagiroad, AS, IN
Jagiroad, AS, IN
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)
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)