Database Developer

POSITION SUMMARY:  The primary responsibility for this position is to provide support, maintenance and development of the company’s existing data warehouse. Secondary responsibilities include designing, developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively according to our company’s needs. This position is also responsible for enterprise application support and providing technical support to Information Technology staff and business departments.

As part of the IT team, this position collaborates with internal IT staff and other Vigor departments and business units to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, this position ensures our database systems run effectively and securely on a daily basis.

Due to the nature of our business and this work, US Citizenship is required.

ESSENTIAL FUNCTIONS AND MAJOR RESPONSIBILITIES: (This list is not intended to detail all aspects of the assigned work but is representative of the job’s overall responsibilities)

1. Lives the Vigor Values of Truth, Responsibility, Evolution and Love every day.
2. Provide functions including troubleshooting, developing, upgrading and systems management in production, test, and development environments of the data warehouse (Microsoft SQL server) and other enterprise application systems.
3. Secondary support for IFS ERP (Oracle database) and Kronos HR/Payroll and timekeeping system (Microsoft SQL server database).
4. Monitor database usage, analyze business and information systems activities, and develop solutions relative to current technology and methodology.
5. Write and troubleshoot complex stored procedures & interfaces.
6. Manage database accounts and permissions to ensure the security and data integrity of the data.
7. Periodically audit users and their security roles.
8. Install modifications and additions to systems and work with other team members to fully test changes before deployment to production environment.
9. Ability to work both independently as well as collaborate with internal and external team members.
10. Provide direction and oversight to external partners assisting with enterprise application projects.
11. Ensure Corporate and Information Technology policies are adhered to and security consistently enforced through proper role, permissions and access management.
12. Responds to change productively and contributes to team effort by accomplishing related results as needed.

JOB SCOPE: The position operates within established parameters with decision-making authority over approach to database and application security and development architecture.

SUPERVISORY RESPONSIBILITY:   None INTERPERSONAL CONTACTS: Interactions are both internal and external. The incumbent must be comfortable working in highly collaborative environment within the IT team and with other departments, at all levels of the company, and with outside partners. The incumbent communicates regularly through both verbal and written form in understandable terms. The incumbent may coach more junior team members. Interactions are with people who have a wide span of technical abilities.

KNOWLEDGE SKILLS AND ABILITIES:

•  Must possess high degree of technical competence in building and administering Microsoft SQL server databases and in working with ERP systems and other enterprise applications.
•  Proficient in queries, indexes and DB I/O performance tuning.
•  Advanced troubleshooting and query writing skills.
•  Ability to write status reports, technical specs, procedures and correspondence.
•  Solid understanding of the software development lifecycle.
•  Limited knowledge of Oracle and PL/SQL.
•  High degree of technical skill and system aptitude, analytical ability, operational work flow and abstract reasoning.
•  Must possess excellent interpersonal and communication skills, both oral and written for regular interaction with IT team members, internal customer, and external partners.
•  Able to offer solutions to competing interests in a friendly, professional manner.
•  Must have the analytical ability to research problem areas and special requests and identify appropriate, timely and cost-effective solutions.
•  Must be a well-organized, detail and customer (internal and external) oriented self-starter.  
•  Ability to exercise sound judgment, work well independently, prioritize work and follow through tasks to completion.
•  Ability to coordinate work with other departments in an efficient manner.
•  Ability to follow defined processes and to suggest improvements.
•  Ability to keep up with the changing technology field and to work under conflicting requirements of users versus system requirements, limitations and capabilities.

EDUCATION AND/OR EXPERIENCE: BA/BS degree in Computer Information Systems or Computer Science preferred.

Minimum six (6) years increasingly responsible experience with experience in building and supporting Microsoft SQL Server databases and demonstrating above listed skills and abilities.

Experience working in Windows server-based environment is required.

Experience working with IFS ERP and Kronos Workforce Central/Workforce Timekeeper preferred but not required.

PHYSICAL DEMANDS:   Work is conducted in a dynamic, fast-paced office setting. The individual may be required to be in production areas in yard and onboard ships. He/she must be able to walk to and from job sites. He/she may be required to work more than 8-hour shifts and weekend work.

There may be limited local travel and occasional out-of-town travel (including air travel) up to 10% of the time with notice. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

WORK ENVIRONMENT:   While in production areas, will be exposed to all weather conditions, noise, dusts and odors. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Vigor and its wholly owned subsidiaries provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Vigor complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.