Georgia Employer DATABASE DEVELOPER(835957) in Alpharetta, Georgia

Description Job Title: Database Developer Location: Alpharetta, GA Contract: 12+ monthsDescription: 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, goo