SQL Database Engineer

Key Responsibilities:

" Database Installation and Configuration:

• Install, configure, and upgrade SQL Server instances and databases.
• Implement high availability solutions such as clustering, mirroring, and log shipping.
• Configure performance monitoring and tuning tools.
  
  

" Database Maintenance and Optimization:

• Perform routine database maintenance tasks like backups, restores, and indexing.
• Monitor database performance and identify bottlenecks.
• Implement performance optimization strategies.
• Manage database space usage and storage.
• Manage user accounts and permissions.
  
  

" Troubleshooting and Problem Resolution:

• Diagnose and resolve database-related issues.
• Provide technical support to application developers and users.
  
  

" Documentation:

• Create and maintain detailed documentation of database configurations, procedures, and troubleshooting steps.
  
  

Job Summary:

As an SQL Database Engineer, you will be responsible for managing and maintaining SQL Server databases, with a focus on SQL clustering, always on, Replication and SSIS package development , troubleshooting, performance tuning, and supporting database-related projects. This role involves responding to escalated issues from L1/L2 engineers, optimizing database systems, and ensuring operational stability. You will collaborate closely with developers, system administrators, and other IT staff to resolve database issues and improve overall database efficiency.

Key Responsibilities:

• Database Administration:
• Administer, maintain, and monitor SQL Server databases.
• Perform database installations, upgrades, and patching.
• Monitor and optimize the performance of the database system by analyzing performance metrics and logs.
• Ensure database availability, scalability, and security through backup strategies and recovery processes.
• Troubleshooting:
• Act as an escalation point for L1 and L2 database issues, providing advanced troubleshooting and resolving complex database incidents.
• Investigate and resolve performance bottlenecks, deadlocks, and locking issues.
• Collaborate with developers to optimize query performance and enhance database operations.
• Performance Tuning:
• Analyze and optimize slow queries, indexes, and database configurations.
• Perform query optimization and index tuning to improve database performance.
• Use performance monitoring tools (SQL Profiler, Performance Monitor, etc.) to track and resolve performance issues.
• Backup & Recovery:
• Manage automated backup and recovery processes.
• Ensure the reliability of backup and recovery operations through regular testing.
• Implement disaster recovery strategies to minimize downtime in the event of a system failure.
• Security & Compliance:
• Implement and enforce database security measures, including access control and encryption.
• Monitor user roles and permissions to ensure proper data access.
• Ensure compliance with industry standards and internal security policies.
• Collaboration & Support:
• Collaborate with developers and application teams to support database design and query optimization.
• Work with L1/L2 support teams to resolve escalated issues.
• Communicate with stakeholders to provide status updates on database health, incidents, and performance improvements.
• Documentation:
• Maintain detailed documentation of database configurations, processes, and troubleshooting steps.
• Create and update knowledge base articles to assist L1 and L2 teams.

Key Skills & Qualifications:

• Education: Bachelor's degree in computer science, Information Technology, or related field (or equivalent experience).
• Experience: 10+ years of experience in SQL database administration, with at least 1-2 years in an L3 support or senior role.
• Certifications (preferred):
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified Solutions Associate (MCSA) in SQL Server
• Technical Skills:
• Strong experience with Microsoft SQL Server (2012, 2016, 2019, or newer).
• Proficient in T-SQL, query optimization, and performance tuning.
• Experience with database clustering, replication, and AlwaysOn availability groups.
• Hands-on experience with database backup, recovery, and disaster recovery processes.
• Knowledge of SQL Server tools (SSMS, SQL Profiler, Performance Monitor).
• Familiarity with cloud-based databases (Azure SQL, AWS RDS) is an advantage.
• Experience with scripting languages (e.g., PowerShell) for automation.
• Soft Skills:
• Strong problem-solving and analytical skills.
• Excellent communication skills to interact with both technical and non-technical stakeholders.
• Ability to work under pressure and manage multiple priorities.
• Team player with a proactive attitude.
  

Preferred Qualifications:

• Experience working in enterprise environments.
• Familiarity with NoSQL databases is a plus.
• Knowledge of data warehousing and ETL processes.