Sr. Oracle Database Administrator

【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