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.