SQL Database Administrator

Job description:

Job Title: SQL Database Administrator (DBA)

Job Overview:

We are seeking a highly skilled and experienced SQL Database Administrator (DBA) to join our growing team. The ideal candidate will be responsible for managing and optimizing SQL Server databases, ensuring their reliability, security, and performance. As a key member of our IT team, you will support the organization's database infrastructure, working closely with developers, IT staff, and management to provide database solutions and ensure smooth operations.

Key Responsibilities:

• Database Management & Maintenance:
• Administer, configure, and maintain SQL Server databases (including version upgrades, patching, backups, restores, and replication).
• Monitor and optimize database performance, ensuring high availability, reliability, and scalability.
• Ensure regular database health checks, maintenance, and tuning to achieve peak performance.
• Backup and Recovery:
• Implement and manage backup strategies to ensure data recovery and protection against data loss.
• Test and validate recovery procedures for disaster recovery planning.
• Security Management:
• Implement and manage database security policies, including user access control, roles, and permissions.
• Ensure compliance with data privacy and security standards (e.g., GDPR, HIPAA).
• Performance Optimization:
• Conduct performance tuning of SQL queries and database configurations to enhance performance.
• Analyze execution plans, troubleshoot long-running queries, and optimize them for improved efficiency.
• Database Monitoring:
• Use monitoring tools to proactively identify issues, ensure database uptime, and resolve performance bottlenecks.
• Respond promptly to database-related incidents and resolve them with minimal impact to users.
• Collaboration and Support:
• Work closely with developers, system administrators, and other IT staff to design and implement database solutions.
• Provide technical support and troubleshooting expertise for SQL-related issues.
• Documentation and Reporting:
• Maintain up-to-date documentation of database configurations, standards, and procedures.
• Generate reports on database performance, usage, and health for internal stakeholders.

Qualifications:

• Education:
• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Experience:
• Proven experience as an SQL Database Administrator, with at least [X] years of experience in database management.
• Strong experience with SQL Server (versions 2008 and above).
• Familiarity with database replication, clustering, and high availability setups (e.g., AlwaysOn Availability Groups).
• Technical Skills:
• Strong knowledge of T-SQL, SQL Server Management Studio (SSMS), SQL Server Agent, and other database management tools.
• Experience with database performance tuning and query optimization.
• Proficiency in backup and recovery strategies, including high availability and disaster recovery techniques.
• Familiarity with monitoring and automation tools (e.g., Redgate, SolarWinds, SQL Profiler).
• Experience with database security management, including encryption and access controls.
• Soft Skills:
• Excellent problem-solving and analytical skills.
• Strong attention to detail with the ability to work under pressure and meet deadlines.
• Excellent communication and teamwork skills.

Preferred Qualifications:

• Experience with other relational databases (e.g., MySQL, PostgreSQL) is a plus.
• Certification in SQL Server (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: SQL Server) is a plus.
• Knowledge of cloud-based databases (e.g., Azure SQL, AWS RDS) is beneficial.

Benefits

• 100% Remote / WFH setup
• Competitive compensation package
• Company-issued equipment & peripherals
• 13th Month Pay7th Month Bonus
• Paid Time Off