Zen & Art - Alpharetta, GA

posted 2 months ago

Full-time - Mid Level
Alpharetta, GA

About the position

The Sybase DBA position is a critical role within our database engineering team, focusing on the management and optimization of various database systems including Sybase, Oracle, and NoSQL databases. This role requires a hybrid work model, with 2-3 days a week onsite in Alpharetta, GA. The successful candidate will provide guidance and support to the application team, ensuring that database systems are installed, tuned, implemented, and upgraded effectively. The DBA will be responsible for writing and deploying SQL patches, processing work accurately and in a timely manner, and maintaining a high level of attention to detail and urgency in all tasks. In addition to routine database administration tasks, the DBA will proactively make recommendations for system improvements and will be responsible for collating, preparing, and presenting statistical information for both internal and external use. The role also involves writing and maintaining database programs, designing new databases according to business requirements, and continuously monitoring databases to ensure high functionality. Automation is a key aspect of this position, as the DBA will write new support programs and scripts to deploy, operate, and increase data storage capacity while addressing existing database issues. Troubleshooting and debugging are essential components of the role, as the DBA will need to identify and resolve performance issues and ensure that all databases and support systems are operating at peak levels. The DBA will also review daily, weekly, and monthly database reports to spot problems and ensure optimal performance. This position is not for developers; we are specifically looking for experienced Database Administrators who can manage and optimize our database environments 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 in a timely manner
  • Proactively make recommendations for system improvements
  • Collate, prepare and present statistical information for internal and external use
  • Write and maintain database programs
  • Design new databases as per business requirements
  • Continuously monitor databases and related systems
  • Write new support programs and scripts for databases
  • Troubleshoot platform specific performance issues
  • Debug existing database scripts and programs
  • Review daily, weekly, and monthly database reports to ensure optimal performance

Requirements

  • Expertise in installation, upgrade, and patching of Sybase, MS SQL Server, and Postgres
  • Experience with replication setup, troubleshooting issues, and failovers
  • Ability to monitor all systems including work processes, users, system logs, and disk space
  • Ensure production uptime service levels are maintained including backup, recovery, and performance tuning
  • Provide data cleansing services and verify data integrity
  • Experience with schema creation, deployment, and maintenance
  • Knowledge of disaster recovery setup and maintenance
  • Experience with performance analysis and monitoring of SQL queries

Nice-to-haves

  • Experience with NoSQL databases such as Redis and Cassandra
  • Familiarity with scripting languages like Ansible, Python, and Shell
  • Knowledge of SAP ASE/Sybase and SAP Rep Server
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service