Job Description
Apiphani is a technology-enabled managed services company dedicated to redefining what it means to support mission-critical enterprise workloads. We’re a small but rapidly growing company, which means there’s lots of room for growth and learning opportunities abound!
Apiphani is dedicated to creating a diverse and inclusive work environment for all as a fundamental component of our business. Diversity and inclusion are the bedrock of creativity and innovation. Without diversity of experience and thought, we would fail to progress as a company and as a team. Apiphani strives to foster an environment of belonging, where every employee feels respected, valued, and empowered. We embrace the unique experiences, perspective, and cultural background, which only you can bring to the table.
Sr. Sybase ASE 16.x DBA
Job Description
Sybase ASE database administrators are responsible for performing operational activities to manage, maintain, and optimize existing SAP Sybase Adaptive Server Enterprise (ASE) environments to ensure high performance and availability. Key responsibilities include installation, patching, performance tuning, backup/recovery, security management, and troubleshooting.
Job Duties
- Perform sustainment and system maintenance activities by troubleshooting Sybase ASE issues, documenting issue resolution.
- Install, configure, upgrade, and patch SAP Sybase ASE databases.
- Monitor system health and optimize database configuration for maximum performance.
- Tune queries, optimizing indexing and analyze query plans.
- Regularly check the ASE error log, analyze wait events and check for deadlocks, check for long-running, sleeping, or “infected” processes.
- Execute backup strategies, data recovery, and ensure high availability, often using Replication Server. Ensure backups are running frequently enough and are consistent, accurate, and secure to meet contracted recovery point objectives (RPO).
- Manage user access, permissions, and security compliance.
- Perform database migrations, upgrades, and data extraction.
- Participate in on call support rotation.
- Build and maintain comprehensive documentation for problem resolution actions, root cause, procedures, etc.
- Drive continual improvement in systems operations through collaboration with basis, OS, and Cloud Support teams
- Actively engage in root cause analysis, in collaboration with other delivery team members.
Required Skills
- Bachelor of Science in Computer Science, Engineering, Applied Sciences, or equivalent work experience
- 5+ years of working experience with Sybase ASE (12.x to 16.0)
- Proficiency in Linux environments
- Knowledge of Database Monitoring tools and techniques, including managing cache hit ratio, I/O performance, CPU/memory, and locks.
- Strong Understanding of database internals, including memory management, lock contention, and I/O behavior.
- 5+ years in a tier-3 production support position dealing with other functional and technology teams
- Strong analytical and critical thinking skills
- Strong ownership bias
- Deadline and detail-oriented
Key Focus Areas
- Managing and troubleshooting Sybase Replication Server environments.
- Running reorg/rebuilds, update stats, and managing tables (APL/DOL locking schemes).
- Monitoring and managing storage capacity for databases
Base Salary
$60—$80 USD
Company Benefits*
- Medical/dental/vision - 100% paid for employees, 50% paid for dependents
- Life and disability - 100% paid for employees
- 401K - 3% contribution, no employee contribution necessary
- Education and tuition reimbursement - up to $50K annually
- Employee Stock Options Plan
- Accident, critical illness, hospital indemnity benefits offered through our providers
- Employee Assistance Program
- Legal assistance
- Paid Time Off - up to 6 weeks per year
- Sick Leave - up to 2 weeks per year
- Parental Leave - up to 12 weeks
* Benefits listed in the job description apply to employees working in the United States. For international employees, Apiphani partners with an Employer of Record, Deel, and provides all statutory benefits required under local law; certain U.S.-specific programs (such as EAP, legal assistance, etc.) may not be available outside the United States. The specific benefits package will be outlined in the local employment agreement issued through Deel.
