With Query Example Oracle Jobs in Usa

AGE is seeking a Software Developer with strong C# and database expertise to join our development team. This role focuses on building and maintaining robust middle-tier services and data-driven applications. The candidate will work closely with cross-functional teams to design, develop, maintain and optimize scalable backend systems that power critical business functionality.

The ideal candidate combines solid middle-tier development experience with deep database development knowledge and a strong understanding of system design, performance, maintainability, and data integrity.

This role is hybrid in Philadelphia, PA, requiring onsite reporting at the customer's facility at least 1 day/week. Candidates must reside within a commutable distance of Philadelphia, PA in order to work onsite as required.

Responsibilities Include:

• 
  
• Design, develop, and maintain middle-tier services and backend components using C# and .NET technologies.
  
• Apply SOLID principles and clean architecture practices in application design.
  
• Build robust APIs and business logic layers to support web and enterprise applications.
  
• Collaborate with front-end developers, architects, and DevOps teams to deliver integrated solutions.
  
• Design, develop, optimize, and maintain relational databases (Oracle preferred).
  
• Write efficient stored procedures, views, functions, and complex queries.
  
• Optimize database performance, indexing strategies, and query tuning.
  
• Participate in code reviews and enforce best practices for clean, maintainable code.
  
• Troubleshoot and resolve production issues related to application logic and data layers.
  
• Contribute to architectural decisions and technical design discussions.
  
• Document technical designs and implementation details.
  

Required Skills, Qualifications and Experience:

• 
  
• BA/BS in technical discipline.
  
• 10 years of experience in middle-tier and database development.
  
• Experience in applying SOLID principles and object-oriented design patterns.
  
• Strong proficiency in C# and .NET (.NET Core/.NET 6+) and ASP.NET Web API.
  
• Experience designing and building RESTful APIs and middle-tier services.
  
• Experience with ORM frameworks (Entity Framework preferred, Dapper).
  
• Strong SQL skills and experience with relational databases (Oracle preferred, SQL Server, PostgreSQL).
  
• Experience writing and optimizing complex queries and stored procedures.
  
• Strong understanding of data modeling and database design principles.
  
• Experience with version control systems (TFVC and Git).
  
• Strong problem-solving skills and attention to detail.
  
• Must be a United States citizen with a DoD Secret clearance or ability to obtain a favorably adjudicated T3 investigation.
  

Preferred Qualifications:

• 
  
• Experience with microservices architecture
  
• Experience with CI/CD pipelines and DevOps best practices
  
• Experience with cloud platforms (Azure preferred)
  
• Experience with caching strategies (Redis, in-memory caching)
  
• Experience with performance profiling and monitoring tools
  
• Experience with containerization (Docker, Kubernetes)
  
• Experience with automated testing frameworks
  

Work Environment and Physical Demand:

• 
  
• Must be able to work for extended periods of time at a computer.
  

Compensation: $115,000+

At AGE Solutions, we reward performance, invest in growth, and share success. Our benefits support the whole person, professionally, financially, and personally.

• 
  
• 26 Days Paid Leave: Includes vacation, sick, personal time, and holidays. You choose how to use it.
  
• Performance Bonuses: Performance bonuses are awarded based on individual contributions and company-wide results, aligning recognition with impact.
  
• 401(k) with Match: We match 3% of your contributions with immediate vesting.
  
• Financial Protection: Company-paid life insurance up to $300K and options for additional coverage for you and your dependents.
  
• Health Benefits: Multiple medical plans, dental, vision, FSA and HSA options to fit your needs.
  
• Parental Leave: 15 days of fully paid leave for new parents, because family matters.
  
• Military Differential Pay: We bridge the gap for employees on active duty, so they don't take a financial hit while serving.
  
• Professional Growth: Paid training and certifications, tuition reimbursement, and the tools and tech to get the job done right.
  
• Shared Success: In the event of a company sale, our CEO has committed to returning 80% of net proceeds to employees. This ensures our team shares in the long term value they help create.
  

At AGE, you'll do work that matters, supported by a company that delivers for its people.

Summary

We are seeking a highly skilled Data Engineer to build and manage our data infrastructure. The ideal candidate will be an expert in writing complex SQL queries, designing efficient database schemas, and developing ETL/ELT pipelines. You will ensure data is accurate, accessible, and optimized for performance to support business intelligence, analytics, and reporting needs.

