The AES Group, Inc. Atlanta , GA 30301
Posted 1 week ago
Location: Atlanta, GA / Chicago, IL (Hybrid) (W2)
Duration: 12+Months (Possible Extension)
Job description
The team will be subject to multiple critical regulations and also going through a Technology Transformation Journey to build and adopt General capabilities for Data Ingestion, Rules Authoring & Execution, and Analytics capabilities. This is a greenfield project that requires meticulous design to replace multiple legacy applications within Treasury Technology. These applications will also house some critical regulatory programs such as Basel IV, & FRTB.
Responsibilities:
Responsible for developing and delivering complex software requirements to accomplish business goals.
Ensures that software is developed to meet functional, non-functional, and compliance requirements.
Codes solutions, unit tests, and ensures the solution can be integrated successfully into the overall application/system with clear, robust and well-tested interfaces.
Familiar with development and testing practices of the bank.
Debug and identify the performance issues and provide solutions
Support and help the application development team to develop & deliver optimized queries and database objects
Work with Application development team, understand the requirement and provide better optimized solution
Performs spike/proof of concept as necessary to mitigate risk or implement new ideas.
Monitor the database performance and storage and work with DBA team if any DB issues
Support Month-end release process and Month End production run
Assists team with resolving technical complexities involved in realizing story work.
Documents and communicates required information for deployment, maintenance, support, and business functionality.
Participates, contributes and can coach team members in the delivery/release (CI-CD) events. e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes.
Required Skills:
10 years' experience in software development, focusing on data load & processing of Data
7+ years of database design and modeling, coding, and management
5 years of SQL and PL/SQL in Oracle 12+
Strong in Database Architecture, Concepts and storage
Strong database design knowledge and optimization experienced skills are a must
Experience in SQL and performance tuning and handles huge volume of data
Knowledge of Oracle Exadata concepts and features
Working knowledge of SDLC
Oracle concepts with hands on experience in Stored Procedures, Functions, Views, Indexing, Query performance tuning etc.
Problem solving skills and ability to think algorithmically
Strong analytical and organizational skills
The AES Group, Inc.