Senior Oracle DBA #28298 | SunGard | US-IL-Lombard-377 E. Butterfield Rd.; US-MO-Kansas City-2300 Main St

Senior Oracle DBA #28298 | SunGard | US-IL-Lombard-377 E. Butterfield Rd.; US-MO-Kansas City-2300 Main St

Senior Oracle DBA

Job ID #: 28298	Location: US-IL-Lombard-377 E. Butterfield Rd.; US-MO-Kansas City-2300 Main St.
Functional Area: Information Technology	Department: Operations - IT
Position Type: Full-Time Regular	Education Desired: Bachelors Degree or equivalent
Relocation Provided: No	Experience Desired: At least 5 years
Travel Percentage: 0

Position Responsibilities •Responsible for all functions associated with database administration, management, and support of the Oracle databases. •Install and maintain Oracle databases including security, back-up, logging, reporting, trouble shooting, and recovery procedures •Assist with tuning complex application SQL queries with multi level joins.  Some queries created by code generator software. •Work closely with production support teams monitoring and troubleshooting database processes. •Work closely with other DBA team members to manage all technical aspects of database management and process tuning. •Collaborate with project management teams to implement database components and meet project objectives. •Manage User access and auditing. •Assist in maintaining and improving database operational efficiency •Perform daily, weekly, and monthly data maintenance tasks •Ensure data availability to support OLTP and OLAP reports and various reporting requirements •Manage installs and setup configurations •Create, develop, implement, and test backup and recovery procedures •Collaborate with the application development staff for release migration to upgrade ASP software regions. •Install and configure logical database replication for DR sites. •Provide analytical troubleshooting support during production outages. Position Requirements •Minimum 5 years hands-on operational experience with Oracle 10g or 11g DBMS. •Minimum 5 years of experience with performance tuning complex queries. •Minimum 5 years of experience with database design and tuning. •Minimum 5 years of experience OEM. •Must have experience with UNIX scripting. •Would be nice to know Perl scripting. •Minimum 5 years hands-on experience creating and testing Disaster Recovery architectures. •Minimum 5 years hands-on experience setting up RMAN backup processes and Data Guard. •Good understanding of relational principles. •Good understanding of materialized views. •Must have good verbal and written communication skills. •Must have good analytic problem solving skills. •Will require 40 to 50 hrs per week with occasional weekend and off-hours support. •Must be self starter, able to work both independently and within a team environment. •Nice to have experience with Sybase DBMS database administration. •Ability to plan, organize and work on multiple tasks simultaneously •Understanding of CONFIO Ignite helpful. Education Bachelor's Degree in Computer Science or equivalent of experience and education SunGard’s Asset Management segment provides business-critical investment and operational support to asset management businesses in 30 countries, spanning the world of traditional and alternative investment.  Our customers include institutional investors, hedge funds, private equity firms, and third party administrators.   Our systems support every stage of the investment process, from portfolio management, risk and valuation to compliance, accounting, and transfer agency.   With more than 1,000 staff in financial centers around the world and more than $25 trillion processed on our platforms, our business is a global leader in asset management technology.

Recruitment at SunGard Financial Systems works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. SunGard does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company.

We are an Equal Opportunity Employer and do not discriminate against applicants due to race, ethnicity, gender, veteran status, or on the basis of disability or any other federal, state or local protected class. Employment contingent upon successful completion of background investigation and pre-employment drug screen. As part of the selection process this role may require an assessment to determine suitability. http://careers.peopleclick.com/careerscp/client_sungard/external/jobDetails.do?functionName=getJobDetail&jobPostId=61194&localeCode=en-us