Oracle SQL DBA

Oracle SQL DBA in Detroit, MI Posted 06/17/22

• Top 25 U.S. digital financial services company committed to developing award-winning technology and services.
• Named one of the top three fastest-growing banking brands in the U.S. in 2020.
• Offers a full suite of products including mortgage lending, personal lending, and a variety of deposit and other banking products (savings, money-market, and checking accounts, certificates of deposit (CDs), and individual retirement accounts (IRAs)), self-directed and investment-advisory services, and capital for equity sponsors and middle-market companies.
• Where permitted by applicable law, must have received or be willing to receive the COVID-19 vaccine by date of hire to be considered.

• Fast paced, highly collaborative, teamwork-oriented environment
• Make an immediate impact in this high visibility role
• Ability to drive change within the organization with a focus on advancement in technology and programs
• Top-notch leadership committed to developing people

• Detroit, MI (Hybrid Schedule)

• Write SQL code in Oracle to complete comparative analysis of data from source to target to quickly identify data integrity or conversion issues.
• Work with IT mainframe team to complete and analyze current-state solutions, primarily SQL and UI review of the legacy system(s) and target application(s) data to recommend target-state, remediation solutions and enhance or develop data validation / conversion processes.
• Deliver quantity and quality results within established timeline; leverage developed SQL reporting to complete comparative analysis between the source and target data in the migration space.
• Become a subject matter expert by combining technical knowledge and business acumen, to creatively share the completion of the migration cycles and current status of the data.
• Explain the results with every-day terms rather than technical terms.
• Deliver support of the converted and merged date to enable additional functional testing success.
• Produce test cases; and execute tests within planned based upon the program deliverables; research test results when defects/bugs are found to help pinpoint root cause of data differences.
• Able to prioritize multiple aspects of the development work, data analysis, reporting enrichment and test execution to complete each aspect of the migration cycle within the established timeframes to meet business stakeholder requirements.
• Navigate through research of source data fields and profiling to provide recommendations for data governance updates and document data lineage from source to target.
• Research and help develop data clean-up strategies, data mapping documents, data migration documentation to support the movement of data for governance and controls.
• Enhance Power BI reporting to support the migration data validation results.
• Help develop reporting to support merge of migrated data in multiple phases and review/analyze the migrated data and production data during the merge process to provide evidence of successful migrations.

• High school diploma or equivalent required. Bachelors degree is preferred
• Excellent Oracle SQL Developer skills is a must with at least 3 years of experience - read, write, and execute Oracle SQL code.
• Excellence with qTest and test process experience, throughput and reporting.
• MS Office skills - proficient in Excel query building, experience in Access, understands and can write VB code.
• Business and financial services experience as well as an understanding of the need for technical review of data and data management.