Sr Database Administrator

Job Summary :

We are seeking a highly skilled and experienced MSSQL Senior Database Administrator (DBA) to manage, maintain, and optimize our organization&aposs Microsoft SQL Server databases. The ideal candidate will ensure the performance, availability, and security of critical database systems, supporting various applications and business operations 24 / 7 / 365. This role requires a proactive individual with an understanding of database architecture, best practices, and troubleshooting. This individual should have a deep understanding of MSSQL.

Responsibilities

Essential Responsibilities :

• Database Installation & Configuration : Install, configure, and upgrade SQL Server instances (all versions) across various environments (Dev, QA, UAT, Prod).
• Performance Tuning & Optimization : Monitor database performance, identify bottlenecks, and implement solutions for query optimization, indexing strategies, and database configuration to ensure optimal performance.
• Backup & Recovery : Design, implement, and maintain robust backup and recovery strategies to ensure data integrity and availability, including disaster recovery planning and execution.
• Security Management : Manage database security, including user permissions, roles, authentication, and encryption, adhering to security policies and compliance requirements.
• High Availability & Disaster Recovery : Implement and manage high availability solutions such as AlwaysOn Availability Groups.
• Troubleshooting & Support : Provide expert-level troubleshooting for database-related issues, including connectivity, performance, and data corruption, offering timely resolution.
• Monitoring & Alerting : Implement and maintain database monitoring tools and alerts to proactively identify and address potential issues.
• Capacity Planning : Monitor database growth and resource utilization, performing capacity planning to ensure scalability and future needs are met.
• Data Integrity & Corruption Checks : Implement and regularly perform data integrity checks to detect and resolve database corruption, ensuring data consistency and reliability.
• Standard Operating Procedures (SOPs) : Develop, maintain, and regularly update Standard Operating Procedures (SOPs) for all database administration tasks and processes.

Additional Responsibilities

Bonus Skills :

Qualifications

Minimum Education Requirements :

Minimum Experience Requirements :

Other Requirements :

Consilio's True North Values

Consilio, LLC is an EEO / Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.

Show more

Show less

Skills Required

Powershell, High Availability, Ssrs, Backup And Recovery, Disaster Recovery, Sql Server, Version Control, Security Management, Troubleshooting, Optimization, Ssis, Mssql, Performance Tuning, Capacity Planning, Ssas, Tsql, Monitoring