Software Engineer II A - GBS IND

Job Description

Job Description: About Us At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible growth is how we run our company and how we deliver for our clients, teammates, communities, and shareholders every day. One of the keys to driving responsible growth is being a great place to work for our teammates around the world. We?re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being. Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization. Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us! Global Business Services Global Business Services delivers Technology and Operations capabilities to Lines of Business and Staff Support Functions of Bank of America through a centrally managed, globally integrated delivery model and globally resilient operations. Global Business Services is recognized for flawless execution, sound risk management, operational resiliency, operational excellence, and innovation. In India, we are present in five locations and operate as BA Continuum India Private Limited (BACI), a non-banking subsidiary of Bank of America Corporation and the operating company for India operations of Global Business Services. Process Overview* Banking & Lending Product Technology team is responsible for all Consumer and Small business banking and lending products catering to Retail and Preferred customers clients. The products include Credit Cards for Retail as well as Small Business customers, Deposits, Consumer Lending and Client Underwriting (including Vehicle Loans and Home Loans). This team performs application development, testing (functional and automation), design/architecture and business analysis functions to deliver the technology solutions through robust and scalable application platforms developed on various technologies such as Kafka, Datastage, SpringBoot, WebMethods, Java/J2EE, Angular JS, Mainframe, SQL Server, DB2, Oracle and Singlestore. Shared Integration & Data services team provides Shared real time and batch integration services and shared frameworks and data services for credit card, deposit and Lending applications. Job Description* . Responsible for the development, support, maintenance, and implementation of a project module either as an individual contributor or through a team. Works as a guide and sets directions for medium-sized projects and may lead special initiatives. Ensures minimal downtime for systems and related services. The role involves identifying new methods and processes to approach complex situations in database applications. Requires expert knowledge of PL/SQL, Oracle Database, and the Credit Card domain. Expected to continue building domain knowledge and technical/proprietary skills to reach levels of expertise while adhering to standard principles. Responsible for the design and development of database solutions for ongoing initiatives as part of a Scrum Team. Works closely with the Scrum Master and Product Owner to understand use cases and stories, implement database code, test it, and support its deployment to Production. Actively participates in all Scrum routines and discussions. Recommends and participates in the analysis, evaluation, and development of enterprise long-term strategic and operating plans to ensure that the Enterprise Architecture objectives align with the enterprise?s long-term business goals. Designs and develops database solution architecture and design for enterprise-wide systems and supports implementation and deployment by working closely with the delivery teams. Responsibilities* Key responsibilities include: Design, implement, and maintain PL/SQL procedures, functions, packages, and triggers for efficient database operations. Optimize database performance, including tuning SQL queries, analyzing execution plans, and improving database structures. Develop and maintain database solutions for enterprise applications, ensuring scalability, reliability, and high availability. Collaborate with application developers to design and implement data models and database schemas. Write clean, efficient, and maintainable PL/SQL code following best practices. Ensure data consistency, integrity, and security across distributed systems. Debug and resolve performance bottlenecks in PL/SQL code and database queries. Implement ETL processes for data migration, transformation, and integration using PL/SQL and other tools. Work closely with architects and other developers to design scalable and fault-tolerant database solutions. Monitor database performance and troubleshoot issues related to queries, indexes, and storage. Implement logging, monitoring, and alerting for database systems to ensure proactive issue resolution. Collaborate with cross-functional teams, including DevOps, QA, and product teams, to deliver high-quality database solutions. Participate in code reviews, design discussions, and agile ceremonies to ensure adherence to best practices. Create and maintain technical documentation for database designs, PL/SQL code, and data pipelines. Requirements Education* Any Graduation / Post Graduation Experience Range* 6 to 8 years Foundational skills* PL/SQL, Oracle Database, DB2, SingleStore, and strong SQL query optimization skills. Desired skills* Oracle, PL/SQL, DB2, Singlestore/MemSQL etc Work Timings*: 11 AM to 8 PM Job Location*: Chennai