Distillery Tech is committed to diversity and inclusion. We actively seek to cultivate a workforce that reflects the rich tapestry of perspectives, backgrounds, and experiences present in our society. In our recruitment efforts, we are dedicated to promoting equal opportunities for all candidates, regardless of race, ethnicity, gender, sexual orientation, disability, age, or any other dimension of diversity.
Distillery accelerates innovation through an unyielding approach to nearshore software development. The world’s most innovative technology teams choose distillery to help accelerate strategic innovation, fill a pressing technology gap, and hit mission-critical deadlines. We support essential applications, mobile apps, websites, and eCommerce platforms through the placement of senior, strategic technical leaders and by deploying fully managed technology teams that work intimately alongside our client’s in-house development teams. At Distillery, we’re not here to reinvent nearshore software development, we’re on a mission to perfect it.
As a DBASQL Server Developer, you will be an integral part of the team. They will be responsible for monitoring uptime and errors of all production databases and back-end processes. They will design strategies for database systems and establish standards for operations, programming, and security. You will use best practices and improve the architecture when necessary taking into account performance, maintainability, reliability, security and scalability. You will be part of production on-call support on a rotating basis, including after-hours and weekends.
Responsible for the monitoring and uptime of all production databases and processes (SQL jobs,.net framework executables; diagnose and fix database and processes errors).
Performs complex systems analysis and programming activities related to database design, query design, and creation of stored procedures, indexes, and functions.
Refine system performance and functionality; recommend optimizations to existing application queries
Creating and maintaining database standards and policies
Support database design, creation, migration, and testing activities
Manage the database availability and performance, including incident and problem management
Administer database objects to achieve optimum utilization
Define and implement event triggers that will alert on potential database performance, errors, or integrity issues
Perform database housekeeping, such as tuning, indexing, etc.
Monitor usage, transaction volumes, response times, concurrency levels, etc.
Identify reporting, and manage database security issues, audit trails, and forensics
Design database backup, archive, and storage strategy
Continually assess and improve the current database environment
Participates in design and code reviews, leveraging Systems Development Live Cycle best practices and ensuring architectural alignment
Perform Production On-Call Support on a rotational basis - including off-hours and Weekends
Experience designing, developing, and maintaining complex SQL Server solutions
Experience in Data Security, Performance Tuning and Optimization (PTO), and using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Experience in troubleshooting and resolving database problems
Experience in indexes, index management, and statistics
Experience with Windows server, including Active Directory and proper disk configurations7. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
Experience defining and writing requirements and design documents as well as generating user and application documentation
Proficient in with Visual Studio, DataTools, .NET, SSRS, SSIS and understanding of code revision tools
Experience from SQL Server 2008 R2 to SQL Server 2019
Experience with Software Development Life Cycle Process (SDLC)
Experience in .NET Development
PGP Encryption and ASPEncrypt
PCI and GDPR
Agile Methodologies ScrumKanban, CICD, Atlassian Products (Jira, Confluence, Bitbucket)
FinancePayment Industry Experience
The ability to work on and partner with multi-national teams that are committed to our core values: Unyielding Commitment, Relentless Pursuit, Courageous Ambition, and Authentic Connection.
A generous, competitive compensation package for exceptional performers, as well as a generous vacation package and competitive benefits plan
Remote working environment
Professional and personal development