Job Description
Job Overview:
Devonshire Recruiting & Consulting Partners is actively seeking a skilled SQL Server DBA to join a fast-paced team that is redefining the role of networks to enable greater bandwidth, capacity, efficiency, and ease of deployment. In this position, youll maintain and optimize database environments, ensuring high availability, performance, and reliability. Your work will impact critical aspects of our operations, making you an essential part of our team.
Key Responsibilities:
- Manage multiple database environments, monitor performance, and implement updates, maintenance, patches, and fixes.
- Maintain high availability in the production environment and oversee database replication to the disaster recovery site.
- Collaborate with developers and QA teams to design and optimize database environments.
- Diagnose and resolve database-related errors and performance issues across various application environments.
- Develop database deployment plans and scripts for application rollouts.
- Design and maintain database reporting infrastructure.
- Execute database administration tasks, including installation, configuration, monitoring, space management, backup and recovery, and disaster recovery procedures.
- Plan and execute database server upgrades and migrations.
- Review and optimize stored procedures and scripts, providing recommendations for schema, indexing, maintenance, and deployment improvements.
Qualifications:
- Bachelors degree in Computer Science, Computer Engineering, or related fields.
- 5-8+ years of professional experience in Microsoft SQL Server database administration in an enterprise-level setting.
- Strong understanding of Relational Databases, T-SQL Scripting, database normalization, and related concepts.
- Experience in database design within a Software Development environment.
- Proficiency in Performance Tuning and Optimization, including the use of native monitoring and troubleshooting tools.
- Competence in database backups, restores, and recovery models.
- Familiarity with Windows server environments.
- Knowledge of High Availability (HA), replication, and Disaster Recovery (DR) options for SQL Server.
- Ability to multitask effectively and work independently.
- Strong written and verbal communication skills.
- Proven experience in troubleshooting and resolving database integrity and performance issues.
- Expertise in Performance Tuning and Query Optimization.
- Familiarity with SSIS, SSRS, or SSAS.
Your application will stand out if you possess the following:
- Experience with SAP (Sybase) SQL Anywhere database system management.
- Administrator experience with Team Foundation Server and SharePoint server.
- Proficiency in one of the following Scripting languages: Python, PowerShell, Bash, or Shell Script.
- Familiarity with monitoring and logging services such as Elasticsearch, Wavefront, Uptime, Solarwinds, etc.
Please note that applicants must be authorized to work for any employer in the U.S., and we are unable to sponsor or take over sponsorship of an employment Visa at this time.
#ZR