Oracle Database Administrator

KēSTA I.T.•Phoenix, AZ

7h•Hybrid

About The Position

KēSTA I.T. is actively seeking an experienced Database Administrator for an immediate contract engagement with our government client. This role will focus on Microsoft SQL Server administration, permissions management, query development and optimization, and SQL Server Reporting Services (SSRS) report development. The ideal candidate will have strong analytical and troubleshooting skills, excellent communication abilities, and experience working with both technical and non-technical stakeholders to deliver accurate, secure, and timely reporting solutions.

Requirements

Advanced experience with Microsoft SQL Server, including T-SQL, permissions administration, database objects, and query optimization.
Proficiency with SQL Server Reporting Services (SSRS), including report design, development, deployment, and management.
Strong experience developing and optimizing complex SQL queries and stored procedures.
Experience working with large and complex datasets.
Knowledge of database security, data governance, and role-based access control.
Strong analytical, troubleshooting, and problem-solving abilities.
Excellent written and verbal communication skills with the ability to work effectively with technical and non-technical stakeholders.
Ability to manage multiple priorities and reporting requests while maintaining accuracy and attention to detail.
Experience documenting database changes, workflows, reporting specifications, and technical processes.
Ability to work independently as well as collaboratively with vendors, technical teams, and business users.

Nice To Haves

Experience in a public safety, government, or enterprise environment is preferred.
Experience with Premier One RMS is highly preferred.
Familiarity with security requirements for sensitive or confidential data is preferred.

Responsibilities

Administer and manage Microsoft SQL Server database permissions, including access required for SSRS folders and reports.
Develop, optimize, and maintain SQL queries, stored procedures, and database objects supporting operational and analytical reporting.
Design, build, test, deploy, and maintain SSRS reports while ensuring accuracy, security, and performance.
Gather and analyze reporting requirements from stakeholders and translate business needs into effective technical solutions.
Validate data outputs and refine reports and database solutions based on operational requirements.
Troubleshoot SQL queries, report execution issues, dataset performance problems, and data integrity concerns.
Monitor and improve database and reporting performance, data quality, and overall reporting efficiency.
Maintain appropriate security controls, role-based access, and data handling practices in accordance with established security and governance standards.
Document database changes, data workflows, permission assignments, reporting specifications, and technical procedures.
Collaborate with vendors, IT staff, business users, and operational teams to resolve technical and reporting issues.
Support system integrations and ongoing enhancements to database and reporting environments.
Manage multiple reporting requests, technical tasks, and project priorities with minimal supervision.
Handle sensitive and confidential information in accordance with applicable security requirements and organizational policies.