Lead Application DBA

Herndon, VA
Jul 17, 2017
Jul 17, 2017
Full Time
Job Description: Lead Application DBA Position Description We're currently hiring a very senior DBA who can independently handle DBA activities in high a pressure environment. In order to be considered, you must have prior experience leading a team. The Application DBA to join our financial services team in Herndon, VA. This is an exciting full-time opportunity to participate in one of the largest technology replacements in history. We're offering a complete benefits package that includes medical, dental, vision, 401k, paid vacation, etc. Your future duties and responsibilitiesResponsible for the application schema in local environment (Capacity Planning, Tables, Views, Stored Procedures, Packages, Performance Tuning etc. specific to the schema)Responsible for coordinating all requests to Database Shared Services for the development environment - Shared Services checks the code into the repository and executes the application schema changes in Development, SIT, UAT and Production environments - Shared Services plays the backend DBA role ie database creation, space management, backups, database level backups, jobs scheduling, data refreshes etc.Lead Performance Tuning, Query Optimization initiatives and mentor/help the team in troubleshooting and resolving performing related issues.Responsible for DB MOD changesCreate and maintain physical data modelExpertise and Hands-on experience developing PL/SQL code as per the solution specificationsSupport System Integration Testing (SIT) and User Acceptance Testing (UAT) as neededParticipate in Production Implementation PlanningPerform the data Backup (export) and restore (import) for Development/ Test environmentsResponsible for database capacity planning/space management/entitlement management of the schemas etc.Excellent communication skills including the ability to interact with various stakeholders at different levels such as PMs, SAs, developers, testers etc.Ability to multi-task, prioritize and take accountability is a must.Working experience in a fast paced Agile/Kanban/Scrum environment. Required qualifications to be successful in this role - Oracle and SQL Server Database Administration (application support, not database/server support) - Advanced Performance Tuning, Advanced PL/SQL Programming, Data Modeling Key Skills Needed: Oracle and SQL Server Database Administration (application support, not database/server support), Advanced Performance Tuning, Advanced PL/SQL Programming, Data Modeling. Preferred but not mandatory: Oracle 12c database experience Education: 1) Bachelor degree in Computer Science, Information Systems or related field 2) Professional certification(s) desired 3) Post-graduate degree desiredLI-RP1 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 . 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

Similar jobs