Senior Analyst, Database Administrator

Job Description – Senior Analyst, Database Administrator (DBA)

Job Summary

We are seeking an experienced Senior Analyst, Database Administrator (DBA) to design, implement, manage, optimize, and support Oracle database environments across enterprise platforms. The successful candidate will provide consulting expertise on database architecture, performance tuning, high availability solutions, security, migration projects, and operational best practices. This role requires strong technical skills, and the ability to deliver database solutions aligned with business objectives.

Key Responsibilities

Database Administration & Support

• Manage Oracle databases across Development, UAT, Production, and Disaster Recovery environments.
• Monitor database health, availability, capacity, and performance.
• Perform proactive maintenance, troubleshooting, and root cause analysis.
• Ensure database backup, recovery, and disaster recovery procedures are regularly tested and maintained.

Performance Tuning & Optimization

• Analyze and optimize SQL queries, PL/SQL code, and database performance.
• Perform database tuning using AWR, ASH, ADDM, Statspack, and OEM tools.
• Monitor system resources and recommend capacity planning strategies.
• Identify and resolve performance bottlenecks across database and application layers.

Architecture & Consulting

• Provide expert consulting services on Oracle database solutions and best practices.
• Design highly available and scalable database infrastructures.
• Advise stakeholders on database architecture and modernization strategies.
• Participate in solution design discussions and technical reviews.
• Prepare technical documentation, standards, and operational procedures.

High Availability & Disaster Recovery

• Conduct DR drills and ensure recovery objectives are met.

Security & Compliance

• Implement database security controls and access management.
• Perform database auditing, vulnerability assessments, and compliance reviews.
• Ensure adherence to organizational security policies and regulatory requirements.
• Support data encryption, masking, and database hardening initiatives.

Required Qualifications

Education

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related discipline.

Experience

• At least 5 years of hands-on Oracle DBA experience.
• Proven experience in enterprise-level Oracle database administration and consulting.
• Experience managing mission-critical Production databases.

Technical Skills

• Oracle Database 19c
• Oracle RAC, ASM, Data Guard, Active Data Guard.
• Oracle Enterprise Manager (OEM).
• SQL and PL/SQL performance tuning.
• Database monitoring and capacity planning.