Las Vegas Valley Water District Senior Database Administrator (#4113) $45.85 hourly / $7,947 monthly / $95,362 yearly Email Me when a Job Opens for the above position(s)

---

Under general direction, performs highly complex duties in the development, installation, integration, administration, maintenance and support of District/SNWA-wide database architectures, multiple enterprise database environments and database management systems; manages and optimizes database performance, reliability and security; develops and implements corporate database standards and procedures; installs and administers RDBMS security and performance management software; and performs related duties as assigned.

Senior Database Administrator is a mastery professional class in the information technology job family. The incumbent is responsible for administration of the District's/SNWA's large, highly complex database environment, including overall Real Application Cluster performance, maintenance and recovery, to ensure reliable, accessible and secure data required for District/SNWA operations, service delivery and decision making. The incumbent provides expert technical advice on methods and techniques for applications database design and integration to meet business process requirements and make efficient use of data storage resources. The incumbent analyzes and participates in planning for expansion of data management and storage capacity to support District/SNWA mission, goals and operational requirements. Assignments are usually given in terms of broad operational or project requirements and performance is measured in terms of overall performance and results.

Senior Database Administrator is distinguished from Principal Database Administrator in that an incumbent in the latter class supervises work of the database administration team and plays an active leadership role in the development of strategies for the design, development and administration of data management systems and processes, database architectures and data storage technologies in accordance with the District's integrated strategic technology plan.

The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this class.

Designs, installs, integrates and manages the District's three tier Oracle database architecture across multiple production, development and testing environments; performs database administration functions, including setting up and running database management utilities to backup, reorganize and restore databases and resolve production and operational problems; monitors memory and disk utilization; manages and reorganizes database objects across servers to meet requirements and make optimal use of available resources; monitors and evaluates database performance including memory utilization and input/output efficiency; uses applicable tools and utilities to tune and optimize database performance; develops packages and procedures over tables for validation purposes; writes and stores database triggers and referential integrity constraints to ensure data validity; verifies that data validation processes are working properly and replicated data sets are current; administers database security processes and procedures; develops, recommends and implements security permissions, privileges, standards and guidelines; installs and configures application software over databases.

Applies physical and logical theory of database structures and applications design to maintain and resolve problems in data integrity and concurrence; troubleshoots, identifies root causes and resolves or advises others on resolving the most complex and ambiguous database management hardware/software, data communication and interoperating problems.

Analyzes disk resource capacity and growth requirements and recommends hardware and RDBMS upgrades and enhancements to meet long-term District/SNWA needs; develops specifications for database management hardware and software upgrades and enhancements; participates with the systems administration team to evaluate and recommend enhancements to the District/SNWA technology infrastructure

Participates in planning and executing installation of patches, new releases and upgrades of corporate database software; establishes and/or participates in project plans for testing, evaluation and implementation processes; manages project change control processes; installs, integrates, configures, upgrades and monitors new database management and developer tools and software; performs sql and executes sql tuning.

Serves as an expert resource and works with applications development teams to ensure sound, logical database/data structure design, integration, administration and management; participates in reviewing new logical and physical design specifications to identify impacts on enterprise database structures and their accessibility for existing as well as new applications; provides recommendations on sizing, growth planning and scalability issues; recognizes and coordinates resolution of synchronization issues related to data sharing, data availability, database maintenance and backup and recovery processes.

Reviews business process analyses and models; reviews logical designs of database structures; determines physical storage requirements and performs the physicalization of logical database structures; participates in administering meta data and central data repositories; participates in developing consistent practices and procedures and formulating standards regarding terminology, definitions, structures, business rules and the accessing and sharing of data entities, objects and structures stored in a central repository/data warehouse.

Monitors trends and developments in database management and storage technologies; consults with vendors and other sources on industry and product direction, functionality and capabilities; conducts research on new technologies and their applicability to the District's database environment.

May perform applications database administration tasks.

Provides back up support to other members of the database administration and systems administration teams; may act for a Principal Database Administrator in the event of that individual’s absence.

Knowledge of:
Relational database theory, design rules and development practices, including data modeling, data flow and entity relationship analysis, data structure analysis, logical and physical database design, data access methods, storage capacity management and database recovery techniques; database management systems and software, including architectures, diagnostic tools, commands and utilities; database development and administration tools; tools and utilities for monitoring and tuning database performance; data storage technologies; network architectures and theory and principles of network design and integration, including topologies and protocols; operating system architecture, characteristics, commands and components applicable to District computer platforms; principles, practices and methods of systems administration; principles and practices of systems analysis and design; software development and maintenance tools and utilities; standard programming languages and utilities similar to those used by the District; disaster planning and recovery methods and techniques; customer relationship management concepts and practices; project management tools and techniques; principles and practices of sound business communication.

Ability to:
Develop conceptual frameworks and apply state-of-the-art technology to the management and administration of enterprise data assets; understand and apply the analysis of functional requirements to the development of proposals, specifications and recommendations for efficient, cost-effective database management and technology solutions; perform database troubleshooting and tuning to resolve complex and ambiguous data management, data communication and interoperating problems; plan, organize and complete projects efficiently and in accordance with District quality standards; prepare clear, concise and accurate database and program documentation, reports of work performed and other written materials; make sound, expert independent decisions within general policy guidelines; communicate clearly and effectively orally and in writing; work collaboratively and effectively as a project leader and team member; exercise tact and diplomacy in dealing with sensitive, complex and confidential issues and situations; establish and maintain effective customer-focused working relationships with all levels of managers, customers, vendors, consultants, employees and others encountered in the course of work.

Training and Experience:
A typical way of obtaining the knowledge, skills and abilities outlined above is graduation from a four-year college or university with a major in management information systems, computer science, business administration, engineering or a closely related field; and five years of progressively responsible experience in the design, development and administration of complex relational databases and the management of rdbms systems; or an equivalent combination of training and experience.

Licenses; Certificates; Special Requirements:
A valid Nevada driver’s license and the ability to maintain insurability under the District’s Vehicle Insurance Policy.

Certification as an Oracle Certified Professional (Master's Level) is highly desirable.

The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this class. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands
While performing the duties of this class, an employee is regularly required to sit; talk or hear, in person, in meetings and by telephone; use hands to finger, handle, feel or operate computers or other standard office equipment; and reach with hands and arms. The employee is frequently required to walk and stand.

Specific vision abilities required by this job include close vision and the ability to adjust focus.

Mental Demands
While performing the duties of this class, the employee is regularly required to use written and oral communication skills; read and interpret complex data, information and documents; analyze and solve complex problems; observe and interpret people and situations; use math and mathematical reasoning; perform highly detailed work on multiple, concurrent tasks with constant interruptions; work under deadlines and interact with all levels of managers, user department and Information Technology staff, consultants, employees and the public.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this class. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The employee works under typical office conditions, and the noise level is usually quiet.

CLASS:	4113	EST:	1/2/2001	REV:	4/7/2008