Database Developer - Oklahoma Job Oklahoma City area,Oklahoma USA,IT/Tech

Position: Database Developer - Oklahoma City

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.

Organizationa…