Senior Database Administrator (SQL Server)

Senior Database Administrator (SQL Server)

We are seeking an experienced Senior Database Administrator to manage, maintain, optimize, and secure the organization’s Microsoft SQL Server database environments. The role is responsible for ensuring high availability, performance, and reliability of databases while supporting enterprise data integration, migration, and automated synchronization across multiple systems

Key Responsibilities

Database Administration

• Install, configure, upgrade, and maintain Microsoft SQL Server database environments.
• Manage databases across development, testing, staging, and production environments.
• Ensure database availability, stability, and optimal performance.
• Monitor database systems and resolve issues affecting performance or availability.

Query Development & Optimization

• Develop and optimize complex T-SQL queries.
• Analyze execution plans and resolve performance bottlenecks.
• Optimize stored procedures, views, functions, and triggers.
• Implement indexing strategies to improve query performance.
• Work with development teams to improve database query efficiency.

Performance Monitoring & Tuning

• Monitor SQL Server performance using monitoring tools and built-in SQL Server features.
• Identify and resolve performance issues including:
• Slow queries
• Blocking
• Deadlocks
• Resource contention
• Implement proactive performance tuning strategies.
• Utilize tools such as Query Store, Dynamic Management Views (DMVs), and Performance Monitor.

Data Integration & Cross-System Connectivity

• Design and implement integration between databases and enterprise systems.
• Configure and manage Linked Servers for cross-database and cross-server queries.
• Implement database connectivity with external systems, applications, and APIs.
• Ensure consistent and secure data exchange across multiple systems.

Data Migration & Database Restructuring

• Plan and execute database migration projects.
• Perform schema restructuring and database refactoring when required.
• Support system upgrades and database version migrations.
• Ensure data integrity and minimal downtime during migration activities.

ETL & Data Processing

• Design and implement ETL (Extract, Transform, Load) processes.
• Build automated data pipelines for transferring and transforming data between systems.
• Utilize tools such as SQL Server Integration Services (SSIS) for complex data workflows.
• Ensure accurate transformation and loading of data between systems.

SQL Server Agent Jobs & Automation

• Design and manage SQL Server Agent Jobs for automation tasks including:
• Data synchronization
• Scheduled data processing
• Maintenance tasks
• Reporting data refresh
• Monitor and maintain scheduled database jobs.

High Availability & Disaster Recovery

• Implement and manage high availability solutions including:
• AlwaysOn Availability Groups
• Log Shipping
• Replication
• Failover Clustering
• Develop and test disaster recovery plans.
• Ensure minimal downtime and rapid recovery during failures.

Backup, Recovery & Data Protection

• Design and maintain backup strategies including full, differential, and transaction log backups.
• Perform periodic backup validation and recovery testing.
• Ensure protection of critical organizational data.

Database Security

• Implement and manage database security policies.
• Manage users, roles, and permissions.
• Protect sensitive data through security best practices.
• Monitor database activity and ensure compliance with internal security policies.

Monitoring & Maintenance

• Implement proactive monitoring and alerting systems.
• Perform routine database maintenance tasks including:
• Index maintenance
• Statistics updates
• Database integrity checks
• Ensure databases operate efficiently and reliably.

Data Architecture & Governance

• Support the design of scalable database architecture.
• Ensure best practices in data modeling and database structure.
• Maintain documentation for database systems and data flows.
• Contribute to enterprise data governance initiatives.

Collaboration & Technical Leadership

• Work closely with developers, system administrators, and application teams.
• Provide technical leadership in database design and optimization.
• Support troubleshooting of database-related issues across enterprise systems.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Minimum 5 years of experience in SQL Server database administration.

Preferred Certifications

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft SQL Server Certifications

• Microsoft SQL Server Administration
• Advanced T-SQL Development
• Query Optimization & Execution Plan Analysis
• Performance Tuning
• Index Design & Optimization
• Stored Procedures, Functions, Views, and Triggers
• SQL Server Agent Jobs
• Backup & Recovery Strategies
• High Availability & Disaster Recovery
• Linked Servers & Cross-Database Queries
• SQL Server Integration Services (SSIS)
• Data Migration & Database Refactoring
• ETL Processes & Data Pipelines
• Database Security & Access Control
• Database Monitoring Tools