Database Administrator

Database AdministratorThis 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 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 Candidate The most competitive candidate is a hands-on, experienced SQL Server Database Administrator with strong production support skills and the technical versatility to support reporting, integrations, and development. The position primarily supports Microsoft SQL Server and related technologies and will be expected to cross-train in Oracle Database, Oracle E-Business Suite, and WebLogic administration to provide broader enterprise application support.Advanced SQL Server Database administration, performance tuning, patching, and upgradesBackup, recovery, high availability, and database securitySSRS administration and developmentAzure, T-SQL, PowerShell, integrations, scripting, and related Microsoft data technologiesWorks independently with sound technical judgmentEvaluates risk, impact, and rollback before production changesTroubleshoots complex issues and drives root-cause resolutionDocuments solutions and shares knowledge across the teamReceives 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.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.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.