We are seeking a highly motivated and experienced Senior DBA Developer with a minimum of 5 years of experience to join our team on a hybrid model across India. This role is crucial for optimizing, automating, and maintaining our critical database infrastructure.

The ideal candidate will possess a strong blend of traditional DBA expertise and advanced development skills, particularly in scripting and T-SQL, with a mandatory minimum of 4 years of relevant experience in PowerShell, T-SQL, and DBA activities.

Mandatory Technical Skills & Experience :

Candidates must demonstrate a minimum of 4 years of hands-on expertise in the following areas:

DBA Developer/Core DBA Activities :

- Expert-level skills in database administration (DBA), including performance tuning, indexing strategies, query optimization, and capacity planning.

- Hands-on experience with database installation, configuration, patching, upgrades, and migrations.

- Strong knowledge of High Availability (HA) and Disaster Recovery (DR) solutions (e.g., Always On Availability Groups, Mirroring, Replication, Log Shipping).

- Proficiency in database security best practices, including user/role management, access control, and encryption.

PowerShell Scripting :

- Mandatory and demonstrable proficiency in using PowerShell for automating routine and complex DBA tasks (e.g., monitoring, backups, patching, configuration management, health checks).

- Experience writing robust and efficient PowerShell modules and scripts to streamline database operations.

T-SQL Development :

- Advanced skills in writing and optimizing complex Transact-SQL (T-SQL) queries, stored procedures, functions, and triggers.

- Ability to perform deep-dive T-SQL code reviews for performance and security vulnerabilities.

Preferred Skills & Qualifications :

- Python: Experience with Python scripting for data manipulation, automation, or integration with database systems is a strong plus.

- Cloud Experience: Familiarity with cloud-based database services (e.g., Azure SQL Database, AWS RDS) and their specific administration models.

- Monitoring Tools: Experience with database monitoring and alerting tools (e.g., SCOM, SolarWinds, or similar custom solutions).

Key Responsibilities :

- Design, develop, and maintain robust, scalable, and high-performance T-SQL code and database objects.

- Proactively monitor database performance and security, identifying bottlenecks and implementing performance tuning solutions.

- Develop, test, and deploy automation scripts using PowerShell to reduce manual effort and improve operational consistency across the database environment.

- Perform all core DBA functions, ensuring optimal uptime, data integrity, and recoverability of all databases.

- Manage HA/DR configurations and participate in regular recovery testing.

- Collaborate closely with development, infrastructure, and QA teams to support the full application lifecycle.

- Maintain comprehensive documentation for database standards, architecture, and operational procedures.

Soft Skills :

- Strong analytical and problem-solving skills with a focus on delivering automated, scalable solutions.

- Excellent communication and interpersonal skills to collaborate effectively in a hybrid, multi-location environment.

- Ability to manage multiple priorities and projects simultaneously.