Key Responsibilities

• Database Design & Management: Design, develop, and maintain relational databases (e.g. SQL Server, ProgressSQL, Oracle) and cloud-based data warehouses.
• Strategic SQL and Data Engineering: Develop sophisticated, optimized SQL queries, stored procedures, and functions to process and analyze large, complex datasets for actionable business insights.
• Data Pipeline Automation & Orchestration:Help build, automate, and orchestrate ETL/ELT workflows utilizing SQL, Python, and cloud-native tools to integrate and transform data from diverse, distributed sources.
• Performance Optimization: Tune queries and optimize database schema (indexing, partitioning, normalization) to improve data retrieval and processing speeds.
• Data Integrity & Security: Ensure data quality, consistency, and integrity across systems. Implement data masking, encryption, and role-based access control (RBAC).
• Documentation: Maintain technical documentation for database schemas, data dictionaries, and ETL workflows.

Required Skills and Qualifications

• Education: Bachelor’s degree in computer science, Information Systems, or a related field.
• SQL Mastery: 5+ years of experience with advanced SQL (window functions, CTEs, query optimization).
• Database Expertise: Deep understanding of relational database management systems (RDBMS) and data modeling techniques.
• Cloud Platforms: Demonstrated experience with Azure Data Services and other data warehouse technologies.
• Programming: Proficiency in Python for scripting and data manipulation.
• ETL Tools: Familiarity with tools like SSIS or Azure Data Factory.
• Soft Skills: Strong analytical thinking, problem-solving, and communication skills.

Nice to Have

• Experience with NoSQL databases (Cosmos DB, MongoDB).
• Experience with big data frameworks (Apache Spark, Kafka).
• Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, Google Professional Data Engineer).

Typical Work Environment

• Tools Used: SQL IDEs (DBeaver, SSMS), Cloud Consoles, Git, Jira, SSIS.
• Industry: Leasing.

Salary is $130-$140k

Location: Chicago, Akron, Arlington, Atlanta, Austin, Baltimore, Birmingham, Boca Raton, Boston, Buffalo, Charleston, Charlotte, Chattanooga, Chicago, Cincinnati, Cleveland, Columbia, Columbus, Dallas,Denver, Des Moines, Detroit, Edison, Fort Worth, Grand Rapids, Greenville, Hartford, Hoboken, Honolulu, Houston, Indianapolis, Irvine, Jacksonville, Kansas City, LA, Las Vegas, Louisville, McLean, Memphis, Miami, Milwaukee, Minneapolis, Nashville, New Orland, New York, Oklahoma, Orlando, Palo Alto, Philadelphia, Phoenix, Pittsburgh, Pleasanton, Portland, Providence, Raleigh, Richmond, Rochester, Rogers, Sacramento, Salt Lake City, San Antonio, San Diego, San Francisco, San Jose, Seattle, Secaucus, Stamford, St. Louis, Syracuse, Tallahassee, Tampa, Toledo, Tucson, Tulsa, Washington DC, Westlake village, Winston-Salem

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.

Whole industries have been disrupted and transformed in recent years by changing technologies, advanced analytics and the need for better insight. EY is helping businesses realize the value they can gain from their IT investments. We deliver exceptional client service — providing advice on how technology, finance process efficiency and enterprise intelligence contribute to performance improvement, as well as how IT can act as a multiplying effect during major program transformations.

The AI Finance Senior Manager is a crucial role responsible for supporting the Finance Applications Data Lead in executing the overall data management strategy for finance applications. The successful candidate will leverage their deep expertise finance applications (planning, reporting, close/consolidation) coupled with deep skills in enterprise data management, data governance, data quality, master data management, Machine Learning, and Generative AI (Gen AI) to support key finance personas. One of the key responsibilities will focus on developing and implementing our “FDL consulting blueprint” service offering, with the goal of creating an industry agnostic data model which can be utilized as a starting point and be extended ensure data consistency and interoperability across finance applications. The successful candidate will work closely with the Data Lead and the Product Owner for the FDL to ensure that the FDL Blueprint is designed on a foundation of accurate, consistent, and reliable finance application data architecture, enabling informed decision-making.

The AI Finance Senior Manager will work closely with finance, IT, and data science teams to support the effective management and utilization of finance application data, harnessing the power of Machine Learning, Gen AI, and Azure data technologies to drive innovation and business value through the development and implementation of the EY AI Finance solution offering.

