Сучасна диджитал-освіта для дітей — безоплатне заняття в GoITeens ×
Access Softek is US-based software development company, started 30 years ago in Berkeley, CA. Today, we have offices opened in New-York city, Chicago, Ohio, Vancouver (Canada) and our head office in California (Berkeley). Since 1986 we continue to unveil cutting-edge innovations to over 400 bank and credit union customers in the USA.
8 серпня 2019

Senior SQL Developer (Remote, Full-time) (вакансія неактивна)

віддалено

Необхідні навички

We are looking for Senior SQL developer with extensive experience in working with large data under high load and experience in solving complex performance/scalability challenges.

In short-term he is going to work on improvements and optimizations for existing MS SQL solution on a machine learning project. In the long-term, he will need to work on transition this solution to AWS services and components.

Our requirements:
1. Significant expertise in MS SQL/T-SQL.
2. Comprehensive experience in design SQL databases in collaboration with application development teams, developing stored procedures, functions, views, and various DDL and DML scripts
3. Knowledge of performance optimization methods, database security, SQL Table Partitioning, etc.
4. Ability to develop SSRS reports, complex SQL queries
5. Knowledge of design patterns, transactions, HA principles and ways to design HA databases/applications
6. Experience in performing database administration and capacity planning
7. Understanding of modern security principles for designing applications i.e. knows possible ways to attack database and ways to protect from it. For example, knows what is SQL injection and how to prevent it?

Knowledge of:
1. Software development practices to write quality code and stable solutions.
2. OOP principles and design patterns.
3. How to work with version control (git) and bug tracking (Jira).
4. Scrum and Agile.

Eager about specifics of our position:
1. Able to work and communicate remotely
2. Work in PST hours
3. Like to solve non-standard tasks
4. Broad thinking and interest to both business and technical problems

Буде плюсом

Good to have:
1. Experience in using No SQL database with MS SQL databases for different purposes when necessary
2. Experience in AWS RDS, AWS services and components.
3. Knowledge C# on a base/Junior level, able to read the code
4. Knowledge of Entity Framework concepts, LINQ and other ways to write DB queries in C#

Обов’язки

Responsibilities:
1.Database support.
2. Monitoring, tuning MS SQL databases.
3. Analyzing existing SQL queries for performance improvements.
4. Creating complex functions, scripts, stored procedures, new queries, database schemes.
5. Developing databases logic and structure, optimizing them.
6. Taking part in developing new products architecture.
7. Some DBA responsibilities such as server monitoring, tuning back-ups, etc.

Про проєкт

Access Softek is a digital banking software company headquartered in Berkeley, California with offices in Manhattan, Chicago, and Vancouver. We are known for our digital banking solutions: online banking, mobile banking, omnichannel lending, and omnichannel account opening.
Since 1986, Access Softek has continued to unveil cutting-edge industry firsts. We were mobile-first when most people were still learning how to text on their flip-phones. Since then we’ve helped our customers be first-to-market with dozens of new features like real-time deposits, P2P transfers, mobile lending, and online biometrics.
Today our 300+ employees are serving over 400 financial institutions and reaching over 3 million mobile banking end-users every month. Our ongoing focus is on innovation: mobile-first, machine-learning, and A.I. everywhere

Гарячі вакансії

Всі вакансії