About Virginia Tech:
Virginia Tech, founded in 1872 as a land-grant institution, is currently ranked as a Top 25 Public University by US News & World Report and a Top 25 Public Research University by the National Science Foundation. Through a combination of its three missions of learning, discovery, and engagement, Virginia Tech continually strives to accomplish the charge of its motto: Ut Prosim (That I May Serve). As the Commonwealth's most comprehensive university and its leading research institution, Virginia Tech serves a diverse population of 30,000+ students and 8000+ faculty and staff from over 100 countries, and is engaged in research around the world. Invent the Future at Virginia Tech.
The Virginia Tech Transportation Institute (VTTI) is seeking a database administrator to be responsible for the administration and operation of databases in a dynamic research environment. In addition to day to day database operations, the position also involves providing consultation to researchers regarding database design, performance, and usage, as well as providing vision and guidance regarding major database decisions. The position requires work both individually as well as collaboratively with other members of the VTTI IT team and researchers. The ideal candidate must be able to communicate and interact effectively with this diverse clientele. Due to the nature of the environment, the ability to be flexible and a motivated self-learner is vital.
The database platforms in use at VTTI are primarily IBM DB2 and Microsoft SQL Server. The DB2 environment is the primary repository for VTTI's research data and currently houses hundreds of terabytes of research data in an MPP infrastructure running on Linux. VTTI uses Microsoft SQL Server for major research projects, especially for a management and inventory database with replication to numerous distributed laptops. In addition, VTTI also uses MySQL and PostgreSQL in miscellaneous roles as appropriate, for example as utility databases for LAMP/LAPP applications.
-Doctorate/terminal degree in Information Technology or related field. Significant work experience and a lesser degree may be considered instead of the advanced degree.
-Demonstrated experience running multiple relational database systems, especially IBM DB2 and Microsoft SQL Server. Significant experience with other database systems (e.g. Oracle, MySQL, PostgreSQL)
-Demonstrated SQL and data modelling skills
-Thorough understanding of and experience applying principles of database security
-Demonstrated experience with performance tuning of databases
-Experience designing and operating backup and recovery procedures for production database systems
-Understanding of and experience managing large parallel database environments in a scientific data warehousing environment, especially with significant sensitivity requirements (e.g. human subject research), using clustering or partitioning to parallelize data access
-Experience supporting researchers using scientific analysis tools, notably SAS, Matlab, and R, as well as writing SQL
-Experience configuring and operating database systems in high-availability configurations
-Experience with database replication, especially with SQL Server
-Experience writing system shell scripts or using high-level programming language, such as Java, C#/.Net, C++, especially for automating various database administration tasks (backups, log parsing, data loading, etc.)
Employee Category: Research Faculty
Appointment Type: Restricted
Tenure Status: Non-Tenure Track
Percent Employment: Full-time
Virginia Tech does not discriminate against employees, students, or applicants on the basis of age, color, disability, gender, gender identity, gender expression, national origin, political affiliation, race, religion, sexual orientation, genetic information, or veteran status; or otherwise discriminate against employees or applicants who inquire about, discuss, or disclose their compensation or the compensation of other employees, or applicants; or any other basis protected by law.
For inquiries regarding non-discrimination policies, contact the executive director for Equity and Access at 540-231-2010 or Virginia Tech, North End Center, Suite 2300 (0318), 300 Turner St. NW, Blacksburg, VA 24061.
Review Date: 03/15/2017