What are the responsibilities and job description for the Database Administrator (SQL Server) position at Providge Consulting?
Job Title: Database Administrator (SQL Server)
Client Industry: Information Systems
Location: Remote
Job Status: Full-time (40 hours per week), Six-month Contract (initial term). Opportunity for remote work or hybrid schedule (depending on company policy). On-call rotation for after-hours support may be required.
Job Summary:
We are seeking a skilled and detail-oriented Database Administrator (DBA) with extensive experience in managing and optimizing Microsoft SQL Server databases. The ideal candidate will have a deep understanding of database management, performance tuning, backup and recovery strategies, and security protocols. As a DBA, you will be responsible for maintaining the integrity, availability, and performance of critical databases to support business operations.
Key Responsibilities:
- Database Installation & Configuration: Install, configure, and maintain SQL Server databases, ensuring high availability and reliability.
- Database Performance Tuning: Monitor and optimize database performance, including query performance, indexing, and server resource utilization.
- Backup & Recovery: Develop and implement effective database backup and recovery strategies to ensure business continuity and minimize data loss.
- Security Management: Implement and manage security policies, user permissions, and roles to protect sensitive data and ensure compliance with industry standards.
- Troubleshooting & Issue Resolution: Provide 24/7 support for database-related issues, troubleshoot performance problems, and resolve any incidents or outages.
- Database Maintenance: Regularly perform database maintenance tasks, including updates, patches, and data integrity checks.
- Disaster Recovery: Design and implement disaster recovery procedures and ensure databases are regularly tested for recovery scenarios.
- SQL Server Upgrades: Manage and execute SQL Server upgrades and migrations, ensuring minimal downtime and system disruption.
- Automation: Develop and implement scripts to automate routine database tasks, such as backups, monitoring, and maintenance.
- Documentation & Reporting: Maintain accurate documentation for database configurations, procedures, and issues. Provide regular performance and availability reports to management.
- Collaboration: Work closely with development teams to design and implement database schemas, stored procedures, and queries that meet business requirements.
Required Qualifications:
- Proven experience as a SQL Server Database Administrator (DBA) with hands-on experience in database design, configuration, and management.
- In-depth knowledge of Microsoft SQL Server 2012 or later (installation, configuration, backup, and recovery).
- Strong understanding of database security principles, including encryption, user access control, and compliance requirements.
- Experience with performance tuning and query optimization.
- Proficient in SQL scripting and automation (T-SQL, PowerShell).
- Experience with high availability solutions, such as Always On Availability Groups, Database Mirroring, or Replication.
- Strong troubleshooting skills and experience resolving complex database issues.
- Familiarity with database monitoring and diagnostic tools (e.g., SQL Profiler, SQL Server Management Studio, and third-party monitoring tools).
- Experience with cloud-based databases and hybrid environments (e.g., Azure SQL Database, SQL Server on virtual machines) is a plus.
Preferred Qualifications:
- Microsoft SQL Server certifications (MCSA, MCSE) or similar certifications.
- Knowledge of data warehousing and ETL processes.
- Familiarity with other database platforms (e.g., MySQL, PostgreSQL, Oracle).
- Experience in scripting and automation using PowerShell, Batch, or similar tools.
- Ability to work in a fast-paced environment and handle multiple tasks simultaneously.
- Strong communication and interpersonal skills.