As a Senior Manager, you will play a pivotal role in leading engagement delivery and managing client relationships. Your time will be spent across various responsibilities, including:

• 
  

• Leading the design and delivery of system architecture solutions in collaboration with technical teams.

  
  

• Tailoring technology platforms to business processes, ensuring clients maximize their investment through effective use and continuous improvement.

  
  

• Managing complex processes, solutions, and projects while maintaining a focus on quality and risk management.

  
  

• 
  

• Proven ability to manage and deliver complex solutions.

  
  

• Fostering relationships with client personnel at appropriate levels. Consistently running and delivering quality client services. Driving high-quality work products within expected time frames and on budget.

  
  

• Monitoring progress, managing risk and confirming that key stakeholders are kept informed about progress and expected outcomes.

  
  

• Managing expectations of client service delivery.

  
  

• Effectively managing and motivating client engagement teams with diverse skills and backgrounds. Providing constructive on- the- job feedback/coaching to team members.

  
  

• Fostering an innovative and inclusive team-oriented work environment. Playing an active role in the counselling and mentoring of junior consultants within the organization.

  
  

• Supporting Data Management Strategy Execution, including helping execute the overall data management strategy for finance applications

  
  

• Defining data requirements, data architecture, and data models for finance applications, considering the potential of Machine Learning and Gen AI technologies

  
  

• Leading the design and implementation of an extensible common information model for the FDL Blueprint

  
  

• Developing and maintaining documentation, including data dictionaries, entity-relationship diagrams, and data lineage maps

  
  

• Leading the development and implementation of our FDL Blueprint solution offering, ensuring scalability, performance, and security

  
  

• Collaborating with data scientists and finance SMR’s across service lines to identify opportunities for applying Machine Learning and Gen AI techniques to finance applications/personas and extend the FDL

  
  

• Supporting the establishment and maintenance of a robust data governance framework for the FDL

  
  

• Staying current with the latest advancements in Machine Learning, Gen AI, Data Management and Azure technologies and identifying and implementing innovative solutions that drive efficiency, accuracy, and insights for finance applications

  
  

• Ability to travel as required for client engagements and project needs.

  
  

• 
  

• Bachelor\'s degree in Finance, Accounting, Business, Computer Science

  
  

• Minimum of seven years of progressive experience in Financial Planning & Analysis (FP&A), with demonstrated expertise in:

  
  

• Strategic financial planning, budgeting, and forecasting processes

  
  

• Financial modeling and scenario analysis

  
  

• Variance analysis and management reporting

  
  

• Cross-functional collaboration with business stakeholders

  
  

• Strong proficiency with EPM (Enterprise Performance Management) platforms, including hands-on experience with solutions such as:

  
  

• Anaplan (Certified Model Builder preferred)

  
  

• Oracle EPM Cloud Suite (PBCS, ePBCS, FCCS)

  
  

• Oracle Hyperion

  
  

• OneStream, Tagetik, or similar platforms

  
  

• Solid understanding of financial data architecture and governance, including:

  
  

• Financial data modeling and dimensional design

  
  

• Chart of accounts structuring and hierarchy management

  
  

• Data quality standards and reconciliation processes

  
  

• Master data management for finance applications

  
  

• Knowledge of finance applications including financial modeling (PnL, Balance Sheet, Cash Flow)

  
  

• Excellent communication, collaboration, and problem-solving skills

  
  

• Ability to work effectively in a fast-paced, dynamic environment, supporting the adoption and implementation of emerging technologies

  
  

• Strong business skills including relationship management, commercial awareness, and communication.

  
  

• Strong analytical and problem solving skills as well as excellent oral and written communication skills

  
  

• A willingness to travel to meet client needs.

  
  

• 
  

• Degree emphasis in Finance, Accounting, Economics, Business, Computer Science, MIS, or IT preferred

  
  

• A strong ability to adapt to changing technology landscapes and stay ahead of industry trends.

  
  

• Exceptional interpersonal skills to foster team collaboration and client trust.

  
  

• A proactive approach to problem-solving and decision-making.

  
  

• Experience in leading diverse teams in dynamic environments.

  
  

We seek top performers with a blend of technical expertise and strategic business acumen. Candidates should be adaptive, proactive, and committed to driving innovative technology solutions that propel the business forward. Strong managerial skills and a continual desire to improve both technical and soft skills are essential to meet the evolving demands of the industry.

