Database Engineer (SAP ASE/Sybase)

$135,200 - $143,520/Yr

Denken Solutions - Alpharetta, GA

Full-time - Mid Level

Remote - Alpharetta, GA

501-1,000 employees

Professional, Scientific, and Technical Services

About the position

The SAP ASE/Sybase Database Engineer at Denken Solutions Inc is responsible for providing guidance and support to the application team, managing database installations, and ensuring optimal performance of database systems. This role involves writing and deploying SQL patches, monitoring databases, and implementing system improvements. The engineer will also be tasked with designing new databases, troubleshooting issues, and maintaining existing database programs to handle data flow effectively.

Responsibilities

• Provide guidance and support to the Application team
• Install, tune, implement, and upgrade DBMS installations
• Write and deploy SQL patches
• Process work accurately and promptly
• Make recommendations for system improvements
• Collate, prepare, and present statistical information for internal and external use
• Write new database programs and maintain existing programs
• Help design new databases per business requirements
• Continuously monitor databases and related systems
• Write new support programs and scripts for automation
• Troubleshoot platform-specific performance issues
• Debug existing database scripts and programs
• Review daily, weekly, and monthly database reports

Requirements

• Expertise in Installation, Upgrade & Patching of Sybase, MS SQL Server, and Postgres
• Experience with Replication including setup, troubleshooting issues, and failovers
• Monitor all systems including work processes, users, system logs, etc.
• Ensure production uptime service levels are maintained
• Provide data cleansing services and verify data integrity
• Provide routine maintenance including problem defect analysis and resolution
• Experience with Schema creation, deployment, and maintenance
• Experience with setting up and configuration of Auditing
• Knowledge of Disaster Recovery setup and maintenance
• Automation using shell-script, python, Ansible, etc.
• Performance analysis and monitoring of SQL queries

Nice-to-haves

• Experience with Snowflake
• Experience with Spark
• Experience with Python

Benefits

• Health Insurance
• 401k benefits
• Paid vacation
• Paid holidays
• Work from home
• Diversity program
• Pension plans