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.
Career Opportunity

The city of Las Vegas is accepting applications forDatabase 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.

Ideal Candidate

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.

Technical Scope

• Oracle EBS architecture and administration
• WebLogic administration
• Patching and upgrade strategies
• Performance tuning and optimization
• Backup and recovery planning
• High-availability and failover configurations

How This Role Operates

• 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

What Success Looks Like

• 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

Selection Process

The selection process will include a review of all applications with only the most qualified participating in an interview. Final candidate selection will include hiring interview (if applicable). Any individual offered employment will be required to pass a pre-employment drug test and complete background check. Some positions may require preliminary background checks.

Supervision Received and Exercised

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

Essential Functions:

1. Assume responsibility for services and activities that directly relate to the relational databases (RDBMS) and systems residing on the city's servers.
2. Develop and implement technical plans for the construction and evolution of the city's database systems.
3. Assist in establishing data integrity and security policies and procedures for user accounts, data creation, data manipulation and data storage.
4. Perform a key role in the establishment of effective RDBMS and systems backup, recovery and re-start procedures.
5. Mitigate cross-organizational issues associated with physical data storage, access, security and database structure.
6. 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.
7. Monitor and tune the databases for optimal performance; recommend hardware and system configuration changes to optimize database and systems performance.
8. 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.
9. Participate in the development and implementation of department goals, objectives, policies and priorities for assigned programs.
10. Provide leadership to and oversight of assigned teams.
11. Participate in the development and administration of the annual budget; forecast funds needed for equipment, materials and supplies.
12. Prepare and present staff reports and other necessary correspondence.
13. Attend and participate in professional group meetings; stay abreast of new trends and innovations in the field of information technologies.
14. Perform related duties and responsibilities as required.

Experience:

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.

Training:

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.

Competencies:

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.