Teamware Solutions is seeking a highly skilled SQL Server Database Administrator (DBA) to manage, maintain, and optimize our critical SQL Server environments.
You'll be responsible for ensuring the high availability, performance, and security of our databases, playing a vital role in our data infrastructure.
This position is ideal for an experienced DBA who thrives on optimizing complex database systems and safeguarding valuable data.
Key Responsibilities
- Database Management & Maintenance:
- Install, configure, and maintain SQL Server instances across various versions and environments (on-premises and cloud).
- Perform regular database backups, restores, and ensure disaster recovery readiness.
- Implement and manage database security, including user permissions, roles, and encryption.
- Conduct routine database health checks, monitoring, and maintenance tasks such as indexing and integrity checks.
- Performance Tuning & Optimization:
- Monitor database performance, identify bottlenecks, and implement solutions for performance tuning.
- Optimize SQL queries, stored procedures, and database schemas for improved efficiency.
- Analyze and troubleshoot complex database-related issues, ensuring minimal downtime.
- High Availability & Scalability:
- Implement and manage high availability solutions like AlwaysOn Availability Groups, Clustering, and Replication.
- Plan and execute database scaling strategies to support growing data volumes and user loads.
- Troubleshooting & Support:
- Provide expert-level support for all SQL Server database issues, responding to incidents and requests in a timely manner.
- Work closely with development and infrastructure teams to resolve database-related application problems.
- Documentation & Best Practices:
- Create and maintain comprehensive documentation for database configurations, processes, and procedures.
- Ensure adherence to industry best practices and internal standards for database administration.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a SQL Server Database Administrator.
- Strong expertise in SQL Server versions (e.g., 2016, 2019, 2022) and their features.
- In-depth knowledge of T-SQL programming, stored procedures, functions, and triggers.
- Experience with performance monitoring and tuning tools for SQL Server.
- Familiarity with Windows Server administration as it pertains to SQL Server.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently and collaboratively in a fast-paced environment.
Preferred Skills
- Experience with cloud database services (e.g., Azure SQL Database, AWS RDS for SQL Server).
- Knowledge of PowerShell scripting for database automation.
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or similar.
- Experience with data warehousing and ETL processes.
Skills Required
Database Management, Database Administration, Performance Tuning, Sql Queries, T-sql, Windows Server