Job Posting
The primary role of this position is to provide advanced technical assistance for TRS databases and related software, ensuring optimum performance levels of Information Technology databases in support of TRS products and services.
Education Requirements:
A Bachelor’s degree in Computer Science, Information Technology or the equivalent knowledge is required.
Experience:
A minimum of four years of progressively responsible experience in the area of Information Technology is required. Requires a working knowledge of Microsoft SQL Server administration tools and practices, relational database design and structure, Business Intelligence practices, and System Development LifeCycle.
Summary of Duties and Responsibilities:
The incumbent will support the organization by providing needed database related technical assistance. This position will also be responsible for the installation and configuration of database and system software, the installation, maintenance, and monitoring of multiple databases in various environments, and the overall design and integrity of the TRS databases. The incumbent will also be responsible for creating TSQL queries for users and other Information Technology staff as needed.
Knowledge/Skills/Abilities:
The incumbent must possess strong analytical skills, excellent organizational skills, the ability to work effectively with others and the ability to communicate complex information at a high level. Strong knowledge of SQL Server Administration, TSQL, relational database design, and various software packages is required.
Selection Criteria:
ANALYTICAL SKILLS
Analyzes information and reviews problems thoroughly; determines the nature and relationship of situations.
COMMUNICATION SKILLS
Demonstrates effective oral and written communication skills. This includes the ability to organize ideas and speak effectively in public situations, to small groups or one-on-one as well as the ability to demonstrate good listening skills including the ability to receive, attend to, interpret and respond to verbal messages and non-verbal cues when conversing with others. In addition, the position requires the ability to compose and edit specified documents in a clear, concise and well-structured manner.
JOB KNOWLEDGE AND EXPERIENCE
Ability to interpret programming logic from documented requirements. Has completed specified amount of time previously performing essential duties of the job and/or has completed specified degrees, coursework or training programs to perform the job. Possesses a body of information or level of understanding necessary to complete assigned responsibilities.
ORGANIZATIONAL SKILLS
Organizes work tasks in an efficient manner; able to complete assignments on time and accurately by prioritizing tasks and monitoring their completion.
PROBLEM SOLVING
The ability to define a problem; define several solutions (if necessary); and implement the solution which resolves the problem in the most effective and timely manner.
TECHNICAL SKILLS
The ability to identify technical limitations on existing systems and define essential technical enhancements and acquisitions to assure the efficiency of TRS systems in the future.
Job Description
Purpose:
Under the supervision of the Database Manager, the Database Administrator is responsible for evaluating, monitoring, maintaining, performance tuning, assessing data quality, performing legacy data conversion activities, and ensuring security of TRS production, test and development databases. This position provides leadership in design, development, and institution of quality assurance measures for production deployment of database objects and functions. In addition, this position is responsible for helping to develop, implement and oversee data policies, standards, and procedures to ensure the relational integrity and availability of the databases and their accompanying software. This position is also accountable for providing staff with access to needed data / databases.
Nature and Scope:
This incumbent is required to advise and provide leadership in the database field giving full technical knowledge transfer and support to applications development staff by providing expert level service and assistance. This position will also be charged with performing research and interpreting technical documentation; compiling and making recommendations and decisions that support organizational needs based upon that thorough research; will work closely and provide assistance to Technical Support personnel for installing and configuring database and system software; and communicating complex information at a high level.
Primary tasks for the incumbent include the ability to monitor database and database server performance metrics, make performance improvements through research of those metrics, and design and implement processes to enhance and maintain databases for TRS production, test and development environments. The incumbent is required to document appropriate procedures for administration and maintenance of these database structures.
The incumbent must possess good organizational skills, the ability to work and communicate effectively with others, a working knowledge of client/server and multi-tiered distributed computing, database hardware, software, various software packages pertaining to database functions and have the ability to work on installation and configuration of that software in conjunction and partnership with Technical Support staff. A working knowledge of best practices in data conversion and transformation practices are a necessary requirement of this position.
The incumbent will also be responsible for assisting in the development and maintenance of a complete database dictionary for reference purposes, and an archival system for historical member and employer information.
The greatest challenge of this position is to interpret input from various teams, analyze requests and implement a database design which protects the integrity of TRS data and database design while efficiently meeting TRS application and business requirements.
Principal Accountabilities:
- Perform RDBMS recovery, restore, restart, maintenance, and rerun procedures and techniques.
- Provide adequate documentation of database administration procedures including procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Develop or modify existing database schemas based on stated agency business requirements.
- Establish appropriate end-user and application database access control levels.
- Participate in assessing and developing long-term strategic goals for production databases in conjunction with user and IT management staff to ensure effective protection and integrity of data assets.
- Provide support, advice, and assist programming staff on database issues and best practices.
- Study techniques and reference materials, which are pertinent to the job; attend classes/seminars covering such topics as database administration, optimization, performance tuning and query (SQL) languages.
- Research and conduct walkthroughs for database modifications.
- Monitor physical data storage requirements for the databases and discuss enhancements and recommendations with Network Services staff.
- Assist in troubleshooting database hardware and software problems.
- Provide database performance statistics and be able to succinctly explain the importance of what statistics provide.
- Participate in communicating and resolving issues with outside vendors on technical database and system software issues.
- Assist in researching and providing recommendations on database products and services in support of procurement and development efforts.
- Assist in developing and maintaining a data dictionary for the production database tables and columns.
- Assist in developing and maintaining an archival structure for historical member and employer information.
- Develop, standardize, and perform production deployment tasks.
- Display advanced TSQL skills necessary to assist development staff with query performance tuning.
- Continually review, refine, and implement existing processes for improvement of database services and practices to development staff and end users.
- Participate in load testing exercises with development staff to ensure newly developed or modified processes do not cause application or database performance degradation.
- Leverage established best practices methods to ensure quality of design, implementation, and performance of data retrieval methods.
- Conduct DBA procedures and practices in conjunction with staff working in an Agile development environment.
- Become familiar with current DevOps trends supporting continuous integration development.
- Assist in researching and proving concepts pertaining to Business Intelligence initiatives and other emerging data technologies such as Cloud databases, Big Data (Hadoop), and Machine Learning.
- Be available on-call at all times.
- Perform other duties as required or assigned.