SQL DBA Consultant

2 days ago

New York, United States Smart IT Frame LLC Full-time
Job Role: SQL DBA Consultant

Location:
New York City, NY (Hybrid) Mode of Hiring: Contract Mandatory

Skills:
• Microsoft SQL DBA with full stack skill (Java, Dot net, python anything) but should be knowing Angular/React, MS SQL Server, MySQL

Job Description
Role Summary We are looking for a strong SQL DBA with extensive experience in database administration performance tuning high availability backup recovery and production support. The candidate should be comfortable supporting business critical enterprise applications in highly available environments Java development application support experience is a plus

Key Responsibilities
• Install configure administer patch and upgrade Oracle databases across production and nonproduction environments
• Perform SQL database performance tuning query optimization indexing execution plan analysis and capacity management
• Manage Oracle RAC Data Guard ASM RMAN backup recovery database cloning and disaster recovery activities
• Monitor database health troubleshoots production incidents and performs root cause analysis
• Ensure database availability security integrity and performance for mission critical applications
• Support database migrations upgrades patching refreshes and release deployment activities
• Automate routine DBA activities using Shell Python scripting where applicable
• Collaborate with application infrastructure DevOps and production support teams
• Provide support for enterprise applications with strong focus on stability, resiliency and operational excellence Required Skills
• Strong Hands-on experience as an Oracle DBA preferably supporting large enterprise production environments
• Strong expertise in Oracle Database RAC Data Guard ASM RMAN OEM and database performance tuning
• Excellent understanding of SQL PLSQL query optimization indexing execution plans backup and recovery
• Experience with troubleshooting database performance and production issues
• Good understanding of Linux Unix environments and scripting
• Experience working with high availability and disaster recovery environments