General Statement of Duties:
Responsible for the analysis, design, implementation and support of databases used in the development of in-house application solutions. Responsible for the development, implementation and support of enterprise strategic data warehouse technologies. Responsible
for the implementation and execution of preventative maintenance routines to ensure end-user availability and performance of database files and their related management systems. Work with management to develop database strategies to support organizational
needs. Consult with and advise the development staff on proper database usage as it relates to development tasks. Direct and control the maintenance and use of the organizational data dictionary. In conjunction with the LAN Systems team and Security team,
the DBA is responsible to ensure proper security of all databases and their respective database management systems. Responsible for quality control and auditing of databases to ensure accurate, secure, and appropriate use of both testing and production databases.
Essential Duties and Responsibilities:
1. Database Administration – Responsible for the administration of existing enterprise databases and the analysis, design, and creation of new databases as necessary.
• Create databases, tables, procedures and grant permissions.
• Design and document database architecture.
• Analyze, load balance, and tune databases for optimal efficiency.
• Proactively monitor systems for optimum performance and capacity constraints.
• Monitor scheduled database jobs to ensure successful and timely completion.
• Monitor and administer DBMS security; including adding and removing users, administering disk space, auditing, and checking for security problems.
2. Development Activities – Responsible for reviewing, promoting, and monitoring all changes to the test and production databases.
• Assist the development staff in creating database designs that meet development requirements and optimal performance requirements.
• Establish standards and best practices for SQL.
• Interact with and coach developers in optimal SQL techniques.
• Review scripts before they are applied to test and production databases.
• Run approved scripts to apply updates to test and production databases.
• Develop database utilities and automated processes.
3. Database Management System Administration – Work with the Network Administrator on maintaining Operating System and DBMS versions and patches to maintain an acceptable level of support and security of the database instances and servers.
• Assist Network Administrator with the installation of new versions of DBMS software, application software, and other software related to DBMS administration.
• Work with Product Development staff in testing new software before being released to production.
• Work with the Network Administrator to configure hardware and software so that it functions optimally with the DBMS.
• Monitor backup procedures to ensure sufficient coverage in case of failure.
• Be prepared to restore/recover any lost databases or database objects.
• Must be able to create SSIS packages
4. Quality Assurance: Ensure that database migration plans and database changes are in line with development specifications have been reviewed prior to being promoted to production. Provide the application development unit with final authorization
to release the application to production. Assist with staff training as requested. Conduct post-implementation follow-up activities.
5. Systems Administration: Work with the Network Administrator when needed in system administration and maintenance tasks. These include Server, Storage networks and Back up Services. Administration of these services includes the research, configuration,
installation, maintenance, and support to IT and general users. In addition, continued research for improvements and upgrades is necessary.
6. Management Reporting: Develop and maintain reporting standards on database performance and usage forecasts.
7. Technology: Achieve and maintain a current working knowledge of advancements in database management systems. Stay up to date on new versions of supported DBMS’s and the advantages/disadvantages that each offers. Attend seminars and conferences
designed to build knowledge of the same.
8. Communication: Create and distribute written communications as necessary regarding database changes, outages, etc. Effectively interact with the Product Development staff, other agency staff and external parties for the purpose of gathering and
providing information related to product development or industry initiatives. Attend seminars and conferences designed to build knowledge of same. Review industry related websites and newsletters.
To build a diverse workforce, MOHELA encourages applications from individuals with disabilities, minorities and veterans.
- Bachelor’s Degree in Computer Science or related field is preferred; equivalent experience and/or education will also be considered. Three years minimum of Database Administration. Experience with database design and application development methodologies
are desirable. Experience within the Federal Student Loan industry will be beneficial.
- Should have knowledge of Database Administration on Microsoft SQL Server 2005 and newer. Extensive expertise with Microsoft SQL Server, SQL queries, stored procedures, data structures and experience with applied SDLC practice and Change Management.
- System administration experience is desirable.
- Sound analytical and problem solving skills; Knowledge of programming, systems analysis and design, and database structures
- Good organizational and time management skills.
- Ability to effectively adapt to a dynamic constantly changing, priority-shifting environment.
- High degree of confidentiality and professionalism, ability to interact effectively with all levels of staff, commitment to service and excellence.
- Self-direction with the ability to manage multiple projects and responsibilities.
- Dedication to professional development in the IT field through continuing education, certification, and/or seminar attendance.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex or national origin.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
In compliance with the American Disabilities Act Amendment Act (ADAA), if you have a disability and would like to request an accommodation in order to apply for a position with MOHELA, please call 636.532.0600 x3571, TDD: Dial 711, or email
From the "Show Me" state comes Missouri Higher Education Loan Authority, one of the country's top holders and servicers of...