At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more .

• 
  

• We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $171,600 to $392,100. The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $205,900 to $445,700. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.

  
  

• Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year.

  
  

• Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

  
  

Are you ready to shape your future with confidence? Apply today.

EY accepts applications for this position on an on-going basis.

For those living in California, please click here for additional information.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at

Position - Manhattan WMOS WMS Consultant

Location - Miami, FL (Day-1 Onsite)

Duration - Long Term

Description:

• Hands on configuration of Manhattan WMOS WMS systems.
• Experience supporting or implementing Manhattan WMOS WMS systems preferred.
• Strong proficiency in Oracle SQL for application development. Ability to write complex SQL queries
• Experience analyzing complex system issues, contributing to estimates and making recommendations.
• Knowledge of enterprise hardware platforms such as UNIX and/or Linux servers and Oracle relational databases is a plus.
• Participate in all phases of implementation and production support of applications and components in multi-technology, business-critical systems.
• Gather requirements and design the most accurate and efficient solution possible.
• Analyzing and reengineering repetitive failed processes to drive out risk
• Work closely with development team to ensure that all have an accurate understanding of the solution to limit rework to the minimum.
• Maintain understanding of interface specifications and configuration options.
• Document requirements and solutions according to the business SDLC process.
• Stay up to date on current and future warehouse execution technologies, capabilities, and trends.
• Excellent Communication skills
• Skills in creating presentations and scorecards
• Follow change control methodology in day-to-day activities.
• Provides shift and on-call coverage as needed to support operations under time constraints and pressure.

Thanks & Regards

Darshan Neema

Client Account Manager, KTEK Resourcing

O 832-260-0695 E

W 2277 Plaza Dr. Suite 240, Sugar Land, TX 77479

Sr. Financial Systems Analyst

Chicago, IL (Hybrid)

The American Medical Association (AMA) is the nation's largest professional Association of physicians and a non-profit organization. We are a unifying voice and powerful ally for America's physicians, the patients they care for, and the promise of a healthier nation. To be part of the AMA is to be part of our Mission to promote the art and science of medicine and the betterment of public health.

At AMA, our mission to improve the health of the nation starts with our people. We foster an inclusive, people-first culture where every employee is empowered to perform at their best. Together, we advance meaningful change in health care and the communities we serve.

We encourage and support professional development for our employees, and we are dedicated to social responsibility. We invite you to learn more about us and we look forward to getting to know you.

We have an opportunity at our corporate offices in Chicago for a Sr. Financial Systems Analyst on our Finance team. This is a hybrid position reporting into our Chicago, IL office, requiring 3 days a week in the office.

As a Sr. Financial Systems Analyst, you will provide administrative
and functional maintenance and support for AMA's financial applications,
including Infor/Lawson, Oracle EPM (Hyperion), Blackline, Ironclad, Concur, and
other Finance-led systems. Focus on business process management, system
utilization, and ensuring data integrity across Finance. Liaise
with internal customers, functional areas and IT resources as well as external
vendors including hosting and SaaS providers.

RESPONSIBILITIES:

Financial Systems Management

• Provide functional support for month-end closing activities, monitor interfaces, troubleshoot user issues, meta-data maintenance, and financial systems operation.
• Perform requirement gathering, analysis, documentation, and coordination of system enhancements or configuration changes based on Finance business needs.
• Conduct testing and user acceptance for system changes.
• Identify system issues by understanding Finance business processes and develop solutions to resolve the issues.
• Collaborate with internal customers, functional areas, and IT resources to evaluate opportunities for system optimization.
• Participate in troubleshooting sessions for system issues, proposing business-side solutions and providing subject matter expertise.
• Maintain the security, confidentiality, and integrity of data on all AMA financial systems.

Documentation, Process, and Project Management

• Document and analyze business processes, system configuration, and user procedures.
• Support transition planning, system upgrades, and releases in conjunction with IT and vendors, providing business-side expertise and functional testing.
• Provide input on changes requests and assist in evaluating system impacts.
• Prepare training materials and support end users.
• Work on cross-departmental initiatives to streamline processes/workflows to improve efficiency of monthly financial closes.

Technical Collaboration

