Job Details

Senior Level Oracle PL/SQL Developer (713) (08/31/2015)

Lansing, MI

This position is for a Sr. Oracle PL/SQL Database Developer responsible for successful delivery of CNSI’s Midwest region’s technology initiatives. Candidates for this role will be supporting the development and operations requirements working cohesively with other database developers/leads/subject matter experts, database administrators, architects, data quality analysts, and other teams, as well as manage client relationships within the context of an individual role.


Job Duties/Responsibilities: 

  • Work under direction from the manager or lead
  • Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL / PL/SQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing
  • Solid facilitation skills to gather the necessary information to document and/or develop a plan - strategic/tactical
  • Participate in meetings and discussions with Functional/Technical Leads to understand the requirements and work out a design.
  • Participate in code reviews and ensure the code written complies with the company standards and policies
  • Interact with all levels of an organization in a professional, diplomatic, and tactful manner
  • Continue enhancing own PL/SQL skills on new practices, frameworks and standards
  • Mentor other PL/SQL developers in enhancing their skills
  • Ability to interpret the requirements and build Logical and Physical Relational Data Models
  • Prepare the PL/SQL Requirements and Design documents
  • Write/maintain SQL and PL/SQL stored program units/packages and maintain coding standards. Experience in Query optimization, debugging, and performance tuning for improving performance.
  • Write unit tests (document and code) for the PL/SQL stored program units/packages
  • Support Production Operations as necessary
  • Conduct meetings and discussions with customer and able to demonstrate appropriate and effective use of technology to meet customer needs
  • Functional understanding of concepts relating to the design and development of software applications

Required Skill

Primary Skills

• BS in Computer Science or related discipline
• Minimum 8+ years’ experience as an Oracle Sr. Developer or Development Lead
• Must have at least 3 years of client interaction skills in support of formal requirements gathering sessions, as well as informal requirements session.
• Oracle 10g, 11g experience is a must
• Strong PL/SQL programming skills
• Excellent SQL tuning experience
• Proven record of accomplishment working in all aspects of the software development life cycle
• Experience with UNIX and shell scripting
• Should have good communication and writing skills
• Candidates must be willing to work independently and/or as part of a team in an energetic, team-oriented environment managing systems of varying size/complexity with a fast turn-around time
• Apply innovation, creativity, and improvement to the development/support processes
• Ability to manage multiple priorities effectively is a necessity
• Experience in creating Use Cases, Process & Activity Diagram using UML tools
• Experience contributing to and managing the planning and execution activities for the following SDLC phases:
o Systems analysis and requirements definition
o Functional systems design
o Integration and functional verification
o Validation, installation and deployment
o Maintenance and operation support

Secondary Skills

  • Understanding of Extract/Transform/Load (ETL) processes to support Data Conversion / Migration / Consolidation
  • TOAD experience
  • Experience in a healthcare/insurance domain is preferred
  • Experience with State government projects is preferred
Apply Now

Personal Information

Upload resumé

Additional Information