Create database tables, views, medium to complex stored procedures, triggers and functions utilizing PL/SQL.
Fine tune the SQL queries and improve the application performance.
Contribute to problem-solving and/or designs and implement new software applications or programs; coordinate and plan all the tasks required for implementation, operations, and maintenance.
Analyze and study system requirements and develop methods for problem-solving by producing complex flow charts/data flow diagrams and/or associated documents.
Advise on computer requirements and limitations to help define automation needs.
Develop detailed coding-level flowcharts, action diagrams, pseudo codes, and associated documents from high-level flowcharts.
Write procedural guidance to be followed by users.
Participate in the testing of computer programs, revise and refine all necessary documentation as testing is completed.
Monitor system errors, diagnoses, and corrects errors.
Develop pseudo codes, tables, and narrative descriptions to implement changes.
Experience/Preferred Skills Required:
3+ years of relevant work experience in PL/SQL, Object Oriented Analysis and Design, creating database tables, views, medium to complex stored procedures, triggers, and functions.
Expertise in fine tuning the SQL queries and improving application performance.
Working knowledge in relational databases and concepts, preferably Oracle.
Experience and knowledge of version control and defect management tools.
Highly organized with analytical and reasoning skills to troubleshoot and solve problems.
Can handle multiple projects and collaborate with a variety of teams.
Knowledge of SharePoint applications, MS Teams and Jira preferred.
Bachelor's degree
About Us:
At CNSI, we strive to be the market leader and most trusted partner for innovative and transformative technology-enabled solutions that improve health outcomes and reduce costs. We're passionate about helping our clients improve the health and well-being of individuals and families. We succeed when our clients succeed.
Innovation and commitment to our mission are core to our DNA. And through our shared values, we foster an environment of inclusion, empowerment, accountability, and fun! You will be offered a competitive compensation and benefits package.
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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
