Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Patch Infotech

NewBe an early applicant

SQL Development

Posted Updated

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

Apply

See also