This job was posted by https://www.azjobconnection.gov : For more
information, please see: https://www.azjobconnection.gov/jobs/6449956
Overview
The Database Administrator implements, maintains and continuously
improves RDBMS systems to ensure availability, scalability, and
advancement of our enterprise applications, showcasing solid technical
and interpersonal skills to assist in debugging protocols/process for
stack callbacks, implementing corrective action within SQL scope, and
analyzing performance trends to identify opportunities for improvement.
Duties & Responsibilities
- Strategy
- Work with development staff to firm-up/harden database
architectures, coding standards, and quality assurance policies
and procedures.
- Design and implement redundant systems, policies, and procedures
for disaster recovery and data archiving to ensure effective
protection and integrity of data assets.
- Research analysis and recommendation regarding database
products, services, protocols, and standards in support of
future database platform design/delivery/management efforts.
- Operations/Config Management
- SQL database management across development, QA and production
environments
- Database performance and capacity management monitoring
- Database maintenance activity implementation (backup/recovery,
rebuilding/reorganizing indexes, etc)
- Database release versioning/assessment/measurement from a
functionality and performance perspective
- Technical expertise/guidance on database design (Logical and
Physical modelling) and development
- Demonstrate SQL expertise related to performance tuning of
database schema, stored procedures, etc
- Failover Cluster/HA set-up/configuration/management
- Database management activity automation using PowerShell, SSIS,
and other technologies
- System monitoring, metric reporting, and diagnostics
Skills Required
- Excellent time management, resource organization and priority
establishment skills with the ability to multi-task in a fast-paced,
deadline-oriented environment
- Keen attention to detail
- Ability to work with an optimistic attitude both independently and
as part of a team
Qualifications Required:
- BS degree in computer science or related field or an equivalent
combination of education and relevant industry experience
- 3 or more years of industry experience with MS SQL Server 2016 and
above
- Experience with Microsoft SQL Server Clustering, Replication, and
Always On
- Experience with database technologies, such as MySQL and Postgres
- Experience in performance tuning, query optimization using
Performance Monitor, SQL Profiler or other related tools
- Experience resolving database integrity issues, performance issues,
blocking/deadlocking issues, connectivity issues, and data
replication issues
- Basic knowledge of MySQL, Postgres and Oracle
Min
USD \$75,000.00/Yr.
Max
USD \$85,000.00/Yr.