Overview
On Site
$$50hr - $55hr
Contract - W2
Contract - 1 day((s))
Skills
Oracle And SQL Database Administrator
Job Details
Job Description:
Pay Range: $50hr - $55hr
- The role involves supporting database functionality for applications by understanding schema, queries, and procedures.
- The Database Support Analyst will work with developers to optimize SQL queries and access patterns, ensure database design meets business and performance goals, and manage schema and objects during deployments.
- This role also supports performance tuning, release cycles, security, backup and recovery, incident response, and ongoing monitoring.
Responsibilities:
- Understand how applications use the database (schema, queries, procedures)
- Work with developers to optimize SQL queries and database access patterns
- Ensure the database design supports business functionality and performance goals
- Manage database objects such as tables, views, indexes, stored procedures, and triggers
- Apply schema changes during application upgrades or deployments
- Monitor query performance using tools such as SQL Profiler, Execution Plans, or DMVs
- Recommend and implement indexing strategies
- Assist in resolving application performance issues related to the database
- Review and execute database scripts during release cycles
- Manage roles, users, and permissions following the principle of least privilege
- Perform backup and restore operations on various databases
- Support data recovery for application-level issues and validate data integrity
- Monitor database health and respond to performance-impacting incidents
- Provide support during outages or scheduled maintenance windows
Skills:
- Strong knowledge of Oracle database concepts and 19c architecture.
- Strong knowledge of SQL database concepts and architecture.
- Strong knowledge of APEX EBS.
- Proficiency in SQL Server.
- Experience with database performance tuning and optimization.
- Familiarity with database security best practices.
- Experience with backup and recovery procedures.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration abilities.
- Experience with Oracle tools and technologies such as Oracle RAC, Data Guard.
- Experience with SSMS and Azure.
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.