Microsoft SQL Server Database Administrator (DBA)

Company Description Nomi is a cloud-based accounting suite designed specifically for accountants and bookkeepers, providing an integrated platform to manage all core accounting and compliance tasks. The suite covers bookkeeping, payroll, accounts production, tax return preparation, and company secretarial activities, all supported by a robust CRM system. Nomi enables accounting professionals to streamline workflows and collaborate efficiently with their clients. A dedicated mobile app further empowers users to manage their practice, generate reports, and capture receipts on the go, making Nomi a flexible solution for modern, digital-first firms.
Job Summary: We are looking for an experienced Microsoft SQL Server Database Administrator (DBA) with 2-5 years of hands-on experience in administering, monitoring, optimizing, and troubleshooting SQL Server databases in staging and production environments. The candidate should have strong expertise in database performance tuning, backup and recovery, security, high availability, and AWS RDS for SQL Server. He/she should be capable of independently managing staging and production environments, optimizing database performance, and supporting business-critical database systems to ensure high availability, reliability, and scalability.
Key Responsibilities:
o Install, configure, administer, and maintain Microsoft SQL Server databases.
o Manage SQL Server instances hosted on-premises and AWS RDS.
o Configure and manage database backups, restores, disaster recovery, and maintenance plans.
o Monitor database health, performance, and availability using SQL Server monitoring tools.
o Identify and resolve database bottlenecks at both the infrastructure and application/query levels.
o Perform query optimization, execution plan analysis, and performance tuning.
o Design, implement, and maintain database objects, including:
▪ Tables ▪ Views ▪ Stored Procedures ▪ Functions ▪ Triggers ▪ Indexes ▪ Constraints
o Configure and manage SQL Server Agent Jobs.
o Configure and troubleshoot Linked Servers.
o Manage TempDB configuration and optimize its performance.
o Monitor blocking, deadlocks, waits, and resource utilization.
o Perform index analysis, maintenance, fragmentation management, and statistics updates.
o Troubleshoot database issues using: ▪ Extended Events ▪ SQL Profiler ▪ Activity Monitor ▪ Query Store
▪ Dynamic Management Views (DMVs)
o Support database deployments, schema changes, and release activities.
o Ensure database security by managing users, roles, permissions, auditing, compliance and encryption where applicable.
o Production Incident Handling, Root cause analysis (RCA), performance troubleshooting and proactive monitoring.
o Work closely with development teams to improve database performance and application scalability. Prepare and maintain database documentation, SOPs, and operational runbooks.
• Required Technical Skills
o SQL Server Administration
o Microsoft SQL Server 2016/2019/2022
o Installation and configuration
o Backup and Restore o Database maintenance
o SQL Server Agent o Linked Servers
o TempDB optimization
o Database Migrations & Upgrades: Experience upgrading SQL Server versions and migrating databases
• AWS o AWS RDS for SQL Server
o Snapshot management
o Parameter Groups
o Option Groups
o Performance Insights
o CloudWatch monitoring
• Performance Tuning
o Query optimization
o Execution Plan analysis o Index tuning
o Statistics management o Wait Statistics Analysis: Understanding waits such as `PAGEIOLATCH`, `CXPACKET`, `CXSYNC_PORT`, `ASYNC_NETWORK_IO`, etc
o Blocking and deadlock troubleshooting
o CPU, Memory, and I/O performance analysis
o Monitoring & Troubleshooting ▪ Extended Events ▪ SQL Profiler ▪ Query Store ▪ Activity Monitor ▪ Dynamic Management Views (DMVs): Strong hands-on experience using DMVs for troubleshooting Performance Monitor (PerfMon) ▪ Windows Event Viewer ▪ Resource Monitoring: CPU, memory, disk I/O, and storage performance analysis.
Database Development Knowledge ▪ T-SQL ▪ Stored Procedures ▪ Functions ▪ Triggers ▪ Constraints ▪ Indexes ▪ Views ▪ CTEs ▪ Window Functions o Database Concepts ▪ OLTP and OLAP ▪ Database normalization and denormalization ▪ Database design and data modelling ▪ Transaction management ▪ Isolation levels ▪ Locking and blocking ▪ Concurrency management
o Good to Have ▪ High Availability & Disaster Recovery (HA/DR), Always On Availability Groups, Log Shipping, Replication, Database Mirroring, Failover Clustering ▪ Automation: PowerShell and SQL scripting for routine DBA tasks ▪ Experience with CI/CD for database(dacpac) deployments ▪ Database security and auditing ▪ Capacity planning ▪ Partitioning and compression ▪ Experience with large databases (VLDB) ▪ Familiarity with Azure SQL is an added advantage o Soft Skills ▪ Strong analytical and troubleshooting skills ▪ Excellent problem-solving ability ▪ Good communication and documentation skills ▪ Ability to work independently in production support environments ▪ Experience working with cross-functional teams

Work arrangement
Yes