Database Administrator (DBA)

Requirements:

Proven experience as a Database Administrator with hands-on expertise in managing Microsoft SQL Server & Databases

Strong knowledge of SQL and database design principles, with familiarity across various DBMS platforms.

Strong command of SQL, T-SQL and potentially Shell scripting for automation

Experience in setting up various High Availability (HA) solutions as part of a Disaster Recovery Strategy for enterprise databases.

Establishing and managing database backup and recovery processes to ensure data integrity and availability

Monitoring database performance, identifying bottlenecks, and implementing tuning strategies to optimize query execution and resource utilization.

Proficiency with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).

Experience with Windows and SQL Server clustering for high availability and failover configurations.

Expertise in creating and managing tables, views, stored procedures, functions, triggers, indexes, and other database objects

Experience with query optimization, analyzing execution plans, indexing strategies, and using tools like SQL Profiler

Develop and optimize complex SQL queries, stored procedures, and functions.

Proven ability to maintain and manage a four-environment landscape—Development (DEV), Quality Assurance (QA), User Acceptance Testing (UAT), and Production (PROD)—to support multiple teams and deployment workflows.

Developing and enforcing data security policies to protect sensitive information

Leading and executing database migration projects

Excellent analytical and problem-solving skills to troubleshoot and resolve complex database-related issues.

Strong verbal and written communication skills for effective collaboration with cross-functional teams and thorough documentation of processes and procedures.

Please note that the above JD includes expectations covering both DBA and Database Development (DB Dev) responsibilities.