Oracle Database Administrator at Blue Chip Talent (Detroit, MI)

 RESPONSIBILITIES

• Design and execute overall database architecture strategy, standards and practices as part of a team.
• Work closely with project teams to develop data models that support business processes.
• Work with Application Development team to ensure database changes adhere to best practices and are properly prioritized and scheduled.
• Support all areas of the enterprise, ensuring all databases run at optimal performance.
• Proactively identify and troubleshoot databases performance issues.
• Ensure that industry-wide security standards are properly implemented.
• Develop and optimize complex T-SQL and PL/SQL code.
• Understand written business requirements and translate them into technical design.
• Design and develop SQL code, ETL processes and SSRS reports based on provided requirements.
• Respond to business requests in a professional manner with high sense of urgency.
• Participate in on-call rotation and occasional off-hours activities (DR tests, catalog-to-web cut overs, DBMS upgrades, etc.).

MINIMUM REQUIREMENTS

• Bachelor's degree in information technology or related field.
• 10+ years experience in data integration, data movement and database administration Proficient in the following RDBMS: SQL Server 2012-2017, basic Oracle 11g and 12c, basic Oracle RAC and basic DB2 LUW 11.1 (pureScale).
• Experience developing, troubleshooting and optimizing T-SQL and PL/SQL code, ETL/SSIS processes and SSRS reports.
• Experience performing SQL Server replication (transactional, snapshot, SQL and Oracle target).
• Proficient in installing, configuring, upgrading and patching all RDBMS listed above, as well as OLTP performance troubleshooting.

by via developer jobs - Stack Overflow