Senior Engineer - Database Administration

About the Job
Presight is seeking an experienced Senior Engineer - Database Administration (DBA) to manage a large, complex production database environment. The ideal candidate will possess technical expertise across Applications, Server, Storage, and Network technologies. This role focuses on providing effective centralized database administration for multiple databases, ensuring 24/7 operations of mission-critical applications.

Key Responsibilities:

• Ensure database availability 24/7 for mission-critical applications.
• Proactively manage and maintain security standards and controls, including database security and encryption.
• Optimize and simplify database architecture.
• Monitor performance and capacity; execute data migration jobs and scripts as required.
• Assist the infrastructure team with hardware sizing for the database.
• Collaborate with product developers and contribute to disaster recovery plans.
• Create and oversee backup strategies, including backup, clustering, mirroring, replication, and failover.
• Define and document database policies, procedures, and standards.
• Conduct performance testing and evaluation to ensure data security, privacy, and integrity.
• Identify bottlenecks and deadlock issues.
• Meet SLAs and operational KPIs, coordinating with internal and external support during major incidents.
• Perform routine maintenance on Oracle and SQL servers and databases.
• Manage database backups and restorations, recovering corrupted databases as needed.
• Evaluate and recommend new database technologies.
• Develop, manage, and test database backup and recovery plans.
• Document activities and prepare reports for management, including status reports.
• Interface with Oracle Corporation for technical support including patch management and version control.
• Ensure compliance with QHSE (Quality, Health, Safety, and Environment), Business Continuity, Information Security, Privacy, Risk, and Compliance Management policies.

Qualifications:

• Bachelor's degree in Computer Science or a related field with a minimum of 6 years of DBA experience.
• Preferably Oracle Certified DB Professional (OCP) with over 6 years of experience with Oracle in a lead role.
• Proficient knowledge of MS SQL Server, PostgreSQL, and native replication tools.
• At least two years of experience with database platform-specific advanced features like clustering, encryption, logical/physical standby, ETL, and replication.
• Experience in database design (modeling and normalization), capacity planning, performance tuning, data partitioning, and managing schemas and data security.
• Extensive UNIX/Linux experience.
• Familiarity with Oracle HA and replication technologies such as Data Guard, RMAN, Data Pump, and GoldenGate.
• Strong practical experience with Oracle in a production RAC (ASM) environment.
• Must be self-motivated with a keen attention to detail.
• Experience in environments reliant on 24/7 database reliability.
• Proficiency in Shell scripting and Python is an advantage.
• In-depth market and domain knowledge, a passion for improvement, and innovative problem-solving skills.
• Excellent communication skills are essential.

What Working at Presight Offers:

• Culture: An open, diverse, and inclusive environment that fosters personal growth and focuses on innovative, industry-first projects.
• Career: Opportunities for outstanding learning, development, and growth through structured training programs and high-tech projects.
• Rewards: A competitive remuneration package complemented by perks including healthcare, education support, leave benefits, and more.