What are the responsibilities and job description for the Database Administrator (PostgreSQL / SQL Server) position at DATAMAXIS, Inc?
Position Overview: We are seeking an experienced Database Administrator (DBA) to join our Enterprise Data team, with a strong focus on PostgreSQL and Microsoft SQL Server database platforms. The ideal candidate will have a minimum of 3 years of database administration experience and be responsible for the installation, configuration, patching, security, performance optimization, and capacity management of enterprise database systems.
The candidate should have hands-on experience managing production and non-production database environments, implementing backup and recovery strategies, supporting high availability solutions, and automating routine database administration tasks.
Required Technical Skills
- Hands-on PostgreSQL Database Administration experience (EDB preferred).
- Microsoft SQL Server Database Administration experience.
- Database installation, configuration, patching, upgrades, and maintenance.
- Database performance monitoring, troubleshooting, and tuning.
- Backup, recovery, and disaster recovery management.
- High Availability (HA) and database reliability solutions.
- Scripting and automation using BASH, KSH, PowerShell, Python, or Perl.
- Experience with Microsoft Windows Server and/or Unix/Linux environments.
- Cloud database migration and administration experience.
Key Responsibilities
- Monitor and manage day-to-day operations of production and non-production database environments to ensure availability, stability, and optimal performance.
- Perform database space management at both the database and operating system levels to prevent capacity-related issues and service disruptions.
- Configure, monitor, and respond to automated alerts to maintain database integrity, availability, and stability.
- Develop, maintain, and document database administration procedures, operational guidelines, and work instructions.
- Implement and maintain database monitoring processes, backup and recovery procedures, and automated routine maintenance activities.
- Perform database performance tuning and troubleshooting for OLTP and Data Warehouse environments.
- Manage database installation, configuration, patching, upgrades, security, and capacity planning.
- Evaluate, recommend, and implement new database technologies and ensure seamless integration with the enterprise technology environment.
- Develop, maintain, and test business continuity and disaster recovery procedures.
Salary : $70 - $80