Database Administrator

Salt-River-Pima--maricopa-Indian-Community-; Scottsdale (AZ); On-site; USD 95,000 - 125,000; Full time

Job summary

Salt River Pima-Maricopa Indian Community (SRPMIC) seeks a Database Administrator to plan, design and maintain test and production databases, ensuring performance and reliability for business operations. The role supports purchased applications and enforces SRPMIC standards and security policies.

Ideal candidates will have a Bachelor's degree in a related field and at least 3 years of SQL Server administration, with experience in SSIS, Power BI, and data warehousing concepts.

Qualifications

• BS in Computer Information Systems, Computer Science, Engineering or related discipline or equivalent experience.

Responsibilities

• Provide primary and secondary database and server support.
• Develop and maintain automated maintenance, monitoring, and optimization plans.
• Design databases, create objects, and apply security for in-house Java and PeopleSoft People Tools application development.
• Migrate non-SQL Server data to SQL Server and upgrade databases.
• Document database standards and enforce security auditing.

Skills

SQL Server administration

Power BI

SSIS

Database security

SharePoint admin tools

Team collaboration

Problem solving

Communication

Education

Bachelor's degree in Computer Information Systems/CS or related

Tools

TortoiseSVN

Windows Server

SQL Server

ETL tools

Power BI

Job description

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.

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.

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 who closely qualifies for the minimum qualifications for a position may be considered for employment under SRPMIC Policy 2-19, Underfill

• 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).