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.
Codevian TechnologiesRemotePlease note that the above JD includes expectations covering both DBA and Database Development (DB Dev) responsibilities.…+ 30 d