The Database Administrator (DBA) is responsible for the design, implementation, performance, security, and reliability of the organization's database systems across multiple platforms, including Microsoft SQL Server and PostgreSQL. This role ensures that databases are highly available, properly backed up, optimally tuned, and securely configured to support business applications and reporting needs. The DBA collaborates closely with software developers, infrastructure engineers, and business stakeholders to design scalable data architectures, troubleshoot performance issues, and implement best practices for data governance, disaster recovery, and regulatory compliance. This position requires a strong technical foundation across relational database technologies, sound judgment under pressure, and the ability to balance proactive system improvements with responsive incident resolution.
Principal Duties and Responsibilities
- Install, configure, upgrade, and maintain Microsoft SQL Server and PostgreSQL instances across development, test, and production environments.
- Monitor database performance, proactively identify bottlenecks, and tune queries, indexes, and configurations to optimize throughput and response times.
- Design and implement backup, recovery, and disaster recovery strategies, and regularly test restore procedures to ensure data integrity and business continuity.
- Manage database security, including user access provisioning, role-based permissions, encryption, and auditing to ensure compliance with organizational policies and regulatory requirements.
- Plan and execute database migrations, upgrades, and patching with minimal disruption to business operations.
- Collaborate with application developers on schema design, query optimization, data modeling, and best practices for database integration.
- Implement and maintain high-availability and replication solutions (e.g., Always On Availability Groups, PostgreSQL streaming replication).
- Develop and maintain documentation for database architecture, configurations, standard operating procedures, and disaster recovery plans.
- Establish and enforce data governance standards, including naming conventions, data quality controls, and retention policies.
- Respond to and resolve database-related incidents, including participation in off-hours support when necessary.
- Automate routine administrative tasks using scripting tools (e.g., PowerShell, Bash, Python) to improve operational efficiency.
- Capacity-plan for storage, memory, and compute resources, and provide recommendations for infrastructure scaling.
- Stay current with emerging database technologies, vendor patches, and industry best practices, recommending improvements where appropriate.
- Support audits and compliance reviews by providing documentation and evidence of database controls.
