Database Developer II

WellDyneRx | 12 d ago
Published date Posted on Indeed on Jul 18, 2021

Location

Remote - U.S.

Position Summary

As an integral member of the IT Data Management team, the Database Developer is responsible for the design, development, implementation and support of mission-critical data integration efforts. The position will develop and implement SQL enterprise data warehouse systems, support various data and application integration efforts, and collaborate on the revision of existing systems and applications. Working with cross-functional teams, the Database Developer will gather and document applicable requirements and technical solutions to meet business needs. The Database Developer will then use those requirements to design, develop, test and implement successful back-end data solutions. The Database Developer will ascend through a progression of increasing responsibilities as outlined in the next section.

Essential Duties and Responsibilities

  • Develop scripts to automate routine and repetitive database SQL tasks.
  • Estimate, document, review and evaluate application requirements and specifications
  • Work with data & business analysts or end users to gather project requirements, analyze needs and process flow and develop user-oriented data solutions
  • Perform data entry or run scripts, either scheduled or manually, when needed or required
  • Work in a team environment offering assistance, advice and technical expertise to peers
  • Interact regularly with management and clients to constantly improve data structures, ETL processes, and application performance
  • Provide production support as required to ensure the availability and performance of developed applications for both external and internal users
  • Generate and run routine and ad hoc SQL scripts
  • Develop stored procedures, triggers, functions and views to support IT initiatives
  • Work with application developers, project managers, business owners, analysts and clients to develop database solutions to validate system requirements
  • Design and develop, modify or enhance applications based on formal or informal specifications
  • Develop testing data (unit testing, test-driven) for own systems as well as other systems developed by team
  • Develop SQL databases and design applications to interface with SQL databases
  • Thoroughly develop, debug, test and document systems
  • Technical understanding regarding data models and database design development
  • Creating/tuning/optimizing stored procedures, DTS/SSIS packages and SQL code


Knowledge, Skills, and Abilities

  • Strong communication skills, both written and verbal
  • Strong attention to detail in high-pressure situations
  • Understanding of business practices and desktop, server and network technologies
  • Experience in SQL Server Integration Services (SSIS) and Transact SQL (T-SQL)
  • Strong experience on creating database objects such as tables, indexes, stored procedures, functions, triggers and writing complex queries.
  • Data warehouse techniques, methods and logging process and dimensional modeling
  • Proven ETL development and data integration between multiple data source systems
  • Experience in Query Optimization and tuning
  • Detailed problem solving skills, documentation , communication and flexibility
  • Ability to manage time, work within a team environment to meet project goals/deadlines
  • Ability to work on multi (Technical/Business) environments and train end users
  • Strong SSIS/T-SQL troubleshooting and debugging skills
  • Experience developing database solutions using database design principles/standards
  • Mature analytic problem-solving skill
  • Experience with Microsoft development tools and technologies including:
    • SQL Server 2008 R2/2012/2014/2016
    • MS Office (Excel, Word, PowerPoint, Access, Project, Visio)
  • Experience with Team Foundation Server 2012 or other source control tools
  • Experience with .Net and Biztalk is a plus
  • Experience with HIPAA 834 format or other EDI formats a plus
  • Experience with creating and reading documents in UML notation is a plus


Education and Experience

  • High School Diploma required. Bachelor's in Computer Science, Information Management, Engineering or related fields preferred
  • 1-3 years of previous SQL development experience


Work Environment / Physical Demands

This position is in a typical office environment which requires prolonged sitting in front of a computer. Requires hand-eye coordination and manual dexterity sufficient to operate standard office equipment including operation of standard computer and phone equipment. May have occasional high stress when dealing with customers/clients.

EOE M/F/D/V


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Talentiqo RPO Talentiqo RPO |
Today

URGENT: Title: IT Infrastructure AnalystDuration: 11 Months ContractLocation: Pittsburgh, Pennsylvania (100% Remote)Note: USC OnlyRequirements: Must have experience with Linux (and some Windows) and Oracle DB.1-3 years of experienceWill consider a college graduate with formal ed

Arctic Information Technology Arctic Information Technology... |
Today

Job Reference 21-0185Post Date 7/29/2021CARC YesCity/Location TelecommutePoint of Hire Nationwide, USACompany AIT-Arctic Information Technology, Inc.Type of Position Regular Full-TimeFLSA Status ExemptDescriptionThe Data Engineer’s main responsibility is to be the single Po

Gryphon Technologies Gryphon Technologies |
Today

Overview:Gryphon Technologies is a premier engineering and technical services provider supporting National Security programs. Gryphon is the federal Government’s partner working in support of mission critical systems in every phase of their lifecycle. We are proud of our ab

***THIS POSITION REQUIRES AN ACTIVE TOP SECRET CLEARANCE***__**JOB RESPONSIBILITIESRequired Qualifications over Five (5+) years of experience with programming and software development, including analysis, design, development, implementation, testing, maintenance, quality assuranc

Agfa HealthCare, is a division of the Agfa-Gevaert Group which is headquartered in Mortsel, Belgium and traded on Euronext Brussels (AGFB).At Agfa HealthCare, we support healthcare professionals across the globe to transform the delivery of care. Our focus is 100% on providing be