Transact-SQL Developer ( 4+ yrs)

Summary Description:

Majority of the time will be spent designing, developing, automating and coding projects for improving efficiency within our systems. Developer will work with the business and vendors to understand customer needs and develop high value solutions. They are accountable for the design and implementation of solutions that meet software functional and non-functional requirements and adhere to established development standards. The deliverables are expected to meet Lucent’s and customer’s needs, be secure, high performing, scalable, maintainable, supportable, compliant with standards, and consistent with the architectural framework. Developer is expected to support products in use by diagnosing and resolving issues. Developer will also participate in initiatives to improve processes, standards, and practices. ExperienceExperience with relational database design and writing efficient SQL queries or data transformation scripts.Experience working with multiple data sources to extract, transform, and load data.Process / Job ManagementKnowledge of transmission protocols: FTP, SFTP, FTPS, SSH, Telnet, APIKnowledge of JSON blob storage and retrieval.Ability to manipulate and optimize data loads during transit with tools like Node.JS or Python.Encryption Technologies: PGP, GPGDevelop solutions using TDD or event driven methodology.Automation mindset and experience Required SkillsMinimum 5-7 years of hands-on database development experience, using stored procedures, functions, triggers, and views on Microsoft SQL Server and PostgreSQL platforms.Proven Microsoft T-SQL skills as well as PostgreSQL to include optimizations through Explain/Analyze.Excellent Written and Verbal SkillsDemonstrated strengths in organization, attention-to-detail, follow-through, reasoning, critical thinking, and problem-solving skillsWork independently, ability to multi-task, and comfortable engaging with all levels of the organization, including leadershipAbility to learn established codeAbility to translate business needs into computer-oriented solutionsAbility to document work

Key Skills

• PostgreSQL