Highlights
Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures. " Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
Numbers & Facts
| Location | Aurora, IL |
| Industry | Computer/IT Services |
| Company Size | 500 to 999 employees |
| Year Founded | 1990 |
| Website | http://q1tech.com/ |
Description
Must Have Technical/Functional Skills
" Strong hands-on experience in Oracle SQL and PL/SQL development.
" Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries.
" Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting.
" Experience working with large-volume transactional databases and complex data structures.
" Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
" Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL.
" Ability to analyze business requirements and translate them into technical/database solutions.
" Experience with Unix/Linux and Shell Scripting.
" Familiarity with Git, JIRA, and Agile development methodologies.
" Experience in Banking, Financial Services, or Capital Markets is preferred.
" Strong analytical, debugging, and problem-solving skills.
Roles & Responsibilities
Design, develop, test, and maintain complex Oracle SQL and PL/SQL components.
Develop and enhance procedures, packages, functions, triggers, views, and database scripts.
Analyze and optimize complex SQL queries to improve application and database performance.
Perform query tuning, execution-plan analysis, indexing, and database performance optimization.
Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions.
Support data extraction, transformation, validation, reconciliation, and migration activities.
Troubleshoot application/database issues and perform root-cause analysis.
Support UAT, production deployments, release activities, and post-production validation.
Participate in code reviews and ensure adherence to database development standards and best practices.
Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures.
Track development activities, defects, and deliverables through JIRA.
" Strong hands-on experience in Oracle SQL and PL/SQL development.
" Expertise in developing stored procedures, packages, functions, triggers, cursors, views, and complex SQL queries.
" Strong knowledge of SQL performance tuning, including execution plans, indexing, query optimization, and troubleshooting.
" Experience working with large-volume transactional databases and complex data structures.
" Strong understanding of Oracle database concepts, relational data models, joins, constraints, and database objects.
" Experience in data analysis, data validation, reconciliation, and data migration using SQL/PLSQL.
" Ability to analyze business requirements and translate them into technical/database solutions.
" Experience with Unix/Linux and Shell Scripting.
" Familiarity with Git, JIRA, and Agile development methodologies.
" Experience in Banking, Financial Services, or Capital Markets is preferred.
" Strong analytical, debugging, and problem-solving skills.
Roles & Responsibilities
Design, develop, test, and maintain complex Oracle SQL and PL/SQL components.
Develop and enhance procedures, packages, functions, triggers, views, and database scripts.
Analyze and optimize complex SQL queries to improve application and database performance.
Perform query tuning, execution-plan analysis, indexing, and database performance optimization.
Work closely with Business Analysts, application developers, QA, and business teams to understand requirements and deliver database solutions.
Support data extraction, transformation, validation, reconciliation, and migration activities.
Troubleshoot application/database issues and perform root-cause analysis.
Support UAT, production deployments, release activities, and post-production validation.
Participate in code reviews and ensure adherence to database development standards and best practices.
Maintain technical documentation covering database designs, data flows, implementation details, and production-support procedures.
Track development activities, defects, and deliverables through JIRA.
About Company
Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.
Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.
