Database Administrator Job Scottsdale area,Arizona USA,IT/Tech

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.

Provides primary and secondary Database and Database Server support.

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.

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

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

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.

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.

Develops and adheres to patch management and upgrade strategies for consistent and reliable data systems throughout the organization.

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.

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.

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…