The (Sr./Lead) Application Developer designs and develops Oracle database solutions in PL/SQL, ensuring high quality and timely delivery of critical applications. Responsibilities include troubleshooting, documentation, and collaboration with project teams.
Flexible Work Arrangement: HybridThe (Sr./Lead) Application Developer is responsible for understanding the requirements of the business units and supporting project and support teams by implementing technical systems based on those requirements. This role focuses on designing, developing, enhancing, and supporting business-critical application systems with a strong emphasis on Oracle database development and PL/SQL. The developer works with project teams, support teams, database administrators, testers, architects, and business subject matter experts to ensure technical solutions meet business needs and are developed and implemented with high quality.The ideal candidate will have extensive hands-on experience developing complex PL/SQL solutions, deep familiarity with Oracle databases, and proven experience working with very large tables and views. Experience with Oracle Exadata is a plus. The scope of responsibility includes project support, maintenance, production support, troubleshooting, technical documentation, code reviews, and mentoring other developers.Essential Functions:Customer satisfaction
Characteristics and Qualifications:
Required:
Bachelor's degree in Computer Science, Management Information Systems or equivalent work experience
- Understand the development needs of the business units and establish a positive, service-oriented relationship by ensuring timely and accurate delivery of application systems
- Learn the business – develop a solid understanding of the business functions and processes and implement solutions based on that understanding
- Establish and maintain high client satisfaction levels
- Document, track and resolve problems in client business systems
- Have primary responsibility for technical deliverables associated with application code development, including work estimates, detailed and technical design documentation, application code and associated documentation including documentation to fulfill audit requirements
- Determine (Sr.) and document technical requirements for application systems, including system, module and unit design, unit test plans and test cases
- Design, develop, debug, test, enhance, and support applications using Oracle PL/SQL and related Oracle database technologies
- Develop and optimize PL/SQL packages, procedures, functions, triggers, SQL queries, views, database links, and other database objects
- Work with very large Oracle tables and views, including query optimization, performance tuning, indexing considerations, and data access patterns
- Support all phases of the software development lifecycle, including Requirements Gathering, Analysis, Design, Testing, Implementation, and Production support for PJM software systems.
- Work with the database analyst/administrator to develop a data model appropriate to the application development solution
- Develop, debug and test computer applications based on user requirements documentation, and on input from subject matter experts.
- Debug, remediate and enhance existing computer applications based on documented variances and enhancement requests, and with guidance from subject matter experts.
- Develop and maintain design documents to be used to develop applications.
- Follow the approved methodology for application systems development and maintenance.
- Respond, as necessary, to support calls in off-hours in order to support 24X7 applications.
- Assist testing staff in developing product and integration testing approaches.
- Assist business clients and work teams in integrating systems from external vendors
- (Sr.) Mentor other staff members to ensure consistency in development approaches and in understanding of development processes
- Identify and recommend application system solutions to business problems and enhancements to existing systems
- Identify enhancements to application development standards and best practices.
- Build and develop strong relationships with ITS's business clients by providing superior customer support as demonstrated by clearly owning, resolving and communicating issues and problems, and being responsive to needs, requirements, and deadlines
- Collaborate with cross-functional Scrum or project teams, including developers, business analysts, testers, architects, database administrators, and business clients
- Support application integrations with internal systems, external vendors, and enterprise integration platforms
- Support the operation of a continuous integration environment, including development of automated test cases, build and release management support, and defect correction support as applicable
Characteristics and Qualifications:
Required:
Bachelor's degree in Computer Science, Management Information Systems or equivalent work experience
At least 5 years of experience Extensive experience developing applications and database solutions using Oracle PL/SQL.
Ability to visualize and solve complex problems
Ability to apply analytical and mathematical solutions
Experience in developing applications using Oracle PL/SQL
Experience with DBMS concepts (including SQL queries, tables, views, DB links, etc.)
Preferred:Experience with Oracle Exadata.Experience with Oracle performance tuning in large-scale database environments.Experience supporting applications that rely on high-volume data processing, complex views, large joins, and performance-sensitive database operations.Experience working in Agile/Scrum teams
MS, Computer Science
Experience with PJM operations, markets, and planning functions
- Deep familiarity with Oracle databases, including SQL queries, tables, views, indexes, stored procedures, packages, functions, triggers, database links, and related database objects.
- Experience working with very large Oracle tables and views in enterprise or high-volume environments.
- Experience troubleshooting, tuning, and optimizing complex SQL and PL/SQL code.
- Experience developing, debugging, testing, enhancing, and supporting business-critical applications.
Ability to visualize and solve complex problems
Ability to apply analytical and mathematical solutions
Experience in developing applications using Oracle PL/SQL
Experience with DBMS concepts (including SQL queries, tables, views, DB links, etc.)
Preferred:Experience with Oracle Exadata.Experience with Oracle performance tuning in large-scale database environments.Experience supporting applications that rely on high-volume data processing, complex views, large joins, and performance-sensitive database operations.Experience working in Agile/Scrum teams
MS, Computer Science
Experience with PJM operations, markets, and planning functions
Similar Jobs
Energy
The role involves developing web applications, integrating systems, and collaborating within a team to meet business needs, focusing on high-quality deliverables.
Top Skills:
.NetJavaMs SqlOraclePostgres
Fintech • Mobile • Software • Financial Services
As a Member Service Representative, you will provide customer service for SoFi's financial products via phone, chat, and email, resolving member inquiries and ensuring satisfaction while meeting performance metrics.
Top Skills:
Google Suite
Information Technology
The Operations Analyst manages service delivery, provides tier-1 support, analyzes operations for service improvement, and collaborates with stakeholders. They ensure compliance with SLAs and communicate effectively with customers and team members.
Top Skills:
AutomateIbm Power IMS OfficeNimsoft Unified ManagementSciencelogicServicenow
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
