Sr Database Developer Analyst

Job Title        Sr Database Developer Analyst

Job Summary  

The Database Developer Analyst supports the full systems life cycle management activities (e.g., analyses, technical requirements, design, coding, testing, implementation of systems and applications software, etc.) for multiple applications or projects. He/She will accomplish this via application development with Visual Basic for Applications (VBA), ActiveX Data Objects Database (ADODB) and Structured Query Language (SQL) against SQL server and Oracle Databases. The developer’s efforts provide daily access to secure, consistent, objective business data and the critical factors needed to manage exceptions and reconciling items that have financial implications.

The Database Developer Analyst designs and builds databases to support Accounting applications and provide daily, weekly, monthly and quarterly account information (i.e. volume, revenue, expense, reconciliation and operation reports).  He/She builds foundation designs for implementation based on specific business rules and requirements; as well as gathering of data from multiple sources. The Database Developer harvests and analyzes data from various sources to evaluate content, consistency, usability, and reliability and to collect data for research and financial analysis. He/She also provides knowledge, development, maintenance and support
of applications.  The developer will also investigate user application issues to provide resolutions and to ensure applications meet user expectations.

Other Duties  

• Writes database application code and creates support processes to produce final applications.
• Manages and performs SQL programming to generate usable and meaningful data and data flow.
• Manages and coordinates the automatic running of applications (Automation/Scheduling).
• Analyzes data for information and trends to establish dataset value, uncover data meanings, and identify trending for financial reconciliations and decision-making.
• Acts as a subject matter expert to ensure project team members understand data meaning
  and methods for extracting information.
• Documents automated processes and business rule changes to provide application histories, ensure details are retained for future planning, and maintain programming
  knowledge.
• Maintains data processes linked with multiple-source applications to ensure applications
  provide users with the most current and accurate data.
• Manages and holds others accountable to established performance levels to achieve
  individual and group goals.
• Manages data back-up and retention procedures in accordance with UPS guidelines.

Preferred Competencies  

• Demonstrates advanced knowledge of programming techniques and advanced knowledge of database design principles; defines requirements with minimal oversight from others;
  describes security measures, such as passwords and access rights based on
  requirements; describes information organization, such as classes, links, records, and fields.
• Demonstrates an understanding of the strategy, structures, processes and procedures of the enterprise in its relationship with the business and its activities.
• Demonstrates proficiency in the use of different system tools; recommends appropriate tools to meet development and support needs; utilizes various tools to diagnose and
  resolve problems; prepares business cases for the use of new tools; integrates
  systems with other technologies.
• Completes work timely and with thoroughness; maintains records and information in an
  organized manner; audits available information for inconsistencies; maintains
  documentation that support the completion of work and retention of details/decisions.
• Develops standards for naming and structuring standard data; maintains existing
  standards according to technical requirements, industry practices, corporate
  policy, and quality assurance recommendations; addresses and resolves issues
  impacting data standards.
• Makes minor adjustments to test plans; recognizes the importance of quality assurance
  to the business; identifies conditions that impede that quality assurance process.

Minimum Qualifiers 

• Bachelor’s degree-Preferred
• Bachelor’s degree-Computer Science, MIS, or related discipline-Preferred
• Experience in application development using Visual Basic for Applications (VBA),
  ActiveX Data Objects Database (ADODB) and Structured Query Language (SQL),  Systems analysis and systems architecture-Preferred
• Experience with application testing and debugging in Windows environment – Preferred
• Experience supervising others - Preferred

Basic Qualifications

• Must be a U.S. Citizen or National of the U.S., an alien lawfully admitted for permanent residence, or an alien authorized to work in the U.S. for this employer
• Must have experience in application development with Visual Basic for Applications
  (VBA), ActiveX Data Objects Database (ADODB) and Structured Query Language (SQL).
• Must have experience in database with skills in Stored Procs and Performance Tuning

InterpersonalSkills

• Candidate must have excellent oral and written communication skills. Must be self-motivated and have the ability to manage multiple tasks successfully andpossess good planning and organizational skills. Must be a team player with a positive attitude.