Senior Database Administrator

Job Description

About Us Ignatiuz is a digital transformation and intelligent workplace consulting company with offices in the US (PA) and India (Indore). Focused on accelerating digital performance through innovation and automation. Our team has worked with a variety of Fortune 500 clients and has a track record of delivering reliable, high-quality solutions that drive business success. 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. Show more Show less