Sql Database Administrator

Job Title: SQL Database Administrator (DBA)- Contract Role

Location:

Job Summary:

Key Responsibilities:

• Basic Connectivity Issues:

  Investigate and resolve user connection problems, ensure database services are running.

• User Account Management:

  Create, delete, or modify user accounts and roles, reset passwords, grant/revoke access permissions.

• Monitoring and Alerts Handling:

  Respond to automated monitoring alerts for performance issues, check for high CPU/memory/disk usage, notify L2/L3 if needed.

• Backup Monitoring:

  Ensure scheduled backups complete successfully, notify the L2 team of any failures or inconsistencies.

• Basic Query Optimization:

  Identify slow-running queries, provide basic troubleshooting (e.g., missing indexes).

• Service Restarts:

  Restart database services when non-responsive or encountering failures.

• Database Space Management:

  Monitor database storage and disk space, notify L2/L3 if space thresholds are crossed.

• Database Status Checks:

  Check the health and availability of databases and server resources, monitor error logs for critical issues.

• Supporting SOX & HIPAA Audit Requests:

  Assist with data gathering for SOX and HIPAA audit requests.

• Incident Ticket Handling:

  Triage and escalate complex issues to L2/L3 teams, log issues in the ticketing system.

• Basic Performance Troubleshooting:

  Investigate basic performance complaints (e.g., slow response times) and escalate if needed.

• Running Routine Scripts:

  Execute pre-approved SQL scripts or queries for basic maintenance tasks (e.g., clearing logs).

• Handling Failover Notifications:

  Notify higher-level teams in case of database failovers in HA environments.

• Special Requests:

  Handle special requests like generating reports, running diagnostics, or performing data extracts under L2/L3 guidance.

• Vulnerability Remediation Support:

  Assist with applying security patches and addressing basic vulnerabilities under L2/L3 guidance.

• Supporting Database Migrations:

  Support pre-migration tasks and monitor migration processes, escalating issues to L2/L3 as needed.

• Continuous Improvement & Knowledge Management:

  Continuously enhance processes and tools while updating knowledge base articles to improve efficiency and streamline issue resolution, under L2/L3 guidance.

• Facilitating New Deployments for DBs & Managing Deployment Features:

  Help with new deployments for IaaS/On-Prem DBs and handle deployment features.

Technology Landscape:

• PaaS:

  Azure SQLDB, Managed Instance, Hyperscale

• IaaS:

  SQL + On-prem