Database Developer in Alpharetta, GA at APEX Systems

Date Posted: 5/12/2018

Job Snapshot

  • Employee Type:
    Contractor
  • Job Type:
    Other
  • Experience:
    Not Specified
  • Date Posted:
    5/12/2018

Job Description

Job #:  835957

Job Title: Database Developer  Location: Alpharetta, GA  Contract: 12+ months Description:
  • Works on problems of moderate and varied complexity where analysis of data may require adaptation of standardized practices or precedent.
  • Acts independently to identify and select appropriate methodologies.
  • Work customarily and regularly (50% of time or more) requires the exercise of discretion and independent judgment.
  • Normally receives general instructions on non-routine work assignments.
  • Requires additional instructions and frequent guidance on new assignments.
  • Decisions are made independently.
  • Assigned multiple tasks or projects are generally reviewed after completion.
  • Contact is typically coordinates in nature and involves exchanging detailed technical information.
  • May deal with both internal and external contacts. Demonstrates working knowledge in job-related functional area and of the business.
 
  • Minimum 7 to 8 years full SDLC development experience with Informatica Power Center 9.1.
  • 6-7 years Oracle PL/SQL, SQL, Stored Procedures, Packages, SQL Navigator or similar
  • 3-4 years Unix Shell scripting Working knowledge of the Data Transformation 8.6 or higher and how it integrates with Power Center.
  • Full understanding of each Power Center component:
  • Designer, Workflow Manager, Workflow Monitor.
  • Ability to create and maintain Tasks, Worklets, Workflow, Sessions, Mappings, Mapplets, Transformations.
  • Full understanding of each data transformation type and ability to effectively implement into a mapping.
  • Ability to trouble-shoot and solve configuration issues.
  • Design and implement full solutions according to Business Requirements.
  • Identify existing software defects and develop solutions Create design documents of work done for the project team.
  • Can take ownership of assigned tasks and plan own time to ensure project milestones are met. very good understanding of database structures to support data integrity and performance, SQL, PL/SQL, query tuning
  • The team member in this role will work on database systems critical to a great customer experience in or self service channel (web portals and mobile application).

JOB DUTIES:
  • Analyze architecture, including relationship between database tables and relationships of business data stored
  • Analyze database design to understand impact on performance
  • Recommend target database solution based on business and/or technical requirements - such as RDBMS vs. No SQL database
  • Create high-performing database designs/code to retrieve large datasets and optimize system resources
  • Tune poor performing SQL to run at optimized levels; exercise intermediate to advance practices to identify poorly performing code and identify areas to improve it
  • Demonstrate capability to write DDL and SQL of low to medium complexity
  • Execute database statements from Java code, including SQL statements, prepared statements, and stored procedures
  • Analyze data, automate monitoring of very large datasets to identify data anomalies early to minimize impact to customer facing data, and write code to reconcile
  • Encrypt data to restrict visibility of sensitive information
  • Manage database updates across lower environments
Testing
  • Create and execute test plan to exercise functional and technical requirements.

Release Support
  • Verifying database schema and data patches applied correctly
  • Monitoring database activity and log activity during release testing
  • Investigate issues found during a release, assess customer and system impacts

MUST HAVE SKILLS:
  • Development experience with
    • Oracle 10g
    • PostgreSql
    • Database development IDE (Toad, Oracle SQL Developer, or other)
    • SQL, DDL, Explain plan analysis
  • Experience with all phases of the Software Development Life cycle, including system analysis, design, coding, testing, debugging and documentation
  • Excellent written and verbal communication skills
  • Team player, collaborative
  • Delivers excellent quality of code and documentation
  • Critical thinker, good problem solver
  • Can deliver assigned work independently
  • Must have Informatica and PowerCenter (can be spelled as two words) 
  • Must be able to create triggers, stored procedures, and performance tuning 
  • SQL experience 
  • Needs to be able to explain a time where they had to improve database performance 
DESIRED SKILLS:
  • Cassandra design, development experience
  • Elastic design, development experience
  • Java
  • OOM framework

EDUCATION REQUIREMENTS

  • BS in computer science, information systems, or other technical field is a plus but not required

REQUIRED SHIFT:

  • 9am ET - 6pm ET