SQL Developer Job in Norcross 30092, Georgia US

SQL Developer

Location: Norcross, Ga 30092
Employment Type: Full Time, Employee

Job Title:
SQL Developer/Database Engineer

Job Purpose:
The Database Engineers role is to strategically design and implement large scale data migrations/conversions into Fiservs products using Microsoft SQL Server 2005/2008. Additionally, the Database Engineer will be called upon to design and implement highly custom large scale database solutions that augment Fiservs products. On occasion, the Database Engineer will be asked to evaluate, size and select technology components, such as software, hardware, and networking capabilities, for database management systems and application databases across the organization.

Focusing more broadly on projects that impact multiple areas of Fiservs products, the Database Engineer will work directly with external clients using both analytical skills and subject matter expertise in financial applications to gather requirements, design solutions and execute implementations.

Job Responsibilities:
 Perform extensive analysis of database entities, relationships and attributes.
 Participate in both data design and data processing sessions for assigned projects and teams.
 Create migration/conversion designs that meet the project's business, system and data requirements.
 Create written data migration/conversion plans and data file/data model specifications that meet the project's business, system and data requirements.
 Reverse engineer existing migration/conversion processes and data models including designing and utilizing Microsoft SQL Server Profiler traces.
 Design and develop ETL (Extract, Transform and Load) processes using Transact-SQL (T-SQL) and Microsoft SQL Server Integration Services (SSIS).
 Optimize ETL processes and T-SQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
 Research and review data for presentation, accuracy and compliance within the business/system needs.
 Review with team members/client and other database engineers the content, accuracy and completeness of data models, file specifications and migration/conversion processes.
 Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes.
 Respond to data design and/or data processing problems and find solutions in a timely manner.
 Identify appropriate resources and work with them to research and resolve any open data-related issues.
 Mentor staff by reviewing deliverables and offering team assistance whenever needed.

Candidate Attributes:
 Strong understanding of relational database structures, theories, principles, and practices.
 Deep understanding of Microsoft SQL Server, T-SQL and SSIS  including data validation, data cleansing and performance optimization/tuning.
 Experience with data processing and ETL approaches and techniques.
 Ability to conduct research into data/database issues, standards, and products.
 Understanding the value of data quality and promoting data as a corporate asset.
 Exceptional analytical, conceptual, and problem-solving abilities.
 Strong written and oral communication skills.
 Strong presentation and interpersonal skills.
 Ability to present technically complex ideas in a clear, concise and user-friendly manner.
 Ability to prioritize and execute multiple tasks in a high-pressure environment.
 Ability to thrive in a team setting as well as excel independently and autonomously.
 Ability to think outside-the-box in brainstorming and designing creative data migration/conversion solutions.
 Experience working in large team-oriented, collaborative environments.
 Hands-on experience with business requirements gathering/analysis.
 Familiarity with Online Banking, Bill Pay and Mobile Banking data requirements.
 Familiarity with applicable data privacy practices and laws.

Job Requirements:
 Bachelors degree in Computer Science, Information Technology or equivalent combination of education and experience.
 4-6+ years technical expertise in database and ETL development with Microsoft SQL Server  primarily T-SQL and DTS/SSIS.
 Extensive development experience in analysis, modeling and design of database solutions.
 Technical understanding of network, PC, and platform operating systems, including Microsoft Windows Server 2003/2008.
 Application development understanding of Microsoft .NET technologies  primarily ASP.NET and C#.
 Technical understanding of the different phases of the Software Development Life Cycle (SDLC)
 Able to effectively communicate verbally and in writing; in large meeting settings and when presenting to large groups; in both technical and non-technical arenas.
 Able to research, analyze and interpret information in a clear and concise manner.
 Able to understand and convey technical issues to non-technical associates, and vice-versa.
 Able to develop and maintain effective working relationships across enterprise level lines.
 Able to identify issues warranting escalation.

Contact:
PLEASE E-MAIL RESUMES TO: Apply by Email

Apply using the Technisource application process

Apply using your My Monster account

      

Open all references in tabs: [1 - 4]