Database Administrator

Salt River Pima-Maricopa Indian Community•Scottsdale, AZ

About The Position

Under general supervision of the IT Assistant Director (EA, Dev & Cyber), the Database Administrator (DBA) plans, designs, and maintains test and production databases supporting the Salt River Pima-Maricopa Indian Community (SRPMIC). The DBA assists departments and database staff in developing data management systems and implementing databases for purchased applications. The position helps establish IT standards and techniques that improve database development and monitoring, ensure compliance, and maintain database health. It applies database administration best practices to meet customer requirements and maximize data-system performance and reliability. This job class is FLSA exempt. The role provides database and server support, develops maintenance and monitoring plans, manages data storage, and supports secure database environments. It designs databases and objects, applies database security, maintains version control, develops ETL packages, and supports database migrations and upgrades. The DBA documents and promotes standards, manages database-level security and auditing, and develops patch and upgrade strategies. The position also works with IT divisions and vendors to ensure compliance with SRPMIC standards and contributes to analytics, business intelligence, workflow automation, research, and proof-of-concept work. A bachelor’s degree in Computer Information Systems, Computer Science, Engineering, or a related discipline, or equivalent experience, is required, along with three years of Microsoft SQL Server administration experience. An equivalent combination of education and experience may be considered. The role may require work beyond normal business hours, including nights, weekends, and holidays, and may require background investigations, drug and alcohol testing, and specified licenses or certifications.

Requirements

Bachelor’s degree from an accredited college or university in Computer Information Systems, Computer Science, Engineering, or a related discipline, or equivalent experience.
Three years of experience with Microsoft SQL Server administration.
Knowledge of database design best practices, data normalization, logical and physical database modeling, legacy application integration, SQL, and network architectures.
Skill in implementing, testing, and supporting high-availability infrastructure requirements.
Skill in investigating, troubleshooting, and resolving database, system, or application problems.
Skill working in a Microsoft environment.
Skill maintaining highly available and recoverable transaction-based data systems.
Excellent verbal and written communication skills.
Ability to solve problems using improvisation and creativity; analyze data, draw logical conclusions, and make sound decisions and recommendations.
Ability to adapt to changing environments, requirements, and assignments; assess business requirements and translate them into technical specifications; and explain complex technical concepts effectively.
Ability to conceptualize data relationships and enforce integrity rules, work in a team environment, and maintain a quality-minded, accountable, flexible, results-oriented work ethic and positive attitude.
Knowledge of the history, culture, laws, rules, customs, and traditions of the Salt River Pima-Maricopa Indian Community.
May be required to work beyond normal business hours, including nights, weekends, and holidays.
May be required to complete a Salt River Police Department background investigation and polygraph examination.
May be required to obtain and maintain a Salt River Pima-Maricopa Indian Community Community Regulatory License and State Certification (ADOG).
Applicants are subject to pre-employment drug and alcohol testing and fingerprint and background checks; additional requirements apply to employees providing services to a campus with children.
Preference documentation must be submitted by the position closing date for applicants seeking Community Member Veteran, Community Member, spouse of a Community Member, or Native American preference.

Nice To Haves

Experience with the current version of Microsoft Windows Server.
Experience with the current version of Microsoft SQL Server.
Experience with SQL Server Reporting Services and/or Power BI.
Working experience with ETL, analytics, and data warehousing.
Recent Microsoft certification.
Experience with SharePoint administrative tools.
An enrolled Community Member who closely qualifies for the minimum qualifications may be considered for employment under SRPMIC Policy 2-19, Underfill.

Responsibilities

Provide primary and secondary database and database server support.
Develop and maintain automated maintenance, monitoring, and optimization plans; manage logical and physical data storage devices, directories, and file structures; and assist Networking staff in maintaining a secure database environment.
Provide logical and physical database designs, create database objects, and apply database security for in-house Java and PeopleSoft People Tools application development.
Maintain version control using Tortoise SVN or a similar filesystem-based version control system.
Develop and maintain SQL Server Integration Services (SSIS) packages for Extract, Transform and Load (ETL) activities.
Support migration of non-SQL Server data storage systems to SQL Server and upgrades of existing SQL Server databases.
Document, publish, maintain, and promote database best practices and standards for configuration, normalization, data storage, access management, and optimization.
Recommend performance and efficiency improvements for organizational data management systems as they grow in size and complexity.
Implement and maintain database-level security policies and auditing compliance.
Develop and follow patch management and upgrade strategies for consistent and reliable data systems.
Assist internal IT divisions and external vendor partners with compliance with SRPMIC database standards or with workarounds that preserve application support.
Review peer and subordinate database object design and coding for compliance with SRPMIC standards.
Participate in designing, developing, and supporting analytics, business intelligence, and workflow automation solutions sourced from managed databases.
Research and review new database features, support proof-of-concept evaluations and prototype development, and enhance existing solutions.
Perform other job-related IT tasks as assigned by the Enterprise Architecture Supervisor, Assistant IT Director, Enterprise Architecture and Custom Applications, or IT Director.