Job Posting
The primary role of this position is to analyze business data requirements and using modern tools design and implement solutions to store and present data to meet organizational needs. This includes data modeling and design, data conversion, performance tuning for optimum performance of TRS databases and the presentation of business information in various formats including the use of third party tools such as Business Intelligence (BI).
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 knowledge of relational database concepts and principles, TSQL, and SQL Server in an enterprise environment using Microsoft Visual Studio and Team Foundation Server (TFS). Experience with Internet-based applications, Azure cloud platform, Dynamics 365, SQL Reporting Services (SSRS), Power BI, ASP.NET, Visual Basic.NET and Winforms development is a plus.
Summary of Duties and Responsibilities:
The incumbent will support the organization by providing needed database related technical solutions. This position will be responsible for the installation, configuration and monitoring of database and system software across multiple on-premise and cloud databases environments. The incumbent will also be responsible for the design and integrity of the TRS databases, creating TSQL queries, data conversion, setup and presentation of data within approved BI tools and assisting business 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 Senior Database Administrator works as a team leader with software and systems engineering teams in order to design, propose, and create database architecture that provides computing services with necessary data elements to accomplish complex business tasks. In addition, this position is responsible for evaluating, monitoring, maintaining, performance tuning, assessing data quality, performing legacy data conversion activities, 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 mentor, advise and provide leadership in the database field giving full technical knowledge transfer and support to other DBA and applications development staff by providing senior expert level architecture support, service and assistance. This position will also be charged with performing research, proofs of concept on potential emerging technology that could enhance performance and reporting, 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.
In addition, 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 maintain database performance 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 comprehensive knowledge of best practices in data design, mapping, 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 incumbent will support multi-faceted database environment across diverse platform including on premise and cloud. In addition, 3rd party solutions including Dynamics 365. The incumbent will also analysis TRS business data needs and present results in various formats such as BI (Business Intelligence).
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 all IT 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.
- Assume a leadership role 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, develop, test, and implement 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.
- Mentor junior DBA staff on procedures and processes related to daily support and maintenance of all production level TRS databases.
- Be available on-call at all times.
- Perform other duties as required or assigned.