Job Title: SQL Developer
Job Summary:
Perform product improvement and new feature development as well as trouble shooting and optimization for databases supporting web based applications. The person in this role will interact with application developers on a daily basis to help them with their develop activities as they interact with the database. This person will also work closely with the database administrator as needed for operational issues and performance tuning. A strong candidate will have a background in application development.
Scope of the Role:
• Participate in the design and implementation of new features focusing on the database
• Write and optimize complex stored procedures for both OLAP and OLTP
• Write and optimize complex SQL statements
• Perform databased design for both OLAP and OLTP
• Work with application developers to support their use of the database as outlined by the above items
• DB2 is the RDBMS used in this role however experience with other databases still qualifies
Education and Experience Requirements:
• Bachelor’s degree in computer science or applicable technical area of study or experience
• 3-5 years of experience in developing relational databases
• Experience on high volume data and transaction oriented applications (OLTP and OLAP)
• Strong SQL skills including query analysis and optimization
• Strong experience writing, debugging and optimizing complex stored procedures in the context of application development
• Strong experience with index analysis
• Work experience with any of the following RDBMS (DB2, Oracle or MS SQL Server)
• Experience with transactions and concurrency
• Operating Systems: Windows & Linux
Attributes Desired:
• Excellent verbal and written communication skills
• Excellent problem solving skills
• Ability to work as a team member and independently
Preferred Experience:
• Experience with a language such as Java
• Experience in the healthcare domain and or Accounts Receivables (A/R) processing