• Perform limited hands-on scripting, including simple SQL queries,
• Collaborate with IT teams for complex technical tasks, integrations, and technical troubleshooting.
• Work with system vendors and IT to support system upgrades, enhancements, and drive issue resolution.
• Document data flows between Finance systems and assist in defining requirements for integrations.

May include other responsibilities as assigned

REQUIREMENTS:

1. Bachelor's Degree in Finance, Accounting, Information Systems,
   or a related field required.
2. 5+ years of experience working on finance business processes and
   a suite of financial applications including Infor/Lawson or similar ERP systems
   required.
3. In depth expertise with multiple financial system cycles including
   accounts receivable, accounts payable, general ledger and bank settlement
   processes.
4. Demonstrated ability to gather and document business
   requirements, assist with solution configuration / design, and coordinate user
   acceptance testing.
5. Strong collaboration skills with IT and vendors.
6. Working knowledge of both relational and multi-dimensional data
   modeling concepts and processes using Microsoft SQL.
7. Strong analytical and problem-solving skills, with the ability
   to understand complex financial definitions and information and grasp
   technology concepts.
8. Demonstrated experience supporting, configuring, and
   administering financial systems, ideally Oracle Lawson, Hyperion, Concur, or
   similar ERP platforms, including coordinating enhancements with IT and vendors.
9. Excellent written and oral communication skills to translate
   business needs into clear requirements for IT partners.

The American Medical Association is located at 330 N. Wabash Avenue, Chicago, IL 60611 and is convenient to all public transportation in Chicago.

This role is an exempt position, and the salary range for this position is $87,394-$115,797. This is the lowest to highest salary we believe we would pay for this role at the time of this posting. An employee's pay within the salary range will be determined by a variety of factors including but not limited to business consideration and geographical location, as well as candidate qualifications, such as skills, education, and experience. Employees are also eligible to participate in an incentive plan. To learn more about the American Medical Association's benefits offerings, please click here.

We are an equal opportunity employer, committed to diversity in our workforce. All qualified applicants will receive consideration for employment. As an EOE/AA employer, the American Medical Association will not discriminate in its employment practices due to an applicant's race, color, religion, sex, age, national origin, sexual orientation, gender identity and veteran or disability status.

THE AMA IS COMMITTED TO IMPROVING THE HEALTH OF THE NATION

Job summary:

We are seeking highly skilled full stack developers with strong expertise in backend development using Java Spring Boot, frontend development using Angular and Drupal. The ideal candidate will have deep database design and optimization skills, experience building scalable web applications and ability to work across the full software development cycle.

Key responsibilities:

Database & Data Management:

• Strong Oracle Database skills.
• Design and maintain relational database schemas (Oracle, MySQL)
• Write complex SQL queries, Stored procedures, triggers, and performance tuned indexes.
• Handle data migration . normalization and optimization for high volume systems.
• Experience with NOSQL database is a plus.

Frontend Development:

• Develop responsive, user-friendly web interfaces using Angular(latest version), HTML, CSS, TypeScript, React etc.
• Work on UI/UX designs and prototypes and translate the designs into functional UI components.
• Optimize frontend performance and ensure cross-browser compatibility.

Web Platform Development:

• Develop, customize, and maintain Drupal-based websites and applications.
• Build and manage custom Drupal modules, themes, content types, and views.
• Integrate Drupal with backend services and third-party systems via APIs.

Backend Development:

• Design, develop and maintain REST APIs and microservices using Java, Spring Boot, Spring MVC and Spring Security.
• Implement business logic, integrations, backend services with high performance and reliability.
• Ensure application security , scalability, and performance best practices.

Other Preferred Skills:

• Participate in CI/CD pipelines, build automation and deployment processes.
• Write unit, integration, and end to end tests.
• Troubleshoot and resolve issues
• Conduct code reviews and ensure adherence to coding standards.
• Additionally, experience with version control (Git/Bitbucket) and DevOps practices (CI/CD, Docker) is crucial.
• Familiarity with Docker and Kubernetes.
• Knowledge of cloud platforms (AWS, Azure)
• Experience working in Agile/Scrum teams.
• Healthcare industry experience.
• Soft skills like communication, teamwork, accountability, ownership, self-driven, analytical thinking and problem-solving are also essential.
• Ability to work independently and collaboratively in cross-functional teams.
• Excellent communication and documentation skills.
• Proactive mindset with attention to detail.