Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)
No Travel Required
Skills
Oracle
AWS
Query Optimization
***Must have Grafana
Python***
SQL Server DBA (SQL Server 2016 or newer).
index management
and server performance tuning.
troubleshoot query performance using execution plans
SQL Profiler
and DMVs.
SQL Server and Oracle databases.
SQL Server
SQL Server Replication
T-SQL
PL/SQL
Python
RDS
DMS
EC2
CloudWatch
S3
Grafana
Performance Tuning
Index Optimization
Shell Scripting
Database Automation
Job Details
Requirements:
- 12 or more years of experience in SQL Server DBA roles including replication setup and performance tuning.
- Proficiency in T-SQL and advanced index/query optimization techniques.
- Experience in SQL Server replication (transactional, snapshot, merge, peer-to-peer).
- Experience with Python scripting for automation and task orchestration.
- Experience in AWS database services (RDS, DMS, CloudWatch, EC2, S3).
- Experience with Oracle administration and SQL/PLSQL.
- Excellent communication skills for cross-team collaboration.
Responsibilities:
- Manage and optimize SQL Server environments with a focus on replication performance.
- Build and maintain Grafana dashboards to monitor key database and replication metrics.
- Troubleshoot replication latency, sync failures, and conflict issues across systems.
- Apply patches and perform upgrades on SQL Server and Oracle platforms.
- Create and maintain schema objects such as tables, indexes, and stored procedures.
- Handle cross-platform data replication workflows between SQL Server and Oracle.
- Support planning and execution of disaster recovery and high availability strategies.
Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting-edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.
Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
For more information about Resourcesoft and our services, please visit our website.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.