Senior Database Administrator - MSSQL
- Hiring from
- Philippines
- Work type
- Remote
- Posted
623,897 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
|
ROLE OVERVIEW |
The Senior SQL Database Administrator ensures the reliability, security, and performance of MS SQL database systems in 24/7 environments, optimizing for scalability and high availability. This role designs cloud database architectures, enforces compliance, drives performance tuning, and collaborates with stakeholders to align database strategies with business needs.
|
SPECIFIC DUTIES AND RESPONSIBILITIES |
- Ensure the smooth implementation, administration, maintenance, and support of Microsoft SQL Server database environments across development, test, and production systems
- Provide 24x7 production support for SQL Server databases, including incident response, troubleshooting, root cause analysis, and issue resolution
- Monitor and optimize SQL Server performance by analyzing query execution plans, indexing strategies, database workloads, and system resource utilization to ensure high availability and reliability
- Configure, maintain, and test database backup, recovery, disaster recovery (DR), and high availability (HA) solutions, including Always On Availability Groups, Failover Clustering, and Log Shipping
- Perform database patching, upgrades, migrations, and capacity planning activities while minimizing downtime and operational impact
- Collaborate with security and compliance teams to implement and maintain database security controls, including user access management, encryption, auditing, and compliance with regulatory standards
- Develop, maintain, and enforce database governance standards, naming conventions, configuration baselines, and operational procedures
- Create and maintain technical documentation, including database architecture diagrams, operational runbooks, recovery procedures, and troubleshooting guides
- Work closely with application development teams, business stakeholders, and infrastructure teams to gather requirements and design scalable, secure, and high-performing SQL Server database solutions
- Implement database monitoring and alerting solutions to proactively identify performance issues, storage concerns, replication failures, and availability risks
- Manage and optimize SQL Server Agent jobs, maintenance plans, data imports/exports, and automation scripts using T-SQL and PowerShell
- Stay current with emerging SQL Server technologies, best practices, cloud database platforms (Azure SQL, Managed Instance), and recommend improvements to enhance database operations and efficiency
- Support capacity planning and forecasting by analyzing database growth trends, storage utilization, and infrastructure requirements to ensure optimal resource allocation
|
COMPETENCIES |
Core Competencies (Must-have Competencies)
- Microsoft SQL Server Administration: Ability to install, configure, administer, troubleshoot, patch, upgrade, secure, and optimize Microsoft SQL Server environments to ensure high availability, reliability, and performance of enterprise database platforms
- Database Performance Tuning and Optimization: Ability to analyze and resolve performance issues through query tuning, index optimization, execution plan analysis, resource monitoring, and database configuration improvements
- High Availability and Disaster Recovery (HA/DR): Ability to design, implement, manage, and support SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), replication, backup strategies, and disaster recovery solutions to ensure business continuity
- Backup, Recovery, and Data Protection: Ability to develop, manage, and validate backup and recovery strategies, perform database restores, and ensure data integrity, recoverability, and compliance with organizational requirements
- Database Security and Compliance: Ability to implement and manage database security controls, including authentication, authorization, encryption, auditing, vulnerability remediation, and adherence to security and compliance standards
- Scripting and Automation: Ability to leverage T-SQL, PowerShell, Python, and automation tools to streamline database administration, maintenance, monitoring, deployment, and operational processes
- Database Monitoring and Troubleshooting: Ability to proactively monitor database health, identify performance bottlenecks, analyze system metrics, and resolve complex database, application, and infrastructure-related issues
- Cloud and Hybrid Database Technologies: Ability to support and manage database platforms across on-premises and cloud environments, including Microsoft Azure SQL solutions and hybrid database architectures
- Infrastructure and Platform Integration: Ability to work with Windows Server, virtualization platforms, storage systems, networking, and enterprise infrastructure components that support SQL Server environments
- Analytical Problem-Solving and Technical Leadership: Ability to analyze complex database incidents, identify root causes, implement sustainable solutions, provide technical guidance to junior DBAs, and lead database-related initiatives and projects
Complementary Competencies (Good-to-have Competencies)
- Enterprise Database Platform Support: Ability to support and administer database environments across Windows and Linux platforms, including Microsoft SQL Server on Red Hat Enterprise Linux (RHEL), and leverage automation tools such as Ansible for database deployment, configuration management, and operational efficiency
- Operational Resilience and Change Management: Ability to follow ITIL-based change management practices, operate effectively within 24x7 and on-call support environments, adapt to changing business priorities, and participate in disaster recovery and business continuity activities
- Collaboration, Communication, and Documentation: Ability to work independently and collaboratively across infrastructure, application, cloud, and development teams; communicate complex technical concepts clearly to technical and non-technical stakeholders; manage competing priorities; and maintain accurate technical and operational documentation
- Multi-Database Platform Exposure: Familiarity with additional database technologies such as Oracle, PostgreSQL, MySQL, enabling effective collaboration within diverse enterprise database environments
|
QUALIFICATIONS |
Educational Qualification/s
Required:
- Bachelor’s Degree in Computer Science, Information Technology, Engineering, or related fields
Preferred:
- Experience supporting 24x7 enterprise database environments.
- Experience mentoring junior DBAs and leading database-related projects and initiatives.
Professional Qualification/s
- 5+ years of experience administering Microsoft SQL Server in enterprise production environments
- Strong experience with High Availability and Disaster Recovery technologies, including Always On Availability Groups, Failover Clustering, Replication, and Log Shipping
- Expertise in SQL Server performance tuning, query optimization, indexing, and database monitoring
- Experience with database backup, recovery, maintenance, patching, upgrades, and migrations
- Proficiency in T-SQL, PowerShell, and database automation
- Experience designing and supporting secure, scalable, and highly available SQL Server environments
- Strong understanding of database security, encryption, auditing, and compliance requirements
- Experience with cloud and on-premises SQL Server migration projects
- Knowledge of capacity planning, storage management, and database resource optimization
- Strong analytical, troubleshooting, and problem-solving skills in mission-critical environments
- Excellent communication and collaboration skills with cross-functional teams and stakeholders
- Experience supporting 24x7 production environments and working within change management processes
Work Conditions
- Work from Home
Work Schedule:
- 24x7 Rotational Support - Must be amenable to be assigned to any of the shifts below:
- Morning: 8AM-5PM PHT / 10 AM-7PM PHT
- Mid: 12PM-9PM PHT
- Night: 8PM-5AM PHT / 10 PM-7AM PHT
On-Call Requirements:
- Occasional overtime, weekend, and on-call support may be required based on operational or project needs