Database Administrator
Posted Updated
Description
Position: Database Administrator
Location: Carson City or Las Vegas
Duration: 6+ months
Client: State of Nevada
Job ID: 168301
Agency: NV-DOT
Work Mode: Onsite 100%
Location: Carson City or Las Vegas
Duration: 6+ months
Client: State of Nevada
Job ID: 168301
Agency: NV-DOT
Work Mode: Onsite 100%
Job Description:
The Agency requires professional Database Administration (DBA) services to ensure the reliable, secure, and efficient operation of its database environments. The Contractor will support mission critical systems by performing database administration, optimization, maintenance, security, and documentation activities as described in this Scope of Services.
The Agency requires professional Database Administration (DBA) services to ensure the reliable, secure, and efficient operation of its database environments. The Contractor will support mission critical systems by performing database administration, optimization, maintenance, security, and documentation activities as described in this Scope of Services.
Objectives
The objectives of the services include:
Ensuring high availability, performance, and stability of Agency databases.
Maintaining secure database configurations aligned with Agency policies.
Supporting operational needs through monitoring, optimization, and incident response.
Providing clear documentation and knowledge transfer to Agency staff.
Supporting controlled releases and changes within established governance processes.
The objectives of the services include:
Ensuring high availability, performance, and stability of Agency databases.
Maintaining secure database configurations aligned with Agency policies.
Supporting operational needs through monitoring, optimization, and incident response.
Providing clear documentation and knowledge transfer to Agency staff.
Supporting controlled releases and changes within established governance processes.
The Contractor shall:
Provision, configure, and maintain database instances across production and non production environments.
Manage database users, roles, permissions, and access controls.
Perform routine maintenance tasks, including index management, statistics updates, and integrity checks.
Conduct database capacity planning and provide periodic growth forecasts.
Provision, configure, and maintain database instances across production and non production environments.
Manage database users, roles, permissions, and access controls.
Perform routine maintenance tasks, including index management, statistics updates, and integrity checks.
Conduct database capacity planning and provide periodic growth forecasts.
Performance Management
The Contractor shall:
Monitor performance and establish baseline metrics.
Diagnose and resolve performance issues such as blocking, deadlocks, and inefficient queries.
Optimize indexes, query execution plans, and database configuration settings.
Collaborate with application teams to support performance testing and release readiness.
The Contractor shall:
Monitor performance and establish baseline metrics.
Diagnose and resolve performance issues such as blocking, deadlocks, and inefficient queries.
Optimize indexes, query execution plans, and database configuration settings.
Collaborate with application teams to support performance testing and release readiness.
Backup, Recovery, High Availability (HA), and Disaster Recovery (DR)
The Contractor shall:
Maintain backup and restore strategies that meet Agency recovery objectives (RPO and RTO).
Validate restore procedures regularly and provide documentation of outcomes.
Support, configure, and maintain HA/DR mechanisms such as replication, clustering, or availability groups.
Participate in DR drills and document processes, gaps, and recommendations.
Security and Compliance
The Contractor shall:
Apply database security hardening practices, including encryption, privilege management, and audit configuration.
Remediate database vulnerabilities identified through scans or audits.
Maintain compliance with Agency requirements and applicable regulatory standards.
Implement and verify database patching and updates on a regular schedule.
The Contractor shall:
Maintain backup and restore strategies that meet Agency recovery objectives (RPO and RTO).
Validate restore procedures regularly and provide documentation of outcomes.
Support, configure, and maintain HA/DR mechanisms such as replication, clustering, or availability groups.
Participate in DR drills and document processes, gaps, and recommendations.
Security and Compliance
The Contractor shall:
Apply database security hardening practices, including encryption, privilege management, and audit configuration.
Remediate database vulnerabilities identified through scans or audits.
Maintain compliance with Agency requirements and applicable regulatory standards.
Implement and verify database patching and updates on a regular schedule.
Monitoring, Incident Response, and Troubleshooting
The Contractor shall:
Configure database monitoring, alerting thresholds, and automated health checks.
Respond to incidents according to established Agency priorities and timelines.
Perform root cause analysis (RCA) after major incidents and document corrective actions.
Maintain operational dashboards and reporting artifacts as required.
The Contractor shall:
Configure database monitoring, alerting thresholds, and automated health checks.
Respond to incidents according to established Agency priorities and timelines.
Perform root cause analysis (RCA) after major incidents and document corrective actions.
Maintain operational dashboards and reporting artifacts as required.
Change Management and Release Support
The Contractor shall:
Participate in the Agency’s change management process, including CAB reviews.
Attend and participate in required governance committees, including the IT Committee (ITC) and the Work Authorization Committee (WAC).
Provide impact analyses, rollback plans, and deployment recommendations.
Support database changes during maintenance windows and production releases.
The Contractor shall:
Participate in the Agency’s change management process, including CAB reviews.
Attend and participate in required governance committees, including the IT Committee (ITC) and the Work Authorization Committee (WAC).
Provide impact analyses, rollback plans, and deployment recommendations.
Support database changes during maintenance windows and production releases.
Automation & Scripting
The Contractor shall:
Automate recurring tasks where feasible, such as backups, maintenance, and provisioning.
Maintain scripts within Agency approved repositories with documentation.
Implement automation aligned with Agency standards (e.g., PowerShell, Bash, Python, IaC tools).
The Contractor shall:
Automate recurring tasks where feasible, such as backups, maintenance, and provisioning.
Maintain scripts within Agency approved repositories with documentation.
Implement automation aligned with Agency standards (e.g., PowerShell, Bash, Python, IaC tools).
Documentation & Knowledge Transfer:
The Contractor shall:
Maintain as built documentation, inventories, architecture diagrams, and runbooks.
Provide updates to documentation at least monthly or as changes occur.
Deliver knowledge transfer sessions for Agency technical staff as requested.
The Contractor shall:
Maintain as built documentation, inventories, architecture diagrams, and runbooks.
Provide updates to documentation at least monthly or as changes occur.
Deliver knowledge transfer sessions for Agency technical staff as requested.
Service Levels
The Contractor shall meet or exceed the following service expectations:
Production database uptime target: 99.9% per calendar quarter (excluding approved maintenance windows).
The Contractor shall meet or exceed the following service expectations:
Production database uptime target: 99.9% per calendar quarter (excluding approved maintenance windows).
Incident response expectations:
Priority 1: Acknowledge within 15 minutes; begin mitigation within 2 hours.
Priority 2: Acknowledge within 30 minutes; begin mitigation within 4 hours.
Priority 3: Acknowledge within 1 business day; plan within 3 business days.
Security patching: Standard patches within 30 days; critical patches within 7 days.
Restore validation: At least one restore test per critical database each month.
Agency Responsibilities
The Agency will:
Provide required system access, licensing, accounts, and networking resources.
Identify system priorities, business criticality, and maintenance windows.
Review Contractor deliverables and provide timely feedback.
Supply contact points for escalation and coordination.
Priority 1: Acknowledge within 15 minutes; begin mitigation within 2 hours.
Priority 2: Acknowledge within 30 minutes; begin mitigation within 4 hours.
Priority 3: Acknowledge within 1 business day; plan within 3 business days.
Security patching: Standard patches within 30 days; critical patches within 7 days.
Restore validation: At least one restore test per critical database each month.
Agency Responsibilities
The Agency will:
Provide required system access, licensing, accounts, and networking resources.
Identify system priorities, business criticality, and maintenance windows.
Review Contractor deliverables and provide timely feedback.
Supply contact points for escalation and coordination.
Exclusions (Out of Scope)
The following services are not part of this Scope unless separately authorized:
Application level development except for SQL objects such as stored procedures or functions.
Large scale database redesigns or platform migrations unless explicitly included.
End user training outside database operations.
Any activities requiring unsupported software or tools not approved by the Agency.
The following services are not part of this Scope unless separately authorized:
Application level development except for SQL objects such as stored procedures or functions.
Large scale database redesigns or platform migrations unless explicitly included.
End user training outside database operations.
Any activities requiring unsupported software or tools not approved by the Agency.
Reporting Requirements:
The Contractor shall provide:
Weekly status reports outlining completed work, issues, risks, and planned tasks.
Monthly operational reports including performance metrics, backup status, and incident summaries.
Quarterly reviews discussing progress, risks, and improvement recommendations.
The Contractor shall provide:
Weekly status reports outlining completed work, issues, risks, and planned tasks.
Monthly operational reports including performance metrics, backup status, and incident summaries.
Quarterly reviews discussing progress, risks, and improvement recommendations.
Skills
Sign in to read and join the discussion.