Sql Developer (On-Site)

Summary

The SQL Developer role is to ensure that all SQL based database systems are functioning efficiently and effectively for proper support of the business requirements. The SQL Developer role includes: implementing and continuously improving processes for converting data from one system another; design data modeling/analysis services used to mine enterprise systems and applications for knowledge and information that enhance business processes. This individual is also responsible for building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. This position will monitor ETL and data conversion processes to ensure they run appropriately every day and may include other duties as defined by their manager.  This position will use a variety of development languages and environments to perform their daily duties.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Assist to define standards and guidelines to guide the use and acquisition of software and to protect vulnerable information
• Develop and test programs or databases, correcting errors and make necessary modifications to database, database systems, or programs helping to define standards and guidelines to guide the use and acquisition of software and to protect vulnerable information
• Train users and answer questions as related to the databases; work with users on optimizing and centralizing user databases (where appropriate)
• Develop data model describing data elements and how they are used.
• Develop methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs
• Review project requests describing database user needs to estimate time and cost required to accomplish project
• Create data definitions for new database file/table development and/or changes to existing ones.
• Review and revise as appropriate company definition of data as defined in data dictionary.
• Work with application development staff to coordinate the creation and management of data queries.
• Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data mining applications with existing systems.
• Provide and apply quality assurance best practices for data mining/analysis services across the organization.
• Develop, implement, and maintain change control and testing processes for modifications to data models.
• Determine required network components to ensure data access, as well as data consistency and integrity.
• Develop routines for end users to facilitate best practices use of data mining tools.
• Collaborate with database and disaster recovery administrators to ensure effective protection and integrity of data assets.
• Monitor data mining system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Respond to and resolve data mining performance issues.
• Diagnose, troubleshoot, repair, and document solutions and problems with existing ETL processes
• Work with and as the database administrator to design, develop, and update databases
• Perform other incidental and related duties as required or assigned.

Supervisory Responsibilities

This job has no supervisory responsibilities.

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

Analytical - Synthesizes complex or diverse information; collects and researches data.

Continuous Learning - Pursues training and development opportunities; strives to continuously build knowledge and skills; shares expertise with others.

Job Knowledge - Competent in required job skills and knowledge; exhibits ability to learn and apply new skills; keeps abreast of current developments.

Use of Technology - Demonstrates required skills; adapts to new technologies; troubleshoots technological problems; uses technology to increase productivity; keeps technical skills up to date.

Problem Solving - Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; works well in group problem solving situations.

Communications - Expresses ideas and thoughts verbally; expresses ideas and thoughts in written form.

Cooperation - Offers assistance and support to co-workers; works cooperatively in group situations.

Customer Service - Responds promptly to customer needs; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments.

Planning/Organizing - Prioritizes and plans work activities; uses time efficiently.

Quality - Demonstrates accuracy and thoroughness.

Quantity - Meets productivity standards; completes work in timely manner.

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 and/or Experience

Bachelor's degree from four-year college or university and three to five years related experience; or equivalent combination of education and experience.

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.  Ability to write reports, business correspondence, and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Mathematical Skills

Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry.  Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Reasoning Ability

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Computer Skills

To perform this job successfully, an individual should have strong knowledge and experience with MS SQL and/or PostgreSQL, hands on experience with MS Access and Excel, and knowledge of ODBC, JCDB, JSON, XML, linked servers, and data replication is required. Experience with Interbase, FireBird, and Unidata database is helpful.

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 occasionally required to stand and walk. The employee must regularly lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. 

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.

While performing the duties of this Job, the employee is occasionally exposed to moving mechanical parts. The noise level in the work environment is usually moderate.

Employment at Replacement Parts, Inc. is subject to post offer, pre-employment drug testing.  Equal Opportunity Employer.   Replacement Parts, Inc. is a drug-free workplace.