Software Guidance & Assistance, Inc., (SGA), is searching for an Oracle/Exadata Engineer for a right to hire assignment with one of our premier financial clients in Wilmington, DE.
Will work closely with project managers, architects, DBAs and application developers to gather requirements for testing, develop estimates for testing execution, design test approaches and manage the end-to-end life cycle of technology sponsored projects.
Will be responsible for doing pre-production performance testing/tuning of integrated Consumer Data Warehouse applications. Every major code or infrastructure changes have to be certified by performance team under production like workload before promoting it to production.
The performance team uses high-end integrated production like infrastructure testing environment for following use cases:
Certify application code Releases and note any performance impacts under production like workloads.
Verify impact of any Infrastructure changes and under production like workloads.
Validate fail-over/recovery scenario and measure any impact to response times/interruption during execution of these scenario's
Find processing ceilings to prepare organization for high volume card transaction days (like Black Friday, holiday season) or mergers.
Find opportunities to make application/infrastructure more efficient
Pinpoint the bottlenecks, memory leaks ahead of time to help increase application performance.
Accountable for Change Management, Incident and Problem management reporting and analysis, creation and maintenance of Service Level Agreements, management communication, client relationship management with assigned application areas, and/or coordination of multiple staff involved in internal/external customer file transmission implementations.
Responsible for coaching and mentoring less experienced team members as well as overall team management responsibilities.
May lead several teams that may cross project boundaries, but typically will be responsible for both deliverables and projects.
7+ years of demonstrated hands-on experience on end-to-end application development life cycle
5+ years of hands-on experience in writing, re-writing and dissecting complex SQL queries using multiple join conditions, case statements, arithmetic, aggregate functions and query tuning/optimization techniques
5+ years of experience in performance tuning
3+ years of experience using one/more scalable (MPP) relational databases such as Teradata for advanced analytics solutions.
Excellent interpersonal and analytical skills, self-motivated, quick learner and team player
Active listening skills and assertiveness in negotiating the requirements based on project needs.
Ability to work in a fast paced environment and multi-task
Experience with Exadata performance tuning
Experience with Ab Intio graphs performance tuning
Experience with Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT and Query manager
Experience with testing tools like LoadRunner, Performance Center
Experience with any monitoring tools like Sitescope, Wily Introscope
SGA is a Certified Women's Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. We encourage Veterans to apply. To view all of our available job postings and/or to learn more about SGA please visit us online at .