Posted: Tuesday, September 5, 2017 8:58 PM
Job DescriptionPostgreSQL Database Administrator Position Description The PostgreSQL Database Administrator (DBA) must have hands on experience with PostgreSQL database management systems. The ideal candidate will have a good foundation of database management, including performance tuning and managing the integrity and security of the database. The DBA shall maintain and administer highly scalable database and data lake environments as well as integrate with project management, QA, Operations, UX and Application Development teams. Your future duties and responsibilities Duties: Support and administer ADO PostgreSQL database hosts and environments Be a contributing member of an agile development team, following rapid project implementation methods Gather and assemble information to support risk assessment and security vulnerabilities of client and corporate enterprise systems Support testers and quality assurance engineers in requirements validation and verification activities Provide third level customer support Maintain and administer highly scalable database and data lake environments using the latest technologies (Hadoop, Cloudera, etc.) following software engineering best practices Monitor performance and manage parameters to provide fast query responses to front-end users Install and test new versions of the database management system Maintain data standards, including adherence to the Data Protection Act Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata) Develop, manage and test back-up and recovery plans Ensure that storage, archiving, back-up and recovery procedures function correctly Communicating regularly with technical, applications and operational staff to ensure database integrity and security Assemble, deliver and share technical information and training materials used across many technical disciplines and staff roles Provide implementation estimates outlining business and technical risks Develop, manage and test back-up and recovery plans Perform database capacity planning Control access permissions and privileges Lead or perform proof-of-concept initiatives in new technologies All other duties as assigned or directed Required qualifications to be successful in this role Qualifications: BS in Computer Science or related 6+ PostgreSQL database administration experience 6+ years of systems analysis experience 6+ years of data modeling experience 5+ year of database programming experience 3+ years of experience implementing fault-tolerant and scalable database solutions in a clustered environment Familiarity with data lake methodology and Hadoop framework products such as Cloudera Education and/or formal training may substitute for experience requirement Skills: Ability to administer large scaled database solutions in a complex n-tiered environment Ability to perform database monitoring and tuning Ability to communicate clearly and professionally with all levels of the organization, both written and verbal (top two levels) Establishes and maintains effective professional relationships with internal and external stakeholders Ability to work well in a team environment, to collaborate with others, and interface with team members internal and external to the organization Must be able to adapt to organizational change Flexibility and ability to plan, prioritize, and execute multiple tasks in a fast paced environment Self motivated, well-organized, and detail oriented Ability to design and implement logical and physical database structures Ability to develop database scripts to automate database administration and maintenance activities Ability to work with configuration management teams to implement database scripts in a continuous integration environment Ability to work with cross-functional project teams to support end-to-end software development lifecycle activities Ability to support planning activities with project management, including implementation estimates and task tracking Ability to lead and direct a team, manage resources, and to collaborate with managers across programsOther: US citizen or legal right to work in the United States without sponsorship 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, 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 Reference 564849 Company DescriptionAt 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.
• Location: Baltimore
• Post ID: 26557337 baltimore