【Purpose】
Senior Oracle Database Administrator is responsible for the design, implementation, management, and maintenance of Oracle databases within the organization. This position requires expertise in database architecture, performance tuning, backups, security, and troubleshooting, as well as a deep understanding of Oracle database technologies. Provide operationally efficient systems that meet business objectives and control costs.
【Key Responsibilities】
§ Database Administration §
●Install, configure, and maintain Oracle databases and related database software
●Perform regular database health checks, including capacity planning and tuning
●Manage Oracle database backups and disaster recovery procedures
●Configure, optimize, and troubleshoot Oracle databases for performance, stability, and reliability
§ Performance Tuning §
●Monitor database performance and make necessary adjustments to improve performance
●Utilize Oracle tools (e.g., OEM) to diagnose and resolve performance issues
●Implement indexing strategies and SQL query optimizations
§ Security Management §
●Implement and enforce database security policies, including user access control and data encryption
●Monitor and audit database activities to ensure compliance with security standards
§ Backup & Recovery §
●Design and implement efficient backup and recovery strategies
●Test backup and recovery processes regularly to ensure data integrity
§ Database Upgrades & Patch Management §
●Plan and execute Oracle database upgrades and patching
●Review and apply database patches for bug fixes and performance improvements
§ Capacity Planning & High Availability §
●Ensure the scalability of Oracle databases by analyzing future requirements and performing capacity planning
●Implement and maintain high-availability solutions
§ Disaster Recovery §
●Develop and maintain a disaster recovery plan for Oracle databases
●Ensure minimal downtime during system failure or disasters
§ Collaboration §
●Collaborate with development teams to support database-related queries, issues, and database design
●Provide mentoring and guidance to junior DBAs and other technical teams
§ Automation & Scripting §
●Develop scripts for automation of regular database maintenance tasks (e.g., backups, health checks, monitoring, cloning or replicating databases)
§ Troubleshooting & Support §
●Provide 24/7 on-call support for production database issues
●Diagnose and resolve critical database problems, including SQL and performance issues
* This position works with US stakeholders mostly, so the working hours are not consecutive 8 hours in the daytime. Some hours in the evenings are required. The time slots and the allocation are all negotiable.
* This position works onsite in the daytime and remote in the evenings
【Who We Are?】
Hytech是一個年輕、充滿活力的團隊,專注於推動金融科技行業的企業技術轉型,是全球領先的管理技術諮詢公司。創新思維和扁平化的管理,讓團隊成員以公開、透明的方式自在工作,也為全球客戶提供卓越的商業價值服務。
【Why Join The Team?】
我們的運營卓越團隊是我們以客戶為中心業務的核心。他們是與我們的客戶、客戶服務團隊和業務緊密合作的前線人員,通過説明客戶在實現其目標方面取得成功,每天都在啟動、支援和發展公司的客戶。
【身為團隊的一份子您將負責】
1. Design, deploy, maintain, and monitor the company’s cloud database infrastructure, ensuring reliable 24/7 operation.
(負責設計、架設、維護和監控公司雲端資料庫,並確保 7x24 穩定運行)
2. Diagnose and optimize the performance of the company’s cloud database and provide timely follow-up to resolve issues.
(負責公司雲端資料庫問題診斷及性能優化,並能夠及時跟進解決)
3. Collaborate with developers, operations personnel, and project managers to design efficient, secure, and reliable SQL programs.
(與開發、運維人員及項目經理溝通協作,設計高效、安全且穩定可靠的 SQL program)
4. Responsible for the planning, setup, management, and drills for cloud database backup and recovery.
(負責公司雲端資料庫備援規劃、建置、管理及演練)
5. Provide necessary technical support to the security and compliance teams.
(為安全及合規部門提供必要支援)
本公司自行開發及設計自有ERP產品:ArgoERP
主要使用Oracle Forms & Reports進行ERP系統產銷人發財等各模組的開發
此職缺主要是做ERP系統的日常維護,包括Oracle PL/SQL、Forms & Reports資料庫應用及操作介面之程式撰寫
並協助客戶排除ERP系統問題、提供客戶系統功能諮詢服務