We’re passionate about designing and delivering top-notch digital experiences for our clients — and their customers — and helping them create efficiencies using data and technology. But what’s most important about us is that we have a diverse team of experts all dedicated to getting clients from goals to outcomes — and that’s where you come in.
As a SQL Server Database Administrator, you’ll be joining our team of talented experts. The right candidate will possess the following experience:
Overview:
- The Senior SQL Server Database Administrator (DBA) will play a critical role in ensuring the optimal performance, reliability, and security of the client organization's SQL Server databases. This position will involve supporting both SQL Server 2019/2022 on-prem and Azure Cloud environments, optimizing stored procedures, developing and maintaining SSIS Jobs, SSRS reports, troubleshooting application data related issues, and optimizing database performance.
Responsibilities:
Database Administration:
- Manage and maintain multiple SQL Server databases hosted on-prem and in Azure Cloud (IaaS).
- Perform routine database maintenance tasks, including backups, restores, and indexing.
- Ensure database security by implementing and maintaining appropriate security measures.
- Monitor database health and performance, identifying and resolving issues promptly.
SSIS and SSRS Development:
- Develop, test, and deploy SSIS packages for data integration and ETL processes.
- Maintain and optimize existing SSIS jobs.
- Troubleshoot and resolve SSIS-related issues.
- Assist with consolidating and maintaining the SSRS Reports.
Performance Optimization:
- Analyze database performance and identify bottlenecks.
- Implement strategies to optimize database performance, such as indexing, query tuning, and hardware upgrades.
- Monitor for deadlocks and blocking issues in shared databases and take appropriate corrective actions.
Troubleshooting:
- Collaborate with application teams to troubleshoot and resolve data integration related issues.
- Investigate and resolve database errors and performance problems.
- Assists developers with complex query tuning and schema refinement.
Cloud SQL Server Administration:
- Assist in the scaling of SQL Server databases hosted on Azure Cloud environments (IaaS) and On-Prem.
- Ensure the smooth operation of databases On-Prem and the cloud environment.
Qualifications:
- 8+ years of hands-on experience with SQL Server database administration.
- Strong knowledge of SQL Server database concepts, architecture, and best practices.
- Experience with SSIS and SSRS development and maintenance.
- Experience with PowerShell scripting.
- Knowledge of data warehousing and ETL concepts.
- Experience with database replication and high availability solutions.
- Experience with scaling SQL Server 2019 and 2022 in Azure and On-Prem.
- Proven ability to troubleshoot and resolve database performance issues.
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal skills.
- Certification in Microsoft SQL Server Administration
More about G2O
We’re different than other companies at G2O. We blend the research and design, technology, and data expertise to deliver the solutions our clients crave — and we do all of this as one in-house team, from vision to execution. We’re also the largest company of our kind
based in Ohio to do this — and have been evolving how we do it for 40
years.
Individually, we bring a wealth of experience from diverse backgrounds — personally and in business. We’re a diverse and passionate team of leaders and experts in technology, data,
analytics, design, content, and more. But we think we’re best when we put our minds together. Each person brings something distinct to our team — some unique flavor to their background or their experience. That makes for stronger collaboration — and elevates the outcomes for our clients.
Are you ready to collaborate to greatness with us?
- Learn more at G2O.com/careers