What are the responsibilities and job description for the Oracle DBA position at Link Technologies?
Job Details
- JOB-7175
- Oracle DBA
- Las Vegas, NV
- C2H/Perm
- Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently seeking an Oracle Database Administrator to join our team.
JOB SUMMARY
This position will be responsible for designing, developing, testing, and deploying high-quality database solutions that align with project goals, technology architecture standards, and departmental best practices. The DBA will develop and execute database strategies, oversee enterprise-wide data architecture, manage complex data structures, and handle the daily operations of all corporate databases. This role will be in charge of creating and managing all database objects from design through deployment, leveraging expertise to design, configure, and implement database solutions and processes that optimize system availability, performance, integrity, recoverability, and supportability.
REQUIREMENTS- Bachelor's degree in a related technical field.
- Minimum five (5) years of hands-on experience as an Oracle DBA working with Oracle Database versions 10g, 11g, 12c, and 19c.
- Familiarity with the Oracle Exadata technology stack.
- Proficient in working with multiple operating systems including Microsoft Windows and Linux.
- Skilled in database backup using RMAN and RMAN Catalog.
- Experienced in using Oracle 10g, 11g, and/or 12c Data Guard.
- Knowledgeable in Oracle Enterprise Manager (OEM) Grid Control, Emrep, and OMS, as well as monitoring tools such as Toad, Spotlight, or others.
- Strong expertise in PL/SQL and UNIX/Linux Shell Scripting.
- Solid skills in SQL and PL/SQL design, development, tuning, and debugging.
- Experience in Oracle Security Administration.
- Capable of maintaining a positive attitude under high pressure and tight deadlines.
- Ability to prioritize a heavy workload with minimal supervision.
- Highly adaptable with the ability to thrive in a fast-paced, demanding environment.
- Excellent communication and interpersonal skills.
- Collaborative team player, able to work effectively with development and infrastructure teams on database design, changes, and application enhancements.
- Support for interfaces and back-end integration with applications.
- Strong troubleshooting capabilities.
- Excellent organizational and analytical skills.
- Understanding of high availability and disaster recovery concepts and solutions.
PREFERRED- Oracle Education and Certifications (OCP) are a plus.
- Experience with Oracle Streams and/or database replication is a plus.
- Security and compliance experience including encryption, audit, authentication, PCI, GLBA, SOX, etc.
- Experience in supporting Oracle RAC environments and ASM is preferred.
- Experience in data modeling and DM tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
- Understanding of or experience supporting .NET application.
RESPONSIBILITIES- Evaluate patch releases from Oracle and patching requests from development, and communicating constraints, issues, and timelines for deployment.
- Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
- Provide 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
- Provide proactive database monitoring and issue resolution
- Perform database and PL/SQL optimization including performance tuning, query optimization and supportability.
- Participate and contribute to projects involving enterprise systems enhancements.
- Perform Implementation and ongoing support of high availability architecture (standby logical/physical Data Guard, RAC, hot standby databases, etc)
- Work with development project teams to design and implement database solutions to meet business requirements.
- Participate in project design and Oracle database design decisions. Refine and troubleshoot the design.
- Create and maintain appropriate documentation about the database and the data architecture.
- Support of the nightly ETL processing
- Ensure regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports.
- Attend project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
- Develop and implement Database security polices and procedures, in line with corporate objectives
- Perform other duties as assigned
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination because of race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.
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.
