Database Administrator

Synergy Systems - McLean, VA

Full-time

McLean, VA

Machinery Manufacturing

About the position

The Database Administrator is responsible for managing and maintaining relational database management systems, ensuring optimal performance, security, and availability. This role involves installing and configuring databases, monitoring their performance, implementing necessary changes, and providing support and training to users. The Database Administrator plays a crucial role in minimizing downtime and ensuring data integrity through proactive management and regular evaluations.

Responsibilities

• Install and configure relational database management systems
• Monitor database performance, implement changes, and apply new patches and versions when required
• Determine, enforce and document database policies, procedures, and standards
• Minimize database downtime and manage parameters to provide fast query responses
• Use high-speed transaction recovery techniques and backup data
• Provide proactive and reactive data management support and training to users
• Perform tests and evaluations regularly to ensure data security, privacy, and integrity

Requirements

• Monitoring and Troubleshooting, performance tuning, and operational limitations of PostgreSQL
• Excellent knowledge of PostgreSQL, MSSQL Server RDBMS systems and internal architecture
• Experience to configure production systems replication, clustering, users and privileges management
• Working experience with Linux systems (hardware resource Monitoring and Troubleshooting)
• PostgreSQL application setup and dependencies resolution, configuration, the experience of application setup
• Experience with Microsoft Azure Database Services (IaaS, PaaS, SaaS) is a plus
• Good knowledge of database encryption layers and technologies is a plus
• Good understanding of Database Backup & Restore