DBA
Core
Manage, maintain, and optimize PostgreSQL and Microsoft SQL Server environments to ensure availability, performance, security, and reliability for business-critical applications. (via careerplan.io/jobs/76-008-33-560-dba)
Role type
Senior Database Administrator
Builds
Production database environments supporting development teams and business applications
Domain
Enterprise Data Management
Required skills
PostgreSQL administration, Microsoft SQL Server administration, database performance tuning, query optimization, backup and recovery strategies, disaster recovery planning, database security management, automation scripting
Preferred skills
Cloud database services (AWS RDS, Azure SQL, Google Cloud SQL), monitoring tools (Grafana, Prometheus, Zabbix), scripting languages (PowerShell, Bash, Python), CI/CD pipelines, Infrastructure as Code, NoSQL databases
Technologies
PostgreSQL, Microsoft SQL Server, AWS RDS, Azure SQL, Google Cloud SQL, Grafana, Prometheus, Zabbix, PowerShell, Bash, Python
Responsibilities
Administer, maintain, and monitor PostgreSQL and Microsoft SQL Server databases; Ensure high availability, performance, and reliability of production environments; Perform database installation, configuration, upgrades, and patch management; Monitor performance and resolve bottlenecks; Design and implement backup, recovery, and disaster recovery strategies; Optimize database structures, queries, indexes, and stored procedures; Troubleshoot and resolve production incidents; Manage database security, user permissions, and access control; Automate routine administration tasks using scripts and tools
