What are the responsibilities and job description for the SQL Developer position at Karmak, Inc.?
Position Summary
The SQL Developer assists in the design, development, documentation and maintenance of
Karmak's database environment to ensure that the performance, quality and reliability surpass the expectations of our customers.
Essential Functions
- Ensure that best practices for database design and development activities are followed
- Design and implement database systems based on requirements while focusing on reliability, stability and performance
- Develop and troubleshoot complex stored procedures, scripts and functions supporting application development
- Performance tune queries and provide expertise on set-based operations
- Develop and implement data movement strategies between environments
- Work closely with DevOps to prepare deployment and rollback scripts across development and production environments
- Administer source control and build process of databases within the Karmak SDLC
- Create and manage schema and other technical artifacts relating to the database environments
- Troubleshoot and resolve bugs issues (data or DB code) and performance issues
- Assist Product Owners and Quality Assurance in development and testing efforts
- Be responsible for or be a contributor to documentation artifacts including functional requirements documents, design documents, and data management plans
Essential Knowledge, Skills and Abilities
- Working knowledge of SQL Server 2012 - 2019, Azure SQL Database, TSQL, Visual Studio and VSTS
- Knowledge of database tuning and troubleshooting
- Knowledge of basic Project Management principles
- Ability to design, develop and create database objects on Microsoft SQL Server platform. i.e. Tables, Indexes, Keys, Stored Procedures, Views, Functions, Triggers, etc.
- Ability to monitor Database performance including execution time and experience implementing efficiency improvements.
- Use of tools to diagnose database performance issues, create reporting index strategies and improve database designs based on SQL execution
- Bachelor's Degree in related field or equivalent experience
- Cooperative attitude and team-oriented
- Must possess focused multi-tasking abilities and be detail-oriented
- Excellent communication, problem-solving and organizational skills
- 5 years' experience in the design and building of data models
- 5 years' experience in relational database design and tuning.
- This is a position that operates with minimal supervision, technical expertise in software development or other Information Technology areas a plus.
The above statements describe the general nature and level of work being performed in this job. They are not intended to be an exhaustive list of all duties. Additional responsibilities may be assigned by Karmak.