Role: Database Engineer

Location : Alpharetta, GA Hybrid

Duration: Contract 12 Months (Possible extension or conversion based on performance)       

Must-Have: Sybase and Oracle (19.3/4) and Linux experience is a must

Responsibilities

• Provide guidance and support to Application team
• Install, tune, implement and upgrade DBMS installations
• Write and deploy SQL patches.
• Proactively and regularly make recommendations for system improvements
• Collate, prepare, and present statistical information for internal and external use

Requirements

• Expertise in Installation, Upgrade & Patching of different components in Sybase, MS SQL Server, Postgres and experience with the other platforms we manage listed in the Duties and
• Experience with Replication including setup, troubleshooting issues and failovers
• 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, monitoring of SQL queries and platform specific tuning.

Posted By