Database administrator – SQL Server

As a SQL Server Database Administrator (DBA), you will manage and maintain the SQL Server database system, ensuring data integrity, performance and security.

Basic Requirements:

1. Database Administration:
   • Installation, configuration, and maintenance of SQL Server (versions: 2012, 2014, 2016, 2019, 2022)
   • Backup and Recovery strategies (Full, Differential, Transaction log backups, Point-in-time recovery)
   • High Availability (HA) & Disaster Recovery (DR) solutions:
   • Always On Availability Groups
   • Replication (Transactional)
   • Security & Compliance:
   • Role-based security management (users, roles, permissions)
   • Transparent Data Encryption (TDE)
   • Data Masking & Row-Level Security
   • Auditing and GDPR/HIPAA Compliance
2. Performance Tuning & Optimization:
   • Query Optimization (Execution plans, Indexing strategies, Query Store)
   • Index and Statistics maintenance (Clustered, Non-Clustered, Columnstore indexes)
   • SQL Profiler, Extended Events, and Performance Monitoring tools (Dynamic Management Views – DMVs)
   • I/O, CPU, and Memory tuning for SQL Server performance
   • TempDB Optimization & Locking/Blocking Analysis
   • Deadlock troubleshooting & resolution
3. SQL Development & Scripting:
   • Writing complex T-SQL queries, stored procedures, functions, triggers, and views
   • Working with Common Table Expressions (CTEs), Dynamic SQL, and XML/JSON
   • PowerShell scripting for automation
   • SQL Server Agent Job automation and scheduling
4. Cloud & Hybrid DBA Skills:
   • Azure SQL Database
   • SQL Server on Virtual Machines (IaaS) vs. Managed Instances (PaaS)
   • Azure Data Factory
   • Cloud Backup & Disaster Recovery strategies
5. ETL & Data Integration:
   • SSIS (SQL Server Integration Services) for data migration and transformation
   • Data Warehousing and Reporting (SSRS, Power BI, Tableau integration)
   • Change Data Capture (CDC) and Change Tracking
6. Monitoring & Automation:
   • Database health checks and proactive monitoring
   • Third-party tools: Redgate, DataDog SentryOne, SQL Monitor
   • Writing scripts for automated maintenance and alerts
   • SQL Server Audit Logging & Activity Monitoring
7. DevOps & CI/CD for SQL Server:
   • Database deployment automation using Flyway, Liquibase, Redgate
   • Integration with version control systems (Git, Azure DevOps, SVN)
   • CI/CD pipeline integration (Jenkins, Azure DevOps, GitHub Actions)
8. Soft Skills:
   • Strong problem-solving and troubleshooting ability
   • Excellent documentation and communication skills
   • Experience working in JIRA environments
   • Team leadership & mentoring junior DBAs
   • Ability to work under pressure in production environments
   • Advanced English