Contract
Alpharetta, GA
Job description
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:
Work Location: In person
