Database Administrator

Definition Under general supervision of the IT Assistant Director (EA, Dev & Cyber), the Database Administrator (DBA) is responsible for ongoing planning, design and maintenance of test and production databases in support of the general business of Salt River Pima-Maricopa Indian Community (SRPMIC). Assists departments and DBA staff with developing data management systems and implementation of databases for purchased applications. Assists the Information Technology (IT) Department in establishing standards and techniques for improving the database development and monitoring processes to ensure compliance and overall database health. Responsibilities include identifying and utilizing database administration best practices to meet internal and external customer requirements that maximize the performance and reliability of the data management systems. This job class is treated as FLSA Exempt.

Essential Functions: Essential functions may vary among positions and may include the following tasks and other characteristics. This list of tasks is ILLUSTRATIVE ONLY and is not intended to be comprehensive list of tasks performed by all positions in this classification. Examples of Tasks

1. Provides primary and secondary Database and Database Server support.
2. Develops and maintains automated maintenance, monitoring, and optimization plans.

• Manages logical and physical data storage devices, directories and file structures. Assist Networking staff in maintaining a secure database environment.

3. Provides logical and physical database designs, create database objects and applies database security in support of in-house Java and PeopleSoft People Tools application development.

• Maintains version control utilizing Tortoise SVN or similar filesystem-based version control systems.
• Develops and maintains SQL Server Integration Services (SSIS) packages for Extract, Transform and Load (ETL) activities.

4. Provides overall support for migration of non-SQL Server data storage systems to SQL Server and for the upgrade of existing SQL Server databases to newer versions.
5. Documents database best practices and standards for the organization.

• Publishes, maintains and champions standards in configuration, normalization, data storage, access management and optimization.
• Recommends performance and efficiency improvements for data management systems across the organization as data systems grow in size and complexity.
• Implements and maintains security policies and auditing compliance at the database level.

6. Develops and adheres to patch management and upgrade strategies for consistent and reliable data systems throughout the organization.
7. Assists internal IT divisions and external Vendor partners in adhering to, and complying with, SRPMIC database standards or providing workarounds that preserve internal and contractual application support.

• Provides peer/subordinate review of database object design and coding for compliance with SRPMIC database standards.

8. Participates in the design, development and support of analytics, business intelligence, and workflow automation solutions sourced from managed databases.

• Assists in the research and review of new database feature-functionality, supports proof-of-concept evaluations, prototype development, and enhancements to existing solutions.

9. Performs other job-related IT related tasks as assigned by the Enterprise Architecture Supervisor, Assistant IT Director, Enterprise Archicture and Custom Applications, or IT Director.

Knowledge, Skills, Abilities and Other Characteristics:

• Knowledge of the history, culture, laws, rules, customs and traditions of the Salt River Pima-Maricopa Indian Community.
• Knowledge of database design best practices and data normalization rules.
• Knowledge of logical and physical database modeling.
• Knowledge of legacy application integration.
• Knowledge of Structure Query Language (SQL).
• Knowledge and general understanding of network architectures.
• Skill providing implementation, testing and support of high-availability infrastructure requirements.
• Skill providing problem investigation, troubleshooting and problem resolution involving database, system or applications issues.
• Skill working in a Microsoft environment.
• Skill working with SharePoint administrative tools preferred.
• Skill establishing and maintaining effective working relationships with peers, business partners, customers, vendors, direct reports and superiors.
• Skill maintaining highly available and recoverable transaction-based data systems.
• Skill with excellent verbal and written communication.
• Ability to utilize problem solving techniques, improvisation and creativity to accomplish goals.
• Ability to analyze data, draw logical conclusions and make sound decisions and recommendations.
• Ability to adapt to changing environments, requirements and assignments.
• Ability to assess business requirements and translate into technical specifications
• Ability to express complex technical concepts effectively, both verbally and in writing
• Ability to conceptualize data relationships and enforce integrity rules
• Ability to work in a team environment.
• Ability to maintain a quality minded, accountable, flexible and results oriented work ethic.
• Ability to practice a positive, can-do attitude.

Minimum Qualifications Education and Experience: A Bachelor’s degree from accredited college or university in Computer Information Systems, Computer Science, Engineering or related discipline or equivalent experience

• Three (3) years experience with Microsoft SQL Server administration
• Experience in all of the following areas is preferred:
• Current version of Microsoft Windows Server
• Current version of Microsoft SQL Server
• SQL Server Reporting Services/PowerBI
• Working experience with ETL, Analytics and Data Warehousing highly desirable
• Recent Microsoft Certification is highly desirable.

Equivalency – Any equivalent combination of experience and education that will allow the applicant to satisfactorily perform the duties of the job may be considered when filling the position. Underfill Eligibility: An enrolled Community Member whom closely qualifies for the minimum qualifications for a position may be considered for employment under SRPMIC Policy 2-19, UnderfillSpecial Requirements

