Senior Database Developer

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.