CNSI is empowering the delivery of public sector healthcare in claims and encounter processing platforms, provider support solutions, and promoting consumer engagement and interoperability. Our technology-enabled products and solutions connect consumers, payers, and providers to improve health outcomes for one in five Americans.

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.

**Position will work remotely, but candidates based in Atlanta, GA, or Washington DC Area (VA, MD or DC) preferred.

.

To learn more about us, check us out at www.cns-inc.com

Press Release: https://bit.ly/3vEZSvg

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 CNSI’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:

• 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 withData flow diagrams, Data dictionaries, Database normalization theory techniques, Entity relation modeling, anddesign techniques. Expertise in Client-Server application development
• Working knowledge in relational databases and concepts, preferably Oracle
• Good knowledge of logical and physical Data Modeling using normalizing Techniques
• 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
• Domain knowledge of Medicare/healthcare verticals and MMIS experience in Medicaid – Provider and Claims module is strongly preferred

CNSI is an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, marital status, genetic status, family responsibilities, protected veteran status, or any other status protected by applicable federal, state, or local law. We are proud of our diversity and encourage all qualified applicants to apply.

#LI-ZS1