Application and Database support BOSTON MA ONSITE

Job Description

Job Description

Job Role : Application and Database support

Location : Boston MA (onsite)

Job Type : W2 Only

Mandatory skills: SQL, Oracle, Postgres SQL, MongoDB

Visa type : Any Visa

Experience: 4+ years

Job description

• Administer, maintain, and optimize SQL Server environments, with exposure to Oracle, PostgreSQL, and MongoDB.
• Handle database installation, configuration, patching, upgrades, and migrations across on-prem and AWS Cloud (EC2/RDS).
• Implement and maintain backup, recovery, and disaster recovery (HA/DR) strategies.
• Conduct performance tuning, query optimization, and index management to improve database efficiency.
• Collaborate with application and infrastructure teams for release deployments, environment refreshes, and configuration management.
• Troubleshoot complex issues impacting applications or infrastructure and provide root cause analysis.
• Automate recurring tasks and monitoring using PowerShell, Python, or scripting tools.
• Manage security, user access, audit trails, and compliance reporting.
• Work closely with developers and DevOps teams to ensure smooth CI/CD integration and database change management.
• Maintain accurate runbooks, documentation, and operational dashboards.

Skills & Experience

• Core Expertise: Microsoft SQL Server (2016+), Always On, Replication, Backup/Restore, Performance Tuning, SSIS/SSRS.
• Additional Exposure: Oracle, PostgreSQL, MongoDB, AWS RDS, AWS EC2, and Aurora.
• Experience working with both application teams (for deployments, schema changes) and infrastructure teams (for performance, patching, monitoring).
• Familiarity with automation and monitoring tools such as CloudWatch, DataDog, SolarWinds, or similar.
• Strong understanding of security, HA/DR, backup policies, and ITIL processes.
• Excellent problem-solving and communication skills with experience in enterprise or managed service environments.