Role:Database Programmer Analyst

Location: Willingboro, NJ

MANAGER's Comments :

• That we are looking for candidates that have P21 experience this is a critical skillset we need.
  

Job Summary

• Support existing SQL Server databases and develop solutions in support of growth.
• This includes the development of database objects and structures for data storage, retrieval, and reporting, with a heavy emphasis on stored procedure writing.
• Understand the business model, data sources, database, structure and business requirements to provide effective technical support for all SQL applications and databases.
  

Essential Duties And Responsibilities

• Develop, test, debug, and document database solutions/designs
  
• Demonstrate an ability to effectively resolve database issues
  
• Demonstrate an ability to implement, install, manage, and troubleshoot Microsoft SQL Server systems running in a network environment
  
• Demonstrate an understanding of basic SQL statements i.e. DDL and DML
  
• Evaluate and define user requirements for new business intelligence implementation and develop queries, tables, packages and stored procedures to support delivery of requirements
  
• Debug and optimize existing queries, views and tables to improve performance
  
• Develop programs and leverage statistical methods and software to identify the trends, anomalies and degradation of data
  
• Manage allocation of system storage and develop plans for future storage requirements to support database growth
  
• Manage/Monitor nightly backups and recovery of database systems
  
• Demonstrate an understanding of operational functions (i.e. sales order processing, purchasing, inventory management, shipping, and accounting) and the related software interaction.
  
• Engage in continuous self improvement and team improvement activities, including but not limited to independent study of technical topics, peer to peer training, and attainment of external certifications related to the tools and technologies utilized by the team.
  
• Other tasks may also be required from time to time, at the discretion of management, in order to achieve department and company objectives.
  
• METRICS
  
• Complete monthly commitments and project deadlines as agreed and described in monthly meetings or through other project planning efforts.
• Effectively accomplish and adhere to development standards, policies, and quality.
• Database Programmer Analyst will be measured on the quality of their code and on how effectively they accomplish their tasks when compared to the set objectives.
  

CERTIFICATES, LICENSES, REGISTRATIONS

• Microsoft Certified Solutions Associate (MCSA) certification is a plus
  

PHYSICAL DEMANDS

• Continuous sitting and typing for extended periods.
  
• Lifting requirements include occasional lifting of up to 25 pounds
  
• Frequent walking or standing may be required at times