Database Analyst

State Of Montana Helena , MT 59624

Posted 2 weeks ago

THE OUTSIDE IS IN US ALL.

Please remember to attach the required documents (COVER LETTER, RESUME AND ANSWERS TO SUPPLEMENTAL QUESTIONS) listed in this announcement. Applications missing the requested documents will be considered incomplete and may not progress further in the process.

Documents not requested will not be considered in the recruitment process. This position closes at 11:59 PM Mountain Time on November 1, 2020. You must apply through the State of Montana Career site.

Special Information:

Identity of applicants who become finalists may be released to the public if the Department deems it necessary. Employees who exceed 1,040 hours in a calendar year are also provided health, dental and life insurance.

Other benefits include retirement, paid vacation, sick and holidays. This position may be covered by a VEBA (Voluntary Employee Beneficiary Association).

A successful applicant will be subject to a background investigation.

Women and minorities are under-represented in this job category and are encouraged to apply.

Job Duties (narrative summary):

This position monitors, maintains and administers the database servers at Fish, Wildlife & Parks to ensure that the ability of the agency to collect and utilize data is provided to the maximum extent possible. To complete this role, the position must ensure that database standards are established and conformed to, security is maintained, and backup and disaster recovery procedures are in place and followed.

This position spends a portion of their time performing various aspects of software development: requirements gathering and analysis, design, coding, testing and documentation for any assigned projects and programs. This position is responsible for the overall direction and supervision of the FWP relational database environment.

The Database Administrator is part of the DevOps Bureau. The DevOps Bureau is responsible for promoting communication, collaboration and integration between software developers, information technology operations professionals, testers, managers, product owners, business analysts and reaching across functional borders.

Staff within DevOps are dedicated to the study of building, evolving and operating rapidly changing resilient systems at scale. This bureau oversees quality assurance, systems security and manages the Software Development Lifecyle with automated tools. FWP has a dozen enterprise-class databases that contain more than two billion records.

DevOps monitors, maintains and administers the database servers to ensure that the ability of the agency to collect and utilize data is provided to the maximum extent possible. To complete this role, the bureau must ensure that database standards are established and conformed to, security is maintained, and backup and disaster recovery procedures are in place and followed.

Minimum Qualifications (Education and Experience):

The knowledge, skills, and abilities of this position are normally attained through a Bachelor's Degree in Computer Science or a related field to include education/training in Programming languages, MS Windows, Linux, database administration, SQL*Plus, MS Office, PL/SQL, PostgreSQL and at least 5 years of job-related experience to include Oracle Server Database experience. Education/training in Java, data modeling tools, Networking, Storage Area Networking, WildFly are desirable. Other combinations of education and experience will be considered on a case-by-case basis.

Application Requirements:

To be considered for this position, you must submit a Cover Letter, Resume, and Answers to the Supplemental Questions below:

1.Explain your experience in maintaining a production database environment and list what you think are the most critical things that need to be done for maintaining a healthy database environment, and how that relates to networking and development efforts.

2.What do you see as the similarities and differences in the roles and responsibilities of systems administrators, software developers and database administrators? How can they work effectively together?



icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Program Analyst

Department Of Defense

Posted 3 days ago

