Database Administrator

Database Administrator

This is an open and continuous recruitment which may close without notice once a sufficient pool of highly-qualified candidates has been created. The city of Las Vegas is accepting applications for Database Administrator. This position participates in the management, supervision and coordination of the programs and activities for effective administration and management of the Innovation and Technologies (IT) databases and systems within the City of Las Vegas; to coordinate assigned activities with other City departments and outside agencies; and to provide responsible and complex database administration to IT management. The most competitive candidate is a hands-on Oracle Database Administrator with experience supporting both standalone Oracle environments and databases integrated with Oracle E-Business Suite.

Oracle EBS architecture and administration

WebLogic administration

Patching and upgrade strategies

Performance tuning and optimization

Backup and recovery planning

High-availability and failover configurations

Works independently in production environments with sound judgment

Evaluates risk, impact, and rollback strategy before executing changes

Leads root-cause analysis and drives issues to resolution

Documents solutions and shares knowledge to strengthen team capability

Consistent, reliable support of critical systems

Clear decision-making in complex or unfamiliar situations

Ownership of outcomes, not just tasks

Contribution to a stable, sustainable operating environment

Receives general direction from the IT management. Exercises technical and functional supervision over professional and technical staff.

Assume responsibility for services and activities that directly relate to the relational databases (RDBMS) and systems residing on the city's servers.

Develop and implement technical plans for the construction and evolution of the city's database systems.

Assist in establishing data integrity and security policies and procedures for user accounts, data creation, data manipulation and data storage.

Perform a key role in the establishment of effective RDBMS and systems backup, recovery and re-start procedures.

Mitigate cross-organizational issues associated with physical data storage, access, security and database structure.

Participate in the development of RDBMS standards and database connectivity strategies to support an open database architecture; participate in the development of operating systems and programming standards to meet the needs of the city.

Monitor and tune the databases for optimal performance; recommend hardware and system configuration changes to optimize database and systems performance.

Support application development by providing assistance in database architecture and design techniques; review proposed changes to the RDBMS structures; review data security, data validation and data integrity controls.

Participate in the development and implementation of department goals, objectives, policies and priorities for assigned programs.

Provide leadership to and oversight of assigned teams.

Participate in the development and administration of the annual budget; forecast funds needed for equipment, materials and supplies.

Prepare and present staff reports and other necessary correspondence.

Attend and participate in professional group meetings; stay abreast of new trends and innovations in the field of information technologies.

Perform related duties and responsibilities as required.

Three years of increasingly responsible relational database administration experience, including two years of direct administration of Oracle or MS SQL databases in a client-server environment. Bachelor's degree from an accredited college or university with a major in computer science, management information systems or a closely related field. A combination of formal education and directly related work experience may substitute for the degree. The city assesses 1.5 years of fulltime experience as equivalent to one year of education. Completion of specialized training in Oracle Database Management, Oracle financial application software is highly desirable.

Knowledge of: Oracle database architecture and features. Microsoft SQL Server database architecture and features. Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data Guard (DG) and Recovery Manager (RMAN). Microsoft SQL Server Management Studio. Relational database management systems such as Oracle, SQL Server, My SQL. Database administration and management techniques in a client-server environment. Structured Query Language (SQL). Report writing, query tools and data integration tools such as Oracle Analytics Cloud (OAC), Oracle Data Integration Platform Cloud (DIPC), SSRS, SSIS, SSAS, and Power BI. Principles of relational database design, development and administration, data integration, data security, data quality, data warehouse/ETL/ELT, and BI analytics reporting. Linux and Windows operating systems, networking concepts and computer security. Physical database design, backup and recovery strategies, performance monitoring and tuning. Principles of supervision, training and performance evaluation and effective team building. Ability to: Perform capacity planning of databases. Perform performance tuning and optimization activities of databases. Analyze programs, policies and operational needs. Assess problems, identify alternative solutions, project consequences of proposed actions and implement recommendations in support of goals. Research, analyze and evaluate new administration methods and techniques. Communicate clearly and concisely, both orally and in writing. Establish and maintain effective working relationships with those contacted in the course of work. Core Workforce Competencies Professionalism – Demonstrates core values by being honest, respectful and positive. Effective Communication – Expresses verbal and written thought in a clear and understandable manner. Customer Focus – Demonstrates genuine concern and satisfies external and/or internal customers based on the CLV core purpose and values. Adaptability – Able to effectively modify behavior to suit changing workforce demands. Problem Solving – Solves problems by considering all causes, solutions and outcomes. Productive Partnerships – Develops, maintains and strengthens partnerships with others. Technical and Safety Expertise – Possesses a depth of knowledge, skill and ability in a technical (job) area.