Senior pl-sql developer job description

Sr. Software Engineer - Database

Trellis Energy, a subsidiary of Blackstone Technology Group, is hiring a permanent Sr. Software Engineer - Database. In this role you will work directly with data architects, business analysts, project managers and other developers to build a suite of out-of-the box and comprehensive business modules. Your in-depth experience with problem solving capabilities, solution design and PL SQL development will be crucial to developing complex business solutions. Your efforts will support both in-house product development as well as customer implementation projects. Great growth opportunity to help build an enterprise level software serving the energy market. As a member of a tight knit and high-performing team, you will be integral to our product, client, and team successes.

Location: San Francisco or Houston preferred; remote optional.

Trellis Energy Background:
Trellis Energy (trellisenergy.com) is an innovative San Francisco-based technology company offering the first SaaS B2B marketplace, to transform the commercial operations across the natural gas value chain.

Responsibilities:

Learn the Trellis software and gain understanding across all subject areas
Collaborate with industry experts, SME's, product stakeholders to understand business process and requirements.
Formulate high-performing technical design/solution to solve for complex business problems.
Be a hands on developer - convert technical design/solutions into code using PL/SQL.
Develop, enhance, customize, support, and maintain code as per design and coding standards.
Create data to support, and maintain unit test cases, scenarios, and data.
Present innovative ideas for product improvements based on business understanding.

Required:

7+ years experience in Oracle PL/SQL development
Relational database experience a must: Oracle v12 minimum; Oracle v19 preferred.
Strong coding experience in Oracle PL/SQL.
Ability to come up with technical design based on business requirements
Working experience in data mapping and data loader activity
Ability to perform SQL tuning of queries, optimize reports and data retrieval response times
Strong in debugging and looking at existing code for modifications
Design, develop, and maintain tools and scripts to help unit testing, development and QA
Undergraduate degree in Computer Science, MIS, Business, or other related Engineering fields
Strong analytical skills and ability to work in a fast paced environment
Ability to think creatively and work independently on complex tasks
Must have strong work ethics, career goals, and accomplishments
Open source reporting experience required; JasperReports preferred.

Preferred:

Knowledge with Unix shell scripting
Recent development experience. Experience with Java development
Database Schema Design and Data Modeling skills
Oracle DBA skills and System Admin skills
Knowledge and experience in Natural Gas industry
Recent development experience with a software product company.

Blackstone offers a comprehensive compensation and benefits package; the company pays 100% of Employee's health insurance premiums.

#Work4BTG

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. We'll give you the space to share your strengths and we want you to show us what you can do. You can innovate, grow and discover in a place where you can thrive and Let Your Colors Show! 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.

The Senior PL/SQL Developer (Time & Attendance Solutions) is responsible for implementing Time and Attendance solutions into client environments. This position will utilize the defined implementation process from requirements gathering and documentation through customization development, testing, and migration into multiple environments. The incumbent works in a complex technical environment requiring a multi-product solution (Time & Attendance, Human Resources, and Payroll, for example), as well as product integration and/or custom solutions. Responsible for the reliability of all scheduled jobs between the aforementioned multi-product solution. Time & Attendance system performance and functionality will also be a top priority ensuring 24x7 application software/hardware availability in support of mission-critical business requirements, i.e., running payroll.
Essential Functions



Strategy & Planning


Work with management to generate quarterly work plans. Participate in recommendations of improvements to existing technical processes. Research tools and technologies and identify those that can best help serve the needs of clients. Research and implement related tools to improve the development process. Provide recommendations to address and resolve business issues for a specific business group. Recommend system changes and enhancements for continuous improvement.


Development & Deployment


Accept service requests received from the user community and assigned by management. Gather requirements from the user community, fellow developers, and system documentation. Review design with users, development staff, support staff, and management for adherence to all requirements and completeness in solving the user problems at hand, as well as supportability, maintainability, user understandability, and utility. Plan and test application and database changes, installation of upgrades, patches, and new versions, and interact with Development, Business Process Owners, and Infrastructure teams. Work with cross-project and T&A Global Support Teams to resolve functional
performance/operational issues. Provide advanced T&A Application functional and technical support. Create test plans, test cases, and test scripts, and performs functional testing. Work with existing systems to track and manage requests and issues. Use Oracle PL/SQL coding for maintaining inter-product interfaces. Troubleshoot failures in scheduled jobs using BMC and Oracle Concurrent Manager. Analyze, design, develop, test, and deploy: System configuration, Labor Level Sets, Rounding and Punch interpretation rules, Schedule shifts, and patterns, Pay code distribution tables, Work rules and Pay rules, Combination, and Hidden Pay Codes WIM (Workforce Integration Manager) Interfaces experience Customized Hyperfinds, Reports, detail, and roll-up Genies Accrual Rules and Policies Advanced Scheduler, Forecasting, and Analytics modules. Create and maintain system and user documentation. Submit and conduct peer reviews of designs and implemented solutions. Submit proper requests and documentation for the software release. Provide user support for new software implementations.


Operational Management


