Senior Database Administrator
- Ignatiuz Software
- 8 - 9 years
- Indore
- 2 months ago
- Email to a friend
- Report this job
Job Description
We are seeking an experienced and highly skilled Senior Database Administrator (DBA) to oversee and manage mission-critical Microsoft SQL Server database environments. This role involves administering various separate databases across virtual servers, configured for high availability with failover clustering. The ideal candidate will be proficient in proactive monitoring and alerting systems, particularly using Redgate, and will bring expertise in maintaining optimal performance, security, and uptime of all database services.
Key Responsibilities:
Database Management Administration:
o Oversee and manage the daily operations of multiple SQL Server instances across virtual servers.
o Ensure high availability and disaster recovery solutions for mission-critical databases.
o Manage and configure SQL Server Always on Availability Groups and SQL Server Failover Clustering to ensure uptime and reliability.
o Configure and maintain SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
o Perform regular database health checks and system audits to ensure the security and integrity of data.
Performance Tuning Optimization:
o Perform performance tuning and optimization across all SQL environments to enhance query performance and overall database health.
o Proactively identify and resolve potential performance issues including index fragmentation, query optimization, and resource bottlenecks.
o Utilize tools like Redgate, SQL Profiler, and SQL Server Management Studio (SSMS) to monitor and identify problematic queries and resources.
Monitoring Alerting:
o Implement and maintain comprehensive monitoring systems using Redgate, SQL Diagnostic Manager, and custom scripts to ensure proactive detection of database issues.
o Set up alerting mechanisms to notify teams of critical incidents, database downtime, or performance degradation.
o Implement real-time database monitoring and automate response mechanisms to mitigate downtime.
Backup, Recovery, Security:
o Manage regular database backups and implement disaster recovery strategies to ensure minimal downtime during system failures.
o Automate backup and recovery procedures, ensuring integrity and availability of data.
o Apply security measures including encryption, patch management, and user access controls to maintain data privacy and regulatory compliance.
Database Upgrades Migrations:
o Lead database migrations, upgrades, and patches to newer versions of SQL Server, ensuring minimal disruption to business operations.
o Plan and execute database rollouts for new features, ensuring smooth transition and minimal impact on performance.
Collaboration Support:
o Collaborate closely with application development teams to ensure seamless integration of database systems with business applications.
o Provide database support for troubleshooting and resolution of database-related issues impacting production environments.
o Serve as a subject-matter expert (SME) for other teams on SQL-related technical matters, offering guidance and best practices.
Documentation Reporting:
o Maintain up-to-date documentation for database configurations, backup strategies, high-availability setups, and troubleshooting guides.
o Develop and produce regular reports for database performance metrics, capacity planning, and optimization recommendations.
Automation Scripting:
o Develop and maintain scripts to automate routine database maintenance tasks, such as indexing, backups, and log file management.
o Use PowerShell, T-SQL, or other scripting languages to automate daily database operations and improve system efficiency.
Requirements
8+ years of hands-on experience with Microsoft SQL Server database administration.
Extensive experience managing SQL Server Failover Clustering, Always on Availability Groups, and high-availability database configurations.
Proficiency in database monitoring and alerting tools, especially Redgate, and experience with SQL Diagnostic Manager, SQL Profiler, or other third-party monitoring tools.
Strong experience in database performance tuning and query optimization using techniques such as indexing, query plans, and resource management.
Expertise in backup and disaster recovery strategies, including point-in-time recovery and transaction log management.
Proficiency in writing complex T-SQL queries, stored procedures, and scripts for automation and data manipulation.
Strong understanding of SQL Server security practices, including encryption, roles, and permissions.
Experience with database migrations, upgrades, and patching, particularly in high-availability environments.
Familiarity with virtualized environments and cloud database platforms such as Azure SQL, AWS RDS, or Google Cloud SQL.
Preferred Qualifications:
Experience with PostgreSQL and/or NoSQL databases (e.g., MongoDB, DynamoDB).
Familiarity with cloud-based database platforms (Azure SQL, AWS RDS, etc.).
Experience working in virtualized environments (e.g., VMware, Hyper-V).
Exposure to DevOps practices and CI/CD pipelines involving database deployments.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: Ignatiuz SoftwareLocation(s): Indore+ View Contact
Keyskills: Performance tuning VMware Automation Postgresql SSRS Application development Stored procedures SSIS Troubleshooting SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Ignatiuz Software
Ignatiuz is a modern software and services company offering state of the art technology solutions. The company is passionate about digital transformation and digital innovation. We are experts in modern digital transformation and robotic process automation
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in