Role: SQL Server DBA with Java Knowledge
Location: New York, NY (4 days Onsite per week/Hybrid)
Duration: Long-term Contract
Employment Type: W2
Domain: Preferred exp. with Banking, financial services, capital markets, or fintech
Job Description:
We are seeking an experienced SQL Server Database Administrator (DBA) with strong expertise in Microsoft SQL Server database administration and working knowledge of Java applications. The ideal candidate will be responsible for database installation, configuration, performance tuning, maintenance, troubleshooting, and ensuring database availability, security, and reliability.
The candidate should also have experience working closely with Java development teams to support database integrations, troubleshoot application-related database issues, and optimize SQL queries for enterprise-scale applications. Experience in financial services or banking environments is highly preferred.
Key Responsibilities
- Install, configure, administer, and maintain Microsoft SQL Server databases in enterprise environments.
- Perform database performance monitoring, query optimization, indexing, and execution plan analysis.
- Troubleshoot database issues, deadlocks, blocking, connectivity, and performance bottlenecks.
- Manage database backups, restoration, disaster recovery, and high availability solutions.
- Work with Always On Availability Groups, replication, clustering, and failover mechanisms.
- Perform database upgrades, patching, migrations, and capacity planning.
- Develop, review, and optimize complex SQL queries, stored procedures, functions, and triggers.
- Collaborate with Java development teams to support database connectivity and application integration.
- Troubleshoot Java application-to-database issues, including JDBC connectivity, connection pooling, transaction management, and SQL-related errors.
- Work with developers to identify and resolve performance issues involving Java applications and SQL Server databases.
- Ensure database security, access controls, auditing, and compliance with enterprise standards.
- Participate in production support, incident management, root cause analysis, and change management processes.
- Maintain database documentation and follow established operational procedures.
