Database Analyst/Programmer

PlanIT Group LLC

• $90K — $120K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years in software development, database design, and administration
  • 5+ years with Oracle Applications R12 in key financial modules
  • Experience with Oracle Application 12.2.7 upgrade
  • 6+ years of SQL/PLSQL expertise with relational databases
  • Knowledge in enterprise-level analytics and reporting
  • Advanced skills in writing business requirements and data needs documentation
  • Experience in performance tuning for report execution times

Responsibilities

  • Lead development and maintenance of database systems
  • Provide database development support for the team
  • Review and offer technical solutions across project stages
  • Produce database analyses and documentation
  • Work independently on high-visibility and mission-critical programs
  • Oversee and manage direct reporting resources
  • Responsible for all staff efforts on specific jobs

Benefits

  • Business casual dress code
  • Standard work hours of Monday to Friday, 8-hour shifts
  • Potential travel opportunities to support business needs
  • Focus on high-visibility programs with significant impact
  • Opportunities for training and mentoring less experienced personnel
Full Job Description
Database Analyst/Programmer

Description:
Under general direction, leads and participates in the development and maintenance of database systems while also providing database development services to the development team. Required to review and provide technical solutions to projects which may be in different stages of the development life cycle. As part of consulting activities, produces database-related analyses and technical documentation to support recommended solutions. Performs all functional duties independently. Works on high-visibility programs, or mission critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.

Required Skills:
• A minimum of eight (8) years experience in software development, database design, database administration, and/or related field;
• 5+ years of advanced working skills with Oracle Applications (E-Business Suite) R12 in AR, GL, OM, INV, SLA, WSH and PO modules
• Oracle Application 12.2.7 Upgrade experience
• 6+ years of expert experience working with a relational database using SQL/PLSQL skills
• Significant knowledge and experience in all aspects of enterprise-level analytics, operations support, and reporting
• Advanced experience developing and writing requirements according to standard templates including data needs and business rules.
• Experience with performance tuning to ensure acceptable report execution times, including validation of report SQL

Preferred Skills:
• Able to adhere to client development standards and SOX compliance
• Ability to communicate to a wide variety of audiences, both business and technical
• Proven ability to develop and maintain system documentation
• Demonstrated ability to work independently with minimal direction
• Java experience a plus

Additional Required Skills/Experience:
• A minimum of eight (8) years experience in software development, database design, database administration, and/or related field;
• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
• Able to perform all functional duties independently on high-visibility programs, or mission critical aspects of a given program;
• Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job;
• Experience training/mentoring less experienced personnel;
• Extensive knowledge of and experience with designing, constructing, and maintaining large relational database systems;
• Extensive experience with Oracle or MS SQL Server DBMS, SQL Language, Unix/Linux including basic shell commands, data warehousing, report generation, job scheduling and monitoring tools, XML, HTML, open source development, and technical documenting skills (Windows Office/Visio/Cvs, etc.). ;
• Advanced Oracle or Microsoft SQL Server certification required;
• Extensive experience producing database-related documentation such as technical analyses and technical designs;

Additional Provisions:
• All candidates must be a US Citizen or have permanent residence status (Green Card).
• Candidate must have lived in the US for the past 5 years.
• Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)
• The enforced dress code is business casual, i.e. collared shirt with slacks for men, no skirts above the knee for women. Place and Period of Performance
• Hours of support:
o The standard work week for contract staff will be 5 days a week and 8 hours per day preferable Monday through Friday.
o Contract staff may be required to travel to support business efforts.

Similar Jobs

More Jobs at PlanIT Group LLC

More Information Technology Jobs

Find similar Database Analyst/Programmer jobs: