COMPANY OVERVIEW:
This is a leading operations management and analytics company that helps businesses enhance growth and profitability. The company integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance.
The Analytics Practice provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. The company takes an industry-specific approach to transform clients’ decision making and embed analytics more deeply into their business processes. The global footprint of nearly 10,000 data scientists and analysts serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries.
This US based company has more than 58,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa.
POSITION OVERVIEW:
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 a 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 global development, test and production environments.
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
PREFERRED PROFILE:
- 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 (2012–2019+)
- 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
LOCATION: Remote in USA or Canada
Job ID# 3405384
Artemis invites you to subscribe to our free Job Alerts and “The Hunt” Blog for free insights on hiring and career development.
Artemis Referral Bonus – $500! If you know someone for this job, please join our Referral Bonus Program.