Database/application developer job description

** This is a hybrid position located in the Collinsville, Illinois area with some local travel required **

Delivers ongoing data loading and reconciliation, customer support, technical troubleshooting, and maintenance of developed database software. Designs, develops, and maintains a multitude of complex relational database reports.

Run performance testing procedures to ensure the proper operations of a database and to ensure that it's error-free.

Analyze the needs of an organization and produce an effective database system according to their needs and specifications. This includes collecting data, analyzing the data, designing algorithms, drawing flowcharts and implementing code for the logic developed through the algorithms and flowcharts.
Develop database documentation. Designs, develops and enhances data models using SQL. Test designs to ensure the system runs smoothly. Provides requirements analysis and data modeling. Designs system workflow, architecture to meet business requirements. Develops all database objects and deploys new database applications. Independently maps out, plans and performs ongoing administration of database and datamart software including data loading and reconciliation, analysis of data anomalies with business customers. Provides new feature enhancements, education and training, monitoring and optimization, technical support, and database maintenance. Architects, designs, develops, and maintains a multitude of complex relational database reports supporting executive dashboards, ongoing operations analysis, management decisions, process and quality improvement, and business partner negotiations. Performs quality assurance role for complex and sensitive database application features developed by others including preparing and executing test plans, logging defects, and retesting corrected defects to validate feature integrity, accuracy, and completeness prior to customer deployment. Capacity plan and properly identify required hardware, software, database configuration/architecture necessary to support application needs Responsible for system performance of the data tier and the reliability of data feeds across the enterprise system Read, analyze, and digest what the client wants to accomplish with its data, and design the best possible ETL process around those goals. Use interactive reporting features by providing links to sub-reports and drill-through reports Automate report distribution through standard and data-driven subscriptions Maintain existing data warehouse for reporting and data analytics Develop data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching. Assist correction of performance bottlenecks and debugging application or data content related issues. Participate in the development and support of reporting solutions including program modifications, performance tuning, problem solving, debugging, and unit testing. Identifies and effectively communicates technology needs and/or investments needed to support team goals and success. Develops customer trust and builds team reputation as highly skilled experts in strategic decision support. Performs all other duties as assigned. Minimum Qualifications:

Education Bachelor's degree in Information Systems, Computer Science, Business Administration, Healthcare Administration, Finance, a related discipline Experience
One year experience operating with relational databases - Required One year experience with Microsoft SQL Server, SSIS, SSRS, SSAS One year experience with ETL and performance loading Healthcare background is preferred Certifications, Licenses, and Registrations
None

Responsible for performing SQL and PL SQL Development/PL/SQL/Python Coding. Perform database tuning including ASM, AWR, ADDM, ASH, and Flashback for troubleshooting. Analyze database performance and provide database administration and support. Perform enterprise release and production support. Deploy code and perform code reviews. Perform system analysis and design, database design and modeling. Perform SQL and PL/SQL development and tuning. Upgrade application code and databases. Perform Golden Gate set-up and provide replication support. Perform project management, database upgrades and migration. Set up virtual database Delphix and utilize Jenkins and Autopilot tools for deployment.
Knowledge of programing languages, including Python, Javascript, SQL, .NET, Perl and TSQL Strong written and verbal communication skills, critical thinking skills, and problem-solving skills. Ability to collaborate with high-performing teams and individuals throughout the firm to accomplish common goals
As a member of our Database Development team, you have the opportunity to learn - and make a difference - at one of the world's most innovative financial firms. In this role, you'll gain critical experience analyzing, designing, installing and configuring database management systems. You'll collaborate with some of the best technologists in the industry, and cultivate a powerful network of colleagues from around the world. You'll exercise your innovative idea to automated solutions with focus on customer self-service and your solutions will impact and improve operations for your colleagues and our clients. Your responsibilities will span monitoring, incident management, and risk control, performance tuning, patching, upgrades and migration. And we'll offer feedback, coaching and mentoring all the way, helping you improve your skills and setting you up for greater opportunities within our Global Technology team.

JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.

As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.

Equal Opportunity Employer/Disability/Veterans