Senior Oracle DBA
Jobs via Dice, Austin, TX, United States
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Collaborate Solutions, Inc., is seeking the following. Apply via Dice today!
Role Title Senior DBA
Location Austin, TX
Duration 12+ Months Contract
Required Skills
Oracle DB, SQL, data modeling, SQL tuning - 12+ years of experience in implementing, administering, managing, and monitoring databases in production and non-production environments, ensuring data integrity and security.
12+ years of advanced knowledge in developing and optimizing Oracle SQL and PL/SQL code.
Proven ability to lead large, complex initiatives and performance tuning improvements, including using Explain Plan for query optimization.
Strong knowledge of Oracle internal views, functions, and architecture, including tablespace consolidation and index analysis.
Experience with Oracle 11/19c databases on Solaris/Linux systems for troubleshooting and optimization.
Proficiency in Oracle SQL Developer and Erwin Modeling tools for creating data models, including star schemas.
Experience using Agile methodologies in large development projects.
Preferred Skills
Able to work with Erwin tool for reverse engineering and create subject areas.
Able to work on AWS and its technology.
Must have good knowledge of PostgreSQL.
Responsibilities
Design, develop, and maintain database solutions and support application developers.
Collaborate with development teams and stakeholders to enhance the applications and implement new solutions.
Perform advanced database administration tasks, including performance monitoring, tuning, and providing database-related support.
Participate in Agile practices such as backlog grooming and user story development.
Provide production, development, and test environment support, including on-call support for troubleshooting.
Develop and modify Linux shell scripts to support day-to-day database administration tasks.
Advanced expertise in Oracle SQL and PL/SQL development and tuning.
#J-18808-Ljbffr
Role Title Senior DBA
Location Austin, TX
Duration 12+ Months Contract
Required Skills
Oracle DB, SQL, data modeling, SQL tuning - 12+ years of experience in implementing, administering, managing, and monitoring databases in production and non-production environments, ensuring data integrity and security.
12+ years of advanced knowledge in developing and optimizing Oracle SQL and PL/SQL code.
Proven ability to lead large, complex initiatives and performance tuning improvements, including using Explain Plan for query optimization.
Strong knowledge of Oracle internal views, functions, and architecture, including tablespace consolidation and index analysis.
Experience with Oracle 11/19c databases on Solaris/Linux systems for troubleshooting and optimization.
Proficiency in Oracle SQL Developer and Erwin Modeling tools for creating data models, including star schemas.
Experience using Agile methodologies in large development projects.
Preferred Skills
Able to work with Erwin tool for reverse engineering and create subject areas.
Able to work on AWS and its technology.
Must have good knowledge of PostgreSQL.
Responsibilities
Design, develop, and maintain database solutions and support application developers.
Collaborate with development teams and stakeholders to enhance the applications and implement new solutions.
Perform advanced database administration tasks, including performance monitoring, tuning, and providing database-related support.
Participate in Agile practices such as backlog grooming and user story development.
Provide production, development, and test environment support, including on-call support for troubleshooting.
Develop and modify Linux shell scripts to support day-to-day database administration tasks.
Advanced expertise in Oracle SQL and PL/SQL development and tuning.
#J-18808-Ljbffr