Database Administrator 1

THIS IS NOT A REMOTE POSITION Pay : $90-100K Full time Benefits available Primary Purpose : Responsible for extracting and copying business data and loading it into our data warehousing environment according to the business requirements.

Test the performance of the system and troubleshoot any problems. Maintain quality control standards, and recommend any necessary changes.

• Essential Duties and Responsibilities include the following. Other duties may be assigned. 1.Administers a variety of database systems including Microsoft SQL Server, and other Database Management Systems (DBMS);
• maintains and administers Web server and middleware tools used to develop Web database systems and framework; develops and enforces database administration and user standards and procedures;
• audits, modifies, and amends data in systems using SQL commands, hand-editing, and bulk import; oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites;
• supervises andmanages multiple concurrent projects; evaluates database server integrity and security; assumes the technical lead for SQL Server and online database projects;
• assists Database Designers / Information System Analysts in the development and creation of SQL and Web-based databases and database systems;
• reviews technical designs, reports, documentation, and other materials produced by staff; creates and maintains high-level reporting systems using products such as Crystal Reports;
• researches and implements new database and online technology. 2.Communications / Technical Assistance 3.Oversees the design and maintenance of online communications, including database-driven web sites and distance learning programs;
• assists and supports organizational members and clients with network, database, and application training and technical support;
• plans and prepares correspondence. 4.Office Operations Support 5.Assists staff in developing procedures, forms, exhibits, and database documentation;
• configures hardware and software utilized on database and Web servers; allows end-users to access management information systems directly by using Open Database Connectivity(ODBC) and other methods of connectivity;
• assists office staff in the creation of database reports and exhibits; trains and provides technical direction to staff as needed;

supports internal operations, local area network administration, budget management, and project planning. Competencies To perform the job successfully, an individual should demonstrate the following competencies : 1.

Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data.

• 2.I nterpersonal Skills - Maintains confidentiality; Keeps emotions under control. 3.Oral Communication - Speaks clearly and persuasively in positive or negative situations;
• Listens and asks questions to receive clarification; Responds well to questions; Demonstrates group presentation skills;
• Participates in meetings. 4. Written Communication - Writes clearly and informatively; Edits work for spelling and grammar errors;

Varies writing style to meet the needs of different projects; Presents numerical data effectively; Able to read and interpret written information.

• 5. Business Acumen - Understands business implications of decisions; Displays orientation to profitability. 6. Ethics - Treats people with respect;
• Keeps commitments; Inspires the trust of others; Works with integrity; Upholds organizational values. 7. Organizational Support - Follows policies and procedures;
• Supports organization's goals and values. 8. Judgment - Displays willingness to make decisions; Exhibits sound and accurate judgment;

Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.

• 9. Planning / Organizing - Prioritizes and plans work activities; Uses time efficiently.10.Professionalism - Approaches others in a tactful manner;
• Reacts well under pressure; Accepts responsibility for own actions. 11. Quality - Demonstrates accuracy and thoroughness;
• Looks for ways to improve and promote quality; Monitors own work to ensure quality. 12. Quantity - Meets productivity standards;
• Completes work in timely manner; Works quickly.13.Safety and Security - Observes safety and security procedures. 14. Adaptability - Adapts to changes in the work environment;
• Able to deal with frequent change, delays, or unexpected events. 15. Attendance / Punctuality - Is consistently at work and punctual;
• Ensures work responsibilities are covered when absent; Arrives at meetings and appointments on time. 16. Dependability - Follows instructions and responds to management direction;

Commits to long hours of work when necessary to reach goals. 17.Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.

18.Proficiency in Power BI Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

The requirements listed below are representative of the knowledge, skill, and / or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education, Training and Experience Any combination of education and training equivalent to possession of a Bachelor's degree that demonstrates the ability to perform the duties and responsibilities as described.

• Sufficient formal and / or informal training experience in Database Management Systems (DBMS) administration and maintenance, database design, analysis, and management;
• extensive experience as a database designer / information systems analyst, database manager or database administrator. Knowledge of : Administration and maintenance of management information systems;
• server hardware and software technologies (including Linux and Windows Servers); standard computer hardware and software;
• basic principles of computer system analysis, principles of organization and project management; Internet technology including Hypertext Markup Language (HTML) forms;
• middleware or common gateway interface (CGI) programming used in database Web publishing, including the following : Cold Fusion, PHP Hypertext Preprocessor (PHP), Active Server Pages (ASP) and JavaScript;
• procedures for using SQL; standard office procedures and practices; advanced databases and database design concepts; data communications and networked systems;

database integration on the Web; fundamentals of page layout, design, and graphic illustration; Microsoft SQL, Access, FileMaker Pro, or other relational database systems.

• Familiarity and regular use of the Power Bi systems and capabilities. Skill and Ability to : Communicate effectively in both oral and written forms;
• interact with users and office staff in non-technical, clear terms; assist staff with difficult technical tasks, including the creation of specialized reports and exhibits using Crystal Reports;
• work independently and as a team member; set priorities and organize work to meet strict deadlines; make decisions on a variety of complex matters;
• establish and maintain cooperative working relationships with those contacted during the course of work; research and evaluate computer applications and database server hardware and software;

manage hardware / software configurations including set-up, maintenance, and back-up; ability to adapt to changes in technology.

Working Environment and Physical Demands : Hours : 8 : 00 AM to 4 : 45 PM Database administrators usually work regular office hours, but may be required to work evenings and weekends, and be on call.

Contact with people- Database administrators mostly work alone, but may have contact with : clients, computer users, other staff, and manufacturers of database management systems.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is required to sit at least 50% of the time.

The employee is regularly required to stand and walk about the office to complete various tasks. The employee must occasionally lift and / or move up to 25 pounds.

The person in this position frequently communicates with individuals who have inquiries, thus the person selected must be able to exchange accurate information in such situations.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The worker is regularly in a typical office environment and is not exposed to adverse environmental conditions.

The noise level in the work environment is usually moderate. WE ARE AN EQUAL OPPORTUNITY EMPLOYER Oklahoma Farm Bureau & Affiliated Companies does not discriminate on the basis of race, color, religion, national origin, sex, age or disability.

It is our intention that all qualified applicants are given equal opportunity and that selection decisions be based on job-related factors. Powered by JazzHR