Software Engineer II

Basic/ Essential Qualifications:

• Experience as a Senior Level Database Administrator, with a focus on Oracle and similar database technologies such as PostgreSQL or MS-SQL.
• Proven track record of implementing and leading SRE practices across large organizations or complex teams.
• Expert-level knowledge of telemetry, monitoring, and platform observability tooling (e. g. , ESAAS, Grafana, Prometheus, ) with experience in customizing and scaling these solutions.
• Experience in implementing modern DevOps and SRE practices in enterprise environments.
• Proven expertise in SQL query optimization and database performance tuning at scale.
• Experience with DevOps automation tools such as Code versioning (git), JIRA, Ansible, Containers and Kubernetes (OpenShift), database CI/CD tools and their implementation.
• Recognized as a Oracle subject matter expert, serving as the technical escalation for complex database issues.
• Proven experience in executing database migration strategies at enterprise-scale.
• Exceptional collaboration skills with executives and cross-functional teams.
• Extensive experience working with large, distributed, high-performance, high-availability databases with 24/7 uptime.
• Expert knowledge of database administration on Oracle.
• Expert in multiple versions of Oracle - 11g, 12c, 19c.
• Expert knowledge of RMAN, Dataguard, Database Performance Tuning, OEM, plus third-party products such as Imperva.
• Understand and meet the scale, capacity, security, performance attributes, and requirements of the service and technology stack.
• Responsible for debugging the code in case any bug is reported in the Oracle product and fixing theinfrastructure/databaserelated issues.
• Hands-on as DevOps on Ansible, Python, PL SQL coding.
• Focus on resilience, scaling, reliability, uptime, and robustness.
• Strong technical skills in areas such as Oracle system administration, networking, cloud infrastructure, automation, and monitoring tools.
• Expert knowledge of Real Application Cluster with Maximum Availability setup.
• Must exhibit SME expertise in solving database contention, Performance Tuning problems (Slow sql response, slow database response etc).
• Database, RAC, OEM, OID installation, configuration and integration.
• Database Upgrade, Migration with ZDLR and Patching.
• Expertise in Goldengate configuration, troubleshooting.
• Database Security policies, fine grained auditing.
• Must have extensive experience as Production support Oracle Database Administrator - strong experience in handling large, high volume and high criticality environments.
• Demonstrate extensive expertise in performance tuning including both query and database optimization.
• Knowledge of the ITIL framework, vocabulary and best practices.
• Excellent spoken and written English communication skills.

Desirable skillsets/ good to have:

• Working experience in a financial environment.
• Cloud experience (AWS, Azure, GCP).
• Oracle Certified Performance Tuning Expert - Oracle 19c, 12c or 11g.
• Oracle Certified Maximum Availability Expert - Oracle 19c, 12c or 11g.
• Experience of working in a highly regulated environment and the associated processes and tools.
• Expert in system configuration management tools such as Chef, Ansible for database server configurations.
• Expert expertise with scripting languages (e. g. PowerShell, Python, Bash) for automation/migration tasks.
• AWS Certified Database - Specialty certification is a plus.