DBA (Oracle & SQL)

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)