Title: Sybase DBA
Location: Richfield, MN/ Remote till Covid
Skills: Sybase, SAP SQL Anywhere DBA
SAP SQL Anywhere (ASA) 17.0 Database Administration, installation, configuration and in-depth troubleshooting and performance tuning skills.
Roles & Responsibilities
o Stabilizing existing SAP SQL Anywhere Database environment
o Troubleshooting and resolving production problems, involving SAP SQL Anywhere databases.
o Recommending and implementing best practices for Optimal database (SQL Anywhere ASA) and application performance
o Providing Database Administration and support for the SAP SQL Anywhere Server ASA.
o Tune queries, write Stored Procedures, perform indexing, and other database elements.
o Database design, coding, testing, debugging, and installing.
o Working through business requirements and designs with IT partners.
o Providing real time support to maintain the necessary functionality and respond to issues as they arise for SAP SQL Anywhere Server
o Supporting technical users by identifying and resolving Issues.
o Administering and implementing security procedures
o Upgrading SAP SQL Anywhere Database to latest version and implementing best practices.
Qualifications / Requirements:
o Minimum 10+ years of experience in SAP SQL Anywhere (ASA) Database Administration, installation, configuration and in-depth troubleshooting and performance tuning skills, along with exposure to latest versions.
o Experience in SAP SQL Anywhere (ASA) 17.0
o Working experience in SAP SQL Anywhere (ASA) Database Administration, installation & configuration
o Experience in Windows, Virtualization and PowerShell scripting.
o Experience in Database upgradation and migration projects in SAP SQL Anywhere (ASA).
o Experience in SAP SQL Anywhere (ASA) Replication, Database Backup, Recovery back-up & loading in database
o Other responsibilities included maintenance and issue resolution in production & dev environment
o Experience in production environment, handling tasks, ticket closure
o Development experience in SAP SQL Anywhere (ASA) 17.0, handling tasks in development
o Performance tuning, reorg and stats collection, DB failover activities, Database Backup / Recovery, DR activities
o Troubleshoot and resolve production problems involving SAP SQL Anywhere (ASA) databases.
o Monitoring databases and troubleshooting, recovering databases when necessary, experience in configuring new servers.
o Should be a team player, ready to take on critical activities anytime.
o Ability to thrive in a fast-paced, deadline-sensitive environment.
o Knowledge with PowerShell scripts & other scripting languages to develop automation strategies.
o Experience with Incident & Change Management principles and tools.
o Effective verbal, written, and interpersonal communication skills.
o Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.