Senior SQL Server Database Administrator

We are looking for a highly skilled and experienced Senior SQL Server Database Administrator (DBA) with expertise in Microsoft SQL Server to manage, optimize, and ensure the performance, availability, and security of our SQL Server database systems. The ideal candidate will have a strong background in database administration, SQL Server expertise, and the ability to proactively address database-related issues. This role will encompass in-depth SQL Server performance optimization, including indexing, wait stats analysis, query tuning, and integration with .NET-based applications. Additionally, experience with both on-premises and cloud-based installations is crucial to the organization's evolving infrastructure. 

Work at Exadel - Who We Are

Since 1998, Exadel has been engineering its products and custom software for clients of all sizes. Headquartered in Walnut Creek, California, Exadel has 2,800+ employees in development centers across America, Europe, and Asia. People drive Exadel’s success and are at the core of our values.

About Our Customer

The customer is the leading European provider of e-tendering, procurement systems, and information between buyers and suppliers. The European government is a major user of their services.

About Our Project

The customer landed an enterprise-level project within Procure-2-Pay in August 2022. The project is for the Danish government, and the scope is procurement, invoice workflow management, and contract management. 

We have had this customer using our platform since 2014. Still, the new tender also includes many changes, including a minimum requirement to deliver a completely new invoice workflow solution handling the entire payment plan for the Danish government. The project has 350+ functional requirements, 150+ non-functional, and 50+ process requirements to be delivered within the project's scope.

Project Tech Stack

• MS-SQL
• TeamCity (CI/CD)
• Git
• ElasticSearch and Kibana
• Redis cache
• LaunchDarkly (Feature flags)
• WCF
• REST API
• ASP.NET
• Windows servers
• HyperV
• PowerShell
• KafkaMQ

Requirements

• Proven experience as a SQL Server Database Administrator with expertise in indexing, wait stats analysis, and query tuning
• Proficiency in SQL, T-SQL, and query optimization
• Knowledge of database security best practices and compliance requirements
• Competency in high availability and disaster recovery solutions
• Significant background with .NET for connecting databases with the application codebase and verifying findings
• Ability to troubleshoot and resolve database-related issues
• Teamwork skills

Nice to have

Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate)

English level

Intermediate+

Responsibilities

• Administer, configure, and maintain Microsoft SQL Server databases to ensure high availability and performance
• Create, modify, and optimize database objects, such as tables, views, stored procedures, and functions
• Monitor database performance, troubleshoot, and resolve issues in a timely manner
• Implement and maintain database security, including user access control and data encryption. Ensure compliance with data protection regulations and best practices for data security
• Develop and maintain backup and recovery strategies to prevent data loss and ensure business continuity. Perform regular backups and test recovery procedures to guarantee data integrity
• Identify and resolve database performance bottlenecks through indexing, wait stats analysis, and query tuning. Optimize SQL queries to enhance overall system performance
• Configure and manage high-availability solutions, such as failover clustering and database mirroring. Develop and maintain disaster recovery plans to minimize data loss and downtime
• Plan and execute SQL Server upgrades and apply patches to keep systems up-to-date and secure
• Collaborate with developers to integrate SQL Server databases with .NET-based codebase. Verify findings through codebase interactions
• Manage SQL Server installations in both on-premises and cloud environments
• Implement and optimize database solutions on cloud platforms, such as Azure SQL Database or AWS RDS
• Implement automation and scripting to streamline routine tasks and improve efficiency
• Collaborate with application developers and IT teams to ensure seamless integration with database systems
• Provide guidance and support to developers in database design and optimization

Advantages of Working with Exadel

Transparent Career Roadmap

• The HR manager accompanies each employee on their first steps in the company and assists them in achieving future professional goals
• Exadel is a global company with 30+ offices in 15+ countries. Employees can discover new places to live and work and transfer to any location with an Exadel production office. The HR manager and the Global Mobility specialist accompany the employee and assist throughout the relocation process
• Your career growth is in your hands, so each Exadeller decides when to level up and initiate performance assessments. The management team supports career planning and the discovery of new tech stacks and languages

Learning & Development Opportunities

• Each Exadeller is given a $1,000 yearly budget for self-education, which includes certifications, training sessions, meetups, conferences, and educational materials
• Employees participate actively and benefit from the knowledge-sharing environment across seven practice units: Digital Marketing Technologies, Content Marketing, AI, QA, QAA, Agile, and DevOps
• Employees can find recordings from meetups and trainings on Exadel’s Internal Learning System

Work & Life Balance

• Each Exadeller is in charge of managing their workflow independently without being micromanaged at every step; it is, however, important that an employee always attends meetings, logs their time, and meets deadlines
• Operating from the office or remotely depends on which mode the employee prefers. Hybrid or remote mode staff will receive the necessary equipment before their first working day. For those who prefer to work in the office, the office network offers up-to-date equipment, good facilities, and a warm, collaborative environment
• The team meets at two annual team-building events across locations; in addition, there are team events such as Pizza Days, Programmer’s Day, informal meetups, board game parties, and sports initiatives

Employee Perks & Bonuses

• The Exadel referral program covers all regions and involves recognition for hired recommended professionals. Depending on the location and the position, an employee receives a monetary bonus for recommending a candidate to Exadel who ends up being hired
• Employees collect coins for numerous project activities, exchanging them for products or services of their choice available at the Exadel store
• Volunteers for mentoring, interviewing, performing assessments, and participating in community meet-ups get additional monetary bonuses
• Location-dependent, Exadellers can access benefit platforms with vouchers for online stores, medical insurance reimbursement, sports membership fees, vacations, and childbirth bonuses