Support and maintain the University’s Oracle and SQL Server databases; Develop plans for University database capacity growth and work with data stewards to determine enterprise strategic database needs; Maintain data standards; Coordinate the implementation of database software; Review and implement vendor database security releases; Keep abreast of evolving database security best practices and apply them locally; Install/upgrade and support existing and required new instances, including various methods of redundancy — clustering, log shipping, mirroring, etc.; Creation and maintenance of agent jobs to migrate data to/from Oracle and SQL Server instances as well as performing maintenance routines including backups and recovery/history retention/history cleanup/index defragmentation/etc. Coordinate, supervise, and support projects that span multiple technologies related to the evolving decisions and user services support environment (data warehousing, metadata repository, access management tools, database servers, data migration tools, etc.). Assist users to determine database requirements; define and develop project plans and detailed specifications; design and program database applications and queries. Analyze, troubleshoot, and debug technical hurdles when encountered; provide technical support and guidance to users, systems analysts, systems administrators.
Knowledge: Oracle and/or SQL Server database environments, application servers, web servers, and monitoring tools; Linux, or Unix operating systems; Relational or object-oriented database technology, data modeling concepts, tools/techniques, general business operations Proficiency in SQL and web programming All facets of contemporary systems in general, i.e. networks, firewalls, ports, etc., information technology including hardware and system software for host and desktop systems, local area/wide area network technology, and Web based applications Understanding of applications from end user perspective as well as DBA perspective
Demonstrated abilities: install Oracle Relational Database Server systems and Oracle Application Server systems and/or install SQL Server systems both Standard and Enterprise editions; work with enterprise Linux or Unix systems; effectively monitor performance and health of Oracle or SQL Server database systems to optimize database performance, resource use, physical implementations of databases; address multiple database integration issues i.e., migration between disparate databases, integration with other databases, maintenance/conversion, capacity planning issues, new applications effectively review, develop, and design data models using standard diagramming techniques, in conjunction with application development teams; create logical data models and translate into physical database structures that integrate with existing or proposed database structures provide guidance and advice to applications programmers in the effective use of database languages; advise on troubleshooting, exception processing needs, and other data management issues; maintain data standards; review and implement vendor database security releases; keep abreast of evolving database security best practices; maintain backup and recovery plans; work nights and/or weekends as necessary; effective critical thinking skills; effective interpersonal, written and oral communication skills; establish and maintain effective working relations with diverse constituencies: faculty, staff, students; express ideas clearly and concisely