SQL Development
Description
Position Overview The Database Administrator is responsible for designing, managing, optimizing, and securing enterprise database platforms with a strong focus on Microsoft SQL Server and Azure-based database services. This role ensures high availability, performance, and scalability of mission-critical systems across on-premises and cloud environments. This position emphasizes proactive performance monitoring, tuning, and optimization, leveraging modern observability tools and best practices to support high-volume transactional systems and data-driven applications. The DBA partners closely with DevOps, development, and infrastructure teams to support cloud-first strategies and continuous improvement initiatives. The role also supports operational excellence through ServiceNow-based incident and change management processes and participation in an on-call rotation supporting production systems.
Key Responsibilities Cloud & Platform Management:
- Administer and support Azure SQL Database, Azure Managed Instance, and SQL Server (on-prem & cloud) environments
- Design and implement high availability and disaster recovery (HA/DR) solutions (Always On Availability Groups, geo-replication)
- Support cloud migration initiatives, including database modernization and re-platforming efforts
- Manage hybrid environments integrating on-prem SQL Server with Azure services
Performance Monitoring & Optimization:
- Proactively monitor database performance using tools such as Azure Monitor, Query Store, Extended Events, and third-party tools (e.g., Redgate, AppDynamics)
- Diagnose and resolve performance issues including query tuning, indexing strategies, blocking, deadlocks, and resource contention
- Establish performance baselines and implement continuous optimization strategies
- Collaborate with development teams to optimize SQL code and database design
Database Administration & Operations:
- Install, configure, patch, and maintain SQL Server instances across environments (dev, test, prod)
- Manage backup, recovery, and data retention strategies using native and cloud-native solutions (Azure Backup, automated backups)
- Ensure database security, encryption, and compliance standards are enforced (TDE, auditing, role-based access)
- Automate administrative tasks using PowerShell, T-SQL, and Azure automation tools
Data Architecture & Integration:
- Support schema design and data modeling aligned with business requirements
- Assist with data integration and ETL processes across systems and platforms
- Develop and execute data migration strategies with minimal downtime
- Ensure data integrity, consistency, and governance across systems
Monitoring, Incident Management & Support:
- Implement and maintain database monitoring and alerting systems
- Triage and resolve performance and data issues in collaboration with internal teams and vendors
- Provide Tier 2/3 support for database-related incidents through ServiceNow, ensuring:
- Timely response, troubleshooting, and resolution of incidents
- Accurate and complete ticket documentation, including root cause and remediation steps
- Adherence to SLA and escalation procedures
- Support and execute change management processes via ServiceNow, including proper risk assessment, documentation, and validation
- Maintain clear and thorough documentation of database environments, standard operating procedures, and knowledge base articles
On-Call & Operational Support:
- Participate in a rotational on-call schedule to support production database environments
- Respond to after-hours alerts, incidents, and critical system issues, ensuring timely resolution and communication
- Perform incident triage, root cause analysis, and post-incident reviews for production issues
- Collaborate with application, infrastructure, and DevOps teams during high-severity incidents
- Identify recurring issues and implement proactive fixes and automation to reduce operational load
Required Qualifications:
- 5+ years of experience in database administration with a strong focus on Microsoft SQL Server
- Proven experience supporting Azure SQL platforms or cloud-based database environments
- Strong expertise in performance tuning, query optimization, and monitoring
- Hands-on experience with HA/DR solutions (Always On, replication, backup/recovery strategies)
- Advanced SQL skills including complex queries, indexing, transactions, and execution plan analysis
- Experience with PowerShell scripting and automation
- Experience working within ServiceNow or ITSM-based incident and change management processes
- Knowledge of Windows Server and/or Linux environments
- Strong understanding of database security, access control, and compliance standards
- Experience with monitoring tools such as Azure Monitor, Redgate, AppDynamics, or similar
Preferred / Nice-to-Have Skills:
- Experience with MariaDB, PostgreSQL, or other non-Microsoft database platforms
- Experience with cloud-native architecture and DevOps practices (CI/CD, Infrastructure as Code)
- Familiarity with data platforms (SSIS, SSRS, SSAS or modern Azure equivalents such as ADF, Synapse, Fabric)
- Experience supporting 24x7 production environments with on-call responsibilities
- Azure certifications such as Azure Database Administrator Associate (DP-300)
Soft Skills:
- Strong problem-solving and analytical mindset with a focus on root cause analysis
- Excellent communication skills, including clear updates during incidents and thorough documentation
- Detail-oriented with strong documentation and ServiceNow ticket hygiene practices
- Ability to manage multiple priorities in a fast-paced, production support environment
Skills
Sign in to read and join the discussion.