Open Date: 04/05/2018
Date Initial Screening Begins:
Minimum Education/Experience: Bachelor's degree or an equivalent combination of education and experience and additional one year of experience. All degrees must be received from appropriately accredited institutions.
Special Instructions to Applicant: East Carolina University requires applicants to submit a candidate profile online in order to be considered for the position. Candidates must also submit a cover letter/resume, and a list of three references, including contact information, online.
Job Duties: This position will function as a Database Administrator (DBA), with primary responsibility for SQL Server, versions 2008 and forward. The DBA will utilize database management guidelines, perform current situation analyses of all SQL Server instances/databases and servers, and otherwise assume a lead role in the management of all SQL Server instances/databases, in consultation with Senior DBAs. More generally, this position will plan, install, configure, tune, and maintain primarily SQL Server databases on Windows operating systems, though crossover into Oracle database management is possible. This position will monitor database systems using various tools in order to determine baseline performance levels, and to identify and minimize/eliminate bottlenecks or other forms of performance degradation. This position will assist with the installation, configuration and maintenance of applications that are currently being maintained by the DBA team. This position will also be solely responsible for managing and implementing projects as assigned by the DBA Manager and/or Senior DBA, taking and working Database support tickets as they come in, and acting as a DBA resource on major project teams. This position will be required to participate in an on-call rotation. RDBMS Installation and Configuration - Install and configure SQL Server instances and customize database products to support new and existing business applications from development, testing and production migration. This includes sizing and planning database resources based on business needs, data integration needs and evaluation of potential fit with existing technical solutions on a variety of platforms. Database Maintenance - Monitor and optimize existing databases; resize or reorganize datafiles, tables, and indexes; determine database growth rates to assist the systems teams in planning for additional disk allocation and to make database parameter changes. Check daily backups and ensure database recoverability, using backups for disaster recovery testing. Ensure that database statistics are updated on a regular basis. Update database software as new releases are made available. Apply patches to database software. Data Security - Grant access to production and test tables when authorized, and according to established policies. Review database access regularly, using exception reporting to ensure. Review and adhere to data standards as defined by ECU's Data Governance committee, ensuring that sensitive data is identified and protected within the database. Performance and Tuning - Adjust system settings and memory allocation as needed. Capture and analyze any SQL statements impacting system performance, and notify developers of needed changes. Educate developers on toolsets that enable them to create optimized queries during the development cycle. Leadership - Establish SQL Server management procedures and provide guidance as well as implementation assistance as needed. Evaluate and consolidate existing SQL Server databases, based on University requirements, making recommendations on appropriate hardware and RDBMS platforms. Provide database consulting for new development and application purchases, to help guide the technical/development and functional teams. Teamwork - Work closely with Senior DBA and other DBA team members to document configurations, manage projects, cross-train and share knowledge, and review and adhere to database management standards as defined within the DBA team. Writing and Communication - Document configurations clearly and concisely. Must be able to discuss and explain complex technical problems and resolutions to developers and users who are not familiar with database technology. May be required to give presentations on database topics to other IT staff from time to time. Critical Thinking and Technical Troubleshooting - Analyze complex technical problems, using error messages, logs, and input from users, and decide on a course of investigation in order to troubleshoot a given problem. Every problem will be different, with a different set of symptoms and circumstances surrounding it. The effective DBA must be able to take the set of errors and facts at hand, logically eliminate possibilities, and decide on a course of action to test and determine the root of a given problem. Employees are required to adjust their standard work schedule to meet the requirements of their position, which includes and not limited to evening and weekend hours to perform scheduled and unscheduled workload requirements to maintain University operations. Duties require On-Call responsibilities.