Software Engineer II A

bankofamerica

Chennai, India 6 Years Exp Posted 2h ago

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.