Senior Systems Analyst Database AdminAutomationAI

Job Summary

This role combines database management and development responsibilities. The candidate will design maintain and optimize databases while also developing automation scripts tools and integrations to improve system performance and reliability. The role requires strong expertise in Oracle Database proficiency in scripting or programming languages (such as Python Shell) and a solid understanding of performance tuning backup strategies and DevOps practices. A technically versatile professional who can manage databases efficiently while contributing to development and automation initiatives.

Key Responsibilities

Manage monitor and optimize Oracle and Exadata databases to deliver high availability scalability and peak performance.

Design and implement automation for database maintenance monitoring incident resolution and reporting using Python Shell or PowerShell.

Conduct performance tuning including query optimization index strategy and database configuration fine-tuning.

Develop validate and maintain robust backup recovery and disaster recovery strategies for mission-critical environments.

Lead incident and problem management for complex database issues performing deep root-cause analysis and implementing preventive controls.

Execute capacity planning storage optimization and resource utilization analysis to support business and application growth.

Collaborate with application DevOps and infrastructure teams to design efficient database architectures and contribute to data modeling discussions.

Promote continuous improvement by researching and adopting emerging technologies automation frameworks and performance engineering practices.

Qualifications & Skills

Mandatory

6 years of hands-on experience in database administration monitoring automation and performance engineering.

Expert-level experience in Oracle Exadata administration including performance tuning storage optimization patching and security.

Strong proficiency in high-availability database architectures (clustering replication Always On DR solutions).

Deep understanding of SQL indexing query optimization locking transaction management and DB internals.

Proven ability to troubleshoot complex database performance reliability and scalability issues.

Strong experience designing and implementing backup recovery and DR strategies.

Hands-on experience with scripting and automation (Python Shell PowerShell).

Ability to thrive in high-stakes 24x7 operational environments with a proactive solution-focused mindset.

Excellent communication and collaboration skills.

Good-to-Have

Exposure to cloud-based database solutions (OCI AWS Azure).

Knowledge of DevOps practices CI/CD and Infrastructure-as-Code (Terraform Ansible).

Experience with data modeling or supporting application development teams.

Certifications in Oracle Database Exadata or Cloud technologies.

Experience with database observability and APM tools.

Self-Assessment Questions

Candidates can use these questions to assess their fit for the role:

Have I administered and optimized Oracle Exadata environments at a deep expert levelincluding performance tuning storage optimization and security

Do I have at least 8 years of hands-on experience managing production databases with strong skills in monitoring automation and troubleshooting

Can I design and implement robust high-availability backup recovery and DR solutions in mission-critical 24x7 environments

Am I proficient in SQL query tuning indexing strategies and understanding database internals to solve complex performance issues

Do I have strong scripting skills (Python/Shell/PowerShell) and experience building automation to improve efficiency and reduce errors

Career Level - IC3