Job Description :
* Sr. SQL Engineer role expectation *
· Write lots of high-quality, secure, efficient, scalable, and reusable code which protects customer privacy and confidentiality at all times.
· Always perform unit tests and take responsibility for the quality of your own code once in production environments.
· Extend existing system functionality based on user requirements; analyzing code to identify areas for modification, as well as, maintain and support existing products.
· Provide input on our architecture, databases, and APIs.
· Consult with product managers to define scope and plan new features.
· Partner with your QA teammates to ensure that cohesive, quality, and usable solutions are delivered.
· Test, evaluate and recommend technologies to improve our overall solutions.
· Be a key participant in our agile development process.
· Proactively analyze, assess, and identify problematic areas of batch processing, production jobs, and production workflow; work to address the issues you’ve identified, helping to make our solutions more robust and stable.
· Evaluate data quality processes and resolve data quality issues.
Requirements
· 5+ years of experience in all aspects of the application development process; including gathering end user requirements, coding, deployment, and the creation of documentation.
· Significant industry experience in all aspects of batch processing, production workflow, and data oriented solutions.
· Experience with SQL Clustering, Views, Database Replication, SSIS, SSRS
· Expert level in the Microsoft SQL Server platform, including current versions, for use in enterprise-level or SAAS implementations.
· Experience working with C#, ASP/ASP.Net, and RESTful API’s
· Nice-to-have experience: Docker, Kubernetes, Lucene, Service Fabric, Kafka/Service Bus, RabbitMQ, ActiveMQ
· Experience with CI/CD Pipeline systems like TeamCity, Jenkins, Concourse, Hudson, Bamboo
· Proficient in identifying & troubleshooting SQL performance issues efficiently.
· Excellent written and oral communications skills required
· Enjoy learning new technologies and design patterns.
· 4-year degree in computer related field or equivalent experience in computer systems desired.