Description


RESPONSIBILITIES

Essential Functions

Strategy & Planning

 

  • Work with the business units to identify business requirements for requested projects.
  • Identify the technical requirements of projects.
  • Analyze all aspects of the projects.
  • Provide feasibility and cost/benefit analyses responses for proposed projects.
  • Plan and organize tasks, report on progress, coordinate with additional development teams.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.



Development & Deployment

 

  • Perform complex programming assignments requiring an advanced aptitude of established programming standards, methods, and best practices.
  • Design application and database components for development projects.
  • Perform analysis of business models, logical specifications, and/or customer requirements to design and build Internet solutions utilizing multiple technologies.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) and working familiarity with various databases.
  • Mitigate significant risks associated with projects, which have a high technical complexity and/or involve significant challenges to the business.
  • Guide full stack developer in design approaches and teach them to create performant queries



Operational Management

 

  • Maintain and modify Sher-link applications, make approved changes by amending application documentation, developing detailed programming logic, and coding changes.
  • Provide support for these critical application problems and issues.
  • Analyze existing SQL queries for performance improvements and implement the improvements.
  • Act as a Subject Matter Expert in the discovery and investigation of critical production problems as required.
  • Proactively search for and make improvements on non-performant database programs.
  • Willingness and ability to coordinate the efforts of other developers.



Incidental Functions

 

  • Conduct research into modern technologies, including tools, components, and frameworks.
  • Train and knowledge share with development teams.
  • Mentor and coach developers and/or Professional Apprentices.
  • Project and task management and reporting, as necessary.
  • Make presentations to management, clients, and peer groups as requested.
  • Schedule and lead project and communication meetings.
  • Provide tier 2, on-call support for critical application problems and issues.
  • Analyze program performance and correct deficiencies based on user consultation. Work with manager to prioritize approved list of remediations.
  • Assist with projects required to contribute to efficiency and effectiveness of the work.
  • Attend management meetings on behalf of team.
  • Application server maintenance tasks such as: software/hardware upgrades, patching, security configuration, batch process maintenance and migration to new platforms.
  • Address internal audit concerns to address Sarbanes-Oxley compliance.
  • Work area is adequately lighted, heated, and ventilated.
  • Working outside the standard office 7.5 hours workday may be required; on-call availability.



QUALIFICATIONS

Formal Education & Certification

 

  • Bachelor's degree (or foreign equivalent) in a Computer Science, Computer Engineering, or Information Technology field of study (e.g., Information Technology, Electronics and Instrumentation Engineering, Computer Systems Management, Mathematics) or equivalent experience.



Knowledge & Experience

 

  • 5+ years of IT experience.
  • 5+ years of experience developing OLTP database applications in Oracle 10g/11g and UNIX/LINUX/Solaris environment within a multi-tier environment; building and formulating business requirements.
  • Work experience with PL/SQL Types, PL/SQL Collections, SQL Loader, PL/SQL Functions and Procedures, Packages, and Materialized view, Triggers, Complex SQLs, and SQL Reports.
  • Work experience with PL/SQL techniques in LOBs, Multilingual character conversion; Optimize the applications using Exadata Oracle Performance Tuning Techniques; develop Unit Testing Methods for PL/SQL; develop UNIX scripts for batch processing and work with Oracle RAC clusters and Exadata systems.
  • Experience with relational SQL and NoSQL databases. Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
  • Experience building and optimizing data pipelines, architectures, and data sets.



Personal Attributes

 

  • Strong and comprehensive verbal and written communications, including ability to present ideas and solutions to all levels.
  • Responsive and alert to new learning opportunities, growth, and development of technical, interpersonal, and business skills; able to recognize and address areas needing improvement.
  • Motivated and competent to contribute appropriate time and effort to work needing attention.
  • Attentive to detail with focus on accurate and timely results.
  • Organized and able to prioritize tasks, responding effectively to competing needs.
  • Works well with team members as a peer programmer.
  • Attentive and reactive to customer needs and concerns.
  • Advanced analytical and problem-solving abilities.
  • Strong customer service orientation.
  • Able to contribute to team effort and individual achievement.
  • Strong commitment to inclusion and diversity.

Key Skills
Education

Bachelor's degree (or foreign equivalent) in a Computer Science, Computer Engineering,