* *Our services impact EVERY Montanan! _MISSION STATEMENT _* * To be the nation's most citizen oriented, efficiently administered, state tax agency. The Montana Department of Revenue administers almost 40 state taxes, property appraisals, alcoholic beverage laws, cannabis laws, and unclaimed property for the state of Montana. The Technology Services Division is an internal support division that providesapplication development, quality assurance and technical operations (system and desktop) services to all otherDepartment of Revenue divisions in meeting their goals and objectives of providing services to the State of Montana and its citizens. What We Can Offer You The State of Montana's comprehensive benefits package includes: * Health, dental, and vision care; life insurance; and long-term disability. The State currently contributes $12,648/year toward these benefits. * Free health care for employees and eligible family member at Montana Health Centers. * Employee Assistance Benefits including counseling, legal assistance, well-being coaching, financial information, which are free resources. * Retirement plans- The State currently contributes/9.17/%, vested after 5 years of continuous employment. * Paid vacation- starting at 15 days a year. * Sick leave- 12 days a year. * 11 holidays, including a floating holiday, which can be used any time. * Eligibility to participate in the Public Service Loan Forgiveness (PSLF) program. Visit the Health Care and Benefits Division for more information at https://benefits.mt.gov/. In addition to employee benefits, there are a wide range of advancement opportunities throughout the Department of Revenue. _DUTIES_ Job Overview: This position resides in theTechnology Services DivisionofDepartment of Revenue. The Database Analyst plans, develops, and manages database and application server operations and enhancements to ensure systems meet user needs, comply with state and federal regulations, and are operating efficiently within state standards. The Database Analyst is responsible for the performance, data integrity, and security of the agency’s MS SQL Server databases and critical applications. Key responsibilities include: 1) Provides guidance to Application Services Bureau (ASB) personnel when problems arise; 2) Installs, configures, and tests Microsoft SQL Server software packages and new software releases; 3) Monitors database performance and statistics, and conducts maintenance to ensure efficient system operations; 4) Configures, maintains, and administers Microsoft SQL Server database environments for critical DOR applications including GenTax and Assessment & Tax Pro. The Database Analyst will have on-call responsibilities outside of normal business hours. The position does not supervise other staff. Key Responsibilities Include: * Provides database backup and recovery strategies and provide guidance to other database and ASB personnel when problems arise in database backup and recovery situations. * Analyzes, develops, and implements solutions to resolve database problems. * Provides analytical and technical assistance, guidance, and direction to coworkers. * Develops scripts for server and database maintenance. * Determines problems and support for application batch processing on mid-tier servers. * Prepares and provides training and documentation for programmers and technical support staff. * Provides technical guidance in the use of Microsoft SQL Server programming products, designing database structures, maintaining data integrity, and ensuring the security of Microsoft SQL Server databases. * Installs, configures, and tests Microsoft SQL Server software packages and installs new software releases. * Monitors database performance and statistics and conducts maintenance to ensure efficient operation of the system. * Establishes and maintains database security roles to ensure database access is enforced for department employees, consultants, and the public. * Configures and maintains replicated database environments, utilizing databases located in multiple sites, for high availability and disaster recovery purposes. * Analyzes and evaluates agency business processes, system specifications, associated costs, and applicable policies and procedures to determine viable solutions to computer system issues. * Develops standard operating procedures for those areas to bring improved efficiency and effectiveness to the work unit. * Provides automated solutions and alternatives to the agency’s business needs that are compatible, efficient, and cost effective. * Manages database and application server enhancement, and maintenance efforts to ensure projects are completed within established timeframes. * Establishes database and application server maintenance policies and procedures with supervisor, contractors, and management. * Identifies potential threats and liabilities to computing systems and alerts the Computer Security Specialist. /Knowledge of:/ * Concepts and theories of information systems, databases, and computer science * System design, and system implementation within a large public agency * Computer operating systems, equipment, and software * Databases and data management tools * Database security and protection * Information systems development, enhancement, and maintenance * Systems analysis, design, testing, and customer service standards * Telecommunications and information systems networking * Data structures and interrelationships / / /Skills in:/ * Research and analysis * Accuracy and attention to detail * Microsoft programs and other data base applications * Written, verbal, and interpersonal communication * Managing complex and varied system development and project implementation * Isolating and resolving technical problems * Reading and interpreting technical manuals and data reports / / You would be a great fit for this position if you have: * Demonstrate self-motivation * //Follow instructions * //Provide timely, customer service * //Handling multiple priorities under deadlines * //Translate technical information to varied audiences// To be considered for any DOR position, applicants must complete and submit their application online, and upload any required documents. Successful applicants are required to successfully pass DOR tax and background check(s). DOR is an equal opportunity employer. Women, minorities, and people with disabilities are encouraged to apply. *This is an incomplete list of job duties. For a complete job description please contact Human Resources. (dorhr@mt.gov or 406-444-9858) *(All computer systems and tax guidelines will be trained on the job.) _Working Conditions_ * __ Work hours may exceed 40 hours from time to time, including weekends. * Office environment * Lifting is infrequent, less than 15 pounds. * Some travel may be required, must have a valid driver’s license. _REMOTE/TELEWORK:_This position may be eligible to work from an approved worksite within the state of Montana. This position would be required to report to a Department of Revenue office assigned by the supervisor. Employees must meet and sustain Department of Revenue telework eligibility requirements and supervisor's approval to participate in the DOR Telework Program. __ _Training Assignment:_ This agency may use a training assignment. Employees in training assignments may be paid below the base pay established by the agency pay rules. Conditions of the training assignment will be stated in writing at the time of hire. _HOW TO APPLY_ To be considered for this position, via the “Apply Online” button located on this posting. * * Applicant Pool Statement: If another department vacancy occurs in this job title within six months, the same applicant pool may be used for the selection. * * Requires the successful completion of a background check and state tax compliance status check. * *_EDUCATION / EXPERIENCE_ The above competencies are typically acquired through a combination of education and experience equivalent to: · Bachelor’s degree in computer science, business, mathematics, engineering, or closely related field, and · Three years job related work experience including programming information technology systems; troubleshooting and problem isolation; projection facilitation; and end-user assistance.* · Other combinations of education and experience will be evaluated on an individual basis. * Title: Database Administrator 2 Location: Helena Requisition ID: 25140331