Role: Senior PLSQL Developer
Location: Atlanta, GA
Client is currently looking for a Senior level PL/SQL Developer to join our GA program team now!
**Position will work remotely, but candidates based in Atlanta, GA preferred.
Summary:
As a Senior PL/SQL Developer, you will play a key role in designing and developing the PL/SQL packages to meet health service client program requirements and business objectives. In this role, you will also shepherd and lead a team of PLSQL developers comprised of both onshore and offshore resources.
Job Responsibilities:
Design, develop, deploy and maintain SQL, PLSQL packages for large-scale projects using hybrid agile, iterative SDLC methodology
Write and execute unit test cases for the PL/SQL stored procedures/packages
Debug, optimize, and performance tune SQL, PLSQL packages for improving performance
Work with java developers to enhance the code base of PL/SQL packages to fix production issues and/or build new functionality
Support Software Quality Assurance team to develop complex test scenarios
Participate in code reviews and ensure the code written complies with Client’s standard and best practices and provide improvement feedback to developers
Use SVN version management to manage various versions of the procedures and functions of the application
Review Linux shell scripts and make necessary changes required for the process
Perform gap and impact analysis of system software for change requests
Assure quality, security, and compliance requirements are met for supported area
Required Experience/Skills Required:
Bachelor’s degree with 8 + years of work experience as related to job duties
Demonstrated experience in PL/SQL, Object-Oriented Analysis and Design, creating database tables, views, medium to complex stored procedures, triggers, and functions
Experience in SQL performance tuning using Cost-Based Optimization (CBO), Profiler, Explain-plan and has sufficient knowledge on AWR
Experience with Data flow diagrams, Data dictionaries, Database normalization theory techniques, Entity relation modeling, and design techniques. Expertise in Client-Server application development
Working knowledge in relational databases and concepts, preferably Oracle
Experience and knowledge of version control and defect management tools
Ability to handle multiple projects and collaborate with a variety of teams
Highly organized with analytical and reasoning skills to troubleshoot and solve problems
knowledge of logical and physical Data Modeling using normalizing Techniques preferred
Domain knowledge of Medicare/healthcare verticals and MMIS experience in Medicaid – Provider and Claims module is strongly preferred