Database Administrator for Sybase

Job Description:

-Provide guidance and support to Application team

-Install, tune, implement and upgrade DBMS installations

-Write and deploy SQL patches

-Process work accurately and in a timely manner

-Always paying attention to the detail

-Urgency: proactively and regularly make recommendations for system improvements

-Collate, prepare, and present statistical information for internal and external use

-Write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.

-Help design new databases based on company needs, data storage needs, and the number of users accessing the database.

-Continuously monitor databases and related systems to ensure high functionality.

-Write new support programs and scripts for databases to deploy, operate, increase data storage capacity, and fix existing database problems.

-Troubleshoot platform specific performance, checking for potential problems that affect database functionality and related database programs

-Look through coding language to debug existing database scripts and programs.

-Review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels.

Requirements:

- Expertise in Installation, Upgrade & Patching of different components in SAP ASE/Sybase, Redis , Postgres and experience with the other platforms.

Duties and Responsibilities:

- Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).

-Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security

-Provide data cleansing services, verify data integrity, and implement access controls

-Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management

-Experience with Schema creation, deployment, and maintenance

-Experience with Setting up and configuration of Auditing, audit trails

-Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms

-Should have knowledge of Disaster Recovery setup and maintenance

-Automation using shell-script, python, Ansible, go, etc.

-Performance & Tuning Related Expertise

-Experience with Performance analysis and monitoring of queries.

Job Type: Contract

Pay: From $68.00 per hour

Ability to Commute:

• Alpharetta, GA 30004 (Required)

Work Location: In person

Salary : $68