Complete Continuous Improvement projects as needed. Accurately report hours spent on a project in a timely fashion. Participate in design reviews and testing as needed. Assist users with problems and resolve issues independently. Assist with occasional daytime support as needed, assisting users and resolving issues. Update system and user documentation whenever required. Work with existing systems to track and manage requests and issues. Provide business reports to management and clients. Assist fellow developers in problem resolution, support, and development. Stay appraised of relevant software and technology trends, making recommendations to the team.


Safeguard Continuous System Availability


Respond immediately to reports of system error, outage, or instability Support efforts to update and upgrade systems as necessary to maintain integrity.


Incidental Functions


Assist with projects as may be required to contribute to the efficiency and effectiveness of the work. Attend management meetings on behalf of the team. Keep track of time spent on projects in an accurate and timely fashion. Assist with the effort estimation for new projects. Participate in after-hours on-call support Up to 10% travel as required (domestic and international) Work outside the standard office 7.5 hour work day may be required.


Position Requirements



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 Oracle PL/SQL experience. Significant experience solving complex problems using PL/SQL. Working knowledge of software development and support methodologies. Demonstrated skill in requirements gathering, project management, analysis, and preparation and maintenance of work documents. Understanding of essential business functions to translate business requirements into system configurations. Intermediate/Advanced knowledge and use of Microsoft Office products. Demonstrated ability to research complex issues, develop plans for correcting data, and ability to communicate mitigation plans to all involved parties. Experience with DBMS concepts creating and modifying live and materialized views.


Preferred Experience


5+ years of advanced Kronos experience or equivalent application with the configuration of pay policies, schedules/schedule groups, system configuration, and accruals. Advanced Scheduler and Forecaster for Retail environment. 5+ years of Workforce Integration Manager (WIM) Interface configuration for updating Kronos and extracting data. 5+ years of experience primarily with Kronos Workforce Central Applications/Modules V6 or higher, some experience with Version 7 or 8, and experience with widgets and navigators. Otherwise, 5+ years of demonstrated experience in a Time and Attendance system.


Personal Attributes


Strong written and oral communication skills. Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly. Strong systems/process orientation with demonstrated analytical thinking, organization skills, and problem-solving skills. Ability to work in a team-oriented, collaborative environment. Ability to quickly pick up new tools and technologies. Willingness and ability to train and teach others. Ability to facilitate meetings and follow up with resulting action items. Ability to prioritize and execute tasks in a high-pressure environment. Strong presentation and interpersonal skills. Ability to work effectively in a multi-cultural environment, and to lead and influence cross-organizationally with and without direct authority. Ability to effectively move forward on tasks even with ambiguous or changing requirements. Strong commitment to inclusion and diversity.

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.

ECS is seeking a Sr. Oracle PL/SQL/Java/Python Back End -Developer for our USPS customer.
This is a remote opportunity/can be supported from our Memphis, TN (Zip Code 38120) office as well.

This position will perform and have the following duties, roles, and/or responsibilities:

Design, develop and implement web-based applications.
Design, develop and implement highly complex applications utilizing Oracle and Java technologies.
Demonstrate strong troubleshooting skills to solve complex problems across a large enterprise.
Demonstrate a flexible attitude, ability to perform under pressure and ability to handle change easily while meeting deadlines.
Communicate with technical and non-technical audiences verbally and in writing to design efficient and effective applications.
Work independently and in a team environment, to give and receive direction.
Specific responsibilities include:
Develop and revise Java source code based on clearly defined requirements.
Participate in code reviews for team members as well as yourself.
Assist in the setup of production environments including application servers and database structure.
Assist in the implementation of applications through various testing phases and into production environments.
Must be able to communicate effectively, work in a team environment and think analytically.
Perform maintenance on programs currently in production.
Assist QA teams with writing test scripts and explaining functionality.
Unit Testing candidate releases.

Required Skills:

Must be US citizen or Green Card Holder and must be able to obtain a Public Trust clearance
B.S. degree or 4 years of college in Computer Science or related field
At least 10 years' experience in IT and or Software development
5+ years of experience with web technologies (HTML, CSS, JavaScript frameworks)
5+ years of experience with Java server technologies (JEE, Spring Framework, Spring Boot)
5+ years of experience with SQL and PL/SQL on Oracle or similar platform
4+ years of Experience developing Perl/Unix/Python shell scripting
4+ years of experience in Performance Tuning
4+ years of experience with ETL/Data Warehousing.

Desired Skills:

Experience with Angular, Bootstrap
Experience with the NodeJS and Java toolchains (NPM, Angular CLI, Maven)
Experience creating REST web services (JAX-RS or Spring MVC)
Experience creating single-page web applications
Experience with testing tools (JUnit, Mockito, Mocha, Selenium)
Experience with source control tools (Git, SVN)
Experience with CI/CD tools (Jenkins, Ansible)
Familiarity with Scrum or other agile methodologies
Act as advisor to applications engineering team regarding projects, tasks, and operations.
Extensive experience and judgment to plan and accomplish goals.
Ability to performs a variety of complex tasks

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis of race, color, religion, gender, age, national origin, citizenship, disability, veteran status or any other classification protected by federal, state, or local law. ECS promotes affirmative action for minorities, women, disabled persons, and veterans.

ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3500+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.