The Sr. PL/SQL Developer is responsible for the requirement analysis, design, development, architecture, implementation and support of enterprise-wide databases.
This individual works closely with application developers and project managers in creating functional and scalable applications from design and development through implementation for business clients. The Sr. PL/SQL Developer is responsible for ensuring database integrity as well as usability.
This position requires expert knowledge in database (Oracle) design, tuning, modeling methods in multiple computing environments (Unix, Linux, AIX) and must be well versed in Oracle ML/PL/SQL programming. This position, must also ensure that documentation is created for system designs and modifications, and assist collaboratively in following the established software development life cycle procedures to develop, test and modify system software, utilities; support integrations with other applications by coding, reviewing, preparing test data, testing and debugging, in order to ensure that the developed software is robust and meets user functional and performance requirements. It is preferable to have experience and understanding of Managed Health-care Information systems, subsystems and applications, but is not required.
Must acquire and enhance technological expertise by becoming current with evolving systems programming, analysis and database technology. Must develop, foster and maintain an open, professional relationship with other team members within IT and also with other departments to enhance customer satisfaction.
Standard Duties & Responsibilities:
Evaluate and seek solutions to production issues as well as new projects. Work closely with application developers in solving production issues, for unsuccessful resolution of production issues; maintain successful relationships with application developers.
Prepare short and long term plans to address infrastructure projects as well as support to and technical leadership for internally/externally sponsored company projects. Successful resolution of production issues; maintain successful relationships with application developers.
Recommend schedules for database upgrades; assist in the planning and implementation of major software upgrades; adhere to change management procedures and methodologies.
Ensure all database projects and processes are fully documented. Ensure complete technical documentation exists for all database projects and processes.
Perform in a distributed environment, the modifications and operations for Oracle database (10g DB, 10g AS, 10g CS & 10g DS), and Server (2000) environments. A functional database and/or central repository that allows business client community to access data/information with ease
Perform other duties as assigned.
Required Degree: Bachelors Degree Major: Degree in IT/ business area. Preferred: MS Computer Science
Years of direct/relevant experience required: 7 to 10 years of experience
At least 6+ years of experience in a technical function creating and maintaining software applications. Excellent knowledge on Unix, Linux, AIX systems. Extensive knowledge on PL/SQL, SQL, SQL*Plus, and Unix Shell Script. Experience with specific hands-on practices in the following areas: Proven ability in managing Oracle databases of 500+ GB in sizes; Must be well versed in data modeling and OLAP technology; Significant experience with SQLLoader, TOAD, and Korn Shell programming; Must have the ability to code complex ML/ PL/SQL packages, functions, and procedures; Solid communication skills (oral, written, and presentation) and strong interpersonal skills required; Ability to accurately set and adhere to deadlines; Must have a very high ability to learn new things, especially about new technology developments; Ability to prioritize projects and workload; High level of independent judgment; Must be flexible, organized, and able to handle multiple tasks simultaneously; Strong project management skills; Healthcare HMO experience a plus.
Oracle database (10g DB, 10g AS, 10g CS & 10g DS) Server (2000) PL/SQL, SQL, SQL*Plus Unix, Linux, AIX
Molveno Consulting Pvt Ltd