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