VIEW JOBS 10/28/2020 12:00:00 AM 2021-01-26T00:00 * Duties Help Duties Summary THIS IS A NATIONAL GUARD TITLE 5 EXCEPTED SERVICE POSITION. This National Guard position is for a PROGRAM ANALYST, Position Description Number T5615000 and is part of the MT J8, National Guard. Learn more about this agency Responsibilities To provide management with objectively based information to effectively assess the full range of logistical asset accountability of all units/activities within the state. The purpose is to monitor and ensure effectiveness of operations regarding logistics accountability. Identifies process, system, and equipment on hand deficiencies by applying defect prevention principles and root cause problem resolution techniques and recommends corrective action for each. Serves as advisor to the USPFO and his staff members regarding compliance, readiness posturing as relates to accountability, and mission limiting issues. 1. Develops sampling plans and procedures for validating unit/activity accountability and inventory certifications. Independently evaluates the effectiveness of substantive unit programs and processes in meeting their established goals and objectives. Analyzes evaluation results on both a quantitative and qualitative basis to provide concise and objective information to identify accountability strengths and weaknesses. Plans and designs procedures to improve organizational effectiveness and efficiency. Evaluates unit and organizational effectiveness. Develops and administers a system of reviews, management controls, evaluations, and checklists designed to ensure conformance with law and regulations. The employee plans, coordinates, and carries out the successive steps in fact-finding and analysis of issues necessary to complete each phase of assigned projects. Using standardized and locally developed evaluation programs and processes, management principles, organizational theory, and techniques of analysis and evaluation, plans and accomplishes scheduled evaluations.Coordinates and/or conducts management studies of organization, staffing, work measurement, methods, or procedures. Incumbent reviews administrative audits, Financial Liability Investigation for Property Loss (FLIPL) reports, and Command Supply Discipline Program (CSDP) review reports to determine accountability trends to develop scope of review and recommendations to improve accountability processes and corrective actions. Monitors all unit standardization/evaluation type programs ensuring adherence to all requirements defined in Department of the Army (DA), National Guard Bureau (NGB), and local publications or other applicable directives. Identifies or creates metrics and measures progress toward accomplishment of unit plans, programs, goals, and objectives regarding federal property and supply accountability. 2. Applies statistical analysis techniques to measure progress, efficiency, and trends impacting the effectiveness of the organization to meet the organizational goals and objectives. Performs 100 % inventories of unit/activity equipment and supplies and analyzes requisition data to determine causes of any discrepancies. Develops cost analysis of financial impact regarding accountability, equipment and supply damage, adequacy of storage, physical security and loss of federal supplies and equipment. Provides USPFO, DCSLOG/G4, Command Staff, unit/activity commanders, with factual, objective assessments of the unit's ability to conduct unit logistics operations and account for federal property. Analyzes, evaluates, validates, and identifies ways to improve the mission, function, and activities of the organization. Provides USPFO, DCSLOG/G4, Command Staff, unit/activity commanders, with information needed for effective direction of programs to include reports identifying limiting factors, program management opportunities, and availability of equipment on hand. Advises the USPFO, DCSLOG/G4, Command Staff, unit/activity commanders, activity managers on the evaluation of basic program policies, regulatory requirements, and followup procedures regarding applicable completed evaluation. 3. Develops processes, management, administrative, and technical evaluation plans for implementation by supervisors/managers. Notes deficiencies, identifies necessary resources, and recommends corrective action. Reviews workload requirements to ascertain areas where procedures can be combined, distributed, or simplified to increase productivity, efficiency, or effectiveness and is able to utilize centralized planning and decentralized execution of mission objectives. Recommends internal reporting and status tracking procedures to ensure adequate control in terms of deadlines, progress reports, and follow-up reports. Manages the evaluation program to ensure required actions are tracked and completed. Makes recommendations, reviews responses and ensures that corrective actions are performed. 4. Responsible for on the spot corrective assistance and guidance to unit/activity personnel during the conduct of the evaluation/review. Coordinates with other logistics sections within the USPFO and Joint Force Headquarters to resolve technical problems concerning supply and equipment authorizations and accountability. Performs other duties as assigned. Travel Required Occasional travel - You may be expected to travel for this position. Supervisory status No Promotion Potential None * Job family (Series) 0343 Management And Program Analysis Similar jobs * Analysts, Program * Program Analysts * Requirements Help Requirements Conditions of Employment * Federal employment suitability as determined by a background investigation. * May be required to successfully complete a probationary period. * Participation in direct deposit is mandatory. * Must be able to obtain and maintain the appropriate security clearance of the position. Incumbent must be able to obtain a secret security clearance. * Extensive travel is required to perform duties throughout the state * Ability to establish effective professional working relationships with coworkers and customers, contributing to a cooperative working environment and successful accomplishment of the mission. * May occasionally be required to work other than normal duty hours; overtime may be required. * The duties and responsibilities of your job may significantly impact the environment. * You are responsible to maintain awareness of your environmental responsibilities as dictated by legal and regulatory requirements, your organization, and its changing mission * Proficient in logistics standard army management information system (STAMIS). * This position is designated as Essential Personnel and may be subject to duty in preparation for, or in response to, a state emergency or disaster declaration. * This designation will not exceed 14 calendar days per year unless otherwise approved in advance by the TAG. Qualifications GENERAL EXPERIENCE: None. SPECIALIZED EXPERIENCE: Must possess at least 1 year equivalent to at least GS-7 experience which has provided a working knowledge of the National Guard organizational structures, functions, procedures, and techniques; experience analyzing, interpreting and developing policies and procedures of local management to monitor and ensure effectiveness of operations regarding logistics accountability. OR (Possess 1 of the 3 below Education Substitutes of Specialized Experience; TRANSCRIPTS MUST BE INCLUDED) master's or equivalent graduate degree (courses required in related course work; i.e. 24 Semester hours) or 2 full years of progressively higher level graduate education leading to such a degree (related to work to be performed) or LL.B. or J.D., if related Education If you are using Education to qualify for this position, YOU MUST INCLUDE TRANSCRIPTS! You must provide transcripts or other documentation to support your Educational claims. To receive credit for Education, you must provide documentation of proof that you meet the Education requirements for this position. FOREIGN EDUCATION: If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show that the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: http://www2.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html Department Of Defense Helena MT

Database Analyst

State Of Montana