• May be required to work beyond normal business hours including nights, weekends and holidays.
• May be required to complete and Salt River Police Department (SRPD) background investigation and polygraph examination.
• May be required to receive and maintain a Salt River Pima-Maricopa Indian Community, Community Regulatory License, and State Certification (ADOG).
• All applicants applying for jobs will be subject to Pre-Employment Drug Test and extensive Fingerprint and Background Check. In addition, all employees providing services to a campus with children will be subject to the “Community Code of Ordinances”, Chapter 11 “Minors”, Article X. “Investigation of Persons Working with Children”, random drug testing and completion of a background check every five (5) years.

Prior to hire as an employee, applicants will be subject to drug and alcohol testing. Will be required to pass a pre-employment background/fingerprint check. "SRPMIC is an Equal Opportunity/Affirmative Action Employer" Preference will be given to a qualified: Community Member Veteran, Community Member, Spouse of Community Member, qualified Native American, and then other qualified candidate. In order to obtain preference, the following is required: 1) Qualified Community Member Veteran (DD-214) will be required at the time of application submission 2) Qualified Community Member (must provide Tribal I.D at time of application submission),3) Spouse of a Community Member (Marriage License/certificate and spouse Tribal ID or CIB is required at time of application submission), and 4) Native American (Tribal ID or CIB required at time of application submission).

Documents may be submitted by one of the following methods:

1. attach to application
2. fax (480) 362-5860
3. mail or hand deliver to Human Resources.
4. email HRRecruitment@srpmic-nsn.govDocumentation must be received by position closing date. The IHS/BIA Form-4432 is not accepted.

Your Tribal ID/CIB must be submitted to HR-Recruitment-Two Waters.

Benefits

Salt River Pima-Maricopa Indian Community Employee Benefits Overview Salt River Pima-Maricopa Indian Community (SRPMIC) is committed to supporting the health, well-being, and financial security of our employees. We offer a comprehensive benefits package to employees, designed to enhance your quality of life both at work and at home. Below is a summary of the benefits available to SRPMIC employees. Plan details and eligibility requirements are provided upon hire and are subject to change. Health Care Benefits SRPMIC provides medical, dental, vision, and life insurance coverage for all regular full-time employees enrolled in standard plans. These benefits represent a significant part of your total compensation. Medical: Choose from three plan options to fit your needs - the Low Deductible Plan, the Mid-Deductible Plan, and the High Deductible Health Plan (HDHP) with a Health Savings Account (HSA). As a self-funded plan, SRPMIC directly covers the cost of medical, pharmacy, dental, and vision services for all participants. Dental: Enjoy nationwide access to the Humana Dental PPO/Traditional Preferred network, offering flexibility and choice in selecting dental care providers. Vision: Coverage is provided through Davis Vision, including eye exams, lenses, frames, and contact lenses. Members also benefit from discounted rates on additional eyewear and services. Life Insurance: All eligible employees are automatically enrolled in a fully paid basic term life insurance policy with a matching accidental death benefit. Retirement Plans

SRPMIC supports your long-term financial goals through multiple retirement plan options:

401(k) and Roth Plans: Eligible employees can participate in both pre-tax and post-tax retirement savings plans. SRPMIC contributes 5% of your compensation to the pre-tax 401(k) and matches up to 3% of your salary deferral contributions. Public Safety Personnel Retirement System (PSPRS): Available to eligible certified police officers and firefighters. Arizona State Retirement System (ASRS): Available to Salt River School educators. Health Reimbursement Arrangement (HRA): A retiree HRA with Health Equity, which is a tax-advantaged employer-funded account that retired employees (Age 55+) can use for qualified medical expenses, including some premiums, and out-of-pocket expenses such as copays and deductibles. Paid Leave & Holidays Annual & Sick Leave: Employees accrue separate balances for sick and annual leave each pay period. Sick leave may be used for personal or family illness and medical appointments, while annual leave covers vacation or personal time. Holidays: SRPMIC observes 15 paid holidays each year, including two discretionary holidays and one day of birthday leave. Other SRPMIC Paid Benefits Short-Term Disability Long-Term Disability Employee Assistance Program (EAP) SRPMIC offers a confidential Employee Assistance Program through SupportLinc, available at no cost to employees, their dependents, and household members. Additional Voluntary Benefits WellPath Wellness Program: A voluntary wellness initiative that encourages healthy living and rewards participation with incentives. Available to all employees and their dependents. Flexible Spending Accounts (FSA): Administered by HealthEquity, FSAs allow you to pay for eligible health and dependent care expenses with pre-tax dollars. Health Savings Account (HSA): Available to employees enrolled in the HDHP. Supplemental Life & AD&D Insurance: Employees may purchase additional life and accidental death coverage for themselves and their dependents. Public Service Loan Forgiveness (PSLF): SRPMIC is a qualified employer under the PSLF program. Employees may be eligible for federal student loan forgiveness. At SRPMIC, we value our employees and are proud to offer benefits that support your health, well-being, and future.