Oracle DBA

Employer
CGI
Location
Reston, VA
Posted
Apr 20, 2017
Closes
Apr 21, 2017
Hours
Full Time
Oracle DBA Position Description CGI is looking for a Mid Level (3-5 years) Oracle DBA to join our team in Reston, VA. The position will interact with different teams on various production issues and might require off hours and/or on call support at some time. Skillset Successful candidate should have experience in the following:* 3-5 years of Oracle Application DBA support* Good understanding of the Oracle database (v 10 or higher), related utilities and tools. * Good knowledge of the physical database design. * Perform database tuning and performance monitoring, Tune database queries.* Monitor emails / alerts and act on / troubleshoot issues.* Good knowledge and experience in Oracle data pump utility.* Work as part of a team and provide 24x7 support when required. * 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.* Use of ERStudio, DbArtisan, OEM.* Knowledge of scheduling tools - Oracle Scheduler, Autosys, Cron.* Maintain team documentation.* Take ownership of tasks assigned and provide status daily.* Good communication skills with teams.* Ability to work independently.Sybase & SQL server - not a must, but good to have.Bachelor's Degree in applicable field Your future duties and responsibilities Description 1. Provide physical and logical database support as needed for all the Applications specified by Client.2. Identify and evaluate design considerations, propose design best practices, perform database code re-views and propose performance changes.3. Serve as an escalation point for all database issues and technical support escalated by the Level 1 team or Application teams.4. Own and manage IDs supplied by the applicable vendor software and Client Applications.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. Maintain compliance with Client Standards and Client Rules, including those related to the databases (eg, access management, direct grant, SOX controls, db links, etc.). 10. 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.11. Provide after Business Hours and weekend support in Client's production and contingency environments in accordance with the applicable Application release schedules. In addition, provide on-demand support for the lower environments as requested by Client. As used in this Work Order, "Business Hours" means nine (9) consecutive hours defined by Client on each business day observed by Client.12. Maintain the databases to meet performance standards, maximize efficiency and minimize outages13. Develop/maintain knowledge articles related to databases for the Level 1 and Level 2 teams to follow.14. Proactively provide capacity planning to prevent situations caused by lack of capacity.15. Provide detailed Root Cause Analysis (RCA) for incidents as requested after the incident resolution within the client defined timeframe. 16. Monitor database usage, transaction volumes, response times, and concurrency levels, and measure and report its performance against the applicable Service Levels.17. Generate reports based on the data in the databases and reports related to the performance and integrity of the databases.18. Develop/maintain/enhance database monitoring scripts designed to ensure the stability, security, and performance of the database queries.19. 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.20. 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).21. Identify, report and manage data security issues. Provide audit trails and forensics to Client or its designee when necessary.22. Participate/plan/implement new corporate Client initiatives.23. Develop and maintain database handbooks.24. Maintain, update, and implement database archive processes and procedures to meet Client's business requirements.25. Install database server and client software and provide user support across Client and the other Eligible Recipients.26. 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 occurs. 27. Troubleshoot the failure of both physical & logical DBA owned Autosys jobs.28. Perform database shutdowns and restarts, troubleshooting, and database recovery.29. Generate performance reports (eg, Oracle AWR report, etc.) as required for database troubleshooting.30. Perform system/parameter changes, reorganizations and update/gather statistics to optimize performance when required.31. Document all of the required artifacts in the tickets to comply with the Client-approved change/incident/problem management policies.32. Perform database Upgrades and patching.33. Interface with technology risk leads, internal auditors, external auditors and regulators to provide information and respond to requests.34. Serve as a point of contact for all database issues and database technical support on 24 x 7 basis. Required qualifications to be successful in this role Skillset Successful candidate should have experience in the following:* 3-5 years of Oracle Application DBA support* Good understanding of the Oracle database (v 10 or higher), related utilities and tools. * Good knowledge of the physical database design. * Perform database tuning and performance monitoring, Tune database queries.* Monitor emails / alerts and act on / troubleshoot issues.* Good knowledge and experience in Oracle data pump utility.* Work as part of a team and provide 24x7 support when required. * 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.* Use of ERStudio, DbArtisan, OEM.* Knowledge of scheduling tools - Oracle Scheduler, Autosys, Cron.* Maintain team documentation.* Take ownership of tasks assigned and provide status daily.* Good communication skills with teams.* Ability to work independently.Sybase & SQL server - not a must, but good to have.Bachelor's Degree in Computer Science, Mathematics, Computer Engineering, Information Systems or other applicable field is required. At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please.All CGI offers of employment in the US are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. 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 DatabaseDatabase AdministrationOracle Reference 526737 Company Description: At CGI, we are a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 68,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com. This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please. Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, protected veteran status or disability.