Sr Programmer

Description

Essential Duties and Responsibilities:

Essential duties and responsibilities are listed below. This employee will perform other duties as required.

45% - Programming:

• Creates computer code as necessary.
• Designs and writes code, codes graphical user interface, printed outputs, and interfaces with other systems.
• Uses SQL and object-oriented programming skills to design, develop, test, implement, and support code and systems that are used in production environments.
• Develops and maintains complex SQL code and ETL processes that include process logging, data validation and integrity checks.
• Detects syntax or logical errors during program testing or uses diagnostic software to detect errors.
• Replaces, deletes, or modifies code to correct errors.
• Analyzes, reviews, and alters program, to increase operating efficiency or adapt to new requirements.
• Assists users and programmers in solving problems by responding to inquiries from others regarding errors, problems, or general questions.
• Recreates steps taken by the user to locate the source of problems and rewrites programs to correct errors.
• Trains end user(s) or technical support staff on program use.
• Installs and tests programs and solutions at other remote sites.
• Collaborates with teammates on projects which require various experience and technical levels.
• Monitors and maintains performance of programs and solutions.
• Ensures uptime for mission critical systems.
• Configures and maintains database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Refines and automates complex processes using SQL Agent jobs, SQL Server Integration Services, etc.
• Independently analyzes, solves, and corrects issues in real time.
• Responds to, troubleshoots, and resolves/escalates issues in a timely and accurate manner.

35% - Leadership and Subject Matter Expertise (SME):

• Consults with users to identify current operating procedures and clarify program objectives.
• Formulates plans outlining steps required to develop program using structured analysis and design.
• Submits plans to user for approval.
• Analyzes and estimates feasibility, cost, time, and compatibility with hardware and other programs.
• Converts project specifications, using flowcharts and diagrams, into sequence of detailed instructions and logical steps for coding by applying knowledge of computer programming techniques and computer languages.
• Develops a complete testing program according to industry and corporate standards to test development for production.
• Assists other developers/programmers with complex query tuning and schema refinement; participates in code reviews.
• Provides leadership for all aspects of database management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.
• Attends to, plans out, and executes complex and long-term projects in an organized fashion.
• Participates in process design sessions.
• Participates in and manages database related projects, database security patching audits, and compliance reviews and testing.
• Participates on customer driven and department driven Continuous Improvement events.
• Pursues training and development opportunities and shares learning with the department.
• Participates in training end users and implementation for new processes.
• Provides support during the 'go-live' periods.
• Models the core values. Complies with the company handbook and established IT policies and procedures.
• Partners with the project manager to review and confirm work estimates for specific deliverables.
• Participates in project Go/No-Go criteria definition, as well as the Go/No-Go decision process itself.
• Participates in off hours calls to support operations when projects or issues dictate.
• Answers ticketing system requests in a timely and helpful manner.

15% - Documentation and SOP Writing:

• Effectively documents and communicates code changes/issues/risks to the appropriate stakeholders, partners, and vendors.
• Prepares flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved.
• Coaches and communicates information to United Facilities' other IT support teams and peers across the enterprise on technology changes, new features, key projects, and customer experience improvements.
• Produces technical and end-user documentation to describe program development, logic, coding, and corrections.
• Reviews other's written documentation that describes program function and design, installation, and operating procedures.
• Accurately tracks and records worked time on projects.
• Proactively communicates with business stakeholders, end-users, and technical teams to keep all parties informed of issues, changes, progress, milestones, and deliverables.

5% - Continuous Learning:

• Researches, benchmarks, and suggests improvements to database support processes, customer experience improvements, and compliance requirements.
• Keeps up to date with development trends and maintains current skill sets.