Virtual Networx - Atlanta, GA
posted 2 months ago
The Senior Database Administrator (Sr DBA) position is a critical role within our organization, primarily focused on the management and optimization of our database systems. This position requires a seasoned professional with extensive experience in the installation, upgrade, and patching of various database components, specifically in Sybase, MS SQL Server, and Postgres. The Sr DBA will be responsible for ensuring the integrity, availability, and performance of our database environments, which are essential for supporting our business operations. In this role, the Sr DBA will monitor all systems, including work processes, user activities, system logs, and disk space, to ensure that production uptime service levels are maintained. This includes implementing backup and recovery strategies, performance tuning, and security measures to protect our data assets. The Sr DBA will also provide data cleansing services, verify data integrity, and implement access controls to safeguard sensitive information. The position involves routine maintenance tasks such as problem defect analysis, resolution, and management of physical database layouts. The Sr DBA will be expected to create, deploy, and maintain database schemas, as well as set up and configure auditing and audit trails. In the event of a system crash or log full situation, the Sr DBA will carry out recovery procedures to restore database functionality. Knowledge of disaster recovery setup and maintenance is essential for this role. Automation is a key component of this position, and the Sr DBA should be proficient in using shell scripts, Python, Ansible, and Go to streamline database management processes. Performance analysis and tuning of SQL queries will also be a significant part of the role, requiring the Sr DBA to monitor and optimize database performance continuously.