01 ago
|
Gennte Technologies
|
Xico
01 ago
Gennte Technologies
Xico
**About the Role**
We are seeking a highly skilled and motivated Microsoft SQL Server DBA administration and troubleshooting along Microsoft Azure and any CI/CD and automation is most relevant to manage, optimize and automate SQL Server environments for our client (a leading US based P & C insurer).
You'll ensure database integrity, performance and security—while leveraging Azure DevOps CI/CD pipelines and scripting to support general development, test and production environments.
**Key Responsibilities**
- Administer and automate SQL Server instances (installation, configuration, upgrades, performance tuning, backup & restore).
- Automate repeatable tasks via Azure DevOps Pipelines (e.g. build/release, backups, restores, environment refreshes).
- Maintain performance and system integrity; optimize queries and server configurations.
- Enforce database security and access controls; manage permissions via self-service group structures.
- Define, enforce and document database standards and architectures.
- Review software changes for compliance with standards.
- Create and keep up-to-date architectural documentation and system design.
- Support global environments (development, test, production) and provide on-call troubleshooting as needed.
- Recommend and implement new database technologies, tools and best practices.
- Build reports, dashboards and visualizations using SQL Server reporting tools.
- Where applicable, step up to mentor colleagues and promote a continuous learning culture within the team.
**Experience & Qualifications**
- Required (Minimum):
- 5+ years of hands-on experience in Microsoft SQL Server administration including backups, restores, performance tuning, SSRS/SSIS/SSAS and scripting (PowerShell, Bash).
- Experience with Azure DevOps Pipelines and CI/CD processes for database automation and deployment.
- Familiarity with both Windows/Linux server environments.
- Exposure to cloud environments (Microsoft Azure; exposure to AWS is a plus).
- Knowledge of data warehousing concepts and working with large, complex data sets.
**Technical Skills & Tools needed**:
- Experience with Microsoft SQL Server **********+)
- Experience with SSRS, SSIS, SSAS
- Experience with Scripting: PowerShell, Bash
- Azure DevOps, Azure SQL/VM
- Performance monitoring tools (DMVs, Profiler)
- CI/CD deployment tools (DACPACs, SQL Server database projects)
- Basic Linux and Windows server administration
**Soft Skills**
- Strong problem-solving and analytical abilities
- Good communication and documentation capabilities
- Team-oriented mindset with a commitment to continuous improvement
- Ability to collaborate across global teams and time zones
- On-call support may be required as needed
**Job Types**: Full-time, Permanent
Pay: $50,****** - $70,****** per month
**Education**:
- Bachelor's (required)
**Experience**:
- SSRS/SSIS/SSAS : 5 years (required)
- Azure DevOps, Azure SQL/VM: 5 years (required)
- Linux and Windows : 5 years (required)
- Scripting: PowerShell, Bash: 5 years (required)
- CI/CD : 5 years (required)
- SQL: 5 years (required)
- SQL Server: 5 years (required)
**Language**:
- English (required)
📌 Dba Sql Server (Xico)
🏢 Gennte Technologies
📍 Xico