Manages and maintains all Microsoft SQL Server production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery of Database Management Systems, configures database parameters, and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. Provides technical leadership and operational expertise for the implementation, architecture, design, ongoing support and maintenance of institutional databases and related software systems. Works with multiple IT teams and University departments to develop, maintain, and enhance databases and related applications.
1.Develops and maintains a documented database strategy, including standards, design, maintenance, replication, archiving, access and security to support departmental and organizational needs. 2.Manages and maintains all MS SQL Server production and non-production databases, including performing backups, recovery and validation, as well as reporting on database statistics. 3.Proactively manages the database environment to identify and recommend alternatives to poorly coded applications, including consulting with end users to recommend the most appropriate database solution. 4.Applies patches, installs software, manages database environment, monitors performance, and troubleshoots alerts. Optimizes database configurations for optimal configuration, performance and cost. 5.Maintains current knowledge and keeps management informed of products, developments and trends in database management and software. 6.Performs other duties as assigned.
Bachelor's Degree with coursework in computing or information systems and 3-5 years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment or the equivalent experience. The following knowledge, skills, and abilities are required:
Knowledge of Database Administration for Microsoft SQL Server in an Enterprise environment.
Extensive knowledge of T-SQL
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), profiling, and using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server.
Experience in implementing operational automation using scripts.
Knowledge of indexes, index management, and statistics.
Experience working with Linux/Windows servers, including Active Directory
Good communication and documentation skills.
Bachelor's Degree with coursework in computing or information systems and 5+ years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment.
Certification is a plus; MCTS, MCITP, or MVP.
Experience with Database Administration for MySQL/PostgreSQL/Oracle in an Enterprise environment.
Experience integrating MS SQL Server with SharePoint
Performs problem analysis and troubleshooting of the enterprise database infrastructure.
Coordinate support and problem resolution and planning and implementing new solutions and improvements to existing database infrastructure.
Strong background in System Administration
Knowledge of best practices and IT operations in an always-up, always-available service
A strong focus on business outcomes
Comfortable with collaboration, open communication and reaching across functional borders
Monitor, adjust and performs periodical preventive maintenance of system, database and application performance. Design, plan, implement and maintain performance tools.
Applicants must include in their online resume the following information: 1)Employment history: name of company, period employed (from month/year to month/year), job title, summary of job duties and 2) Education: school name, degree type, major.
UTA is an Equal Opportunity/Affirmative Action institution. Minorities, women, veterans and persons with disabilities are encouraged to apply. Additionally, the University prohibits discrimination in employment on the basis of sexual orientation. A criminal background check will be conducted on finalists. The UTA is a tobacco free campus.
The University of Texas at Arlington sets the standard for educational excellence in the thriving Dallas-Fort Worth metropolitan area and is one of the nation’s fastest-growing public research universities. With an enrollment of 38,000 on-campus students and an additional 15,000 online degree-seeking students, UTA is the second-largest institution in The University of Texas System. The University ...offers more than 180 bachelor’s, master’s, and doctoral degrees through 10 colleges and schools and is rising in stature through its commitment to transforming the lives of students, pushing the boundaries of knowledge, and serving a growing and diverse community.
UTA has developed a strategic plan, “Bold Solutions, Global Impact” (http://www.uta.edu/strategicplan). Taking advantage of our unique location at the center of the fastest growing urban region in the U.S. and adjacency to the Dallas-Fort Worth International Airport, our vision is to be ‘The Model 21st Century Urban Research University’. To support this vision, our strategic plan focuses on four over-arching themes across the University: Health and the Human Condition, Sustainable Urban Communities, Global Environmental Impact, Data Driven Discovery and Knowledge Management. The College of Engineering is playing a critical role in the advancement of each of these themes.
Our highly ranked academic programs attract the best and brightest scholars from around the world, and our faculty and students consistently receive national and international recognition for their accomplishments. U.S. News & World Report ranks UT Arlington fifth among national universities for undergraduate diversity, we are a designated Hispanic Serving Institution, and the Military Times recently named UTA as the best 4-year College for veterans in the state of Texas. The Chronicle of Higher Education ranks UT Arlington among the 20 fastest-growing public research universities in the United States over the last 10 years.
With a population of 7 million, the Dallas-Fort Worth Metroplex is the fourth-largest urban area in the United States. It covers an area larger than the states of Rhode Island and Connecticut combined. The Metroplex is the economic and cultural hub of North Texas and has the 10th-largest gross metropolitan product in the world. Not only is it an exciting place to live and work, the Metroplex offers UT Arlington a host of unparalleled scholarly, research, and economic activity.
UTA has been a catalyst for redevelopment and revitalization in the central business district of Arlington, establishing a true college town environment in downtown Arlington. UTA’s 20-acre, mixed-use College Park District provides new special events and student living space, restaurants, and parking as part of its broad-based initiative to generate and support economic activity at the city’s urban center. In addition, the University is expanding its footprint in both Fort Worth and Dallas and has plans to increase its global presence building on active partnerships led by the College of Business and the College of Nursing and Health Innovation in Central and South America, South East Asia and the Middle East.
For more information on University of Texas at Arlington, visit: www.uta.edu