Database Administrator

$79,456 - $127,088/Yr

Regional Transportation Commission Of Southern Nevada - Las Vegas, NV

Full-time

Las Vegas, NV

Transit and Ground Passenger Transportation

About the position

The Database Administrator is responsible for analyzing, designing, and developing database servers, structures, instances, tables, and related systems while overseeing data integrity. This role involves establishing physical and logistical database architecture and structures to ensure maximum retrieval and efficiency. The Database Administrator will analyze and resolve user problems related to databases and supporting systems, ensuring that all database applications are installed and supported effectively, particularly those using Microsoft SQL Server and Microsoft Access. In addition to installation and support, the Database Administrator will design, implement, and maintain the RTC backup and recovery infrastructure, ensuring adequate redundancy and backup operations. This position requires coordination of database structures to maintain integrity, accuracy, security, and performance efficiency. The Database Administrator will also review the design of programs accessing databases to ensure logical and orderly storage, security, selection, and retrieval of information. The role includes designing, implementing, and maintaining ETL and data interfaces, testing new database releases, and determining the impact of installations on existing production systems. The Database Administrator will utilize technology features in SQL Server, such as partitioning, file groups, replication, indexed views, and file streams. Continuous research on new products, methods, and techniques is essential to contribute effectively to the data team effort and accomplish related results as needed.

Responsibilities

• Establish physical and logistical database architecture and structures for maximum retrieval and efficiency.
• Analyze and resolve user problems related to databases and supporting systems.
• Install and support database applications using Microsoft SQL Server and Microsoft Access.
• Design, implement, and maintain RTC backup and recovery infrastructure.
• Ensure adequate redundancy and backup operations.
• Coordinate database structures to maintain integrity, accuracy, security, and performance efficiency.
• Review the design of programs accessing databases to ensure logical and orderly storage, security, selection, and retrieval of information.
• Design, implement, and maintain ETL and data interfaces.
• Test new database releases and determine the impact of installations on existing production systems.
• Utilize technology features in SQL Server such as partitioning, file groups, replication, indexed views, and file streams.
• Research and keep current on new products, methods, and techniques.
• Contribute to the data team effort by accomplishing related results as needed.

Requirements

• Equivalent to a Bachelor's degree in information systems or a closely related field.
• Two (2) years of demonstrated professional database analysis and administration experience.
• Strong SQL Server database performance analysis and tuning skills including tracing and profiling.
• Strong T-SQL scripting knowledge.
• Experience in ETL development.
• Troubleshooting database servers and operating system failures and problems.
• Knowledge of database and data dictionary concepts, structures, and operating systems interfaces.
• Understanding of data modeling and flow analysis, extraction and access methods, storage allocation, and security requirements.
• Familiarity with operational and technical characteristics of computer equipment and software.
• Knowledge of office administrative practices and procedures.

Nice-to-haves

• Experience in Data Warehouse development.
• Skill in Microsoft Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).
• Experience with Crystal reporting, ODBC, and OLE DB (ADO) connections.