Oracle DBA with Sybase

Job description

Job Description

Oracle DBA with Sybase

Position Description
CGI is looking for an Oracle DBA with Sybase experience to join our team in Reston, VA. The DBA will work in a mixed database environment, primarily Oracle, but should have experience with other databases such as Sybase and/or SQL. Duties will include: Your future duties and responsibilities
1. Provide physical and logical database support as needed for various applications.
2. Identify and evaluate design considerations, propose design best practices, perform database code re-views and propose performance changes.
3. Participate in production issue triage as requested by other support teams or the Enterprise Command Center. Provide periodic updates on production outages and slow response issues as each incident oc-curs.
4. Troubleshoot the failure of both physical & logical DBA owned Autosys jobs.
5. Lead database issues until resolution. Serve as a liaison between the applicable third party vendor technical support team and client if a problem case is submitted to the third party vendor. Initiate meetings/WebEx with the necessary teams, including client teams, and provide regular updates on the issues until resolution.
6. Submit service requests or problem cases to the applicable third party vendors where necessary. Follow through on the service requests and problem cases with the third party vendors until closure.
7. Coordinate with application teams or other teams to resolve database issues even though the issues are not directly related to the databases.
8. Perform database housekeeping designed to ensure that the databases are functioning optimally and securely.
9. Perform performance tuning and/or stress testing in the non-production environment for application re-leases as necessary to ensure database infrastructure is configured optimally.
10. Provide after business hours and weekend support in client's production and contingency environments, as needed.
11. Maintain the databases to meet performance standards, maximize efficiency, and minimize outages
12. Develop/maintain knowledge articles related to databases for the Level 1 and Level 2 teams to follow.
13. Proactively provide capacity planning to prevent situations caused by lack of capacity.
14. Provide detailed Root Cause Analysis (RCA) for incidents as requested after the incident resolution within the client defined timeframe.
15. Monitor database usage, transaction volumes, response times, and concurrency levels, and measure and report its performance against the applicable Service Levels.
16. Develop/maintain/enhance database monitoring scripts designed to ensure the stability, security, and performance of the database queries.
17. Review Turn-Over Log (TOL), follow up on the root cause of the incident tickets generated the previous day, and develop a process to remediate recurring incidents.
18. Provide database resiliency in accordance with client standards. Develop or maintain Technology Contingency Plan (TCP) for the database and participate in routine or on-demand disaster recovery exercises (DREs).
19. Identify, report and manage data security issues. Provide audit trails and forensics to Client or its designee when necessary.
20. Maintain, update, and implement database archive processes and procedures to meet client’s business requirements.
21. Generate performance reports (e.g., Oracle AWR report, etc.) as required for database troubleshooting.
22. Perform system/parameter changes, reorganizations and update/gather statistics to optimize performance when required.
23. Perform database Upgrades and patching. Required qualifications to be successful in this role
• 3-5 years of Oracle DBA experience
• Good understanding of the Oracle database (v 10 or higher), related utilities and tools.
1+ years of Sybase DBA experience
• Good knowledge of the physical database design, database tuning and performance monitoring
• Good knowledge and experience with Oracle data pump utility.
• Perform general technical trouble shooting and give consultation to development teams. Assist developers with database activities.
• Experience in code migration, database change management and data management through the various stages of the development life cycle.
• Ability to handle multiple projects and deadlines.
• Create database objects (tables, indexes, etc.)
• Develop database procedures, functions and triggers.
• Knowledge of Shell scripting.
• Knowledge of scheduling tools – Oracle Scheduler, Autosys, Cron.
• Take ownership of tasks assigned and provide status daily.
• Good communication skills with teams.
• Ability to work independently.
• Ability to work as part of a team and provide 24x7 support when required.
• Bachelor’s Degree in Computer Science, Computer Engineering, Information Systems, or other applicable field Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at www.cgi.com .

No unsolicited agency referrals please.

CGI is an equal opportunity employer.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at . You will need to reference the requisition number of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a requisition number will not be returned .

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held.

CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.

Skills

Reference

603974