Job summary:
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
required skills and qualifications:
* education & certifications:
* bachelor's degree in computer science, information technology, or related field
* experience:
* minimum of 5-7 years of hands-on experience in oracle database administration
* strong experience with oracle standard versions 11g, 12c, and 19c
* proficient in sql, pl/sql, and oracle performance tuning tools
* expertise in backup and recovery methods using rman. Data guard is a plus
* experience with oracle automated storage management (asm). Oem rac grid control is a plus
* technical skills:
* strong understanding of oracle architecture and internals including oracle database multitenant architecture
* proficiency in scripting languages such as linux bash and windows powershell
* familiarity with cloud platforms (e.g., aws) is a plus
* soft skills:
* strong problem-solving and analytical abilities
* excellent communication and documentation skills
* ability to work effectively in a team and under pressure
* strong organizational and time-management skills
complementary technical skills:
* experience with sql server administration including database upgrades, maintenance, replication, performance tuning, ssms, ssis, and ssrs is a plus