About the role: The Database Developer will support database development efforts across multiple database platforms including MSSQL and PostgreSQL. A successful candidate will have an eye for quality and detail to help the team build sophisticated and high performing database systems to support critical business applications.

Responsibilities:

• Ensure delivery of high quality, highly efficient database code according to organizational needs and specifications.
• Perform analysis, design, development, testing and implementation of highly complex database solutions.
• Write scripts for creation of new database objects (Stored Procedures, Tables, Views, Functions, Triggers, etc.)
• Design, build, debug, monitor, schedule and troubleshoot end to end ETL solutions.
• Write Ad Hoc SQL Scripts for importing, exporting or updating data on an as-needed basis, maintaining data integrity across all applications.
• Monitor DB team ticket queue and handle production support tickets as needed to ensure SLAs are being met.
• Analyze existing SQL queries for performance and make suggestions for optimizations.
• Develop and perform unit testing procedures to ensure proper operations of database code ensuring it is performing optimally and is bug free.
• Ensure pristine data quality in all delivered database solutions.
• Participate in code reviews of other developer’s code to review for accuracy, scalability, performance as well as ensuring it meets all defined acceptance criteria.
• Participate in on-call rotation to ensure coverage for off-hours and holiday support.
• Work closely with DBAs and other IT members to quickly identify and resolve production incidents.
• Maintain the use of database best practices and team coding standards.
• Ensure complete and accurate documentation is created and maintained for all design and coding projects.
• Follow all company change management procedures.
• Collaborate with QA Team to help define appropriate test cases and support all testing efforts.

Qualifications:

• Bachelor’s Degree and a minimum of 3-5 years of development in database technologies.
• 3-5 years of experience with Microsoft SQL Server required.
• 3-5 years of experience with SSMS and SSIS required.
• 3-5 years of experience with PostgreSQL.

Required Skills:

• Excellent communication skills both written and oral as well as good interpersonal skills.
• Strong analytical, problem-solving, critical thinking and decision-making skills.
• Proficient in database design and development of new database objects (Stored Procedures, Tables, Views, Functions, Triggers, etc.)
• Demonstrated ability to write highly efficient and complex SQL queries.
• Demonstrated ability to design, build, debug, monitor, schedule and troubleshoot end to end solutions for data transformation (ETL)
• Proficient in database performance tuning and query optimization.
• Experience with XML and JSON a plus.
• Experience with Microsoft SQL Server Merge Replication a plus.

Pay range and compensation package: $115k - $135k

Sponsorship is unavailable for this full time position