Senior Database Developer

JOB DESCRIPTION

The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following standard coding practices and industry best practices. This role develops and maintains solutions for new requests for existing applications. The Developer resolves any issues dealing with performance for all code released to production. This position also assists with impact analyses of any changes made to the database objects. This role develops design documentation and maintains database versions of code with GIT.

The position requires participation in the complete system development life cycle including post implementation support. The Developer provides technical expertise to management, business users, and works closely with other developers by writing optimized SQL queries for integration with different applications.

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.

ABOUT US

Here, we believe there's not one path to success, we believe in careers that grow with you. Whoever you are or wherever you come from in the world, there's a place for you at Sherwin-Williams. We provide you with the opportunity to explore your curiosity and drive us forward. Sherwin-Williams values the unique talents and abilities from all backgrounds and characteristics. All qualified individuals are encouraged to apply, including individuals with disabilities and Protected Veterans. We'll give you the space to share your strengths and we want you show us what you can do. You can innovate, grow and Client in a place where you can thrive and Let Your Colors Show!
At Sherwin-Williams, part of our mission is to help our employees and their families live healthier, save smarter and feel better. This starts with a wide range of world-class benefits designed for you. From retirement to health care, from total well-being to your daily commute—it matters to us. A general description of benefits offered can be found at http://www.myswbenefits.com/. Click on "Candidates” to view benefit offerings that you may be eligible for if you are hired as a Sherwin-Williams employee.
Compensation decisions are dependent on the facts and circumstances of each case and will impact where actual compensation may fall within the stated wage range. The wage range listed for this role takes into account the wide range of factors considered in making compensation decisions including skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled.
The wage range, other compensation, and benefits information listed is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, with or without notice, subject to applicable law.
Sherwin-Williams is proud to be an Equal Employment Opportunity/Affirmative Action employer committed to an inclusive and diverse workplace. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, marital status or any other consideration prohibited by law or by contract.
As a VEVRAA Federal Contractor, Sherwin-Williams requests state and local employment services delivery systems to provide priority referral of Protected Veterans.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.