What are the responsibilities and job description for the Database Developer - Oklahoma City position at Oklahoma Farm Bureau Insurance Company?
| Job Title: Database Developer | Department: Information Systems | |||
Primary Purpose: Database Developers design, build, and optimize the data storage systems that applications depend on. They write complex queries and stored procedures, design schemas that support application requirements, tune performance, manage data migrations, and ensure data integrity. The role combines deep SQL knowledge with understanding of application behavior and business data requirements.
Technical Skills includes some of the following. Other duties may be assigned.
- Really good knowledge of datatypes, data type conversion, and different types of data sources (ODBC, Excel, text, XML).
- Mastery of SQL – SQL Server (SSRS, SSIS) and mySQL.
- Mastery of SQL Server stored procedures and best practices – i.e. temp tables, table variables, cursors, loops.
- Relational database and table design – data modelling, entity-relationship-design.
- Some DBA knowledge – SQL Server jobs (setting up, scheduling, job history, activate /deactive), user permissions, indexes, linked servers, SQL Server logs.
- Experience working with source system data using SQL with (SQL, Aurora, Redshift, Snowflake).
- Familiarity with reporting tools such as Pyramid or Power BI.
Essential Duties and Responsibilities include the following. Other duties may be assigned.
- Designing and coding the data warehousing system to desired company specifications as defined by end users.
- Conducting preliminary testing of the warehousing environment before data is extracted.
- Ensures Data Quality and Accuracy.
- Extracting company data and transferring it into the warehousing environment.
- Follows approved life-cycle methodologies, creates design documents, and performs program coding and testing.
- Develops and conducts program tests; develops test plans and data, performs and/or oversees testing to verify the program function correctly and ensure modifications haven’t caused error to other areas.
- Resolves technical issues through debugging, research and investigation.
- Conducts and coordinates investigative and analytical studies of complex system functions and operations to select approaches for the resolution of complex problems or improving the efficiency of existing systems.
- Develops complex program documentation using structure diagrams, behavior diagrams and interaction diagrams, system and program flowcharts, test plans and conversion plans.
- Reviews the development and coding of programs and systems. Ensures appropriate documentation is utilized in information systems projects.
- Performs post implementation reviews to determine if the system cost objectives of the project were achieved.
- Analyzes and recommends new procedures and techniques to improve the supported systems.
Competencies
To perform the job successfully, an individual should demonstrate the following competencies:
- Member Service - Manages difficult or emotional member situations and directs to appropriate members of department staff.
- Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control.
- Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions.
- Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Able to read and interpret written information.
- Teamwork - Gives and welcomes feedback; Contributes to building a positive team spirit.
- Business Acumen - Understands business implications of decisions.
- Diversity - Shows respect and sensitivity for cultural differences; Promotes a harassment-free environment.
- Ethics - Treats people with respect; Works with integrity and ethically; Upholds organizational values.
- Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values.
- Judgement - Displays willingness to make decisions; Exhibits sound and accurate judgment.
- Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently.
- Professionalism - Approaches others in a tactful manner; Treats others with respect and consideration regardless of their status or position.
- Quality - Demonstrates accuracy and thoroughness; Monitors own work to ensure quality.
- Adaptability - Adapts to changes in the work environment; Able to deal with frequent change, delays, or unexpected events.
- Attendance/Punctuality - Is consistently at work and on time; Ensures work responsibilities are covered when absent.
- Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Commits to long hours of work when necessary to reach goals.
- Initiative - Volunteers readily; Seeks increased responsibilities.
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 accommodation may be made to enable individuals with disabilities to perform the essential functions.
Education and/or Experience
- Knowledge, skill, and development equivalent to the completion of a four-year college degree with course work in computer science or directly related fields.
- Extensive knowledge of IT concepts and principals, theories and functions of computer systems, and the principles and techniques of IT documentation.
- Proven work experience as an ETL developer.
- Extensive knowledge of coding languages, including ODBC, Excel, text, XML.
- Proficiency in warehousing architecture techniques.
- Ability to troubleshoot and solve complex technical problems.
- Experience in P&C Insurance, developing insurance related activities in web applications, and working with a small development team desired.
- Language Skills
- Ability to read and interpret. Ability to write routine reports and correspondence.
- Reasoning Ability
- Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.
- Computer Skills
- To perform this job successfully, an individual should have knowledge of computers and computer systems including hardware and software, such as, MS Word and/or Word Perfect, MS Excel, and/or etc.
- Knowledge of email and maintaining calendar schedules on the computer.
- Other Skills and Abilities
- Ability to effectively participate in and profit from continuing education, both formal and in-service training setting
- Ability to analyze data logically and exercise sounds judgment in defining, evaluating, and solving difficult technical and operational problems where solutions may be of a precedent-establishing nature.
- Ability to gain and maintain effective working relationships with associates, vendors, clients.
- Other Qualifications
- Worker is expected to maintain regular attendance.
Physical Demands
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 regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is frequently required to stand and walk. The employee is occasionally required to stoop, kneel, crouch, or crawl.
Work Environment
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 subject to adverse environmental conditions. The noise level in the work environment is usually moderate.