We are seeking a skilled SQL DBA to manage and optimize our SQL Server environments. The ideal candidate will have extensive experience in SQL Server upgrade, migration, performance tuning, and security management. You will be responsible for ensuring high availability, reliability, and performance of our databases while supporting both production and development environments.
Key Responsibilities
Database Upgrade & Migration
- Manage upgrades from older SQL Server versions to newer releases.
- Execute SQL Server and database migrations, including on-premises to cloud transitions.
- Install SQL Server service packs and updates.
- Perform database installations and configurations, including Always On availability groups and failover clustering.
Performance Optimization & Troubleshooting
- Optimize SQL queries and T-SQL for performance.
- Troubleshoot and resolve application slowness and performance issues.
- Implement system design recommendations based on Microsoft SQL Server best practices.
Database Administration
- Oversee database backups, recovery, and maintenance.
- Monitor logs, disk usage, and configure routine job activities.
- Handle database performance monitoring and manage job failures, backup issues, and resource utilization.
Security & Access Management
- Implement SQL Server security protocols and manage database permissions.
- Create and manage database users, ensuring appropriate access and addressing security concerns.
Advanced SQL Server Concepts
- Utilize advanced features such as Mirroring, Log Shipping, Clustering, and Always-On.
- Configure and manage SQL Server Agent jobs, maintenance plans, and monitoring tools.
System Analysis & Design
- Facilitate brainstorming sessions to analyze and evaluate business systems and user needs.
- Develop strategies for database design, integrity, and data storage management.
Data Management
- Manage data export, import, and mass data loads.
- Monitor and resolve data lock issues.
- Analyze and generate statistics for tables, indexes, memory, locks, and database response times.
Secondary Skills
- Proficiency in SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
- Knowledge of PowerShell scripting for automation and management tasks.
Requirements
- Proven experience in SQL Server upgrade, migration, and performance optimization.
- Strong expertise in database administration, including backups, recovery, and security.
- Experience with advanced SQL Server concepts and tools.
- Ability to work in production (24x7) and development environments.
- Familiarity with SSIS, SSRS, and PowerShell scripting is a plus.
Why HTC Global Services?
- Be part of a dynamic team driving technological innovation.
- Enjoy a supportive environment with opportunities for career growth.
- Access a comprehensive benefits package that supports your well-being and professional development.
Apply Today
Join us at HTC Global Services and take your career to the next level. Apply now and be part of our journey towards technological excellence and client success.