- Assist with the administration and support of Microsoft SQL Server (on-premises and Azure SQL) environments.
|
- Assist with administration and support environments that may include PostgreSQL or other modern database platforms as adopted by the Development team.
|
- Perform routine database maintenance tasks, including backups, restores, monitoring, performance tuning (e.g., updating statistics, index maintenance, etc.) and health checks.
|
- Support database availability, integrity, performance, and reliability under the guidance of the Senior DBA.
|
- Assist in patch management and version upgrades.
|
- Participate in high-availability and disaster recovery testing.
|
- Support SQL Agent jobs and scheduled processes.
|
- Assist with user access provisioning and periodic access reviews.
|
- Support enforcement of least-privilege database permissions.
|
- Monitor database activity alerts and escalate anomalies.
|
- Assist with encryption configuration (at rest and in transit).
|
- Support vulnerability remediation efforts.
|
- Assist with compliance, audit requests, and evidence collection related to database operations.
|
- Follow established change management, incident management, and operational procedures.
|
- Assist with database and application migrations from legacy operating systems and platforms to supported environments.
|
- Gain hands-on exposure to Azure SQL, Azure data services, and DevOps workflows.
|
- Participate in Infrastructure-as-Code and CI/CD database deployment workflows.
|
- Contribute to automation initiatives to reduce manual operational tasks.
|
- Support data validation, testing, and post-migration verification activities.
|
- Help maintain migration documentation, runbooks, and checklists.
|
- Assist with basic SQL development tasks, including queries, stored procedures, and performance troubleshooting under supervision.
|
- Support ETL, data movement, and integration tasks using existing tools and frameworks.
|
- Assist in supporting Azure-based data services as skills develop.
|
- Participate in learning and supporting new database technologies aligned with organizational standards.
|
- Participate in continuous improvement initiatives
|
- Contribute to knowledge-sharing within the team
|
- Maintain and update system documentation, operational procedures, and inventory records.
|
- Work closely with DevOps, application development, and infrastructure teams.
|
- Learn from and be mentored by the Senior Database Administrator.
|
- Participate in project meetings and technical discussions as appropriate.
|
- Build skills to support increased responsibility over time.
|
- Perform tasks as required by management/supervisory staff.
|
- Provide support after hours, and on weekends as needed.
|