JOB
This is an open and continuous recruitment which may close without notice once a sufficient pool of highly-qualified candidates has been created.Career OpportunityThe 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.Ideal CandidateThe 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 ScopeOracle EBS architecture and administration WebLogic administration Patching and upgrade strategies Performance tuning and optimization Backup and recovery planning High-availability and failover configurationsHow This Role OperatesWorks 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 LikeConsistent, 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 environmentSelection ProcessThe 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.
EXAMPLE OF DUTIES
Supervision Received and ExercisedReceives general direction from the IT management. Exercises technical and functional supervision over professional and technical staff.Essential Functions: 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.
SUPPLEMENTAL INFORMATION
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.
