Overview
Skills
Job Details
Job Title: Senior Technical Operations Analyst
Location: West Des Moines, IA
Job Type: Full-Time / Contract
Job Summary:
We are seeking a Senior Technical Operations Analyst who thrives in a fast-paced, complex environment. The ideal candidate is a proactive problem-solver with a strong technical background, excellent SQL and Oracle database skills, and a passion for bridging the gap between business and technology teams. This role will support two key platforms DocD (SQL Database) and PJADF (Oracle-based platform with PDH and RPD on Linux) and requires both deep technical expertise and effective collaboration.
Key Responsibilities:
Support and maintain enterprise data platforms (DocD and PJADF)
Write complex SQL queries, stored procedures, and perform query tuning for optimal performance
Design and maintain relational database schemas and support ETL processes
Administer and optimize Oracle databases, including PL/SQL and performance tuning
Develop backend services using Java and Spring Boot in a Linux-based environment
Collaborate with cross-functional teams to ensure systems are integrated, secure, and compliant
Monitor and troubleshoot platform issues, supporting root cause analysis and resolution
Document processes, improvements, and technical configurations
Technical Skill Requirements:
< data-start="2060" data-end="2099">DocD Platform (SQL Database)</>
Must-Have:
Strong SQL expertise: complex queries, stored procedures, tuning
Relational data modeling
ETL pipeline knowledge
Database security (encryption, access control)
Integration experience with reporting tools or applications
Nice-to-Have:
Power BI, Tableau, or equivalent reporting tools
Python or Shell scripting for automation
Exposure to cloud database services (Azure SQL, AWS RDS, Google Cloud Platform Cloud SQL)
Version control with Git
< data-start="2582" data-end="2633">PJADF Platform (Oracle DB, RPD on Linux)</>
Must-Have:
Proficiency with Oracle DB, PL/SQL, and Oracle tools
Linux command-line, scripting (Bash), and system monitoring
Java and Spring Boot backend development
Oracle-to-Java integration in Linux environments
Knowledge of secure coding and system hardening
Nice-to-Have:
Infrastructure automation (Ansible, Puppet)
Monitoring/logging tools (Nagios, Prometheus, ELK)
Docker and Kubernetes
CI/CD experience (Jenkins, GitLab CI)
Preferred Qualifications:
5+ years of experience in Technical Operations or Application Support
Proven ability to analyze and resolve platform issues
Strong organizational and documentation skills
Experience working in Agile/Scrum environments